1. What is superkey?
2. What is transaction in DBMS?
3. Define candidate key.
4. Which of the following is a query language used in relational database management systems?
A) SQL B) HTML C) Javascript D4) Python
5. A ___________ in a database is a program that responds to database events.
6. ROLLBACK in a database __________statement.
7. A ____________ in a database is a key used to link two tables together.
8. A ___________ in a database is a virtual table based on the result of a query.
9. _____ is the initial value of index for a reverse for loop?
10. What is information about data called_______.
11. _______is known as the minimal super key?
12. An ___ representation of a query is best suited to relational Algebra.
13. __________ is a set of one or more attributes taken collectively to uniquely identify a
Record.
14. By default, the order by clause lists item in ________________ order.
15. The number of attributes in is called as its ______________.
16. Data about data is termed as __________________.
17. The Schema of a hierarchical database is ___________.
18. Data integrity means _____.
19. ROLLBACK in a database is ____ statement.
(A) DDL (B) DML (C) DCL (D) TCL
20. Which database handles full text data, image, audio and video?
(A) Multimedia database (B) Video on demand database (C) Graphics database (D)
Transaction database
21. Database __________ which is the logical design of the database, and the database
_______
22. which is a snapshot of the data in the database at a given instant in time.
(A)Instance, Schema (B) Relation, Schema (C) Relation, Domain (D) Schema, Instance
23. The subset of a super key is a candidate key under what condition?
(A) No proper subset is a super key (B)All subsets are super keys (C) Subset is a super
key (D)Each subset is a super key
24. This query can be replaced by which one of the following?
SELECT name, course_id
FROM instructor, teaches
WHERE instructor_ID= teaches_ID;
(A) Select name,course_id from teaches,instructor where instructor_id=course_id;
(B) Select name, course_id from instructor natural join teaches;
(C) Select name, course_id from instructor;
(D) Select course_id from instructor join teaches;
25. Define the terms key? What are the types of it?
26. Define the term A) pipelining B) Normalization
27. Define the terms a) Prime Attribute b) Non-Prime Attributes.
28. Define the term PL/SQL cursor & trigger.
29. Define the term encryption & decryption?
30. In which of the following formats data is stored in the database management system?
a) Image b) Text c) Table d) Graph
31. To select some particular columns, which of the following commands is used?
a) PROJECTION b) SELECTION c) JOIN d) UNION
32. What type of schema objects are there in schema?
a) Primary Key b) Foreign Key c)Views d)All of the above
33. The file organization that provides very fast access to any arbitrary record of a file is :
a) Ordered file b) Unordered file c)Hashed file d)B-tree
34. Transaction Processing System components are ____.
a) Processing system b) Storage device c) I/O d) All
35. List out various roles of Data Administrator.
36. Explain Cartesian Product Operation with a suitable example?
37. Explain Full Join with a suitable example.
38. Explain advantages & disadvantage of object-oriented database?
39. Why Project Operation is used? Which symbol is used as a select operation notation?
Explain with a suitable example.
40. Explain selection operation with linear search & binary search Algorithm?
41. Explain lossy join & lossless join decomposition with example?
42. What is primary indexing with example? Explain the classification of it? (Dense Index &
Sparse Index)
43. Given relation R with attributes A,B,C,D,E,F and set of FDs,
F = {A → C, A → D, B → E, C → F}.
Find the Closure of A, AC & BF.
44. Explain the term predicates with IN, NOT, Between & like clauses with examples.
45. Which of the following is not a function of a database management system?
a. A) Data Entry B) Data Retrieval C) Data Manipulation D) Data Analysis
46. What is an ER diagram?
47. What is a subquery in a database?
48. What is a database schema?
a. A) A graphical representation of the database structure B) A set of rules for
b. data entry
c. C) A collection of tables in a database D) A blueprint of the
d. database structure
49. Which of the following is an example of a database management system?
A) MS Excel B) MS Word C) MS Access D) MS Powerpoint
50. Define tuple.
51. Define relation in DBMS.
52. Answer the following questions. (Attempt any three)
A) List and brief advantages of Three-tier architecture.
B) Differentiate DDL and DML.
C) Explain two phase locking in details.
D) Explain types of joins in DBMS.
53. Explain ACID properties in details.
54. Explain Deadlock and Deadlock Detection in details.
55. Explain query processing in details.
56. What is Normalization? Brief different normal forms in details.
57. List out ER diagram symbols and Draw an E R Diagram for Printing Press Management
System.
58. Explain view in details with example.
59. Give the difference between DML & DDL and give their suitable examples (07)
60. Explain relational algebra operations.
61. List types of DBMS and Explain distributed and Centralized DBMS.
62. What is Data Dictionary? Explain its types.
