1. How we can define the structure of the relation ,deleting relations and relating schemas ?
a) DML(Data Manipulation Langauge)
b) DDL(Data Definition Langauge)
c) Probe
d) Relational Schema
Answer:b
2. Which one of the following delivers the capability to query material from the database and to insert tuples into, delete tuples from, and modify tuples in the database ?
a) DML(Data Manipulation Langauge)
b) DDL(Data Definition Langauge)
c) Probe
d) Relational Schema
Answer:a
3. What command is used to create a table?
a) DML
b) DDL
c) View
d) Integrity constraint
Answer:b
4. Which command is used to select the data’s from the table ?
a) DML
b) DDL
c) View
d) Integrity constraint
Answer:a

5. The rudimentary data type char(n) is a _____ length character string and varchar(n) is _____ length character. …show more content…
An attribute A of datatype varchar(20) has the value “Bvs” . The attribute B of datatype char(20) has value ”Need” .Here attribute A has ____ spaces and attribute B has ____ spaces .
a) 3, 20
b) 20, 4
c) 20 , 20
d) 3, 4
Answer:a

7. Which command is used to remove a relation from an SQL database?
a) Delete
b) Eradication
c) Remove
d) Drop table
Answer:d

8. Which command is used to dele a relation?
a) Remove relation
b) Clear relation entries
c) Delete fields
d) Delete rows