Discussion
Home ‣ Database ‣ Managing Databases with Oracle See What Others Are Saying!
- Question
You can check on the status of tables with the DESCRIBE or DESC command.
Options- A. True
- B. False
- Correct Answer
- True
- 1. Which of the following is true concerning triggers?
Options- A. You do not create them with SQL.
- B. They execute against only some applications that access a database.
- C. They have an event, condition, and action.
- D. They cannot cascade (cause another trigger to fire). Discuss
- 2. Which of the following is NOT a basic element of all versions of the E-R model?
Options- A. Entities
- B. Attributes
- C. Relationships
- D. Primary keys Discuss
- 3. A foreign key is:
Options- A. a column containing the primary key of another table.
- B. used to define data types.
- C. used to define null status.
- D. all of the above are above correct. Discuss
- 4. The advantage of optimistic locking is that:
Options- A. the lock is obtained only after the transaction has processed.
- B. the lock is obtained before the transaction has processed.
- C. the lock never needs to be obtained.
- D. transactions that are best suited are those with a lot of activity. Discuss
- 5. Legacy data is which of the following?
Options- A. Data contained in a newly-installed system
- B. Data rejected during the installation of a new system
- C. Data contained in a file system
- D. Data contained by a system used prior to the installation of a new system Discuss
- 6. With this type of index, the bottom level of an index does not contain data, but rather it contains pointers to data.
Options- A. Nonclustered
- B. Clustered
- C. Primary
- D. Secondary Discuss
- 7. Which of the following statements is not true about XML Schemas:
Options- A. They are used to define the content and structure of data.
- B. They define a set of symbols and the relationships of those symbols.
- C. They are themselves XML documents.
- D. They have their own syntax. Discuss
- 8. Dirty read, nonrepeatable, and phantom reads are not possible in this instance.
Options- A. Read committed
- B. Read uncommitted
- C. Repeatable read
- D. Serializable Discuss
- 9. Every time attribute A appears, it is matched with the same value of attribute B, but not the same value of attribute C. Therefore, it is true that:
Options- A. A ? B.
- B. A ? C.
- C. A ? (B,C).
- D. (B,C) ? A. Discuss
- 10. A SELECT statement within another SELECT statement and enclosed in square brackets ([...]) is called a subquery.
Options- A. True
- B. False Discuss
More questions
Correct Answer: They have an event, condition, and action.
Correct Answer: Primary keys
Correct Answer: a column containing the primary key of another table.
Correct Answer: the lock is obtained only after the transaction has processed.
Correct Answer: Data contained by a system used prior to the installation of a new system
Correct Answer: Nonclustered
Correct Answer: They have their own syntax.
Correct Answer: Serializable
Correct Answer: A ? B.
Correct Answer: False
Comments
There are no comments.More in Database:
Programming
Copyright ©CuriousTab. All rights reserved.