Welcome to DataBase Quiz, Randomly Selected !!

Question 1. 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 2. 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 3. View text definitions are stored in which system table?

sysobjects

syscolumns

syscomments

sysviews

Question 4. 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 5. In the DBMS approach, application programs perform the

storage function

processing functions

access control

none of the above

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

users

separate files

query languages

database

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