Welcome to DataBase Quiz, Intermediate Level !!

Question 1. What's the maximum value can an INT data type hold?

2,147,483,647

2,147,483,648

4,294,967,295

4,294,967,296

Question 2. The management information system (MIS) structure with one main computer system is called a

hierarchical MIS structure

distributed MIS structure

centralized MIS structure

decentralized MIS structure

Question 3. In your program you want to use the JDBC-ODBC Bridge driver. What code do you use?

Class.callName("sun.jdbc.odbc.JdbcOdbcDriver");

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

Class.callfunc("JdbcOdbcDriver");

Class.Name.init("sun.jdbc.odbc.JdbcOdbcDriver");

Question 4. 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

Question 5. Which of the following correctly describe the sequence of the DBMS operational process?

User issues request -> DBMS retrieves relevant mappings and executes the request DBMS intercepts the request DBMS presents the request to the user.

User issues request -> DBMS intercepts the request DBMS retrieves relevant mappings and executes the request DBMS presents the request to the user.

User issues request -> DBMS retrieves relevant mappings and executes the request DBMS presents the request to the user DBMS intercepts the request.

None of the above

Question 6. A transparent DBMS

can not hide sensitive information from users

keeps its logical structure hidden from users

keeps its physical structure hidden from users

both b and c

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. With SQL, how do you select all the records from a table named "Persons" where the value of the column "FirstName" starts with an "a"?

SELECT * FROM Persons WHERE FirstName='%a%'

SELECT * FROM Persons WHERE FirstName LIKE '%a'

SELECT * FROM Persons WHERE FirstName='a'

SELECT * FROM Persons WHERE FirstName LIKE 'a%'

Question 9. 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 10. 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