25th
Jul
DBMS MCQ

DBMS MCQ

  • Admin
  • 25th Jul, 2020
  • 318 Followers

DBMS MCQ Quiz

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

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

2) A relational database consists of a collection of

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

3) 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

4) 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

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

  • A. Indivisbile
  • B. Constant
  • C. Different
  • D. Divisible
Download Free : DBMS MCQ PDF

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

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

7) 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

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

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

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

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

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

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

11) 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

12) _________ joins are SQL server default

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

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

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

14) The result of _____unknown is unknown.

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

15) 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

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

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

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

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

18) 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

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

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

20) 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

21) What type of statement is this?

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

22) _____ operator is used for appending two strings.

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

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

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

24) 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

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

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

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

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

27) The primary key must be

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

28) Updates that violate __________ are disallowed.

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

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

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

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

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

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

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

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

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

33) 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

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

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

35) 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

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

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

37) The union operation is represented by

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

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

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

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

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

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

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

Leave A Comment :

Valid name is required.

Valid name is required.

Valid email id is required.

Related MCQ/Quiz

01st
Dec
Laravel MCQ
01st
Dec
React JS MCQ
01st
Jan
AngularJs MCQ
01st
Jul
Node js MCQ
01st
Jul
Angular 2 MCQ
01st
Jul
JSON MCQ