Discussion
Home ‣ Computer Science ‣ Database Systems Comments
- Question
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
- Correct Answer
- ALTER TABLE
- 1. 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
- 2. 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
- 3. 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
- 4. 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
- 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
- 6. Goals for the design of the logical schema include
Options- A. avoiding data inconsistency
- B. being able to construct queries easily
- C. being able to access data efficiently
- D. All of the above
- E. None of the above Discuss
- 7. Information can be transferred between the DBMS and a
Options- A. spreadsheet program
- B. word processor program
- C. graphics program
- D. All of the above
- E. None of the above Discuss
- 8. In SQL, which command(s) is(are) used to issue multiple CREATE TABLE, CREATE VIEW, and GRANT statements in a single transaction?
Options- A. CREATE PACKAGE
- B. CREATE SCHEMA
- C. CREATE CLUSTER
- D. All of the above
- E. None of the above ; Discuss
- 9. In which way is a managerial information system (MIS) superior to electronic data processing (EDP)?
Options- A. It is batch oriented
- B. It is most cost effective
- C. It provides summary reports without details
- D. All of the above
- E. None of the above Discuss
- 10. A turnaround document can be a (n)
Options- A. punched card
- B. OCR document
- C. both (a) and (b)
- D. neither (a) nor (b)
- E. None of the above Discuss
Database Systems problems
Search Results
Correct Answer: All of the above
Correct Answer: has the data dictionary keep the date and time of last access last back-up, and most recent modification for all files
Correct Answer: All of the above
Correct Answer: Database management system (DBMS)
Correct Answer: Database administrator
Correct Answer: All of the above
Correct Answer: All of the above
Correct Answer: CREATE SCHEMA
Correct Answer: It provides summary reports without details
Correct Answer: both (a) and (b)
Comments
There are no comments.More in Computer Science:
Programming
Copyright ©CuriousTab. All rights reserved.