On This Page

This set of DataBase Management System (DBMS) Multiple Choice Questions & Answers (MCQs) focuses on Database Management System Set 32

Q1 | ……………… table store information about database or about the system.
  • SQL
  • Nested
  • System
  • None of these
Q2 | …………..defines the structure of a relation which consists of a fixed set of attribute-domain pairs.
  • Instance
  • Schema
  • Program
  • Super Key
Q3 | ……………… clause is an additional filter that is applied to the result.
  • Select
  • Group-by
  • Having
  • Order by
Q4 | A logical schema
  • is the entire database
  • is a standard way of organizing information into accessible parts.
  • describes how data is actually stored on disk.
  • All of the above
Q5 | ………………… is a full form of SQL.
  • Standard query language
  • Sequential query language
  • Structured query language
  • Server side query language
Q6 | The candidate key is that you choose to identify each row uniquely is called ……………..
  • Alternate Key
  • Primary Key
  • Foreign Key
  • None of the above
Q7 | …………….. is used to determine whether of a table contains duplicate rows.
  • Unique predicate
  • Like Predicate
  • Null predicate
  • In predicate
Q8 | To eliminate duplicate rows ……………… is used
  • NODUPLICATE
  • ELIMINATE
  • DISTINCT
  • None of these
Q9 | State true or false i) A candidate key is a minimal super key. ii) A candidate key can also refer to as surrogate key.
  • i-true, ii-false
  • i-false, ii-true
  • i-true, ii-true
  • i-false, ii-false
Q10 | DCL stands for
  • Data Control Language
  • Data Console Language
  • Data Console Level
  • Data Control Level
Q11 | …………………… is the process of organizing data into related tables.
  • Normalization
  • Generalization
  • Specialization
  • None of the above
Q12 | A ………………. does not have a distinguishing attribute if its own and mostly are dependent entities, which are part of some another entity.
  • Weak entity
  • Strong entity
  • Non attributes entity
  • Dependent entity
Q13 | …………….. is the complex search criteria in the where clause.
  • Substring
  • Drop Table
  • Predict
  • Predicate
Q14 | ………………… is preferred method for enforcing data integrity
  • Constraints
  • Stored Procedure
  • Triggers
  • Cursors
Q15 | The number of tuples in a relation is called it’s …………. While the number of attributes in a relation is called it’s ………………..
  • Degree, Cardinality
  • Cardinality, Degree
  • Rows, Columns
  • Columns, Rows
Q16 | State true or false. i) Select operator is not a unary operator. ii) Project operator chooses subset of attributes or columns of a relation.
  • i-True, ii-False
  • i-True, ii-True
  • i-False, ii-True
  • i-False, ii-False
Q17 | …………… database is used as template for all databases created.
  • Master
  • Model
  • Tempdb
  • None of the above
Q18 | One aspect that has to be dealt with by the integrity subsystem is to ensure that only valid values canbe assigned to each data items. This is referred to as
  • Data Security
  • Domain access
  • Data Control
  • Domain Integrity
Q19 | ………………….. operator is basically a join followed by a project on the attributes of first relation.
  • Join
  • Semi-Join
  • Full Join
  • Inner Join
Q20 | Which of the following is not a binary operator in relational algebra?
  • Join
  • Semi-Join
  • Assignment
  • Project
Q21 | Centralizing the integrity checking directly under the DBMS ………….. duplication and ensures theconsistency and validity of the database.
  • Increases
  • Skips
  • Does not reduce
  • Reduces
Q22 | Which of the following is/are the DDL statements?
  • Create
  • Drop
  • Alter
  • All of the above
Q23 | ---------------- is used to retrieve tuples from the relation.
  • Create
  • Drop
  • Select
  • All of the above
Q24 | ……………… defines rules regarding the values allowed in columns and is the standard mechanismfor enforcing database integrity.
  • Column
  • Constraint
  • Index
  • Trigger
Q25 | For like predicate which of the following is true. i) % matches zero of more characters. ii) _ matches exactly one character.
  • i-only
  • ii-only
  • Both of them
  • None of them