Welcome to DataBase Quiz, Intermediate Level !!

Question 1. What will be the output of the following statement? SELECT CAST(-1 AS SMALLDATETIME)

1900-01-01 00:00:00.000

1899-01-01 00:00:00.000

1752-01-01 00:00:00.000

The system will generate an error

Question 2. Which of the following is NOT a valid description of the public role?

The public role captures all default permissions for users in a database.

The public role cannot be dropped.

The public role is contained in every database, including msdb, tempdb, model, and all user databases except in the master database for security purposes.

The public role cannot have users, groups, or roles assigned to it.

Question 3. What will be the output of the following statement? SELECT LEN(CAST(LEFT('026-100', 3) AS INT))

Statement will generate an error.

2

3

7

Question 4. In JDBC, what represents a single instance of a particular database session?

a thread

an opened connection

a closed connection

a pipe

Question 5. What statement do you use to remove a schema and ensure that the removal takes place only if the schema is empty?

DROP SCHEMA RESTRICT

DROP SCHEMA OPTS

DROP SCHEMA CASCADE

DROP SCHEMA CLEAR

Question 6. A file produced by a spreadsheet

is generally stored on disk in an ASCII text fromat

can be used as is by the DBMS

both a and b

none of the above

Question 7. Which is the make given to the database management system which is able to handle full text data, image data, audio and video?

full media

graphics media

multimedia

hypertext

Question 8. The ascending order of a data hirerchy is:

bit-byte-record-field-file-database

byte-bit-field-record-file-database

bit-byte-field-record-file-database

bit-byte-file-record-field-database

Question 9. The language used by application programs to request data from the DBMS is referred to as the

DML

DDL

query language

none of the above

Question 10. Given an employees table as follows: empid name managerid a1 bob NULL b1 jim a1 B2 tom a1 What value will select count(*) from employees return?

1

2

3

None of the above