Discussion
Home ‣ Computer Science ‣ Database Systems Comments
- Question
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
- Correct Answer
- ALTER VIEW
- 1. 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
- 2. 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
- 3. 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
- 4. 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
- 5. 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 Discuss
- 6. Which of the following is a type of DBMS software?
Options- A. database manipulation language
- B. query language
- C. utilities
- D. report writer
- E. All of the above Discuss
- 7. In SQL, the CREATE TABLE is used
Options- A. to create a table, defining its columns, integrity constrains, and storage allocation
- B. to add a column/integrity constraint to a table
- C. to redefine a column
- D. to change a table's storage characteristics
- E. All of the above Discuss
- 8. The physical location of a record is determined by a mathematical formula that transforms a file key into a record location in
Options- A. a tree file
- B. an indexed file
- C. a hashed file
- D. a sequential file
- E. None of the above Discuss
- 9. Which command is used to select distinct subject (SUB) from the table (BOOK)?
Options- A. SELECT ALL FROM BOOK
- B. SELECT DISTINCT SUB FROM BOOK
- C. SELECT SUB FROM BOOK
- D. All of the above
- E. None of the above Discuss
- 10. One approach to standardizing storing of data
Options- A. MIS
- B. structured programming
- C. CODASYL specifications
- D. All of the above
- E. None of the above Discuss
Database Systems problems
Search Results
Correct Answer: the size of the disk storage device
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: ALTER PROCEDURE
Correct Answer: database manipulation language
Correct Answer: to create a table, defining its columns, integrity constrains, and storage allocation
Correct Answer: a hashed file
Correct Answer: SELECT DISTINCT SUB FROM BOOK
Correct Answer: CODASYL specifications
Comments
There are no comments.More in Computer Science:
Programming
Copyright ©CuriousTab. All rights reserved.