GoConqr hat ein neues Design! Sag uns, wie es dir gefällt.

Quiz

Structured Query Language (SQL) (Section 1)

Craig Willey 10 Fragen

Quiz starten

Fragen in diesem Quiz (10)

  1. 1When transforming an ERD into a relational database, you often use an entity to build a database's:
    1. ATable
    2. BColumn
    3. CAttribute
    4. DRelationship
  2. 2The unique identifier of a row in a database table is a(n):
    1. AID
    2. BPrimary Key
    3. CPrimary Column
    4. DColumn
  3. 3Which of the following is true of SQL?
    1. AIt is the most commonly used language for interacting with a database.
    2. BIt is the only language you can use to create a database.
    3. CIt is the only language you can use to interact with a database.
    4. DNone of these
  4. 4What can you use to submit SQL statements for execution? (Choose all that apply.)
    1. APHP
    2. BJava
    3. CSQL Developer
    4. DSQL*Plus
  5. 5What is one of the purposes of DCL? (Choose the best answer.)
    1. AQuery data from a given table
    2. BIssue privileges to users
    3. CRemove existing data from a database table
    4. DNone of these
  6. 6What can DDL be used for? (Choose three.)
    1. AAdd comments to a database table
    2. BAdd columns to a database table
    3. CAdd data to a database table
    4. DAdd privileges for a user to a database table
  7. 7Which one of the following is a DML statement?
    1. AADD
    2. BALTER
    3. CUPDATE
    4. DMODIFY
  8. 8Which of the following can be used to remove data from a table? (Choose two.)
    1. ADELETE
    2. BUPDATE
    3. CMODIFY
    4. DALTER
  9. 9What can a SELECT statement be used to query? (Choose the best answer.)
    1. AOnly one report
    2. BOnly one table
    3. COne or more reports
    4. DOne or more tables
  10. 10Which of the following is not a capability of the SELECT statement?
    1. AIt can transform queried data and display the results.
    2. BIt can remove data from a table.
    3. CIt can join data from multiple tables.
    4. DIt can aggregate database data.

Informationen

Beschreibung
Chapter 1
Sprache
English
Aufrufe
38
Schlagwörter
c192graduate
Bewertung
Noch keine Bewertungen
Bewerte dieses Quiz
Bewerte dieses Quiz

Feedback

Worum geht es?

Wie gefällt dir das neue Design?

Dein Eindruck