IndiaBIX

Database - SQL for Database Construction

Exercise : SQL for Database Construction - General Questions
16.
What SQL structure is used to limit column values of a table?
The LIMIT constraint
The CHECK constraint
The VALUE constraint
None of the above is correct.
Answer: Option
Explanation:
No answer description is available. Let's discuss.
17.
Which is NOT one of the most common types of SQL CHECK constraints?
System date
Range checks
Lists of values
Comparing one column value to another within the same table
Answer: Option
Explanation:
No answer description is available. Let's discuss.
18.
What is an advantage of placing computations in SQL views?
To save users from having to write an expression.
To ensure that the results are consistent.
To accomplish both of the above.
None of the above is correct - computations cannot be placed in a view.
Answer: Option
Explanation:
No answer description is available. Let's discuss.
19.
Views constructed from SQL SELECT statements that conform to the SQL-92 standard may not contain:
GROUP BY.
WHERE.
ORDER BY.
FROM.
Answer: Option
Explanation:
No answer description is available. Let's discuss.
Quick links
Quantitative Aptitude
Verbal (English)
Reasoning
Programming
Interview
Placement Papers