Computer : : Database Management System Questions & Answers

  1. ______ joins are SQL server default

A. Outer

B. Inner

C. Equi

D. None of these

  1. Which of the following is not the function of client?

A. Compile queries

B. Query optimization

C. Receive queries

D. Result formatting and presentation

  1. The DBMS acts as an interface between what two components of an enterprise-class database system?

A. Database application and the database

B. Data and the database

C. The user and the database application

D. Database application and SQL

  1. Which of the following SQL statements are helpful in database redesign?

A. Correlated subqueries only

B. EXISTS/NOT EXISTS expressions only

C. Both of the above are helpful

D. None of the above are helpful.

  1. What SQL command can be used to delete columns from a table?

A. MODIFY TABLE TableName DROP COLUMN columnname

B. ALTER TABLE TableName DROP COLUMN columnname

C. MODIFY TABLE TableName DROP columnname

D. ALTER TABLE TableName DROP ColumnName