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.

Click to view Correct Answer

Previous || Next

SQL for Database Construction - General Questions more questions

A rule of thumb for choosing indexes for a relational....

Sequential retrieval on a primary key for sequential file storage....

A multidimensional database model is used most often in which....

The SQL command to create a table is:

A ________ is a stored program that is attached to....

SQL views can be used to hide:

The SQL statement to create a view is:

To update an SQL view, the DBMS must be able....

Which of the following is NOT a type of SQL....

A ________ is a program that performs some common action....

Advanced SQL - General Questions more Online Exam Quiz

Modeling Data in the Organization - General Questions

Object-Oriented Database - General Questions

Object-Oriented Data Modeling - General Questions

ODBC, OLE DB, ADO, and ASP - General Questions

Physical Database Design - General Questions

The Client-Server Database - General Questions

The Database Development Process - General Questions

The Database Environment - General Questions

ER Model and Business Rules - General Questions

The Internet Database Environment - General Questions