Discussion
Home ‣ Computer Science ‣ Database Systems Comments
- Question
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 ;
- Correct Answer
- CREATE SCHEMA
- 1. 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
- 2. 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
- 3. 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
- 4. 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
- 5. 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
- 6. 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
- 7. 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
- 8. The vice-president of information has primary responsibility for
Options- A. recognizing information needs
- B. preparing an MIS study proposal
- C. setting MIS objectives
- D. establishing MIS constraints
- E. None of the above Discuss
- 9. The manager attempts to slow down the flow of
Options- A. machines
- B. material
- C. money
- D. All of the above
- E. None of the above Discuss
- 10. A central purpose of most decision-support systems is
Options- A. to build a model of the decisionŽmaking problem
- B. to design a data-base manageŽment system
- C. to build an expert system
- D. to determine the key decisions in the problem area
- E. None of the above Discuss
Database Systems problems
Search Results
Correct Answer: All of the above
Correct Answer: All of the above
Correct Answer: ALTER TABLE
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: It provides summary reports without details
Correct Answer: both (a) and (b)
Correct Answer: preparing an MIS study proposal
Correct Answer: machines
Correct Answer: to build a model of the decisionŽmaking problem
Comments
There are no comments.More in Computer Science:
Programming
Copyright ĐCuriousTab. All rights reserved.