TNPSC ASSISTANT SYSTEM ENGINEER- 2019
DATABASE MANAGEMENT SYSTEMS
PREVIOUS YEAR QUESTIONS 1 MARK SOLVED
1. Which RAID level represents. an Error - correcting codes (ECC) can be used directly in disk
arrays by striping bytes across disks
(A) RAID Level 2 (C) RAID Level 4
(B) RAID Level 3 (D) RAID Level 5
ANS: (A) RAID Level 2
2. An index that is based on a uniform distribution of values across a range of brackets is called
(A) ordered index (C) multi layer index
(B) multi level index (D) Hash index
ANS: (B) multi level index
3. The execution of a single query in parallel on multiple processors and disk is called
(A) Interquery Parallism (B) Intraquery Parallism
(C) Interoperation Parallism (D) Intraoperation Parallism
ANS:(B) Intraquery Parallism
4. Special type of table, which can only be accessed and updated by the database system itself
called.
(A)Data Storage (C)DBMS
(B) Data Dictionary (D) Tuples
ANS: (B) Data Dictionary
5. Which construct can be used to test for the absence of Duplicate Tuples in a relation?
(A) exist (B)unique
(C) distinct (D) all
ANS: (B)unique
