Welcome to DataBase Quiz, Randomly Selected !!

Question 1. 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 2. With SQL, how do you select all the records from a table named "Persons" where the "FirstName" is "Peter" and the "LastName" is "Jackson"?

SELECT * FROM Persons WHERE FirstName LIKE 'Peter' AND LastName LIKE 'Jackson'

SELECT * FROM Persons WHERE FirstName='Peter' AND LastName='Jackson'

SELECT FirstName='Peter', LastName='Jackson' FROM Persons

none of the above

Question 3. With SQL, how can you return the number of records in the "Persons" table?

SELECT COLUMNS() FROM Persons

SELECT COUNT() FROM Persons

SELECT COLUMNS(*) FROM Persons

SELECT COUNT(*) FROM Persons

Question 4. Which SQL statement is used to delete data from a database?

TRUNCATE

DELETE

DROP

REMOVE

Question 5. You are managing the in-house database systems. You are creating a series of secondary indexes in your relational database. By doing so, which of the following issues must be carefully considered .

confusion in selection of optimal query execution method

disk space consumption

performance overhead

All of the above

Question 6. 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 7. 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 8. The highest level in the hierarchy of data organization is called

data bank

data base

data file

data record

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

PreparedStatement

CallableStatement

Statement

All of the above