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

Bachelor of Science in Computer Science (BSc CS),

Master of Business Administration (MBA)

Learning Mode Previous Next
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.
Q2 | …………..defines the structure of a relation which consists of a fixed set of attribute-domain pairs.
Q3 | ……………… clause is an additional filter that is applied to the result.
Q4 | A logical schema
Q5 | ………………… is a full form of SQL.
Q6 | The candidate key is that you choose to identify each row uniquely is called ……………..
Q7 | …………….. is used to determine whether of a table contains duplicate rows.
Q8 | To eliminate duplicate rows ……………… is used
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.
Q10 | DCL stands for
Q11 | …………………… is the process of organizing data into related tables.
Q12 | A ………………. does not have a distinguishing attribute if its own and mostly are dependent entities, which are part of some another entity.
Q13 | …………….. is the complex search criteria in the where clause.
Q14 | ………………… is preferred method for enforcing data integrity
Q15 | The number of tuples in a relation is called it’s …………. While the number of attributes in a relation is called it’s ………………..
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.
Q17 | …………… database is used as template for all databases created.
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
Q19 | ………………….. operator is basically a join followed by a project on the attributes of first relation.
Q20 | Which of the following is not a binary operator in relational algebra?
Q21 | Centralizing the integrity checking directly under the DBMS ………….. duplication and ensures theconsistency and validity of the database.
Q22 | Which of the following is/are the DDL statements?
Q23 | ---------------- is used to retrieve tuples from the relation.
Q24 | ……………… defines rules regarding the values allowed in columns and is the standard mechanismfor enforcing database integrity.
Q25 | For like predicate which of the following is true. i) % matches zero of more characters. ii) _ matches exactly one character.
Previous Next