Discussion
Home ‣ Computer Science ‣ Database Systems Comments
- Question
The PROJECT command will create new table that has
Options- A. more fields than the original table
- B. more rows than the original table
- C. both (a) and (b)
- D. all the fields of master table
- E. None of the above
- Correct Answer
- None of the above
- 1. Which of the following is not a relational database?
Options- A. dBASE IV
- B. 4th Dimension
- C. FoxPro
- D. Reflex
- E. None of the above Discuss
- 2. The relational model uses some unfamiliar terminology. A tuple is equivalent to a:
Options- A. record
- B. field
- C. file
- D. data base
- E. data item Discuss
- 3. To have a file hold a list, it is necessary to
Options- A. identify the records in the list
- B. identify the name, width and type of the fields of each record.
- C. decide which fields will be used as sort or index keys
- D. All of the above
- E. None of the above Discuss
- 4. Data item characteristics that are important in data management include
Options- A. punctuation
- B. language
- C. spelling
- D. width
- E. None of the above Discuss
- 5. Which of the following is a database administrator's function?
Options- A. database design
- B. backing up the database
- C. performance monitoring
- D. user coordination
- E. All of the above Discuss
- 6. A top-to-bottom relationship among the items in a database is established by a
Options- A. Hierarchical schema
- B. Network schema
- C. Relational schema
- D. All of the above
- E. None of the above Discuss
- 7. If a calculation is embedded in a form
Options- A. the result of the calculations are stored with the form
- B. the calculations are stored with the form
- C. the result of the calculations are printed in report
- D. All of the above
- E. None of the above Discuss
- 8. If the record management system allows you to edit values before they are recorded on disk, you can
Options- A. correct spelling changes before they are recorded
- B. change the name of a field
- C. change the width of a field
- D. All of the above
- E. None of the above Discuss
- 9. When you have finished entering information into a form
Options- A. the template is written to the data file
- B. the contents of the form are written to the data file
- C. the contents of the form can be printed
- D. All of the above
- E. None of the above Discuss
- 10. Which command is used to remove an index from the database in SQL?
Options- A. DELETE INDEX
- B. DROP INDEX
- C. REMOVE INDEX
- D. ROLL BACK INDEX
- E. None of the above Discuss
Database Systems problems
Search Results
Correct Answer: Reflex
Correct Answer: record
Correct Answer: All of the above
Correct Answer: width
Correct Answer: All of the above
Correct Answer: Hierarchical schema
Correct Answer: the calculations are stored with the form
Correct Answer: correct spelling changes before they are recorded
Correct Answer: the contents of the form are written to the data file
Correct Answer: DROP INDEX
Comments
There are no comments.More in Computer Science:
Programming
Copyright ©CuriousTab. All rights reserved.