SQL Practice Test 1

Question 1

To delete data from a table, which SQL statement is used?

Accepted Answer

TRUNCATE

Answer

DELETE

Answer

REMOVE

Answer

None of the above

Question 2

To update data in a database, which SQL statement is used?

Accepted Answer

UPDATE

Answer

SAVE AS

Answer

SAVE

Answer

MODIFY

Question 3

How do you select all of the columns from the "Persons" table in SQL?

Accepted Answer

SELECT * FROM Persons

Answer

SELECT All Persons

Answer

SELECT [all] FROM Persons

Answer

SELECT *.Pe1‘sons

Question 4

How do you get a column called "FirstName" from a table called "Persons" in SQL?

Accepted Answer

SELECT FirstName FROM Persons

Answer

SELECT Persons.FirstName

Answer

EXTRACT FirstName FROM Persons

Answer

None of the above

Question 5

To extract data from a database, which SQL statement is used?

Accepted Answer

SELECT

Answer

EXTRACT

Answer

GET

Answer

OPEN

Question 6

(T/F) When AUTOCOMMIT is enabled, updates are made at the end of each SQL query automatically.

Accepted Answer

B) True

Answer

A) False

Question 7

The AVG SQL function returns the following

Accepted Answer

average in the values in a group

Answer

the sum of values in a column

Answer

maximum value from a column

Answer

None of the above

Question 8

What does a TRUNCATE TABLE do?

Accepted Answer

deletes all rows from a table

Answer

deletes the table

Answer

checks if the table has primary key specified

Answer

All of the above

Question 9

The primary - foreign key relations are utilized to

Accepted Answer

cross-reference database tables

Answer

to index the database.

Answer

clean-up the database.

Answer

None of the above

Question 10

Which of the following statements about system information in an RDBMS is correct?

Accepted Answer

All of the above.

Answer

This information often cannot be updated by a user.

Answer

RDBMS store database definition information in system-created tables.

Answer

This information can be accessed using SQL.