Discussion
Home ‣ Computer Science ‣ Database Systems Comments
- Question
The _____ command is used to allocates an extent for the table in SQL
Options- A. MODIFY ALLOCATES
- B. MODIFY TABLE
- C. ALTER TABLE
- D. REDEFINE TABLE
- E. None of the above
- Correct Answer
- MODIFY ALLOCATES
- 1. What software packages are commonly used for businesses that have to track extensive lists of clients and inventory?
Options- A. Special purpose packages
- B. Custom made programs
- C. Single function application packages
- D. Data management packages
- E. None of the above Discuss
- 2. The modify operation is likely to be done after
Options- A. Delete
- B. Look-up
- C. Insert
- D. All of the above
- E. None of the above Discuss
- 3. Versatile report generators can provide
Options- A. Columnar totals
- B. Subtotals
- C. Calculations
- D. All of the above
- E. None of the above Discuss
- 4. In SQL, which command is used to remove a stored function from the database?
Options- A. REMOVE FUNCTION
- B. DELETE FUNCTION
- C. DROP FUNCTION
- D. ERASE FUNCTION
- E. None of the above Discuss
- 5. One approach to standardizing storing of data
Options- A. MIS
- B. structured programming
- C. CODASYL specifications
- D. All of the above
- E. None of the above Discuss
- 6. Data encryption techniques are particularly useful for
Options- A. reducing storage space requirements
- B. improving data integrity
- C. protecting data in data communication systems
- D. All of the above
- E. None of the above Discuss
- 7. In order to use a record management system
Options- A. You need to understand the low-level details of how information in stored
- B. You need to understand the model the record management system uses.
- C. Both (a) and (b)
- D. All of the above
- E. None of the above Discuss
- 8. A logical schema
Options- A. is the entire database
- B. is a standard way of organizing information into accessible parts
- C. describes how data is actually stored on disk
- D. All of the above
- E. None of the above Discuss
- 9. The activity of a file
Options- A. is a low percentages of number of records added or deleted from a file
- B. if high, reduces processing efficiency for sequential and nonsequential files
- C. is a measure of the percentage of existing records updated during a run
- D. refers to how closely the files fits into the allocated
- E. None of the above. Discuss
- 10. Data items grouped together for storage purposes are called a
Options- A. record
- B. title
- C. list
- D. string
- E. None of the above Discuss
Database Systems problems
Search Results
Correct Answer: Data management packages
Correct Answer: Look-up
Correct Answer: All of the above
Correct Answer: DROP FUNCTION
Correct Answer: CODASYL specifications
Correct Answer: protecting data in data communication systems
Correct Answer: You need to understand the model the record management system uses.
Correct Answer: is a standard way of organizing information into accessible parts
Correct Answer: is a low percentages of number of records added or deleted from a file
Correct Answer: record
Comments
There are no comments.More in Computer Science:
Programming
Copyright ©CuriousTab. All rights reserved.