adplus-dvertising
frame-decoration

Question

A command to remove a relation from an SQL database

a.

Delete table table name

b.

Drop table table name

c.

Erase table table name

d.

Alter table table name

Posted under SQL DBMS

Answer: (b).Drop table table name

Engage with the Community - Add Your Comment

Confused About the Answer? Ask for Details Here.

Know the Explanation? Add it Here.

Q. A command to remove a relation from an SQL database
keith : June 26, 2023

why not delete?

Similar Questions

Discover Related MCQs

Q. Which SQL Query is use to remove a table and all its data from the database?

Q. A type of query that is placed within a WHERE or HAVING clause of another query is called

Q. Aggregate functions are functions that take a ___________ as input and return a single value.

Q. Select __________ from instructor where dept name= ’Comp. Sci.’;
Which of the following should be used to find the mean of the salary ?

Q. All aggregate functions except _____ ignore null values in their input collection.

Q. A Boolean data type that can take values true, false, and________ .

Q. Select count (____ ID)
from teaches
where semester = ’Spring’ and year = 2010;
If we do want to eliminate duplicates, we use the keyword ______in the aggregate expression.

Q. The ____ connective tests for set membership, where the set is a collection of values produced by a select clause. The ____ connective tests for the absence of set membership.

Q. We can test for the nonexistence of tuples in a subquery by using the _____ construct.

Q. Dates must be specified in the format

Q. An ________ on an attribute of a relation is a data structure that allows the database system to find those tuples in the relation that have a specified value for that attribute efficiently, without scanning through all the tuples of the relation.

Q. Which of the following is used to store movie and image files ?

Q. The user defined data type can be created using

Q. Values of one type can be converted to another domain using which of the following ?

Q. Which of the following closely resembles Create view ?

Q. In contemporary databases the top level of the hierarchy consists of ______, each of which can contain _____.

Q. Which of the following statements creates a new table temp instructor that has the same schema as instructor.

Q. The____condition allows a general predicate over the relations being joined.

Q. Which of the join operations do not preserve non matched tuples.

Q. What type of join is needed when you wish to include rows that do not have matching values?