41. What property of the files prevents sharing of files and directories? A. Tree structure B. One level structure C. Two level structure D. Length Ans Correct Answer is A     42. E-R modeling technique is: A. Tree structure B. Top-down method C. Bottom-up method D. Right-left approach […]

21.) The language which has recently become the defacto standard for interfacing application programs with relational database system is A) Oracle. B) SQL. C) DBase. D) 4GL. Answer: Option B 22.) In an E-R diagram an entity set is represent by a A) Rectangle. B) Ellipse. C) Diamond box. D) Circle. Answer: Option A […]

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 […]

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 […]