Author :Wasiq Aslam/37 0 votes, 0 avg 1 Rwp_2nd_cs_2Rawalpindi Board 2nd year Computer Science Chapter 2 1 / 37 1. DBA stands for: a) Database Application b) Database Administrator c) Data basic Administration d) Database authority 2 / 37 2. A key strictly used for data retrieval purposes is called: a) Candidate key b) Composite key c) Secondary key d) Primary key 3 / 37 3. Who is responsible to design, implement and maintain a databases? a) End user b) Web designer c) Application programmer d) Database administrator 4 / 37 4. A table in which the foreign key is found is called: a) View b) Parent table c) All d) Dependent table 5 / 37 5. Which of the following is also known as control key? a) Composite key b) Primary key c) Candidate key d) Sort key 6 / 37 6. A primary key that consists of more than one attribute is called a) Composite key b) Global Key c) Foreign key d) Multivalued key 7 / 37 7. An attribute in relation used as the primary key of another relation in the same database is called a) Global key b) Foreign key c) Link key d) Logic Key 8 / 37 8. A candidate key is: a) An attribute or group of attributes that can be the primary key b) Primary key c) The primary key selected to be the key of a relation d) All 9 / 37 9. Which field is the most appropriate primary key? a) NIC Number b) Address c) Name d) Birth Date 10 / 37 10. Which of the following can be a primary key a) Last name b) Salary c) Customer ID d) Region 11 / 37 11. How many primary keys can a table have? a) any b) 1 to 5 c) 1 d) 1 or 2 12 / 37 12. Which of the following is NOT a good primary key? a) Zip code b) Student ID number c) Order number d) Social security number 13 / 37 13. Which of the following describes the primary key? a) It helps in indexing of a large database b) It must be unique c) All of the above d) It makes sorting quicker 14 / 37 14. A key is: a) the first field of a relation b) the last field of a relation c) the most important field in a record d) none of these 15 / 37 15. Which of the following are properties of relations? a) There are no multivalued attributes in a relation b) All of the above c) Each attribute has a unique name d) No two rows in a relation are identical 16 / 37 16. An index can used to: a) Reduce data dependency for application programs b) All c) Document the structure of the database d) Improve the performance of the database 17 / 37 17. Which of the following is NOT a characteristic of relations? a) The order of rows is insignificant b) The order of columns is significant c) Columns are all elemental or atomic d) Each row is unique 18 / 37 18. The data or information that describes an entity is called: a) Data item b) Attribute c) Data item d) Tuple 19 / 37 19. A person, place, thing or event about which data is kept in the database is called a) Record b) Attribute c) Entity d) Field 20 / 37 20. A row of a relation is called: a) Attribute b) Tuple c) a and c d) Tuple 21 / 37 21. A relation is also known as: a) Tuple b) Table c) Relationship d) Attribute 22 / 37 22. An attribute is also known as a: a) Table b) Relation c) Row d) Field 23 / 37 23. A table is a two-dimensional structure that consists of: a) Matrix elements b) Intersection of data c) Rows and columns d) x and y co-ordinates 24 / 37 24. A two-dimensional table of data is called: a) Relation b) Module c) Group d) Set 25 / 37 25. A table should have: a) Secondary key b) Sort key c) Primary key d) Composite key 26 / 37 26. The foreign key is found in: a) Pivot table b) Dependent table c) Index table d) Parent table 27 / 37 27. The Columns of a table correspond to a) Table b) Record c) Field d) Cell 28 / 37 28. SQL is used for: a) Data manipulation b) Data definition c) Data control d) All 29 / 37 29. CREATE command is used to create: a) Record b) View c) Report d) Query 30 / 37 30. A virtual table that is constructed from other tables is called: a) View b) Relation c) Table d) Tuple 31 / 37 31. The number of characters in fixed-length field is a) Constant b) 10 c) 100 d) Variable 32 / 37 32. The views are used: a) All of the above b) To hide columns c) To hide complex SQL statements d) To hide rows 33 / 37 33. Views are also called: a) Virtual tables b) Simple tables c) Actual Tables d) Complex tables 34 / 37 34. The SQL statement to create a view is: a) MAKE VIEWS b) SELECT VIEW c) CREATE VIEW d) INSERT VIEW 35 / 37 35. All the intersection of rows and columns must have: a) Single value b) Multiple values c) Constant value d) No value 36 / 37 36. The rows of a relation can be of order. a) Sorted b) Sorted c) Same d) Any 37 / 37 37. Insert command is used to insert: a) New record b) Dependencies c) View d) New table Your score is LinkedIn Facebook Twitter VKontakte 0% Restart quiz Send feedback Post Views: 82 Post navigation Federal Board 2nd year computer science MCQS Chapter Wise. English 2nd year Essays All Chapters MCQS Rawalpindi Board.
