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