Database Management System Set 32
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 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