When transforming an ERD into a relational database, you often use an entity to build a database's:
Table
Column
Attribute
Relationship
The unique identifier of a row in a database table is a(n):
ID
Primary Key
Primary Column
Which of the following is true of SQL?
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
What can you use to submit SQL statements for execution? (Choose all that apply.)
PHP
Java
SQL Developer
SQL*Plus
What is one of the purposes of DCL? (Choose the best answer.)
Query data from a given table
Issue privileges to users
Remove existing data from a database table
What can DDL be used for? (Choose three.)
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
Which one of the following is a DML statement?
ADD
ALTER
UPDATE
MODIFY
Which of the following can be used to remove data from a table? (Choose two.)
DELETE
What can a SELECT statement be used to query? (Choose the best answer.)
Only one report
Only one table
One or more reports
One or more tables
Which of the following is not a capability of the SELECT statement?
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.
