Discussion
Home ‣ Computer Science ‣ Database Systems Comments
- Question
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
- Correct Answer
- subschema
- 1. An audit trail
Options- A. is used to make back-up copies
- B. is the recorded history of operations performed on a file
- C. can be used to restore lost information
- D. All of the above
- E. None of the above Discuss
- 2. The designer of a form includes
Options- A. filed designators
- B. prompts
- C. data
- D. both (a) and (b)
- E. None of the above Discuss
- 3. In a large DBMS
Options- A. each user can "see" only a small part of the entire database
- B. each user can access every sub¬schema
- C. each subschema contains every field in the logical schema
- D. All of the above
- E. None of the above Discuss
- 4. An indexing operation
Options- A. sorts a file using a single key
- B. sorts file using two keys
- C. establishes an index for a file
- D. both (b) and (c)
- E. None of the above Discuss
- 5. In SQL, which command is used to add a column/integrity constraint to a table
Options- A. ADD COLUMN
- B. INSERT COLUMN
- C. MODIFY TABLE
- D. ALTER TABLE
- E. None of the above Discuss
- 6. 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
- 7. 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
- 8. 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
- 9. 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
- 10. 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
Database Systems problems
Search Results
Correct Answer: is the recorded history of operations performed on a file
Correct Answer: both (a) and (b)
Correct Answer: each user can "see" only a small part of the entire database
Correct Answer: establishes an index for a file
Correct Answer: ALTER TABLE
Correct Answer: Network database
Correct Answer: to define a view of one or more tables or views
Correct Answer: ALTER TABLE
Correct Answer: Database
Correct Answer: All of the above
Comments
There are no comments.More in Computer Science:
Programming
Copyright ©CuriousTab. All rights reserved.