IndiaBIX

Database - SQL for Database Construction

Exercise : SQL for Database Construction - General Questions
1.
The SQL command to create a table is:
MAKE TABLE.
ALTER TABLE.
DEFINE TABLE.
CREATE TABLE.
Answer: Option
Explanation:
No answer description is available. Let's discuss.
2.
A ________ is a stored program that is attached to a table or a view.
pseudofile
embedded SELECT statement
trigger
None of the above is correct.
Answer: Option
Explanation:
No answer description is available. Let's discuss.
3.
The DROP TABLE statement:
deletes the table structure only.
deletes the table structure along with the table data.
works whether or not referential integrity constraints would be violated.
is not an SQL statement.
Answer: Option
Explanation:
No answer description is available. Let's discuss.
4.
SQL views can be used to hide:
columns and rows only.
complicated SQL syntax only.
both of the above can be hidden by an SQL view.
None of the above is correct.
Answer: Option
Explanation:
No answer description is available. Let's discuss.
5.
The SQL statement to create a view is:
CREATE VIEW.
MAKE VIEW.
SELECT VIEW.
INSERT VIEW.
Answer: Option
Explanation:
No answer description is available. Let's discuss.
Quick links
Quantitative Aptitude
Verbal (English)
Reasoning
Programming
Interview
Placement Papers