Database Systems problems
- 1. The way a particular application views the data from the data base that the application uses is a :
Options- A. module
- B. relational model
- C. schema
- D. subschema
- E. None of the above Discuss
Correct Answer: subschema
- 2. The model for a _____ resembles the hierarchical model in many respects.
Options- A. Network database
- B. Relational database
- C. Distributed database
- D. Hierarchical database
- E. None of the above Discuss
Correct Answer: Network database
- 3. In SQL, the CREATE VIEW command is used
Options- A. to recompile view
- B. to define a view of one or more tables or views
- C. to recompile a table
- D. to create a trigger
- E. None of the above Discuss
Correct Answer: to define a view of one or more tables or views
- 4. Which command(s) is(are) used to redefine a column of the table in SQL?
Options- A. ALTER TABLE
- B. DEFINE TABLE
- C. MODIFY TABLE
- D. All of the above
- E. None of the above Discuss
Correct Answer: ALTER TABLE
- 5. What name is given to the collection of facts, items of information or data which are related in some way?
Options- A. Database
- B. Directory information
- C. Information tree
- D. Information provider
- E. None of the above Discuss
Correct Answer: Database
- 6. Which of the following is a serious problem of file management systems?
Options- A. difficult to update
- B. lack of data independence
- C. data redundancy
- D. program dependence
- E. All of the above Discuss
Correct Answer: All of the above
- 7. In SQL, which of the following is not a data Manipulation Language Commands?
Options- A. DELETE
- B. SELECT
- C. UPDATE
- D. CREATE
- E. None of the above Discuss
Correct Answer: CREATE
- 8. When performing a look-up operation using a form
Options- A. you enter the search value into the form
- B. you look at each form sequentially until you see the one you want
- C. you type the key in an entry line, and the correct form is displayed
- D. All of the above
- E. None of the above Discuss
Correct Answer: you enter the search value into the form
- 9. Which command(s) is(are) used to enable/disable/drop an integrity constraint in SQL?
Options- A. DEFINE TABLE
- B. MODIFY TABLE
- C. ALTER TABLE
- D. All of the above
- E. None of the above Discuss
Correct Answer: ALTER TABLE
- 10. The data-base environment has all of the following components except:
Options- A. users
- B. separate files
- C. data base
- D. data-base administrator
- E. None of the above Discuss
Correct Answer: separate files
More in Computer Science:
Programming
Copyright ©CuriousTab. All rights reserved.