Database Management System Set 8

Learning Mode Previous Next

On This Page

This set of DataBase Management System (DBMS) Multiple Choice Questions & Answers (MCQs) focuses on Database Management System Set 8

Q1 | The clause is used to list the attributes desired in the result of a query.

where

select

from

distinct

Q2 | Which of the following statements contains an error?

select * from emp where empid = 10003;

select empid from emp where empid = 10006;

select empid from emp;

select empid where empid = 1009 and lastname = ‘geller’;

Q3 | In SQL the spaces at the end of the string are removed by function.

upper

string

trim

lower

Q4 | The union operation is represented by

∩

–

Q5 | The intersection operator is used to get the tuples.

diﬀerent

common

all

repeating

Q6 | If we want to retain all duplicates, we must write in place of union.

union all

union some

intersect all

intersect some

Q7 | The number of attributes in relation is called as its

cardinality

degree

tuples

entity

Q8 | clause is an additional ﬁlter that is applied to the result.

select

group-by

having

order by

Q9 | joins are SQL server default

outer

inner

equi

none of the mentioned

Q10 | The is essentially used to search for patterns in target string.

like predicate

null predicate

in predicate

out predicate

Q11 | A indicates an absent value that may exist but be unknown or that may not exist at all.

empty tuple

new value

null value

old value

Q12 | If the attribute phone number is included in the relation all the values need not be entered into the phone number column. This type of entry is given as

–

Null.

empty space

Q13 | The predicate in a where clause can involve Boolean operations such as and. The result of true and unknown is false and unknown is while unknown and unknown is

unknown, unknown, false

true, false, unknown

true, unknown, unknown

unknown, false, unknown

Q14 | Using the clause retains only one copy of such identical tuples.

Null.

unique

not null

distinct

Q15 | The primary key must be

unique

not null

both unique and not null

either unique or not null

Q16 | The result of unknown is unknown.

xor

and

not

Q17 | Aggregate functions are functions that take a as input and return a single value.

collection of values

single value

aggregate value

both collection of values & single value

Q18 | A Boolean data type that can take values true, false, and

Null.

unknown

Q19 | The connective tests for set membership, where the set is a collection of values produced by a select clause. The connective tests for the absence of set membership.

or, in

not in, in

in, not in

in, or

Q20 | The phrase “greater than at least one” is represented in SQL by

< all

< some

> all

> some

Q21 | SQL applies predicates in the clause after groups have been formed, so aggregate functions may be used.

group by

with

where

having

Q22 | The keyword is used to access attributes of preceding tables or subqueries in the from clause.

lateral

having

with

Q23 | Which of the following creates a temporary relation for the query on which it is deﬁned?

with

from

where

select

Q24 | Subqueries cannot:

use group by or group functions

retrieve data from a table diﬀerent from the one in the outer query

join tables

appear in select, update, delete, insert statements.

Q25 | Which of the following is not an aggregate function?

avg

sum

with

min

Previous Next