1. What is the full form of DBMS?

a) Data of Binary Management System

b) Database Management System

c) Database Management Service

d) Data Backup Management System

2. What is a database?

a) Organized collection of information that cannot be accessed, updated, and managed

b) Collection of data or information without organizing

c) Organized collection of data or information that can be accessed, updated, and managed

d) Organized collection of data that cannot be updated

3. What is DBMS?

a) DBMS is a collection of queries

b) DBMS is a high-level language

c) DBMS is a programming language

d) DBMS stores, modifies and retrieves data

4. Who created the first DBMS?

a) Edgar Frank Codd

b) Charles Bachman

c) Charles Babbage

d) Sharon B. Codd

5. Which type of data can be stored in the database?

a) Image oriented data

b) Text, files containing data

c) Data in the form of audio or video

6. In which of the following formats data is stored in the database management system?

a) Image

b) Text

c) Table

d) Graph

7. Which of the following is not a type of database?

a) Hierarchical

b) Network

c) Distributed

d) Decentralized

8. Which of the following is not an example of DBMS?

a) MySQL

b) Microsoft Acess

c) IBM DB2

d) Google

9. Which of the following is a feature of DBMS?

a) Minimum Duplication and Redundancy of Data

b) High Level of Security

c) Single-user Access only

d) Support ACID Property

10. Which of the following is a feature of the database?

a) No-backup for the data stored

b) User-interface provided
c) Lack of Authentication

d) Store data in multiple locations

11. Which of the following is not a function of the database?

a) Managing stored data

b) Manipulating data

c) Security for stored data

d) Analysing code

12. Which of the following is a function of the DBMS?

a) Storing data

b) Providing multi-users access control

c) Data Integrity

d) All of the above

13. Which of the following is a component of the DBMS?

a) Data

b) Data Languages

c) Data Manager

d) All of the above

14. Which of the following is known as a set of entities of the same type that share same properties, or
attributes?

a) Relation set

b) Tuples

c) Entity set

d) Entity Relation model

15. What is information about data called?

b) Tera data

c) Meta data

d) Relations

16. What does an RDBMS consist of?

a) Collection of Records

b) Collection of Keys

c) Collection of Tables

d) Collection of Fields

17. The values appearing in given attributes of any tuple in the referencing relation must likewise occur
in specified attributes of at least one tuple in the referenced relation, according to
_____________________ integrity constraint.

a) Referential

b) Primary

c) Referencing

d) Specific

18. _____________ is a hardware component that is most important for the operation of a database
management system.

a) Microphone

b) High speed, large capacity disk to store data

c) High-resolution video display

d) Printer

19. The DBMS acts as an interface between ________________ and ________________ of an

a) Data and the DBMS

b) Application and SQL

d) The user and the software

20. The ability to query data, as well as insert, delete, and alter tuples, is offered by ____________

a) TCL (Transaction Control Language)

b) DCL (Data Control Language)

c) DDL (Data Definition Langauge)

d) DML (Data Manipulation Langauge)

21. ______________ is a set of one or more attributes taken collectively to uniquely identify a record.

a) Primary Key

b) Foreign key

c) Super key

d) Candidate key

22. Which command is used to remove a relation from an SQL?

a) Drop table

b) Delete

c) Purge

d) Remove

23. Which of the following set should be associated with weak entity set for weak entity to be
meaningful?

a) Neighbour set

b) Strong entity set

c) Owner set

d) Identifying set

24. Which of the following command is correct to delete the values in the relation teaches?
a) Delete from teaches;

b) Delete from teaches where Id =’Null’;

c) Remove table teaches;

d) Drop table teaches;

25. Procedural language among the following is __________

a) Domain relational calculus

b) Tuple relational calculus

c) Relational algebra

d) Query language

26. _________________ operations do not preserve non-matched tuples.

a) Left outer join

b) Inner join

c) Natural join

d) Right outer join

27. Which forms have a relation that contains information about a single entity?

a) 4NF

b) 2NF

c) 5NF

d) 3NF

28. The top level of the hierarchy consists of ______ each of which can contain _____.

a) Schemas, Catalogs

b) Schemas, Environment

c) Environment, Schemas

d) Catalogs, Schemas
29. _______ indicates the maximum number of entities that can be involved in a relationship.

a) Greater Entity Count

b) Minimum cardinality

c) Maximum cardinality

d) ERD

30. The user IDs can be added or removed using which of the following fixed roles?

a) db_sysadmin

b) db_accessadmin

c) db_securityadmin

d) db_setupadmin

