Structured Query Language (SQL) (Section 1)

Beschreibung

Chapter 1
Craig Willey
Quiz von Craig Willey, aktualisiert more than 1 year ago
Craig Willey
Erstellt von Craig Willey vor mehr als 4 Jahre
14
0

Zusammenfassung der Ressource

Frage 1

Frage
When transforming an ERD into a relational database, you often use an entity to build a database's:
Antworten
  • Table
  • Column
  • Attribute
  • Relationship

Frage 2

Frage
The unique identifier of a row in a database table is a(n):
Antworten
  • ID
  • Primary Key
  • Primary Column
  • Column

Frage 3

Frage
Which of the following is true of SQL?
Antworten
  • It is the most commonly used language for interacting with a database.
  • It is the only language you can use to create a database.
  • It is the only language you can use to interact with a database.
  • None of these

Frage 4

Frage
What can you use to submit SQL statements for execution? (Choose all that apply.)
Antworten
  • PHP
  • Java
  • SQL Developer
  • SQL*Plus

Frage 5

Frage
What is one of the purposes of DCL? (Choose the best answer.)
Antworten
  • Query data from a given table
  • Issue privileges to users
  • Remove existing data from a database table
  • None of these

Frage 6

Frage
What can DDL be used for? (Choose three.)
Antworten
  • Add comments to a database table
  • Add columns to a database table
  • Add data to a database table
  • Add privileges for a user to a database table

Frage 7

Frage
Which one of the following is a DML statement?
Antworten
  • ADD
  • ALTER
  • UPDATE
  • MODIFY

Frage 8

Frage
Which of the following can be used to remove data from a table? (Choose two.)
Antworten
  • DELETE
  • UPDATE
  • MODIFY
  • ALTER

Frage 9

Frage
What can a SELECT statement be used to query? (Choose the best answer.)
Antworten
  • Only one report
  • Only one table
  • One or more reports
  • One or more tables

Frage 10

Frage
Which of the following is not a capability of the SELECT statement?
Antworten
  • It can transform queried data and display the results.
  • It can remove data from a table.
  • It can join data from multiple tables.
  • It can aggregate database data.
Zusammenfassung anzeigen Zusammenfassung ausblenden

ähnlicher Inhalt

Using DDL Statements to Create and Manage Tables ( Section 2)
Craig Willey
Manipulating Data (Section 3)
Craig Willey
Restricting and Sorting Data (Section 4)
Craig Willey
Zeiten Englisch
anna.grillborzer0656
Strafrecht - Definitionen
myJurazone
Zellzyklus
Nele Ramrath
Aufstieg der NSDAP
Anina Hagi
GPSY ALPS
Simon Wirsching
Quiz zum Basiswissen Europa und Europäische Union
lea_seelbach
Vetie: Geflügelkrankheiten Fragen aus den Vorlesungen
Johanna Tr