Discussion
Home ‣ Computer Science ‣ Database Systems Comments
- Question
In a relational schema, each tuple is divided into fields called
Options- A. Relations
- B. Domains
- C. Queries
- D. All of the above
- E. None of the above
- Correct Answer
- Domains
- 1. Internal auditors should review data system design before they are
Options- A. developed
- B. implemented
- C. modified
- D. All of the above
- E. None of the above Discuss
- 2. The data-base environment has all of the following components except:
Options- A. users
- B. separate files
- C. data base
- D. data-base administrator
- E. None of the above Discuss
- 3. Which command(s) is(are) used to enable/disable/drop an integrity constraint in SQL?
Options- A. DEFINE TABLE
- B. MODIFY TABLE
- C. ALTER TABLE
- D. All of the above
- E. None of the above Discuss
- 4. When performing a look-up operation using a form
Options- A. you enter the search value into the form
- B. you look at each form sequentially until you see the one you want
- C. you type the key in an entry line, and the correct form is displayed
- D. All of the above
- E. None of the above Discuss
- 5. In SQL, which of the following is not a data Manipulation Language Commands?
Options- A. DELETE
- B. SELECT
- C. UPDATE
- D. CREATE
- E. None of the above Discuss
- 6. A _____ database does not use pointers or physical links, but instead finds related records by examining the contents of fields.
Options- A. Network
- B. Hierarchical
- C. Relational
- D. Object-Oriented
- E. None of the above Discuss
- 7. The index consists of
Options- A. a list of keys
- B. pointers to the master list
- C. both (a) and (b)
- D. All of the above
- E. None of the above Discuss
- 8. Long-range planning report produced in an MIS are primarily designed for
Options- A. top management
- B. middle management
- C. lower management
- D. All of the above
- E. None of the above Discuss
- 9. In SQL, which command(s) is(are) used to redefine an index's future storage allocation
Options- A. ALTER INDEX
- B. REDEFINE INDEX
- C. MODIFY INDEX
- D. DO INDEX
- E. None of the above Discuss
- 10. Which of the following command(s) is(are) used to recompile a stored procedure in SQL?
Options- A. COMPILE PROCEDURE
- B. ALTER PROCEDURE
- C. MODIFY PROCEDURE id) All of the above
- D. None of the above Discuss
Database Systems problems
Search Results
Correct Answer: All of the above
Correct Answer: separate files
Correct Answer: ALTER TABLE
Correct Answer: you enter the search value into the form
Correct Answer: CREATE
Correct Answer: Relational
Correct Answer: both (a) and (b)
Correct Answer: top management
Correct Answer: ALTER INDEX
Correct Answer: ALTER PROCEDURE
Comments
There are no comments.More in Computer Science:
Programming
Copyright ©CuriousTab. All rights reserved.