Which one of the following is used to define the structure of the relation ,deleting relations and relating schemas ? Options: A . &nbspDML(Data Manipulation Langauge) B . &nbspDDL(Data Definition Langauge) C . &nbspQuery D . &nbspRelational Schema

Which one of the following is used to define the structure of the relation ,del

Question

Which one of the following is used to define the structure of the relation ,deleting relations and relating schemas ?

Options:

A . DML(Data Manipulation Langauge)

B . DDL(Data Definition Langauge)

C . Query

D . Relational Schema

Answer: Option B

DDL(Data Definition Langauge)Data Definition language is the language which performs all the operation in defining structure of relation.

Was this answer helpful ?

Next Question

Question 1. Select * from employee What type of statement is this? ....

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

Question 3. 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 4. The basic data type char(n) is a _____ length character string and varchar(n) is _____ length character. ....

Question 5. 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 6. Delete from r; r “ relation This command performs which of the following action ? ....

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

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

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

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

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