Q.1 Which of the following relational algebra operations do not require the participating tables to be union-compatible? (A) Union (B) Intersection (C) Difference (D) Join Ans: (D) Q.2 Which of the following is not a property of transactions? (A) Atomicity (B) Concurrency (C) Isolation (D) Durability Ans: (B) […]
1. In the relational modes, cardinality is termed as: (A) Number of (B) Number of attributes. (C) Number of tables. (D) Number of constraints. Ans: A 2 . Relational calculus is a (A)Procedural […]
Q.1 Which of the following relational algebra operations do not require the participating tables to be union-compatible? (A) Union (B) Intersection (C) Difference (D) Join Ans: (D) Q.2 Which of the following is not a property of transactions? (A) Atomicity (B) Concurrency […]
81. A data dictionary does not provide information about A. Where data is located B. who owns it C. size of disk storage device D. How the data is used Ans Correct Answer is C 82. Data item characteristics that are important in data management include A. […]
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 […]
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 […]