Database Management System

1. Database management systems are intended to:

Eliminate data redundancy

Establish relationships among records in different files

Manage file access

All of the above

2. The statement in SQL which allows to change the definition of a table is

Alter.

Update

Create

Select.

3. Which command is used to select distinct subject (SUB) from the table (BOOK)?

SELECT ALL FROM BOOK

SELECT DISTINCT SUB FROM BOOK

SELECT SUB FROM BOOK

All of the above

4. Which of the following is a valid SQL type?

CHARACTER

NUMERIC

FLOAT

All of the above

5. In SQL, which command is used to select only one copy of each set of duplicable rows

SELECT DISTINCT

SELECT UNIQUE

SELECT DIFFERENT

All of the above

6. In SQL, the CREATE TABLESPACE is used

To create a database trigger

To add/rename data files, to change storage

All of the above

7. In SQL, which command is used to remove a stored function from the database?

REMOVE FUNCTION

DELETE FUNCTION

DROP FUNCTION

ERASE FUNCTION

8. In SQL, which of the following is not a data definition language commands?

RENAME

REVOKE

GRANT

UPDATE

9. ODBC stands for

Object Database Connectivity.

Oral Database Connectivity.

Oracle Database Connectivity

Open Database Connectivity.

10. The physical location of a record is determined by a mathematical formula that transforms a file key into a record location in

Tree file

An indexed file

A hashed file

None of the above

Database Management System

1. Database management systems are intended to:

2.

What first name or nickname would you like us to use?

2. The statement in SQL which allows to change the definition of a table is

3. Which command is used to select distinct subject (SUB) from the table (BOOK)?

4. Which of the following is a valid SQL type?

5. In SQL, which command is used to select only one copy of each set of duplicable rows

6. In SQL, the CREATE TABLESPACE is used

7. In SQL, which command is used to remove a stored function from the database?

8. In SQL, which of the following is not a data definition language commands?

9. ODBC stands for

10. The physical location of a record is determined by a mathematical formula that transforms a file key into a record location in