Exercise: Sql For Database Construction And Application Processing

Questions for: Sql For Database Construction And Application Processing

SQL views can be used to hide:
A:
columns and rows only.
B:
complicated SQL syntax only.
C:
both of the above can be hidden by an SQL view.
D:
None of the above is correct.
Answer: C
No answer description is available. Let's discuss.
📖
📝
💬
👁️
The DROP TABLE statement:
A:
deletes the table structure only.
B:
deletes the table structure along with the table data.
C:
works whether or not referential integrity constraints would be violated.
D:
is not an SQL statement.
Answer: B
No answer description is available. Let's discuss.
📖
📝
💬
👁️
A ________ is a stored program that is attached to a table or a view.
A:
pseudofile
B:
embedded SELECT statement
C:
trigger
D:
None of the above is correct.
Answer: C
No answer description is available. Let's discuss.
📖
📝
💬
👁️
The SQL command to create a table is:
A:
MAKE TABLE.
B:
ALTER TABLE.
C:
DEFINE TABLE.
D:
CREATE TABLE.
Answer: D
No answer description is available. Let's discuss.
📖
📝
💬
👁️
Ad Slot (Above Pagination)
Quiz