Discussion
Home ‣ Computer Science ‣ Database Systems Comments
- Question
Which of the following is not an advantage of the data-base approach?
Options- A. elimination of the data redundancy
- B. ability to associate related data
- C. increased security
- D. program/data independence
- E. All of the above are advantages
- Correct Answer
- All of the above are advantages
- 1. 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
- 2. 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
- 3. 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
- 4. 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
- 5. 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
- 6. A _____ DBMS distributes data processing tasks between the workstation and a network server.
Options- A. Network
- B. Relational
- C. Client Server
- D. Hierarchical
- E. None of the above. Discuss
- 7. In SQL, which of the following is not a data definition language commands?
Options- A. RENAME
- B. REVOKE
- C. GRANT
- D. UPDATE
- E. None of the above Discuss
- 8. In SQL, which command(s) is(are) used to recompile a stored function?
Options- A. SET FUNCTION
- B. SET STORED FUNCTION
- C. ALTER FUNCTION
- D. All of the above
- E. None of the above Discuss
- 9. In SQL, the command(s) is(are) used to create an index for a table or cluster
Options- A. CREATE INDEX
- B. MODIFY INDEX
- C. SET INDEX TO FILE
- D. All of the above
- E. None of the above Discuss
- 10. In order to use a DBMS, it is important to understand
Options- A. the physical schema
- B. all sub-schemas that the system supports
- C. one subschema
- D. both (a) and (b)
- E. None of the above Discuss
Database Systems problems
Search Results
Correct Answer: SQL
Correct Answer: has a number assigned to each record
Correct Answer: All of the above
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: Flat file
Correct Answer: Client Server
Correct Answer: UPDATE
Correct Answer: ALTER FUNCTION
Correct Answer: CREATE INDEX
Correct Answer: one subschema
Comments
There are no comments.More in Computer Science:
Programming
Copyright ©CuriousTab. All rights reserved.