logo
Coming Soon !!

Computer Awareness Quiz #24



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

(a) DML(Data Manipulation Langauge)

(b) DDL(Data Definition Langauge)

(c) Query

(d) Relational Schema

(e) None of these


Q2) Which one of the following provides the ability to query information 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) Query

(d) Relational Schema

(e) None of these


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

(a) DML

(b) DDL

(c) View

(d) Integrity constraint

(e) None of these


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

(a) Fixed, equal

(b) Equal, variable

(c) Fixed, variable

(d) Variable, equal

(e) None of the above


Q5) To remove a relation from an SQL database, we use the ______ command.

(a) Delete

(b) Purge

(c) Remove

(d) Drop

(e) Drop table


Q6) Updates that violate __________ are disallowed .

(a) Integrity constraints

(b) Transaction control

(c) Authorization

(d) DDL constraints

(e) None of the above


Q7) Insert into instructor values (10211, ’Smith’, ’Biology’, 66000);
What type of statement is this ?

(a) Query

(b) DML

(c) Relational

(d) DDL

(e) None of these


Q8) Delete from r; r – relation
This command performs which of the following action ?

(a) Remove relation

(b) Clear relation entries

(c) Delete fields

(d) Delete rows

(e) None of the above


Q9) Select * from employee
What type of statement is this?

(a) DML

(b) DDL

(c) View

(d) Integrity constraint

(e) None of these


Q10) An attribute A of datatype varchar(20) has the value “Red” . The attribute B of datatype char(20) has value ”Pine” .Here attribute A has ____ spaces and attribute B has ____ spaces .

(a) 3, 20

(b) 20, 4

(c) 20 , 20

(d) 3, 4

(e) 20,4


Click here for the Answers




(Visited 14 times, 1 visits today)

Leave a Reply

*