Welcome to DataBase Quiz, Randomly Selected !!

Question 1. 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 2. In a properly designed DBMS, concurrency control is provided by which of the following components.

Cache Manager

Lock Manager

Transaction Manager

B&C

Question 3. What will be the output of the following statement? SELECT ROUND(123.89, -1)

120.00

123.00

123.90

124.00

Question 4. You run a SELECT statement, and multiple duplicates of values are retrieved. What keyword can you use to retrieve only the non duplicate data?

DUBPLICATE

INDIVIDUAL

INDEX

DISTINCT

Question 5. Which of the following are the factors to consider when you want to select a DBMS based on the criteria of physical capabilities, as recommended by CIW ?

hardware requirements

data compression support

encryption support

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 relational database environment has all of the following components except

users

separate files

query languages

database

Question 8. 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 9. In SQL, relations can contain null values, and comparisons with null values are treated as unknown. Suppose all comparisons with a null value are treated as false. Which of the following pairs is not equivalent?

x = 5, not (not (x = 5))

x = 5, x > 4 and x < 6, where x is an integer

x < 5, not(x = 5)

none of the above

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