SYMBIOSIS CENTRE FOR DISTANCE LEARNING (SCDL)

Subject: Database Management Systems

Sample Questions:

Section I: Subjective Questions

1. Explain: a) Cartesian Product Operation b) Rename Operation

2. Explain the features of a table if it is in Boyce Codd Normal Form

3. Explain database normalisation.

4. Explain the importance of Roles in ER diagram.

5. Explain Referential Integrity.
6. Discuss the advantages of concurrent executions.
7. Discuss the features of DDL, DML and DCL languages.
8. Explain the ACID properties in detail.

Section II: Objective Questions

Multiple Choice Single Response

1. In the following type of schedule, for any database state, the effect of executing the first
schedule is identical to the effect of executing the second schedule.
1] Equivalent schedule
2] Serial schedule
3] Serializable schedule
4] Atomic

2. Allowing multiple transactions to update data concurrently causes several complications with
the following
1] consistency of data
2] rewriting of data
3] summary of data
4] execution of data

3. Following operator finds the common tuples in two relations with like attribute.
1] Set difference
2] Set intersection
3] Set union
4] join

4. When data which has a single value is normally in the following form
1] first normal
2] second normal
 SYMBIOSIS CENTRE FOR DISTANCE LEARNING (SCDL)
Subject: Database Management Systems

3] third normal
4] fourth normal

5. Following language satisfies the constraints oriented to the database Schema

1] DDL
2] DML
3] SQL
4] TCL

6. A user who is granted a privilege can pass the privilege on the other users by using the
following
1] revoke
2] with pass option
3] with grant option
4] with select option

7. With SQL, how do you select an EmpName from a table name 'Employee' where the value of
the column 'LastName' starts with 'P'?
1] Select * from Employee where LastName Like '%p'
2] Select from Employee where LastName Like 'P%'
3] Select EmpName from Employee where LastName Like 'P%';
4] Select from Employee where LastName='%P'

8. Write a command to grant all privileges on 'Branch' table to user 'Anita'.

1] Grant all privileges on Branch Table to Anita
2] Grant all on Branch Table to Anita
3] Grant all privileges to Anita on Branch Table
4] Grant All to Anita on Branch Table

9. Allowing multiple transactions to update data concurrently causes several complications with
the following
1] consistency of data
2] rewriting of data
3] summary of data
4] execution of data

10. Following level of abstraction describes complex low- level data structure in details
1] Physical
2] Logical
3] View
4] User

Multiple Choice Multiple Response

11. Concurrency Control related activities are

1] Lock
2] Unlock
3] Deadlock
4] Abort
 SYMBIOSIS CENTRE FOR DISTANCE LEARNING (SCDL)
Subject: Database Management Systems

12. Following are the derived operators.

1] Set union
2] Set intersection
3] Join
4] Set difference

13. In banks, Database is used for what reason

1] Publicity
2] Accounts information
3] Loans
4] Banking Transaction

14. Primary goal of DBMS is

1] To store data
2] To retrieve data
3] To store and retrieve data
4] To manage data

15. A database management system is a combination of software and hardware that can be used to
do the following
1] Setup Database
2] Monitor Database
3] Update and Retrieval of Database
4] send emails

16. What is the meaning of Data manipulation

1] Retrieval of information
2] Insertion of new information
3] Deletion of information
4] Creation of Information

17. The different states of transaction are

1] Active
2] Partially Committed
3] Update
4] Rollback

18. The options available after transaction gets aborted are

1] Restart the transaction
2] Kill the transaction
3] Update
4] Commit

Fill in the Blanks

19. An RDBMS is a _________.

1] Resource
2] Transaction monitor
 SYMBIOSIS CENTRE FOR DISTANCE LEARNING (SCDL)
Subject: Database Management Systems

3] Resource Manager
4] Language

20. The transaction is recorded in a _________which keeps track of all transactions that update the
DB.
1] Log
2] Database
3] CD
4] Disk

21. Java transaction API(JTA) is a part of J2EE and offers _________ capabilities
1] XA
2] YA
3] AB
4] XY

22. For doing computational functions _________ are used.

1] Subqueries
2] Aggregate functions
3] Set operations
4] String operations

23. A join is a query that combines _________ from two or more tables.
1] rows
2] tables
3] data
4] attributes

24. _________ model is used widely after Relational model.

1] Entity Relationship
2] Network
3] Object oriented
4] Hierarchical

25. An entity set is a set of entities of the _________ type.

1] same
2] different
3] abstract
4] unique

26. _________ statement is used to delete data from a database.

1] Delete
2] Drop
3] Remove
4] Change

27. The relational algebra is a _________ query language.

1] structured
2] procedural
 SYMBIOSIS CENTRE FOR DISTANCE LEARNING (SCDL)
Subject: Database Management Systems

3] natural
4] Unified

28. Any DDL statement after _________ of table schema updates metadata.
1] Creation
2] Deletion
3] Updation
4] Modification

State True or False

29. Concurrent execution of user programs is essential for good DBMS performance.
30. At the logical level all the records can be described as a block of consecutive storage location.
31. WHERE clause condition compares two columns each from same table.
32. Database name cannot begin with an underscore.
33. An SQL trigger can be directly called from an application.
34. Relational algebra is not used for query optimization.
35. With the help of scalable SQL, you can store the data in tables, but cannot modify it.
36. According to 4NF, no table may contain two or more 1:n or n:m relationships that are not
directly related.
37. All locks held by a transaction are not released when the transaction completes.
38. For the Set operations on relations, both operands must have the same scheme.

Match the Following

39. 1] Participates in distributed transaction and

1] Resource
manages some part of data

2] Ensures that XA protocol is properly

2] Resource Manager
followed

3] Co-ordinates communication between

3] Transaction Monitor
application and resource Managers

4] XA 4] Extended Architecture

5] Extended Archive

6] Co-ordinates communication between

resource Managers

40. 1] Integrity manager 1] Authority of user

2] Transaction manager 2] Ensuring consistency of data

3] File manager 3] Data structure

 SYMBIOSIS CENTRE FOR DISTANCE LEARNING (SCDL)
Subject: Database Management Systems

4] Buffer manager 4] Fetching data

5] Stores the metadata of schemes.

6] Provides fast access to data

41. 1] From clause 1] Cartesian product

2] Where clause 2] Selection predicate

3] AND operator 3] Joins two or more conditions

4] DISTINCT operation 4] Eliminate duplicates

5] Projection operation

6] Make a use of Like keyword

42. 1] Set-difference 1] binary operation

2] Select 2] unary operation

3] Cartesian product 3] X operator

4] Rename 4] rho symbol

5] ~ symbol

6] s operator