Database Management System Set 8
Computer Science Engineering (CSE),
Bachelor of Science in Computer Science FY (BSc CS),
Bachelor of Science in Computer Science SY (BSc CS),
Bachelor of Science in Information Technology SY (BSc IT),
Bachelor of Computer Applications (BCA),
Bachelor of Business Administration in Computer Applications (BBA [CA]),
Bachelor of Science in Information Technology (BSc IT),
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