DBMS Questions – Set 7
1. The highest level in the hierarchy of data organization is called________
(A) data base
(B) data file
(C) data record
(D) None of the above
Answer
(A)
2. OLAP stands for_____
(A) Online Arithmetic Processing
(B) Online Analysis Processing
(C) Online Analytical Processing
(D) None of the above
Answer
(C)
3. Which of the following operator used for appending two strings?
(A) %
(B) &
(C) +
(D) ||
Answer
(D)
4. The _____ operation allows the combining of two relations by merging pairs of tuples, one
from each relation, into a single tuple.
(A) Join
(B) Intersection
(C) Union
(D) None of the above
Answer
(A)
5.In SQL, the spaces at the end of the string are removed by _______ function .
(A) Lower
(B) String
(C) Trim
(D) None of the above
Answer
(C)
6.________is the multiplication of all the values in the attributes.
(A) Set difference
(B) Cartesian product
(C) Intersection
(D) None of the above
Answer
(B)
7. Which command is used to remove a relation from an SQL database?
(A) Delete
(B) Remove
(C) Drop
(D) None of the above
Answer
(C)
8. ________ is used to save permanently any transaction into database.
(A) commit
(B) rollback
(C) savepoint
(D) None of the above
Answer
(A)
9. A unit of storage that can store one or more records in a hash file organization is denoted
as_______
(A) Bucket
(B) Disk pages
(C) Blocks
(D) Nodes
Answer
(A)
10. The management information system (MIS) structure with one main computer system is
called a________
(A) Decentralized MIS structure
(B) Distributed MIS structure
(C) Centralized MIS structure
(D) None of the above
Answer
(C)
0 Comments