Database Systems – Section 4


Warning: Undefined variable $ext in /www/wwwroot/gkfeed.com/public_html/wp-content/plugins/show-hidecollapse-expand/bg_show_hide.php on line 281

Warning: Undefined variable $ext in /www/wwwroot/gkfeed.com/public_html/wp-content/plugins/show-hidecollapse-expand/bg_show_hide.php on line 281

Warning: Undefined variable $ext in /www/wwwroot/gkfeed.com/public_html/wp-content/plugins/show-hidecollapse-expand/bg_show_hide.php on line 281

Warning: Undefined variable $ext in /www/wwwroot/gkfeed.com/public_html/wp-content/plugins/show-hidecollapse-expand/bg_show_hide.php on line 281

Warning: Undefined variable $ext in /www/wwwroot/gkfeed.com/public_html/wp-content/plugins/show-hidecollapse-expand/bg_show_hide.php on line 281

1. In SQL, the command(s) is(are) used to create an index for a table or cluster

A. CREATE INDEX
B. MODIFY INDEX
C. SET INDEX TO FILE
D. All of the above
E. None of the above

Correct Answer: A. CREATE INDEX
Advertisement

2. There are certain packages that allow people to define data items, place these items in particular records, combine the records into designated files and then manipulate and retrieve the stored data. What are they called?

A. Data storage system
B. Database management system (DBMS)
C. Batch processing system
D. Data communication package
E. None of the above

Correct Answer: B. Database management system (DBMS)
Advertisement

3. A _____ DBMS distributes data processing tasks between the workstation and a network server.

A. Network
B. Relational
C. Client Server
D. Hierarchical
E. None of the above.

Correct Answer: C. Client Server
Advertisement

4. Information can be transferred between the DBMS and a

A. spreadsheet program
B. word processor program
C. graphics program
D. All of the above
E. None of the above

Correct Answer: D. All of the above
Advertisement

5. Data integrity control

A. is used to set upper and lower limits on numeric data
B. requires the use of passwords to prohibit unauthorized access to the file
C. has the data dictionary keep the date and time of last access last back-up, and most recent modification for all files
D. All of the above
E. None of the above

Correct Answer: C. has the data dictionary keep the date and time of last access last back-up, and most recent modification for all files
Advertisement

Warning: Undefined variable $in_same_cat in /www/wwwroot/gkfeed.com/public_html/wp-content/plugins/EXP.GKFEED.COM/function.php on line 27

Warning: Undefined variable $excluded_categories in /www/wwwroot/gkfeed.com/public_html/wp-content/plugins/EXP.GKFEED.COM/function.php on line 27

Leave A Comment?