Q.1 A DBMS query language is designed to (A) support end users who use English-like commands. (B) support in the development of complex applications software. (C) specify the structure of a database. (D) all of the above. Q.2 Transaction processing is associated with everything below except (A) producing detail, summary, or exception reports. (B) recording a business activity. (C) confirming an action or triggering a response. (D) maintaining data. Q.3 It is possible to define a schema completely using (A) VDL and DDL (B) DDL and DML (C) SDL and DDL (D) VDL and DML Q.4 The method of access which uses key transformation is known as (A) direct (B) hash (C) random (D) sequential Q.5 Data independence means (A) data is defined separately and not included in programs. (B) programs are not dependent on the physical attributes of data. (C) programs are not dependent on the logical attributes of data. (D) both (B) and (C) Q.6 The statement in SQL which allows to change the definition of a table is (A) Alter (B) Update (C) Create (D) select Q.7 E-R model uses this symbol to represent weak entity set ? (A) Dotted rectangle (B) Diamond (C) Doubly outlined rectangle (D) None of these Q.8 SET concept is used in : (A) Network Model (B) Hierarchical Model (C) Relational Model (D) None of these Q.9 Relational Algebra is (A) Data Definition Language (B) Meta Language (c) Procedural query language (D) None of the above Q. 10 Key to represent relationship between tables is called (A) Primary Key (B) Secondary Key (C) Foreign Key (D) None of these ANSWERS: Ans1: D Ans2: C Ans3: B Ans4: B Ans5: D Ans6: A Ans7: C Ans8: A Ans9: C Ans10: C
Posted on: Thu, 20 Mar 2014 19:01:08 +0000
Trending Topics
Recently Viewed Topics
© 2015