Practice More Questions From: Concept Quiz for Module 5
Q:
Using the critical questions provides a guideline
Q:
To convert a database representation into a SELECT statement, one should use
Q:
A database representation requires a table when
Q:
Duplicate rows typically occur in the result of a SELECT statement when
Q:
A prominent type of problem without PK-FK matching is known as
Q:
Examples of poor coding practices are (multiple answers possible)
Q:
In the query formulation process, a problem statement can be
Q:
Examples of redundancy errors are (multiple answers possible)
Q:
What SQL statement uses a SET clause?
Q:
Examples of semantic query errors are (multiple answers possible)
Q:
In a typical join pattern, (multiple answers possible)
Q:
What SQL modification statements use a WHERE clause (multiple answers possible)?
Q:
In an UPDATE statement, only one column can be changed. To update multiple columns of the same row, two UPDATE statements are necessary.
Q:
Indicate the requirements for union compatibility for two tables. More than one answer is possible.
Q:
Matching for SQL set operators involves equality comparison of each corresponding column from two input tables.
Q:
The difference operator (MINUS or EXCEPT) is not communtative meaning the A MINUS B is usually different the B MINUS A.
Q:
The union operator (UNION) is not communtative meaning the A UNION B is usually different the B UNION A.
Q:
The intersection operator (INTERSECT) is communtative meaning the A INTERSECT B is always the same as B INTERSECT A.
Subscribe
0 Comments
Oldest