Questions 1:<\/p>\n
Which of the following fields in a student file can be used as a primary key?<\/p>\n
a. class<\/p>\n
b. Social Security Number<\/p>\n
c. GPA<\/p>\n
d. Major<\/p>\n
\u00a0
Question 2:<\/p>\n
Which of the following is not an advantage of the database approach<\/p>\n
a. Elimination of data redundancy<\/p>\n
b. Ability of associate deleted data<\/p>\n
c. increased security<\/p>\n
d. program\/data independence<\/p>\n
e. all of the above<\/p>\n
\u00a0
Question 3:<\/p>\n
Which of the following contains a complete record of all activity that affected the contents of a database during a certain period of time?<\/p>\n
a. report writer<\/p>\n
b. query language<\/p>\n
c. data manipulation language<\/p>\n
d. transaction log<\/p>\n
e. none of the above<\/p>\n
\u00a0
Question 4:<\/p>\n
In the DBMS approach, application programs perform the<\/p>\n
a. storage function<\/p>\n
b. processing functions<\/p>\n
c. access control<\/p>\n
d. all of the above<\/p>\n
e. none of the above<\/p>\n
\u00a0
Question 5:<\/p>\n
A set of programs that handle a firm’s database responsibilities is called<\/p>\n
a. database management system (DBMS)<\/p>\n
b. database processing system (DBPS)<\/p>\n
c. data management system (DMS)<\/p>\n
d. all of above<\/p>\n
\u00a0
Question 6:<\/p>\n
Which is the make given to the database management system which is able to handle full text data, image data, audio and video?<\/p>\n
a. full media<\/p>\n
b. graphics media<\/p>\n
c. multimedia<\/p>\n
d. hypertext<\/p>\n
\u00a0
Question 7:<\/p>\n
A record management system<\/p>\n
a. can handle many files of information at a time<\/p>\n
b. can be used to extract information stored in a computer file<\/p>\n
c. always uses a list as its model<\/p>\n
d. both a and b<\/p>\n
\u00a0
Question 8:<\/p>\n
A command that lets you change one or more fields in a record is<\/p>\n
a. insert<\/p>\n
b. modify<\/p>\n
c. lookup<\/p>\n
d. none of above<\/p>\n
\u00a0
Question 9:<\/p>\n
A transparent DBMS<\/p>\n
a. can not hide sensitive information from users<\/p>\n
b. keeps its logical structure hidden from users<\/p>\n
c. keeps its physical structure hidden from users<\/p>\n
d. both b and c<\/p>\n
\u00a0
Question 10:<\/p>\n
A file produced by a spreadsheet<\/p>\n
a. is generally stored on disk in an ASCII text fromat<\/p>\n
b. can be used as is by the DBMS<\/p>\n
c. both a and b<\/p>\n
d. none of the above<\/p>\n
\u00a0<\/p>\n
\u00a0<\/p>\n
Answers:<\/p>\n
1.b\u00a0\u00a0\u00a0\u00a0 2.e\u00a0\u00a0\u00a0\u00a0 3.d\u00a0\u00a0\u00a0\u00a0\u00a0 4.b\u00a0\u00a0\u00a0\u00a0\u00a0 5.d\u00a0\u00a0\u00a0\u00a0 6.c\u00a0\u00a0\u00a0\u00a0\u00a0 7.b\u00a0\u00a0\u00a0\u00a0 8.b\u00a0\u00a0\u00a0\u00a0\u00a0 9.c\u00a0\u00a0\u00a0\u00a0\u00a0 10.a<\/p>\n","protected":false},"excerpt":{"rendered":"
Questions 1: Which of the following fields in a student file can be used as a primary key? a. class b. Social Security Number c. GPA d. Major \u00a0 Question 2: Which of the following is not an advantage of the database approach a. Elimination of data redundancy b. Ability of associate deleted data c….<\/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-179","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\/179","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=179"}],"version-history":[{"count":0,"href":"https:\/\/temp.ashkerala.com\/index.php?rest_route=\/wp\/v2\/posts\/179\/revisions"}],"wp:attachment":[{"href":"https:\/\/temp.ashkerala.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=179"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/temp.ashkerala.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=179"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/temp.ashkerala.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=179"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}