Quiz
Structured Query Language (SQL) (Section 1)
Create a free account to finish this quiz
Save your progress and see your final score.
Already have an account? Sign in
Questions in this quiz (10)
1When transforming an ERD into a relational database, you often use an entity to build a database's:
- ATable
- BColumn
- CAttribute
- DRelationship
2The unique identifier of a row in a database table is a(n):
- AID
- BPrimary Key
- CPrimary Column
- DColumn
3Which of the following is true of SQL?
- AIt is the most commonly used language for interacting with a database.
- BIt is the only language you can use to create a database.
- CIt is the only language you can use to interact with a database.
- DNone of these
4What can you use to submit SQL statements for execution? (Choose all that apply.)
- APHP
- BJava
- CSQL Developer
- DSQL*Plus
5What is one of the purposes of DCL? (Choose the best answer.)
- AQuery data from a given table
- BIssue privileges to users
- CRemove existing data from a database table
- DNone of these
6What can DDL be used for? (Choose three.)
- AAdd comments to a database table
- BAdd columns to a database table
- CAdd data to a database table
- DAdd privileges for a user to a database table
7Which one of the following is a DML statement?
- AADD
- BALTER
- CUPDATE
- DMODIFY
8Which of the following can be used to remove data from a table? (Choose two.)
- ADELETE
- BUPDATE
- CMODIFY
- DALTER
9What can a SELECT statement be used to query? (Choose the best answer.)
- AOnly one report
- BOnly one table
- COne or more reports
- DOne or more tables
10Which of the following is not a capability of the SELECT statement?
- AIt can transform queried data and display the results.
- BIt can remove data from a table.
- CIt can join data from multiple tables.
- DIt can aggregate database data.
Information
- Description
- Chapter 1
- Author
- Craig Willey
- Language
- English
- Views
- 38
- Tags
- Rating
- No ratings yet Rate this quiz