Welcome to DataBase Quiz, Randomly Selected !!

Question 1. What will be the output of the following statement? SET ARITHABORT OFF SET ANSI_WARNINGS OFF SELECT 100/0

Null

0

Infinity

Error

Question 2. 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 3. You are managing the in-house database systems.You need to ensure that the user AMY can execute all operations against the SALES relation. What SQL statement sequence will you use?

GRANT ALL PRIVILEGES WHERE FROM ON TO

GRANT ALL PRIVILEGES TO WHERE FROM

GRANT ALL PRIVILEGES WHERE FROM TO

GRANT ALL PRIVILEGES ON TO

Question 4. The relational database environment has all of the following components except

users

separate files

query languages

database

Question 5. 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 6. 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 7. What statement do you use to remove a schema and its related objects from your relational database?

DROP SCHEMA RESTRICT

DROP SCHEMA ALL

DROP SCHEMA CASCADE

DROP SCHEMA OPTS

Question 8. In the world of SQL relational database, the data type for varchar, in general, is:

Fixed length string of n characters

Variable length string up to n characters

Floating point number of p bits precision

32-bit signed integer

Question 9. What is the best data type to store the birthdays of the US Presidents, starting with George Washington's birthday of February 22, 1732?

DATETIME

INT

SMALLDATETIME

VARCHAR

Question 10. 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");