Computer : : Database Management System Questions & Answers
- ______ joins are SQL server default
A. Outer
B. Inner
C. Equi
D. None of these
- Which of the following is not the function of client?
A. Compile queries
B. Query optimization
C. Receive queries
D. Result formatting and presentation
- 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
- 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.
- 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