Final Exam (DBMS Srm)

30 Questions | By Srmdbms | Updated: Mar 20, 2022 | Attempts: 210

Questions

Settings

Create your own Quiz

Final Exam for DBMS SRM. All the best :)

Questions and Answers

1.

The ability to modify the internal schema without causing any change to external schema is
- A.
  
  Physical Data independence
- B.
  
  Logical Data independence
- C.
  
  External Data independence
- D.
  
  None of these
2.

A relation R(A,b,C,D,E) has the following set of dependenciesF: A->BC, C->D, D->B, B->E,A->E. The decomposition of R: R1=(A,B,C), R2=(C,D), R3=(B,D,E) is
- A.
  
  Lossless and dependency preserving
- B.
  
  Lossless but not dependency preserving
- C.
  
  Not lossless but dependency preserving
- D.
  
  Neither Lossless nor dependency preserving
3.

Consider a relation Student with attributes class, section, Roll, name ,address. For any sec, class and roll there is only one address and for one address there is only one name. The highest normal form in which the table is
- A.
  
  1 NF
- B.
  
  2 NF
- C.
  
  3 NF
- D.
  
  BCNF
4.

Consider the following schedule S with three transactions S: R1(B); R3(C); R1(A); W2(A); W1(A); W2(B); W3(A); W1(B); W3(B); W3(C).Which of the following is TRUE w.r.t the above schedule
- A.
  
  It is conflict serializable with sequence
- B.
  
  It is conflict serializable with sequence
- C.
  
  It is view serializable but not conflict serializable
- D.
  
  It is neither conflict serializable nor view serializable
5.

If every attribute is a candidate key then the table is in
- A.
  
  1NF
- B.
  
  2NF
- C.
  
  3NF
- D.
  
  BCNF
6.

What should be the condition for total participation of the entity in a relation
- A.
  
  Maximum cardinality should be one
- B.
  
  Minimum cardinality should be zero
- C.
  
  Minimum cardinality should be one
- D.
  
  None of these
7.

In the top down database design approach which of the following is taken as input?
- A.
  
  Entity
- B.
  
  Relations
- C.
  
  ER Diagrams
- D.
  
  Attributes
8.

Tuple relational calculus is a
- A.
  
  Procedural Language
- B.
  
  Materialized language
- C.
  
  Non-procedural language
- D.
  
  None
9.

Which of the following scenarios may lead to an irrecoverable error in a database system?
- A.
  
  A transaction writes a data item after it is read by an uncommitted transaction
- B.
  
  A transaction reads a data item after it is read by an uncommitted transaction
- C.
  
  A transaction reads a data item after it is written by a committed transaction
- D.
  
  A transaction reads a data item after it is written by an uncommitted transaction
10.

R is a relational schema R(ABC), F ={A->BC,B->C,AB->C } is a set of functional dependencies. The canonical cover will be
- A.
  
  A->BC, B->C
- B.
  
  A->BC, AB->C
- C.
  
  A->BC, A->B
- D.
  
  A->B, B->C
11.

Which privilege is required to create a database?
- A.
  
  SYSDBA
- B.
  
  DBA
- C.
  
  SYSOPER
- D.
  
  RESOURCE
12.

Which of the following is not a binary operator in relational algebra?
- A.
  
  Join
- B.
  
  Semi Join
- C.
  
  Assignment
- D.
  
  Project
13.

The developer issues the following statement:CREATE OR REPLACE TRIGGER soccer_fans_snacks_02 BEFORE DELETE ONSOCCER_FANSBEGINDELETE FROM soccer_fans_snacksWHERE fan_id = :old.fan_id;END;Why will trigger creation fail?
- A.
  
  The row trigger does not properly reference the old value in FAN_ID.
- B.
  
  The statement trigger should have been defined as a row trigger.
- C.
  
  The statement trigger fires after the delete statement is processed.
- D.
  
  The row trigger does not properly define the associated table
14.

The SELECT statement, that retrieves all the columns from empinfo table name starting with d to p is
- A.
  
  SELECT ALL FROM empinfo WHERE ename like '[d-p]%';
