Discussion
Home ‣ Computer Science ‣ Database Systems Comments
- Question
Which of the following command(s) is(are) used to recompile a stored procedure in SQL?
Options- A. COMPILE PROCEDURE
- B. ALTER PROCEDURE
- C. MODIFY PROCEDURE id) All of the above
- D. None of the above
- Correct Answer
- ALTER PROCEDURE
- 1. In SQL, which command(s) is(are) used to redefine an index's future storage allocation
Options- A. ALTER INDEX
- B. REDEFINE INDEX
- C. MODIFY INDEX
- D. DO INDEX
- E. None of the above Discuss
- 2. Long-range planning report produced in an MIS are primarily designed for
Options- A. top management
- B. middle management
- C. lower management
- D. All of the above
- E. None of the above Discuss
- 3. The index consists of
Options- A. a list of keys
- B. pointers to the master list
- C. both (a) and (b)
- D. All of the above
- E. None of the above Discuss
- 4. A _____ database does not use pointers or physical links, but instead finds related records by examining the contents of fields.
Options- A. Network
- B. Hierarchical
- C. Relational
- D. Object-Oriented
- E. None of the above Discuss
- 5. In a relational schema, each tuple is divided into fields called
Options- A. Relations
- B. Domains
- C. Queries
- D. All of the above
- E. None of the above Discuss
- 6. The model for a record management system might be
Options- A. handwritten list
- B. a Rolodex card file
- C. a business form
- D. All of the above
- E. None of the above Discuss
- 7. Which of the following is not true of the traditional approach to information processing?
Options- A. There is common sharing of data among the various applications
- B. It is file-oriented
- C. Programs are dependent on the files
- D. It is inflexible
- E. All of the above are true Discuss
- 8. A data dictionary is a special file that contains
Options- A. the names of all fields in all files
- B. the data types of all fields in all files
- C. the widths of all fields in all files
- D. All of the above
- E. None of the above Discuss
- 9. A data dictionary doesn't provide information about:
Options- A. where data is located
- B. the size of the disk storage device
- C. It allows a many-to-many relationship
- D. It is conceptually simple
- E. It will be the dominant data base of the future Discuss
- 10. In SQL, the _____ command is used to recompile a view
Options- A. COMPILE VIEW
- B. DEFINE VIEW
- C. CREATE VIEW
- D. ALTER VIEW
- E. None of the above Discuss
Database Systems problems
Search Results
Correct Answer: ALTER INDEX
Correct Answer: top management
Correct Answer: both (a) and (b)
Correct Answer: Relational
Correct Answer: Domains
Correct Answer: All of the above
Correct Answer: There is common sharing of data among the various applications
Correct Answer: All of the above
Correct Answer: the size of the disk storage device
Correct Answer: ALTER VIEW
Comments
There are no comments.More in Computer Science:
Programming
Copyright ©CuriousTab. All rights reserved.