Welcome to DataBase Quiz, Randomly Selected !!

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. A top-to-bottom relationship among the items in a database is established by a

hierarchical schema

network schema

relational schema

all of the above

Question 3. 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 4. Under JDBC, which of the following types of instances can be created by the Connection object?

PreparedStatement

CallableStatement

Statement

All of the above

Question 5. Which of the following is true of a network structure?

It is a physical representation of the data

It allows a many-to-many relationship

It is conceptually simple

It will be dominant data base of the future

Question 6. 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 7. Sort/Report generators

are faster than index/report generators

require more disk space than indexed/report generators

do not need to sort before generating report

both a and b

Question 8. You reject someone's proposal to use File-based databases. Which of the following are the disadvantages of such databases?

repetition of data

separation of data

data dependence

All of the above

Question 9. What will be the output of the following statement? SELECT STR(6365, 3)

***

6365

6,365

6400

Question 10. In a properly designed DBMS, concurrency control is provided by which of the following components.

Cache Manager

Lock Manager

Transaction Manager

B&C