Create table employee (name varchar ,id integer) What type of statement is this ? Options: A . &nbspDML B . &nbspDDL C . &nbspView D . &nbspIntegrity constraint

Create table employee (name varchar ,id integer) What type of statement is this

Question

Create table employee (name varchar ,id integer) What type of statement is this ?

Options:

A . DML

B . DDL

C . View

D . Integrity constraint

Answer: Option B

DDLData Definition language is the language which performs all the operation in defining structure of relation.

Was this answer helpful ?

Next Question

Question 1. Which one of the following provides the ability to query information from the database and to insert tuples into, delet....delete tuples from, and modify tuples in the database ?

Question 2. The basic data type char(n) is a _____ length character string and varchar(n) is _____ length character. ....

Question 3. An attribute A of datatype varchar(20) has the value "Avi . The attribute B of datatype char(20) has value Reed .....has ____ spaces and attribute B has ____ spaces .

Question 4. Delete from r; r “ relation This command performs which of the following action ? ....

Question 5. To remove a relation from an SQL database, we use the ______ command. ....

Question 6. Insert into instructor values (10211, 'Smith', 'Biology', 66000); What type of statement is this ? ....

Question 7. Updates that violate __________ are disallowed . ....

Question 8. SQL applies predicates in the _______ clause after groups have been formed, so aggregate functions may be used. ....

Question 9. Aggregate functions can be used in the select list or the_______clause of a select statement or subquery. They cannot b....or subquery. They cannot be used in a ______ clause.

Question 10. Subqueries cannot: ....

Chapter 1 - GLOBAL STEEL SCENARIO & INDIAN STEEL INDUSTRY Part 1 : (13-04-2024) INDUSTRY AND COMPANY AWARENESS (ICA)

Direction Sense Test Part 1 Reasoning (Hindi)

Chapter 1 - RMHP / OHP / OB & BP Part 1 : (14-02-2024) GPOE

Cube & Cuboid Part 1 Reasoning (Hindi)

Data Interpretation (DI) Basic Concept Reasoning (Hindi)

Counting Figures Part 1 Counting Of Straight Lines Reasoning (Hindi)

Sail E0 free webinar Webinars

Real Numbers Part 7 Class 10 Maths

Real Numbers Part 1 Class 10 Maths

Polynomials Part 1 Class 10 Maths

DSP Combined 1 Free Revision Test SAIL JO E-0

GPOE / GPA Combined 1 Free Revision Test SAIL JO E-0

BSP Plant Specific Review Test SAIL JO E-0

BSL Combined 1 Free Revision Test SAIL JO E-0

GFM Combined 1 Free Revision Test SAIL JO E-0