Database Systems – Section 3


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

46. In SQL, the CREATE TABLESPACE is used

A. to create a place in the database for storage of scheme objects, rollback segments, and naming the data files to comprise the tablespace
B. to create a database trigger
C. to add/rename data files, to change storage
D. All of the above
E. None of the above

Correct Answer: A. to create a place in the database for storage of scheme objects, rollback segments, and naming the data files to comprise the tablespace
Advertisement

47. In SQL, which command is used to remove a stored function from the database?

A. REMOVE FUNCTION
B. DELETE FUNCTION
C. DROP FUNCTION
D. ERASE FUNCTION
E. None of the above

Correct Answer: C. DROP FUNCTION
Advertisement

48. The database administration function includes

A. application programming
B. computer operations management
C. database access planning
D. All of the above
E. None of the above

Correct Answer: C. database access planning
Advertisement

49. A relational database management (RDBM) package manages data in more than one file at once. How does it organize these file? As

A. tables
B. relations
C. tuple
D. both (a) and (b)
E. None of the above

Correct Answer: D. both (a) and (b)
Advertisement

50. A command that lets you change one or more fields in a record is

A. Insert
B. Modify
C. Look-up
D. All of the above
E. None of the above

Correct Answer: B. Modify
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?