Database Systems problems
- 1. In SQL, which command(s) is(are) used to recompile a stored function?
Options- A. SET FUNCTION
- B. SET STORED FUNCTION
- C. ALTER FUNCTION
- D. All of the above
- E. None of the above Discuss
Correct Answer: ALTER FUNCTION
- 2. In SQL, the command(s) is(are) used to create an index for a table or cluster
Options- A. CREATE INDEX
- B. MODIFY INDEX
- C. SET INDEX TO FILE
- D. All of the above
- E. None of the above Discuss
Correct Answer: CREATE INDEX
- 3. In order to use a DBMS, it is important to understand
Options- A. the physical schema
- B. all sub-schemas that the system supports
- C. one subschema
- D. both (a) and (b)
- E. None of the above Discuss
Correct Answer: one subschema
- 4. Report generators are used to
Options- A. store data input by a user
- B. retrieve information from files
- C. answer queries
- D. both (b) and (c)
- E. None of the above Discuss
Correct Answer: both (b) and (c)
- 5. Administrate supervision of database activities is the responsibility of the
Options- A. Database administrator
- B. DP Manager
- C. DB Manager
- D. DP administration
- E. None of the above Discuss
Correct Answer: Database administrator
- 6. 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?
Options- A. Data storage system
- B. Database management system (DBMS)
- C. Batch processing system
- D. Data communication package
- E. None of the above Discuss
Correct Answer: Database management system (DBMS)
- 7. Subschema can be used to
Options- A. create very different, personalized views of the same data
- B. present information in different formats
- C. hide sensitive information by omitting fields from the sub¬schema's description
- D. All of the above
- E. None of the above Discuss
Correct Answer: All of the above
- 8. Data integrity control
Options- 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 Discuss
Correct Answer: has the data dictionary keep the date and time of last access last back-up, and most recent modification for all files
- 9. Database management systems are intended to:
Options- A. eliminate data redundancy
- B. establish relationships among records in different files
- C. manage file access
- D. maintain data integrity
- E. All of the above Discuss
Correct Answer: All of the above
- 10. In SQL, which command(s) is(are) used to change a table's storage characteristics?
Options- A. ALTER TABLE
- B. MODIFY TABLE
- C. CHANGE TABLE
- D. All of the above
- E. None of the above Discuss
Correct Answer: ALTER TABLE
More in Computer Science:
Programming
Copyright ©CuriousTab. All rights reserved.