Discussion
Home ‣ Computer Science ‣ Database Systems Comments
- Question
Which two files are used during operation of the DBMS?
Options- A. query language and utilities
- B. data manipulation language and query language
- C. data dictionary and transaction log
- D. data dictionary and query language
- E. None of the above
- Correct Answer
- data dictionary and transaction log
- 1. The main idea behind computer files is that it is convenient to
Options- A. arrange them
- B. store information together
- C. create them
- D. access them
- E. None of the above Discuss
- 2. A list consists of last names, first names, addresses, and pin codes if all people in the list have the same last and the same pin code, a useful key would be
Options- A. the pin code
- B. the last name
- C. a compound key consisting of the first name and the last name
- D. All of the above
- E. None of the above Discuss
- 3. The Management Information system (MIS) structure with one main computer system is called a
Options- A. hierarchical MIS structure
- B. distributed MIS structure
- C. centralized MIS structure
- D. decentralized MIS structure
- E. None of the above Discuss
- 4. A number of related records that are treated as a unit is called
Options- A. file
- B. field
- C. data
- D. batch
- E. None of the above Discuss
- 5. What is the name given to the database management system which is able to handle full text data, image data, audio and video?
Options- A. Full media
- B. Graphics media
- C. Multimedia
- D. Hypertext
- E. None of the above Discuss
- 6. The logical data structure with a one-to-many relationship is a :
Options- A. network
- B. tree
- C. chain
- D. relational
- E. None of the above Discuss
- 7. In SQL, GRANT command is used to
Options- A. allow user to access databases
- B. allow user to create databases
- C. grant system privileges, roles, and object privileges to uses and roles
- D. choose auditing for specific SQL commands
- E. None of the above Discuss
- 8. 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
- 9. 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
- 10. 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
Database Systems problems
Search Results
Correct Answer: store information together
Correct Answer: a compound key consisting of the first name and the last name
Correct Answer: centralized MIS structure
Correct Answer: file
Correct Answer: Multimedia
Correct Answer: tree
Correct Answer: grant system privileges, roles, and object privileges to uses and roles
Correct Answer: All of the above
Correct Answer: width
Correct Answer: All of the above
Comments
There are no comments.More in Computer Science:
Programming
Copyright ©CuriousTab. All rights reserved.