DBMS TEST2

1.

1 point

............... joins are SQL server default

Equi

Inner

None of the above

Outer

2.

1 point

………………… is preferred method for enforcing data integrity

Stored Procedure

Null predicate Null predicate Null predicate Triggers

In predicate Data Control Level Data Control Level Cursors

Constraints

3.

1 point

……………….. contains information that defines valid values that are stored in a column or data type.

Default

Index

Rule

View

4.

1 point

The number of tuples in a relation is called its …………. While the number of attributes in a relation is called it’s ………………..

Degree, Cardinality

Null predicate Null predicate Null predicate Rows, Columns

In predicate Data Control Level Data Control Level Columns, Rows Columns, Rows Columns, Rows Columns, Rows Columns,Rows

Cardinality, Degree

5.

1 point

……… is a full form of SQL.

Standard query language

Structured query language

Sequential query language

Order by Order by Order by Order by Order by Server side query language

6.

1 point

To eliminate duplicate rows ……………… is used

NODUPLICATE

Null predicate Null predicate Null predicate DISTINCT

ELIMINATE

In predicate None of these

7.

1 point

………………….. operator is basically a join followed by a project on the attributes of first relation.

Null predicate Null predicate Null predicate Full Join

Join

Semi-Join

In predicate Data Control Level Data Control Level Columns, Rows Columns, Rows Columns, Rows Columns, Rows Inner Join

8.

1 point

The database schema is written in

HLL

In predicate Data Control Level Data Control Level Columns, Rows Columns, Rows Columns, Rows Columns, Rows DCL

Null predicate Null predicate Null predicate DDL

DML

9.

1 point

............. is a special type of stored procedure that is automatically invoked whenever the data in the table is modified.

Trigger

Procedure

None of the above

Curser

10.

1 point

State true or false
i) A candidate key is a minimal super key.

ii) A candidate key can also refer to as surrogate key.

i-true, ii-false

In predicate i-false, ii-false

i-false, ii-true

Null predicate Null predicate Null predicate i-true, ii-true

11.

1 point

Which of the following SQL command can be used to modify existing data in a database table?

NEW

MODIFY

UPDATE

CHANGE CHANGE

12.

1 point

…………….. is the complex search criteria in the where clause.

Null predicate Null predicate Null predicate Predict

In predicate Data Control Level Data Control Level Predicate

Sub string

Drop Table

13.

1 point

The candidate key is that you choose to identify each row uniquely is called ……………..

Foreign Key

None of the above

Alternate Key

Primary Key

14.

1 point

To change column value in a table the ......... command can be used.

alter

insert

create

update

15.

1 point

Grant and revoke are ....... statements.

DML

TCL

DDL

DCL

16.

1 point

For like predicate which of the following is true.
i) % matches zero of more characters.
ii) _ matches exactly one character.

Both of them

i-only

None of them

ii-only

17.

1 point

.......... keyword is used to find the number of values in a column

COUNT

TOTAL

Order by Order by Order by Order by SUM

ADD

18.

1 point

What are the different events in Triggers?

Select, Commit

Define, Create

Insert, Update, Delete

Drop, Comment

19.

1 point

Which of the syntax is correct for insert statement?
i) insert into values
ii) insert into (column list) values

ii-only

i-only

Both of them Both

None

20.

1 point

Which character function can be used to return a specified portion of a character string?

INSTR

SUBSTR

SUBSTRING

POS

21.

1 point

The language that requires a user to specify the data to be retrieved without specifying exactly how to get it is

Null predicate Null predicate Null predicate Procedural DDL

In predicate Data Control Level Data Control Level Columns, Rows Columns, Rows Columns, Rows Columns, Rows Non-Procedural DDL

Procedural DML

Non-Procedural DML

22.

1 point

Which can be used to delete all the rows if a table?

Delete from table_name

Delete table_name

all rows cannot be deleted at a time.

Delete * from table_name Delete * from table_name delete * from tablename

23.

1 point

………………. First proposed the process of normalization.

Edward Stephen

Edgar F. Codd

Edward Codd

Edgar. W

24.

1 point

…………….. is used to determine whether of a table contains duplicate rows.

Null predicate Null predicate Null predicate Null Predicate

Unique predicate

Like Predicate

In predicate In predicate

25.

1 point

……………… clause is an additional filter that is applied to the result.

Select

Group-by

Having

Order by Order by Order by Order by Order by order by

26.

1 point

.......... command can be used to modify a column in a table

update

alter

set

create

27.

1 point

Which of the following is/are the DDL statements

Null predicate Null predicate Null predicate Alter Alter Alter

Create

All of the above

Drop

28.

1 point

……………… defines rules regarding the values allowed in columns and is the standard mechanism for enforcing database integrity.

Index

Column

Constraint

Trigger

29.

1 point

DCL stands for

In predicate Data Control Level Data Control Level Data Control Level

Data Control Language

Null predicate Null predicate Null predicate Data Console Level

Data Console Language

30.

1 point

The collection of information stored in a database at a particular moment is called as ......

instance of the database

data domain

schema

Order by Order by Order by Order by . independence . independence independence