Exercise: Sql For Database Construction And Application Processing

Questions for: Sql For Database Construction And Application Processing

Views constructed from SQL SELECT statements that conform to the SQL-92 standard may not contain:
A:
GROUP BY.
B:
WHERE.
C:
ORDER BY.
D:
FROM.
Answer: C
No answer description is available. Let's discuss.
📖
📝
💬
👁️
What is an advantage of placing computations in SQL views?
A:
To save users from having to write an expression.
B:
To ensure that the results are consistent.
C:
To accomplish both of the above.
D:
None of the above is correct - computations cannot be placed in a view.
Answer: C
No answer description is available. Let's discuss.
📖
📝
💬
👁️
Which is NOT one of the most common types of SQL CHECK constraints?
A:
System date
B:
Range checks
C:
Lists of values
D:
Comparing one column value to another within the same table
Answer: A
No answer description is available. Let's discuss.
📖
📝
💬
👁️
What SQL structure is used to limit column values of a table?
A:
The LIMIT constraint
B:
The CHECK constraint
C:
The VALUE constraint
D:
None of the above is correct.
Answer: B
No answer description is available. Let's discuss.
📖
📝
💬
👁️
The SQL ALTER statement can be used to:
A:
change the table structure.
B:
change the table data.
C:
add rows to the table.
D:
delete rows from the table.
Answer: A
No answer description is available. Let's discuss.
📖
📝
💬
👁️
Ad Slot (Above Pagination)
Quiz