Exercise: Sql For Database Construction And Application Processing

Questions for: Sql For Database Construction And Application Processing

For what purposes are views used?
A:
To hide columns only
B:
To hide rows only
C:
To hide complicated SQL statements only
D:
All of the above are uses for SQL views.
Answer: D
No answer description is available. Let's discuss.
📖
📝
💬
👁️
A ________ is a program that performs some common action on database data and that is stored in the database.
A:
trigger
B:
stored procedure
C:
pseudofile
D:
None of the above is correct.
Answer: B
No answer description is available. Let's discuss.
📖
📝
💬
👁️
Which of the following is NOT a type of SQL constraint?
A:
PRIMARY KEY
B:
FOREIGN KEY
C:
ALTERNATE KEY
D:
UNIQUE
Answer: C
No answer description is available. Let's discuss.
📖
📝
💬
👁️
To update an SQL view, the DBMS must be able to associate the column(s) to be updated with:
A:
a particular column in a particular underlying table.
B:
a particular column in a particular row.
C:
a particular row in a particular underlying table.
D:
None of the above is correct.
Answer: C
No answer description is available. Let's discuss.
📖
📝
💬
👁️
The SQL statement to create a view is:
A:
CREATE VIEW.
B:
MAKE VIEW.
C:
SELECT VIEW.
D:
INSERT VIEW.
Answer: A
No answer description is available. Let's discuss.
📖
📝
💬
👁️
Ad Slot (Above Pagination)
Quiz