Discussion
Home ‣ Computer Science ‣ Database Systems Comments
- Question
The database administration function includes
Options- A. application programming
- B. computer operations management
- C. database access planning
- D. All of the above
- E. None of the above
- Correct Answer
- database access planning
- 1. A condition that led to the development of databases was
Options- A. a demand for more data to support information needs
- B. an increase in the amount of data handled by organizations
- C. the proliferation of data files
- D. All of the above
- E. None of the above. Discuss
- 2. Which of the following is not the responsibility of the utilities component of DBMS software?
Options- A. creating the physical and logical designs
- B. removing flagged records for deletion
- C. creating and maintaining the data dictionary
- D. monitoring performance
- E. None of the above Discuss
- 3. In SQL, which command is used to select data in rows and column from one or more tables?
Options- A. CHOOSE
- B. SELECT
- C. LIST
- D. BROWSE
- E. None of the above Discuss
- 4. A computer file can be best described as
Options- A. a single data item
- B. a general collection of data items
- C. an orderly collection of data items
- D. a random collection of data items
- E. None of the above Discuss
- 5. If you want to organize a file in multiple ways, it is better to _____ the data rather than to sort it.
Options- A. Delete
- B. Update
- C. Sort Key
- D. Index
- E. None of the above Discuss
- 6. The term _____ is sometimes used to refer to a data file in which all the records have the same record format, that is, the same field names, field lengths, and data types.
Options- A. Database
- B. Table
- C. Flat file
- D. Data structure
- E. None of the above Discuss
- 7. In SQL, the CREATE TABLESPACE is used
Options- A. to create a place in the database for storage of scheme objects, rollback segments, and naming the data files to comprise the tablespace
- B. to create a database trigger
- C. to add/rename data files, to change storage
- D. All of the above
- E. None of the above Discuss
- 8. A scheme describes
Options- A. data elements
- B. records and files
- C. record relationships
- D. All of the above
- E. None of the above Discuss
- 9. The master list of an indexed file
Options- A. is sorted in ascending order
- B. contains only a list of keys and record numbers
- C. has a number assigned to each record
- D. both (b) and (c)
- E. None of the above Discuss
- 10. Which language has recently become the de-facto standard for interfacing application programs with relational database system?
Options- A. Oracle
- B. SQL
- C. dBASE
- D. 4GL
- E. None of the above Discuss
Database Systems problems
Search Results
Correct Answer: All of the above
Correct Answer: creating the physical and logical designs
Correct Answer: SELECT
Correct Answer: an orderly collection of data items
Correct Answer: Index
Correct Answer: Flat file
Correct Answer: to create a place in the database for storage of scheme objects, rollback segments, and naming the data files to comprise the tablespace
Correct Answer: All of the above
Correct Answer: has a number assigned to each record
Correct Answer: SQL
Comments
There are no comments.More in Computer Science:
Programming
Copyright ©CuriousTab. All rights reserved.