29th
Mar
DBMS MCQ

DBMS MCQ

  • Admin
  • 29th Mar, 2021
  • 801 Followers

DBMS MCQ Questions and Answers

Following are mostly asked Dbms MCQ test that are designed for professionals like you to crack you interviews. You can take this Dbms online test before appearing to you real interview. This Dbms quiz there are around 30+ multiple choice questions on Dbms with four options.

1) A relational database consists of a collection of

  • A. Records
  • B. Keys
  • C. Tables
  • D. Fields

2) A ________ in a table represents a relationship among a set of values.

  • A. Row
  • B. Entry
  • C. Key
  • D. Column

3) The term _______ is used to refer to a row.

  • A. Tuple
  • B. Attribute
  • C. Field
  • D. Instance

4) The term attribute refers to a ___________ of a table.

  • A. Record
  • B. Tuple
  • C. Column
  • D. Key

5) For each attribute of a relation, there is a set of permitted values, called the ________ of that attribute.

  • A. Relation
  • B. Schema
  • C. Domain
  • D. Set
Download Free : DBMS MCQ PDF

6) A domain is atomic if elements of the domain are considered to be ____________ units.

  • A. Indivisbile
  • B. Constant
  • C. Different
  • D. Divisible

7) The tuples of the relations can be of ________ order.

  • A. Same
  • B. Sorted
  • C. Any
  • D. Constant

8) Consider attributes ID, CITY and NAME. Which one of this can be considered as a super key?

  • A. ID
  • B. CITY
  • C. NAME
  • D. CITY, ID

9) A _____ is a property of the entire relation, rather than of the individual tuples in which each tuple is unique.

  • A. Key
  • B. Attribute
  • C. Rows
  • D. Fields

10) Which one of the following attribute can be taken as a primary key?

  • A. Street
  • B. Id
  • C. Department
  • D. Name

11) Which one of the following cannot be taken as a primary key?

  • A. Street
  • B. Register number
  • C. Id
  • D. Dept_id

12) Using which language can a user request information from a database?

  • A. Relational
  • B. Structural
  • C. Query
  • D. Compiler

13) Student(ID, name, dept name, tot_cred) In this query which attributes form the primary key?

  • A. Dept
  • B. Tot_cred
  • C. ID
  • D. Name

14) Which one of the following is a procedural language?

  • A. Domain relational calculus
  • B. Relational algebra
  • C. Query language
  • D. Tuple relational calculus

15) The _______operation performs a set union of two “similarly structured” tables

  • A. Product
  • B. Intersect
  • C. Union
  • D. Join

16) The most commonly used operation in relational algebra for projecting a set of tuple from a relation is

  • A. Projection
  • B. Join
  • C. Union
  • D. Select

17) The _______ operator takes the results of two queries and returns only rows that appear in both result sets.

  • A. Intersect
  • B. Projection
  • C. Union
  • D. Difference

18) What type of statement is this?

  • A. DDL
  • B. View
  • C. DML
  • D. Integrity constraint

19) To remove a relation from an SQL database, we use the ______ command.

  • A. Drop table
  • B. Purge
  • C. Delete
  • D. Remove

20) Updates that violate __________ are disallowed.

  • A. Authorization
  • B. Transaction control
  • C. DDL constraints
  • D. Integrity constraints

21) The ________ clause is used to list the attributes desired in the result of a query.

  • A. Where
  • B. From
  • C. Distinct
  • D. Select

22) In SQL the spaces at the end of the string are removed by _______ function.

  • A. Trim
  • B. Upper
  • C. Lower
  • D. String

23) _____ operator is used for appending two strings.

  • A. %
  • B. &
  • C. _
  • D. ||

24) The union operation is represented by

  • A. U
  • B.
  • C.
  • D. *

25) The intersection operator is used to get the _____ tuples.

  • A. Common
  • B. Different
  • C. Repeating
  • D. All

26) If we want to retain all duplicates, we must write ________ in place of union.

  • A. Union all
  • B. Intersect all
  • C. Union some
  • D. Intersect some

27) The number of attributes in relation is called as its

  • A. Entity
  • B. Cardinality
  • C. Tuples
  • D. Degree

28) _____ clause is an additional filter that is applied to the result.

  • A. Having
  • B. Group-by
  • C. Select
  • D. Order by

29) _________ joins are SQL server default

  • A. Inner
  • B. Equi
  • C. Outer
  • D. None of the mentioned

30) The _____________ is essentially used to search for patterns in target string.

  • A. Like Predicate
  • B. In Predicate
  • C. Null Predicate
  • D. Out Predicate

31) A _____ indicates an absent value that may exist but be unknown or that may not exist at all.

  • A. New value
  • B. Old value
  • C. Null value
  • D. Empty tuple

32) Using the ______ clause retains only one copy of such identical tuples

  • A. Null
  • B. Distinct
  • C. Unique
  • D. Not null

33) The primary key must be

  • A. Unique
  • B. Not null
  • C. Both Unique and Not null
  • D. Either Unique or Not null

34) The result of _____unknown is unknown.

  • A. Xor
  • B. And
  • C. Not
  • D. Or

35) Aggregate functions are functions that take a ___________ as input and return a single value.

  • A. Aggregate value
  • B. Single value
  • C. Collection of values
  • D. Both Collection of values & Single value

36) All aggregate functions except _____ ignore null values in their input collection.

  • A. Count(attribute)
  • B. Avg
  • C. Count(*)
  • D. Sum

37) A Boolean data type that can take values true, false, and________

  • A. Null
  • B. 1
  • C. Unknown

38) The phrase “greater than at least one” is represented in SQL by _____

  • A. < all
  • B. > all
  • C. < some
  • D. > some

39) We can test for the nonexistence of tuples in a subquery by using the _____ construct.

  • A. Not exist
  • B. Not exists
  • C. Exists
  • D. Exist

40) Which of the following creates a temporary relation for the query on which it is defined?

  • A. With
  • B. Where
  • C. From
  • D. Select

Leave A Comment :

Valid name is required.

Valid name is required.

Valid email id is required.

Related MCQ/Quiz

01st
Mar
Xml MCQ
01st
Mar
Hadoop MCQ
01st
Jan
CodeIgniter MCQ