24714155
Descrição
Quiz por Craig Willey, atualizado more than 1 year ago
|
Criado por Craig Willey
aproximadamente 4 anos atrás
|
|
Questão 1
Questão
When transforming an ERD into a relational database, you often use an entity to build a database's:
Responda
-
Table
-
Column
-
Attribute
-
Relationship
Questão 2
Questão
The unique identifier of a row in a database table is a(n):
Responda
-
ID
-
Primary Key
-
Primary Column
-
Column
Questão 3
Questão
Which of the following is true of SQL?
Responda
-
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
Questão 4
Questão
What can you use to submit SQL statements for execution? (Choose all that apply.)
Responda
-
PHP
-
Java
-
SQL Developer
-
SQL*Plus
Questão 5
Questão
What is one of the purposes of DCL? (Choose the best answer.)
Responda
-
Query data from a given table
-
Issue privileges to users
-
Remove existing data from a database table
-
None of these
Questão 6
Questão
What can DDL be used for? (Choose three.)
Responda
-
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
Questão 7
Questão
Which one of the following is a DML statement?
Responda
-
ADD
-
ALTER
-
UPDATE
-
MODIFY
Questão 8
Questão
Which of the following can be used to remove data from a table? (Choose two.)
Responda
-
DELETE
-
UPDATE
-
MODIFY
-
ALTER
Questão 9
Questão
What can a SELECT statement be used to query? (Choose the best answer.)
Responda
-
Only one report
-
Only one table
-
One or more reports
-
One or more tables
Questão 10
Questão
Which of the following is not a capability of the SELECT statement?
Responda
-
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.
Quer criar seus próprios Quizzes gratuitos com a GoConqr? Saiba mais.