In the __________ normal form, a composite attribute is converted to individual attributes. A) First B) Second C) Third D) Fourth Answer:A Explanation: The first normal form is used to eliminate the duplicate information. A table on the many side of a one to many ormany to many relationship must: a) […]
26. ____________ is an index whose search key also define sequential order of the file. A. Stack index B. Clustering index C. Hash index D. Dense Answer: Option B 27. Clustering index is also called as ____________. A. secondary index B. primary index C. hash index D. sparse […]
DBMS QUESTIONS 1. The DBMS acts as an interface between what two components of an enterprise-class database system? A. Database application and the database B. Data and the database C. The user and the database application D. Database application and SQL Answer: Option A 2. Which of the following products was an […]
GATE-2006 Consider the relation account (customer, balance) where customer is a primary key and there are no null values. We would like to rank customers according to decreasing balance. The customer with the largest balance gets rank 1. Ties are not broke but ranks are skipped: if exactly two customers […]
Which normal form is considered adequate for normal relational database design? (a) 2NF (b) 5NF (c) 4NF (d) 3NFAns: option (d) Explanation: A relational database table is often described as “normalized” if it is in the Third […]
DBMS MCQ IN GATE SOLVED WITH EXPLANATION SET 1 DBMS MCQ IN GATE SOLVED WITH EXPLANATION SET 2 DBMS MCQ SET 1 DBMS MCQ SET 2 DBMS MCQ SET 3 DBMS MCQ SET 4 DBMS MCQ SET 5 DBMS MCQ SET 6 DBMS MCQ SET 7 DBMS MCQ SET 8 […]
PAGES: 1 2 3 4 5 Suppose x and y are two Integer Variables having values 0x5AB6 and 0x61CD respectively. The result (in hex) of applying bitwise operator AND to x and y will be: (A) 0x5089 (B) 0x4084 (C) 0x78A4 (D) 0x3AD1 Answer: B Explanation: 0x5AB6=0101 1010 […]
PAGES: 1 2 3 4 5 What item is at the root after the following sequence of insertions into an empty splay tree: 1, 11, 3, 10, 8, 4, 6, 5, 7, 9, 2 ? (A) 1 (B) 2 (C) 4 (D) 8 Answer: B Suppose we are […]
PAGES: 1 2 3 4 5 Which activity is not included in the first pass of two pass assemblers? (A) Build the symbol table (B) Construct the intermediate code (C) Separate mnemonic opcode and operand fields (D) None of the above Answer: D Which of the following is not collision […]
PAGES: 1 2 3 4 5 The main objective of designing various modules of a software system is: (A) To decrease the cohesion and to increase the coupling (B) To increase the cohesion and to decrease the coupling (C) To increase the coupling only (D) To increase the cohesion only […]