Discussion
Home ‣ Database ‣ SQL for Database Construction See What Others Are Saying!
- Question
Views constructed from SQL SELECT statements that conform to the SQL-92 standard may not contain:
Options- A. GROUP BY.
- B. WHERE.
- C. ORDER BY.
- D. FROM.
- Correct Answer
- ORDER BY.
- 1. 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
- 2. 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
- 3. 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
- 4. A SELECT statement within another SELECT statement and enclosed in square brackets ([...]) is called a subquery.
Options- A. True
- B. False Discuss
- 5. With an enterprise data model, it is much easier to build applications because you know exactly what data exist and what needs to be added.
Options- A. True
- B. False Discuss
- 6. What is not true of a Java bean?
Options- A. There are no public instance variables.
- B. All persistent values are accessed using getxxx and setxxx methods.
- C. It may have many constructors as necessary.
- D. All of the above are true of a Java bean. Discuss
- 7. With which type of SQL Server recovery model are all database changes logged?
Options- A. Differential recovery
- B. Full recovery
- C. Simple recovery
- D. Bulk-logged recovery Discuss
- 8. The DBMS acts as an interface between what two components of an enterprise-class database system?
Options- A. Database application and the database
- B. Data and the database
- C. The user and the database application
- D. Database application and SQL Discuss
- 9. A binary relationship cannot be which of the following?
Options- A. One-to-One
- B. One-to-Many
- C. Many-to-Many
- D. Zero-to-Zero Discuss
- 10. SQL Server supports three recovery modes: simple, full and Bulk.
Options- A. True
- B. False Discuss
More questions
Correct Answer: They have their own syntax.
Correct Answer: Serializable
Correct Answer: A ? B.
Correct Answer: False
Correct Answer: True
Correct Answer: It may have many constructors as necessary.
Correct Answer: Full recovery
Correct Answer: Database application and the database
Correct Answer: Zero-to-Zero
Correct Answer: True
Explanation:
SQL Server provides three different recovery models that allow you to specify the way SQL Server manages log files and prepares your enterprise for a disaster. Each of these models represents a different approach to balancing the tradeoff between conserving disk space and providing for granular disaster recovery options. The three disaster recovery models offered by SQL Server are:
1. Simple Recovery Model
2. Full Recovery Model
3. Bulk-logged Recovery Model
Comments
There are no comments.More in Database:
Programming
Copyright ©CuriousTab. All rights reserved.