Discussion
Home ‣ Computer Science ‣ Database Systems Comments
- Question
A list in alphabetical order
Options- A. is in descending order
- B. is in ascending order
- C. is the result of a sort operation
- D. both (b) and (c)
- E. None of the above
- Correct Answer
- both (b) and (c)
- 1. Embedded pointer provide
Options- A. a secondary access path
- B. a physical record key
- C. an inverted index
- D. All of the above
- E. None of the above Discuss
- 2. A relational database management (RDBM) package manages data in more than one file at once. How does it organize these file? As
Options- A. tables
- B. relations
- C. tuple
- D. both (a) and (b)
- E. None of the above Discuss
- 3. A command that lets you change one or more fields in a record is
Options- A. Insert
- B. Modify
- C. Look-up
- D. All of the above
- E. None of the above Discuss
- 4. If a piece of data is stored in two places in the database, then
Options- A. storage space is wasted
- B. changing the data is one spot will cause data inconsistency
- C. it can be more easily accessed
- D. both (a) and (b)
- E. None of the above Discuss
- 5. In SQL, which command is used to select only one copy of each set of duplicable rows
Options- A. SELECT DISTINCT
- B. SELECT UNIQUE
- C. SELECT DIFFERENT
- D. All of the above
- E. None of the above Discuss
- 6. 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
- 7. 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
- 8. 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
- 9. 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
- 10. 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
Database Systems problems
Search Results
Correct Answer: a secondary access path
Correct Answer: both (a) and (b)
Correct Answer: Modify
Correct Answer: both (a) and (b)
Correct Answer: SELECT DISTINCT
Correct Answer: Index
Correct Answer: an orderly collection of data items
Correct Answer: SELECT
Correct Answer: creating the physical and logical designs
Correct Answer: All of the above
Comments
There are no comments.More in Computer Science:
Programming
Copyright ©CuriousTab. All rights reserved.