{"id":178,"date":"2020-04-05T06:59:37","date_gmt":"2020-04-05T06:59:37","guid":{"rendered":"https:\/\/temp.ashkerala.com\/?p=178"},"modified":"2020-04-05T06:59:37","modified_gmt":"2020-04-05T06:59:37","slug":"database-management-system-and-design-mcq-1","status":"publish","type":"post","link":"https:\/\/temp.ashkerala.com\/?p=178","title":{"rendered":"Database Management System and Design mcq-1"},"content":{"rendered":"<p>Questions 1:<\/p>\n<p> The ascending order of a data hirerchy is:<\/p>\n<p> a. bit-byte-record-field-file-database<\/p>\n<p> b. byte-bit-field-record-file-database<\/p>\n<p> c. bit-byte-field-record-file-database<\/p>\n<p> d. bit-byte-file-record-field-database<\/p>\n<p> \u00a0<br \/> Question 2:<\/p>\n<p> Which of the following is true of a network structure?<\/p>\n<p> a. t is a physical representation of the data<\/p>\n<p> b. It allows a many-to-many relationship<\/p>\n<p> c. It is conceptually simple<\/p>\n<p> d. It will be dominant data base of the future<\/p>\n<p> \u00a0<br \/> Question 3:<\/p>\n<p> Which of the following is a problem of file management system?<\/p>\n<p> a. difficult to update<\/p>\n<p> b. lack of data independence<\/p>\n<p> c. data redundancy<\/p>\n<p> d. program dependence<\/p>\n<p> e. all of above<\/p>\n<p> \u00a0<br \/> Question 4:<\/p>\n<p> One data dictionery software package is called<\/p>\n<p> a. DB\/DC dictionary<\/p>\n<p> b. TOTAL<\/p>\n<p> c. ACCESS<\/p>\n<p> d. Datapac<\/p>\n<p> e. Data Manager<\/p>\n<p> \u00a0<br \/> Question 5:<\/p>\n<p> The function of a database is &#8230;<\/p>\n<p> a. to check all input data<\/p>\n<p> b. to check all spelling<\/p>\n<p> c. to collect and organize input data<\/p>\n<p> d. to output data<\/p>\n<p> \u00a0<br \/> Question 6:<\/p>\n<p> What is the language used by most of the DBMSs for helping their users to access data?<\/p>\n<p> a. High level language<\/p>\n<p> b. SQL<\/p>\n<p> c. Query Language<\/p>\n<p> d. 4GL<\/p>\n<p> \u00a0<br \/> Question 7:<\/p>\n<p> The model for a record management system might be<\/p>\n<p> a. handwritten list<\/p>\n<p> b. a Rolodex card file<\/p>\n<p> c. a business form<\/p>\n<p> d. all of above<\/p>\n<p> \u00a0<br \/> Question 8:<\/p>\n<p> Primitive operations common to all record management system include<\/p>\n<p> a. print<\/p>\n<p> b. sort<\/p>\n<p> c. look-up<\/p>\n<p> d. all of above<\/p>\n<p> \u00a0<br \/> Question 9:<\/p>\n<p> In a large DBMS<\/p>\n<p> a. each user can &#8220;see&#8221; only a small part of the entire database<\/p>\n<p> b. each subschema contains every field in the logical schema<\/p>\n<p> c. each user can access every subschema<\/p>\n<p> \u00a0<br \/> Question 10:<\/p>\n<p> Information can be transferred between the DBMS and a<\/p>\n<p> a. spreadsheet program<\/p>\n<p> b. word processor program<\/p>\n<p> c. graphics program<\/p>\n<p> d. all of the above<\/p>\n<p> \u00a0<\/p>\n<p> \u00a0<\/p>\n<p> Answers:<\/p>\n<p> 1. c\u00a0\u00a0\u00a0 2. b\u00a0\u00a0\u00a0 3. e\u00a0\u00a0\u00a0\u00a0 4. a\u00a0\u00a0\u00a0\u00a0 5. c\u00a0\u00a0\u00a0 6. c\u00a0\u00a0\u00a0\u00a0 7. d\u00a0\u00a0\u00a0 8. c\u00a0\u00a0\u00a0\u00a0 9. a\u00a0\u00a0\u00a0\u00a0 10. d<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Questions 1: The ascending order of a data hirerchy is: a. bit-byte-record-field-file-database b. byte-bit-field-record-file-database c. bit-byte-field-record-file-database d. bit-byte-file-record-field-database \u00a0 Question 2: Which of the following is true of a network structure? a. t is a physical representation of the data b. It allows a many-to-many relationship c. It is conceptually simple d. It will be&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_kad_post_transparent":"","_kad_post_title":"","_kad_post_layout":"","_kad_post_sidebar_id":"","_kad_post_content_style":"","_kad_post_vertical_padding":"","_kad_post_feature":"","_kad_post_feature_position":"","_kad_post_header":false,"_kad_post_footer":false,"footnotes":""},"categories":[17],"tags":[],"class_list":["post-178","post","type-post","status-publish","format-standard","hentry","category-database-management-system-and-design"],"_links":{"self":[{"href":"https:\/\/temp.ashkerala.com\/index.php?rest_route=\/wp\/v2\/posts\/178","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/temp.ashkerala.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/temp.ashkerala.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/temp.ashkerala.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/temp.ashkerala.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=178"}],"version-history":[{"count":0,"href":"https:\/\/temp.ashkerala.com\/index.php?rest_route=\/wp\/v2\/posts\/178\/revisions"}],"wp:attachment":[{"href":"https:\/\/temp.ashkerala.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=178"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/temp.ashkerala.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=178"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/temp.ashkerala.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=178"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}