Exercise: Advanced Sql

Questions for: Advanced Sql

A CASE SQL statement is which of the following?
A:
A way to establish an IF-THEN-ELSE in SQL.
B:
A way to establish a loop in SQL.
C:
A way to establish a data definition in SQL.
D:
All of the above.
Answer: A
No answer description is available. Let's discuss.
📖
📝
💬
👁️
Which of the following is true concerning a procedure?
A:
You do not create them with SQL.
B:
They do not need to have a unique name.
C:
They include procedural and SQL statements.
D:
They are the same thing as a function.
Answer: C
No answer description is available. Let's discuss.
📖
📝
💬
👁️
What type of join is needed when you wish to return rows that do have matching values?
A:
Equi-join
B:
Natural join
C:
Outer join
D:
All of the above.
Answer: D
No answer description is available. Let's discuss.
📖
📝
💬
👁️
What type of join is needed when you wish to include rows that do not have matching values?
A:
Equi-join
B:
Natural join
C:
Outer join
D:
All of the above.
Answer: C
No answer description is available. Let's discuss.
📖
📝
💬
👁️
Ad Slot (Above Pagination)
Quiz