DBMS Basics

Different values for the same data item is referred to as ................

• Data Redundancy

• Data Integrity

• Data consistency

• Data Inconsistency

Which is a special type of integrity constraint that relates two relations & maintains consistency across the relations

• Entity Integrity Constraints

• Domain Constraints

• Key Constraints

• Referential Integrity Constraints

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

• ID

• City

• Name

• City,ID

Given the relations employee (name, salary, deptno)and department (deptno, deptname, address):Which of the following queries cannot be expressed using the basic relational algebra operations (U, -, x, π, σ, p)?

• Department Address of each employee

• Employees whose name is same as that of their department

• The sum of all employee's salaries

• All employees of a given department

Consider Students (rollno, name, address ) Enroll (rollno, courseno, coursename) where primary keys are shown in italics: The number of tuples in the student and Enroll tables are 120 and 8 respectively: What are the maximum and minimum number of tuples that can be present in (Student *Enroll) , where * denotes natural join ? [GATE 2014]

• 8,8

• 120,8

• 960,8

• 960,120

Data independence means

• data is defined separately and not included in programs

• programs are not dependent on the physical attributes of data

• programs are not dependent on the logical attributes of data

• both option 2 and option 3

Grant and revoke are ................... statements

• DDL

• DCL

• DML

• TCL

………………… is preferred method for enforcing data integrity

• Constraints

• Stored Procedure

• Triggers

• Cursor

The language that requires a user to specify the data to be retrieved with specifying exactly how to get it is

• Procedural DML

• Non-procedural DML

• Procedural DDL

• Non-Procedural DDL

Some of the utilities of DBMS are .......................

(i) Loading (ii) Back up (iii) File Organization (iv) Process Organization

• (i), (ii) and (iii)

• (i), (ii) and (iv)

• (ii), (iii) and (iv)

• All of these