adplus-dvertising
frame-decoration

Question

The SQL database language includes statements for:

a.

Database definition.

b.

Database manipulation.

c.

Database control.

d.

All of the above.

Posted under SQL DBMS

Answer: (d).All of the above.

Engage with the Community - Add Your Comment

Confused About the Answer? Ask for Details Here.

Know the Explanation? Add it Here.

Q. The SQL database language includes statements for:

Similar Questions

Discover Related MCQs

Q. A command to remove a relation from an SQL database

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.