DBMS Multiple Choice Questions With Answers are given here. Based on the questions asked in previous year’s different government and private exams such as CAT, MAT, XAT, NMAT, IIFT, and SNAP. Following MCQs on the database management system for bank exam preparation along with detailed answers will help you to crack most of the questions asked in major exams.
DBMS Multiple Choice Questions With Answers
1. To remove a relation from an SQL database, we use the ______ command.
a) Delete
b) Purge
c) Remove
d) Drop table
Answer: d
2. Updates that violate __________ are disallowed.
a) Integrity constraints
b) Transaction control
c) Authorization
d) DDL constraints
Answer: a
3. The ______ clause allows us to select only those rows in the result relation of the ____ clause that satisfy a specified predicate.
a) Where, from
b) From, select
c) Select, from
d) From, where
Answer: a
4. The ________ clause is used to list the attributes desired in the result of a query.
a) Where
b) Select
c) From
d) Distinct
Answer: b
5. Which of the following statements contains an error?
a) Select * from emp where empid = 10003;
b) Select empid from emp where empid = 10006;
c) Select empid from emp;
d) Select empid where empid = 1009 and lastname = ‘GELLER’;
Answer: d
6. In SQL the spaces at the end of the string are removed by _______ function.
a) Upper
b) String
c) Trim
d) Lower
Answer: c
7. _____ operator is used for appending two strings.
a) &
b) %
c) ||
d) _
Answer: c
8. The union operation is represented by
a) ∩
b) U
c) –
d) *
Answer: b
9. The intersection operator is used to get the _____ tuples.
a) Different
b) Common
c) All
d) Repeating
Answer: b
10. The union operation automatically __________ unlike the select clause.
a) Adds tuples
b) Eliminates unique tuples
c) Adds common tuples
d) Eliminates duplicate
Answer: d
11. If we want to retain all duplicates, we must write ________ in place of union.
a) Union all
b) Union some
c) Intersect all
d) Intersect some
Answer: a
12. The number of attributes in relation is called as its
a) Cardinality
b) Degree
c) Tuples
d) Entity
Answer: b
13. _____ clause is an additional filter that is applied to the result.
a) Select
b) Group-by
c) Having
d) Order by
Answer: c
14. _________ joins are SQL server default
a) Outer
b) Inner
c) Equi
d) None of the mentioned
Answer: b
15. The _____________ is essentially used to search for patterns in target string.
a) Like Predicate
b) Null Predicate
c) In Predicate
d) Out Predicate
Answer: a
16. A _____ indicates an absent value that may exist but be unknown or that may not exist at all.
a) Empty tuple
b) New value
c) Null value
d) Old value
Answer: c
17. 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
a) 0
b) –
c) Null
d) Empty space
Answer: c
18. 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 _____
a) Unknown, unknown, false
b) True, false, unknown
c) True, unknown, unknown
d) Unknown, false, unknown
Answer: d
19. In an employee table to include the attributes whose value always have some value which of the following constraint must be used?
a) Null
b) Not null
c) Unique
d) Distinct
Answer: b
20. Using the ______ clause retains only one copy of such identical tuples.
a) Null
b) Unique
c) Not null
d) Distinct
Answer: d
.pagination { display: inline-block; } .pagination a { color: black; float: left; padding: 8px 16px; text-decoration: none; transition: background-color .3s; border: 1px solid #ddd; margin: 0 4px; } .pagination a.active { background-color: #4CAF50; color: white; border: 1px solid #4CAF50; } .pagination a:hover:not(.active) {background-color: #ddd;}
More Questions
Categories: DBMS
Question and Answers 