Discussion
Home ‣ Database ‣ Advanced SQL See What Others Are Saying!
- Question
Which of the following statements is true concerning subqueries?
Options- A. Involves the use of an inner and outer query.
- B. Cannot return the same result as a query that is not a subquery.
- C. Does not start with the word SELECT.
- D. All of the above.
- Correct Answer
- Involves the use of an inner and outer query.
- 1. The object-oriented development life cycle is which of the following?
Options- A. Analysis, design, and implementation steps in the given order and using multiple iterations.
- B. Analysis, design, and implementation steps in the given order and going through the steps no more than one time.
- C. Analysis, design, and implementation steps in any order and using multiple iterations.
- D. Analysis, design, and implementation steps in any order and going through the steps no more than one time. Discuss
- 2. The SQL command to create a table is:
Options- A. MAKE TABLE.
- B. ALTER TABLE.
- C. DEFINE TABLE.
- D. CREATE TABLE. Discuss
- 3. A class is a concept, abstraction, or thing that makes sense in an application context.
Options- A. True
- B. False Discuss
- 4. A ________ is a program that performs some common action on database data and that is stored in the database.
Options- A. trigger
- B. stored procedure
- C. pseudofile
- D. None of the above is correct. Discuss
- 5. Which of the following is an advantage of partitioning?
Options- A. Complexity
- B. Inconsistent access speed
- C. Extra space
- D. Security Discuss
- 6. An entity class is a collection of entities and is described by the structure of the entities in that class.
Options- A. True
- B. False Discuss
- 7. An attribute that names or identifies entity instances is a(n):
Options- A. entity.
- B. attribute.
- C. identifier.
- D. relationship. Discuss
- 8. In this instance, dirty reads are disallowed, while nonrepeatable reads and phantom reads are allowed.
Options- A. Read committed
- B. Read uncommitted
- C. Repeatable read
- D. Serializable Discuss
- 9. Which of the following occurs when a transaction rereads data and finds new rows that were inserted by a command transaction since the prior read?
Options- A. Nonrepeatable read
- B. Phantom read
- C. Dirty read
- D. Consistent read Discuss
- 10. Business Intelligence (BI) reporting systems cannot do which of the following operations?
Options- A. Filter data
- B. Group data
- C. Modify data
- D. Both filter and group data Discuss
More questions
Correct Answer: Analysis, design, and implementation steps in the given order and using multiple iterations.
Correct Answer: CREATE TABLE.
Correct Answer: True
Correct Answer: stored procedure
Correct Answer: Security
Correct Answer: True
Correct Answer: identifier.
Correct Answer: Read committed
Correct Answer: Phantom read
Correct Answer: Modify data
Comments
There are no comments.More in Database:
Programming
Copyright ©CuriousTab. All rights reserved.