24714155
Descripción
Test por Craig Willey, actualizado hace más de 1 año
|
Creado por Craig Willey
hace más de 4 años
|
|
Pregunta 1
Pregunta
When transforming an ERD into a relational database, you often use an entity to build a database's:
Respuesta
-
Table
-
Column
-
Attribute
-
Relationship
Pregunta 2
Pregunta
The unique identifier of a row in a database table is a(n):
Respuesta
-
ID
-
Primary Key
-
Primary Column
-
Column
Pregunta 3
Pregunta
Which of the following is true of SQL?
Respuesta
-
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
Pregunta 4
Pregunta
What can you use to submit SQL statements for execution? (Choose all that apply.)
Respuesta
-
PHP
-
Java
-
SQL Developer
-
SQL*Plus
Pregunta 5
Pregunta
What is one of the purposes of DCL? (Choose the best answer.)
Respuesta
-
Query data from a given table
-
Issue privileges to users
-
Remove existing data from a database table
-
None of these
Pregunta 6
Pregunta
What can DDL be used for? (Choose three.)
Respuesta
-
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
Pregunta 7
Pregunta
Which one of the following is a DML statement?
Respuesta
-
ADD
-
ALTER
-
UPDATE
-
MODIFY
Pregunta 8
Pregunta
Which of the following can be used to remove data from a table? (Choose two.)
Respuesta
-
DELETE
-
UPDATE
-
MODIFY
-
ALTER
Pregunta 9
Pregunta
What can a SELECT statement be used to query? (Choose the best answer.)
Respuesta
-
Only one report
-
Only one table
-
One or more reports
-
One or more tables
Pregunta 10
Pregunta
Which of the following is not a capability of the SELECT statement?
Respuesta
-
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.
¿Quieres crear tus propios Tests gratis con GoConqr? Más información.