- B.
  
  SELECT * FROM empinfo WHERE ename is '[d-p]%';
- C.
  
  SELECT * FROM empinfo WHERE ename like '[p-d]%';
- D.
  
  SELECT * FROM empinfo WHERE ename like '[d-p]%';
15.

The main task carried out in the …………… is to remove repeating attributes to separate tables.
- A.
  
  First Normal Form
- B.
  
  Second Normal Form
- C.
  
  Third Normal Form
- D.
  
  Fourth Normal Form
16.

Which statement is true about views?
- A.
  
  A view can be created as a join on two or more tables.
- B.
  
  A view cannot have an ORDER BY clause in the SELECT statement.
- C.
  
  A view cannot be created with a GROUP BY clause in the SELECT statement
- D.
  
  A view must have aliases defined for the column names in the SELECT statement
17.

Evaluate this SQL statement:SELECT employee_id, e.department_id, department_name, salary FROM employees e, departments d WHERE e.department_id = d.department_id;Which SQL statement is equivalent to the above SQL statement?
- A.
  
  SELECT employee_id, department_id, department_name, salary FROM employees WHERE department_id IN (SELECT department_id FROM departments);
- B.
  
  SELECT employee_id, department_id, department_name, salary FROM employees NATURAL JOIN departments;
- C.
  
  SELECT employee_id, d.department_id, department_name, salary FROM employees e JOIN departments d ON e.department_id = d.department_id;
- D.
  
  SELECT employee_id, department_id, department_name, salary FROM employees JOIN departments USING (e.department_id, d.department_id);
18.

Evaluate this SQL statement:SELECT e.EMPLOYEE_ID,e.LAST_NAME,e.DEPARTMENT_ID, d.DEPARTMENT_NAME FROM EMP e, DEPARTMENT d WHERE e.DEPARTMENT_ID = d.DEPARTMENT_ID;In the statement, which capabilities of a SELECT statement are performed?
- A.
  
  Selection, projection, join
- B.
  
  Difference, projection, join
- C.
  
  Selection, intersection, join
- D.
  
  Intersection, projection, join
- E.
  
  Difference, projection, product
19.

In which three cases would you use the USING clause? (Choose three.)
- A.
  
  You want to create a nonequijoin.
- B.
  
  The tables to be joined have multiple NULL columns
- C.
  
  The tables to be joined have columns of the same name and different data types
- D.
  
  The tables to be joined have columns with the same name and compatible data types
- E.
  
  You want to use a NATURAL join, but you want to restrict the number of columns in the join condition
20.

In which two cases would you use an outer join? (Choose two.)
- A.
  
  The tables being joined have NOT NULL columns.
- B.
  
  The tables being joined have only matched data.
- C.
  
  The columns being joined have NULL values.
- D.
  
  The tables being joined have only unmatched data
- E.
  
  The tables being joined have both matched and unmatched data
- F.
  
  Only when the tables have a primary key/foreign key relationship
21.

A surrogate key is similar to...
- A.
  
  Primary key
- B.
  
  Artificial key
- C.
  
  Foreign key
- D.
  
  None of the above
22.

Which one will be violated, if the primary key value is null in the new tuple...
- A.
  
  Key constraint
- B.
  
  Entity integrity
- C.
  
  Referential integrity
- D.
  
  Domain constraint
23.

An insert operation may violate...
- A.
  
  Key constraint and Domain constraint
- B.
  
  Referential integrity and Entity integrity
- C.
  
  only Entity integrity
- D.
  
  All 4 constraints
24.

A delete operation may violate...
- A.
  
  Key constraint
- B.
  
  Entity integrity
- C.
  
  Referential integrity
- D.
  
  None of the above
25.

If transaction 'A' sees the effects of transaction 'B', and 'B' then aborts, then 'A' also gets aborted then this schedulehaving only two transactions A and B will be..
- A.
  
  Serializable
- B.
  
  recoverable
- C.
  
  Cascadeless
- D.
  
  None of the above