Discussion
Home ‣ Database ‣ Advanced SQL Comments
- Question
The code to create triggers and routines is stored in only one location and is administered centrally.
Options- A. True
- B. False
- Correct Answer
- True
- 1. A correlated subquery is where the outer query depends on data from the inner query.
Options- A. True
- B. False Discuss
- 2. A transaction is the complete set of closely related update commands that must all be done, or none of them done, for the database to remain valid.
Options- A. True
- B. False Discuss
- 3. There should be one condition within the WHERE clause for each pair of tables being joined.
Options- A. True
- B. False Discuss
- 4. The joining technique is useful when data from several relations are to be retrieved and displayed and the relationships are not necessarily nested.
Options- A. True
- B. False Discuss
- 5. The primary key in a relation does not need to be underlined.
Options- A. True
- B. False Discuss
- 6. A function returns one value and has only output parameters.
Options- A. True
- B. False Discuss
- 7. When AUTOCOMMIT is set on, changes will be made automatically at the end of each SQL statement.
Options- A. True
- B. False Discuss
- 8. With the UNION clause, each query involved must output the same number of columns, and they must be UNION compatible.
Options- A. True
- B. False Discuss
- 9. The most frequently used relational operation, which brings together data from two or more related tables into one resultant table, is called an equi-join.
Options- A. True
- B. False Discuss
- 10. Triggers are stored blocks of code that have to be called in order to operate.
Options- A. True
- B. False Discuss
Advanced SQL problems
Search Results
Correct Answer: False
Correct Answer: True
Correct Answer: True
Correct Answer: True
Correct Answer: False
Correct Answer: False
Correct Answer: True
Correct Answer: True
Correct Answer: False
Correct Answer: False
Comments
There are no comments.More in Database:
Programming
Copyright ©CuriousTab. All rights reserved.