Discussion
Home ‣ Database ‣ Data and Database Administration See What Others Are Saying!
- Question
Which of the following is the preferred way to recover a database after a transaction in progress terminates abnormally?
Options- A. Rollback
- B. Rollforward
- C. Switch to duplicate database
- D. Reprocess transactions
- Correct Answer
- Rollback
- 1. SQL can be used to:
Options- A. create database structures only.
- B. query database data only.
- C. modify database data only.
- D. All of the above can be done by SQL. Discuss
- 2. Both ASP and ColdFusion allow for the coding of custom tags within an HTML document.
Options- A. True
- B. False Discuss
- 3. Correlated subqueries are similar to a regular subquery.
Options- A. True
- B. False Discuss
- 4. The transaction log includes which of the following?
Options- A. The before-image of a record
- B. The after-image of a record
- C. The before and after-image of a record
- D. The essential data of the record Discuss
- 5. What is not true about XSLT?
Options- A. XSLT is a declarative transformation language.
- B. XSLT uses a set of rules that govern how a document is to be materialized is created.
- C. XSLT uses a set of procedures that specify how a document is to be programmed.
- D. XSLT is used to transform the input document into another document. Discuss
- 6. A subtype discriminator is which of the following?
Options- A. An attribute of the supertype whose values determine the subtype
- B. An attribute of the subtype whose values determine the supertype
- C. An attribute of the supertype whose values determine the supertype
- D. An attribute of the subtype whose values determine the subtype Discuss
- 7. A conceptual schema is usually depicted in graphical format using E-R or object-modeling notations.
Options- A. True
- B. False Discuss
- 8. SQL Server program code that is executed instead of an SQL command that needs to be processed is called a(n):
Options- A. INSTEAD OF trigger.
- B. BEFORE trigger.
- C. AFTER trigger.
- D. BEGIN trigger. Discuss
- 9. A data warehouse administrator is concerned with which of the following?
Options- A. The time to make a decision but not the typical roles of a database administrator
- B. The time to make a decision and the typical roles of a database administrator
- C. The typical roles of a data administrator and redesigning existing applications
- D. The typical roles of a database administrator and redesigning existing applications Discuss
- 10. MySQL is just as powerful as Oracle and is half the price.
Options- A. True
- B. False Discuss
More questions
Correct Answer: All of the above can be done by SQL.
Correct Answer: True
Correct Answer: False
Correct Answer: The essential data of the record
Correct Answer: XSLT uses a set of procedures that specify how a document is to be programmed.
Correct Answer: An attribute of the supertype whose values determine the subtype
Correct Answer: True
Correct Answer: INSTEAD OF trigger.
Correct Answer: The time to make a decision and the typical roles of a database administrator
Correct Answer: False
Comments
There are no comments.More in Database:
Programming
Copyright ©CuriousTab. All rights reserved.