Craig Willey
Quiz by , created more than 1 year ago

Chapter 1

14
0
0
Craig Willey
Created by Craig Willey over 4 years ago
Close

Structured Query Language (SQL) (Section 1)

Question 1 of 10

1

When transforming an ERD into a relational database, you often use an entity to build a database's:

Select one of the following:

  • Table

  • Column

  • Attribute

  • Relationship

Explanation

Question 2 of 10

1

The unique identifier of a row in a database table is a(n):

Select one of the following:

  • ID

  • Primary Key

  • Primary Column

  • Column

Explanation

Question 3 of 10

1

Which of the following is true of SQL?

Select one of the following:

  • 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

Explanation

Question 4 of 10

1

What can you use to submit SQL statements for execution? (Choose all that apply.)

Select one or more of the following:

  • PHP

  • Java

  • SQL Developer

  • SQL*Plus

Explanation

Question 5 of 10

1

What is one of the purposes of DCL? (Choose the best answer.)

Select one of the following:

  • Query data from a given table

  • Issue privileges to users

  • Remove existing data from a database table

  • None of these

Explanation

Question 6 of 10

1

What can DDL be used for? (Choose three.)

Select one or more of the following:

  • 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

Explanation

Question 7 of 10

1

Which one of the following is a DML statement?

Select one of the following:

  • ADD

  • ALTER

  • UPDATE

  • MODIFY

Explanation

Question 8 of 10

1

Which of the following can be used to remove data from a table? (Choose two.)

Select one or more of the following:

  • DELETE

  • UPDATE

  • MODIFY

  • ALTER

Explanation

Question 9 of 10

1

What can a SELECT statement be used to query? (Choose the best answer.)

Select one of the following:

  • Only one report

  • Only one table

  • One or more reports

  • One or more tables

Explanation

Question 10 of 10

1

Which of the following is not a capability of the SELECT statement?

Select one of the following:

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

Explanation

Previous
Check answer
Next