24714155
Description
Quiz by Craig Willey, updated more than 1 year ago
|
Created by Craig Willey
over 4 years ago
|
|
Question 1
Question
When transforming an ERD into a relational database, you often use an entity to build a database's:
Answer
-
Table
-
Column
-
Attribute
-
Relationship
Question 2
Question
The unique identifier of a row in a database table is a(n):
Answer
-
ID
-
Primary Key
-
Primary Column
-
Column
Question 3
Question
Which of the following is true of SQL?
Answer
-
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
Question 4
Question
What can you use to submit SQL statements for execution? (Choose all that apply.)
Answer
-
PHP
-
Java
-
SQL Developer
-
SQL*Plus
Question 5
Question
What is one of the purposes of DCL? (Choose the best answer.)
Answer
-
Query data from a given table
-
Issue privileges to users
-
Remove existing data from a database table
-
None of these
Question 6
Question
What can DDL be used for? (Choose three.)
Answer
-
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
Question 7
Question
Which one of the following is a DML statement?
Answer
-
ADD
-
ALTER
-
UPDATE
-
MODIFY
Question 8
Question
Which of the following can be used to remove data from a table? (Choose two.)
Answer
-
DELETE
-
UPDATE
-
MODIFY
-
ALTER
Question 9
Question
What can a SELECT statement be used to query? (Choose the best answer.)
Answer
-
Only one report
-
Only one table
-
One or more reports
-
One or more tables
Question 10
Question
Which of the following is not a capability of the SELECT statement?
Answer
-
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.
Want to create your own Quizzes for free with GoConqr? Learn more.