Lakshya Education MCQs

Question: The DROP TABLE statement:
Options:
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: Option B

Submit Answer & Explaination

Earn Reward Points by submitting Detailed Explaination for this Question

More Questions on This Topic :

Question 1. The SQL statement to create a view is:
  1.    CREATE VIEW
  2.    MAKE VIEW
  3.    SELECT VIEW
  4.    INSERT VIEW
Answer: Option A
Question 2. To update an SQL view, the DBMS must be able to associate the column(s) to be updated with:
  1.    a particular column in a particular underlying table.
  2.    a particular column in a particular row.
  3.    a particular row in a particular underlying table.
  4.    None of the above is correct.
Answer: Option C
Question 3. Which of the following is NOT a type of SQL constraint?
  1.    PRIMARY KEY
  2.    FOREIGN KEY
  3.    ALTERNATE KEY
  4.    UNIQUE
Answer: Option C
Question 4. SQL views can be used to hide:
  1.    columns and rows only.
  2.    complicated SQL syntax only.
  3.    both of the above can be hidden by an SQL view.
  4.    None of the above is correct.
Answer: Option C
Question 5. A ________ is a stored program that is attached to a table or a view.
  1.    pseudofile
  2.    embedded SELECT statement
  3.    trigger
  4.    None of the above is correct.
Answer: Option C
Question 6. The SQL command to create a table is:
  1.    MAKE TABLE
  2.    ALTER TABLE
  3.    DEFINE TABLE
  4.    CREATE TABLE
Answer: Option D

Check all Questions in this Topic : Click HERE