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
  • u
  • *
Q5 | The intersection operator is used to get the            tuples.
  • different
  • 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 filter 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
  • 0
  • 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
  • or
  • 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                 
  • 1
  • 0
  • 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.
  • in
  • lateral
  • having
  • with
Q23 | Which of the following creates a temporary relation for the query on which it is defined?
  • with
  • from
  • where
  • select
Q24 | Subqueries cannot:
  • use group by or group functions
  • retrieve data from a table different 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