Discussion
Home ‣ Computer Science ‣ Database Systems Comments
- Question
In SQL, the ALTER TABLESPACE command is used
Options- A. to add/rename data files
- B. to change storage characteristics
- C. to take a tablespace online/offline
- D. to begin/end a backup
- E. All of the above
- Correct Answer
- All of the above
- 1. The language used in application programs to request data from the DBMS is referred to as the
Options- A. DML
- B. DDL
- C. query language
- D. All of the above
- E. None of the above Discuss
- 2. If you want your database to include methods, you should use a _____ database.
Options- A. Network
- B. Distributed
- C. Hierarchical
- D. Object-Oriented
- E. None of the above Discuss
- 3. A computer file contains several records. What does each record contain?
Options- A. Bytes
- B. Words
- C. Fields
- D. Database
- E. None of the above Discuss
- 4. Data security threats include
Options- A. hardware failure
- B. privacy invasion
- C. fraudulent manipulation of data
- D. All of the above
- E. None of the above Discuss
- 5. With respect to data input, the most accurate description of batch control is
Options- A. dividing documents to be entered into batches
- B. controlling the input of each input clerk
- C. comparing to a pre-calculated figure the total of a data item summed across a batch records put into the system
- D. All of the above
- E. None of the above Discuss
- 6. Characteristic(s) of a distributed MIS structure is
Options- A. interactive sharing of the workload
- B. a multiprocessing environment
- C. computers supporting local DP operations
- D. All of the above
- E. None of the above Discuss
- 7. A ____ Contains the smallest unit of meaningful data, so you might call it the basic building block for a data file.
Options- A. File structure
- B. Records
- C. Fields
- D. Database
- E. None of the above Discuss
- 8. A _____ means that one record in a particular record type may be related to more than one record of another record type.
Options- A. One-to-one relationship
- B. One-to-many relationship
- C. Many-to-one relationship
- D. Many-to many relationship
- E. None of the above Discuss
- 9. In SQL, which command is used to add a column/integrity constraint to a table
Options- A. ADD COLUMN
- B. INSERT COLUMN
- C. MODIFY TABLE
- D. ALTER TABLE
- E. None of the above Discuss
- 10. An indexing operation
Options- A. sorts a file using a single key
- B. sorts file using two keys
- C. establishes an index for a file
- D. both (b) and (c)
- E. None of the above Discuss
Database Systems problems
Search Results
Correct Answer: DML
Correct Answer: Object-Oriented
Correct Answer: Fields
Correct Answer: privacy invasion
Correct Answer: comparing to a pre-calculated figure the total of a data item summed across a batch records put into the system
Correct Answer: All of the above
Correct Answer: Fields
Correct Answer: One-to-many relationship
Correct Answer: ALTER TABLE
Correct Answer: establishes an index for a file
Comments
There are no comments.More in Computer Science:
Programming
Copyright ©CuriousTab. All rights reserved.