IndiaBIX

Database - Introduction to SQL

Exercise : Introduction to SQL - General Questions
6.
A view is which of the following?
A virtual table that can be accessed via SQL commands
A virtual table that cannot be accessed via SQL commands
A base table that can be accessed via SQL commands
A base table that cannot be accessed via SQL commands
Answer: Option
Explanation:
No answer description is available. Let's discuss.
7.
The command to eliminate a table from a database is:
REMOVE TABLE CUSTOMER;
DROP TABLE CUSTOMER;
DELETE TABLE CUSTOMER;
UPDATE TABLE CUSTOMER;
Answer: Option
Explanation:
No answer description is available. Let's discuss.
8.
ON UPDATE CASCADE ensures which of the following?
Normalization
Data Integrity
Materialized Views
All of the above.
Answer: Option
Explanation:
No answer description is available. Let's discuss.
9.
SQL data definition commands make up a(n) ________ .
DDL
DML
HTML
XML
Answer: Option
Explanation:
No answer description is available. Let's discuss.
10.
Which of the following is valid SQL for an Index?
CREATE INDEX ID;
CHANGE INDEX ID;
ADD INDEX ID;
REMOVE INDEX ID;
Answer: Option
Explanation:
No answer description is available. Let's discuss.
Quick links
Quantitative Aptitude
Verbal (English)
Reasoning
Programming
Interview
Placement Papers