31. The traditional storage of data organized by the customer, stored in separate folders in filing
cabinets is an example of ______________ type of ‘database’ management system.

a) Object-oriented database management system

b) Relational database management system

c) Network database management system

d) Hierarchical database management system

32. After groups have been established, SQL applies predicates in the ___________ clause, allowing
aggregate functions to be used.

a) Where

b) Having

c) Group by

d) With

33. Which of the following is not the utility of DBMS?

i) Backup ii) Loading iii) Process Organization iv) File organization

a) I, ii, and iv only

c) I, iii and iv only

d) All I, ii, iii, and iv

34. Which of the following is correct regarding the file produced by a spreadsheet?

a) can be used as it is by the DBMS

b) stored on disk in an ASCII text format

c) all of the mentioned

d) none of the mentioned

35. What is the function of the following command?

Delete from r where P;

a) Clears entries from relation

b) Deletes relation

c) Deletes particular tuple from relation

d) All of the mentioned

36. ______ resembles Create view.

a) Create table . . . as

b) Create view as

c) Create table . . .like

d) With data

37. Which of the following is the best way to represent the attributes in a large db?

a) Dot representation

b) Concatenation

c) Relational-and

d) All of the mentioned

a) Data Described Language

b) Data Retrieval Language

c) Data Manipulation Language

d) Data Definition Language

39. Which of the following functions construct histograms and use buckets for ranking?

a) Ntil()

b) Newtil()

c) Rank()

d) All of the mentioned

40. __________ command is used in SQL to issue multiple CREATE TABLE, CREATE VIEW and GRANT
statements in a single transaction.

a) CREATE CLUSTER

b) CREATE PACKAGE

c) CREATE SCHEMA

d) All of the mentioned

41. Which of the following key is required in to handle the data when the encryption is applied to the
data so that the unauthorised user cannot access the data?

a) Primary key

b) Authorised key

c) Encryption key

d) Decryption key

42. Which of the following is known as the process of viewing cross-tab with a fixed value of one
attribute?

a) Dicing
b) Pivoting

c) Slicing

d) Both Pivoting and Dicing

43. For designing a normal RDBMS which of the following normal form is considered adequate?

a) 4NF

b) 3NF

c) 2NF

d) 5NF

44. Which of the following is popular for applications such as storage of log files in a database
management system since it offers the best write performance?

a) RAID level 0

b) RAID level 1

c) RAID level 2

d) RAID level 3

45. Which of the following represents a query in the tuple relational calculus?

a) { }{P(t) | t }

b) {t | P(t)}

c) t | P() | t

d) All of the mentioned

46. The oldest DB model is _______________

a) Network

b) Physical

c) Hierarchical

d) Relational
47. Which of the following establishes a top-to-bottom relationship among the items?

a) Relational schema

b) Network schema

c) Hierarchical schema

d) All of the mentioned

48. A major goal of the db system is to minimize the number of block transfers between the disk and
memory. Which of the following helps in achieving this goal?

a) Secondary storage

b) Storage

c) Catalog

d) Buffer

49. What happens if a piece of data is stored in two places in the db?

a) Storage space is wasted & Changing the data in one spot will cause data inconsistency

b) In can be more easily accessed

c) Changing the data in one spot will cause data inconsistency

d) Storage space is wasted

50. The logical design, and the snapshot of the data at a given instant in time is known as?

a) Instance & Relation

b) Relation & Schema

c) Domain & Schema

d) Schema & Instance

5 MARK

1.Explain about temporal database

2.Explain about Intervels

4.Integrity of constais

5.Multimedia database Applications

6.Explain Entity types

7 .ER to Relational maping algorithms

8. Explain BCNF

9.Inter Query parallies intra query

10.Functional dependence

11.Commit protocols

12.Distributed data storage

13.Concorency control

14.Object Identity and reference types

15.Table Inheritance

16.XML Documents

17.Define DTD

18.XML Schema

19.spatial database characteristics

20.Techniques of spatial database query

21.Logic based database

22.propositional calculus

23.Dedective database systems

8 MARK

1.Relationship Types

2.Normalization

3.ER Model

4.Relational and parallel database design Architecture

5.Intraoperation and Interoperation

7.Distributed transactions

8.Query processing

9.complex data types

10.object oriented VS object relational

11.XML queries

12.Define XHTML with examples

13.LLiustrative exprement

14.spatial data model

15.spatial database Queries

16.Predicate calculus

17.Recuraive query processing

18. Overview of calculus

19.packing and unpacking relations

20.Gendralizing relational operators

21.Multimedia database

22.Multimedia sourcers

23.Multimedia database query