DB Queries constraints and Triggers Mcqs

Our collections of Multiple choice questions and answers focuses on study of DB Queries constraints and Triggers. These questions are chosen from a collection of most authoritative and best reference books on DBMS. Our aim is to prepare an individual for competitive exams like NTS, GAT, ECAT, University and College entrance exams and various tests and job interviews. One should practice our Mcqs to assimilate knowledge on DB Queries constraints and Triggers comprehensively.

  1. Home
  2. »
  3. Computer Science Mcqs
  4. »
  5. DBMS Mcqs
  6. »
  7. DB Queries constraints and Triggers...

Computer MCQS

Sciences MCQS

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

DML(Data Manipulation Langauge)

DDL(Data Definition Langauge)

Query

Relational Schema

Answer Discus (0)

2.
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 ?

DML(Data Manipulation Langauge)

DDL(Data Definition Langauge)

Query

Relational Schema

Answer Discus (0)

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

DML

DDL

View

Integrity constraint

Answer Discus (0)

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

Fixed, equal

Equal, variable

Fixed, variable

Variable, equal

Answer Discus (0)

6.
An attribute A of datatype varchar(20) has the value “Avi” . The attribute B of datatype char(20) has value ”Reed” .Here attribute A has ____ spaces and attribute B has ____ spaces.

3, 20

20, 4

20 , 20

3, 4

Answer Discus (0)

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

Delete

Purge

Remove

Drop table

Answer Discus (0)

8.
Delete from r; r – relationThis command performs which of the following action ?

Remove relation

Clear relation entries

Delete fields

Delete rows

Answer Discus (0)

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

Query

DML

Relational

DDL

Answer Discus (0)

10.
Updates that violate __________ are disallowed.

Integrity constraints

Transaction control

Authorization

DDL constraints

Answer Discus (0)

11.
NameAnnieBobCallieDerekWhich of these query will display the the table given above ?

Select employee from name

Select name

Select name from employee

Select employee

Answer Discus (0)

12.
Select ________ dept_name from instructor;Here which of the following displays the unique values of the column ?

All

From

Distinct

Name

Answer Discus (0)

13.
The ______ clause allows us to select only those rows in the result relation of the ____ clause that satisfy a specified predicate.

Where, from

From, select

Select, from

From, where

Answer Discus (0)

14.
Select ID, name, dept name, salary * 1.1 where instructor;The query given below will not give an error. Which one of the following has to be replaced to get the desired output?

Salary*1.1

ID

Where

Instructor

Answer Discus (0)

15.
The ________ clause is used to list the attributes desired in the result of a query.

Where

Select

From

Distinct

Answer Discus (0)

Engineering MCQS

General Subjects MCQS

0Shares
0
Scroll to Top