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?
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.