Name – Nelakshi Thakur

Student Id – 241001271209
Roll Number – 1209
Subject Code – TIU-PCA-TI25
Subject Name – Advance
Database

Management system
Semester – 1st
Section -1A
Department – MCA
Date – 25.11.2024
1.If every non- key attribute is
Functional department on the
primary key ,then the relation will be
in:
A. First normal form
B. Second normal form
C. Third normal form
D. Fourth normal form

Answer>> C. Third normal form

2. An attribute of one table machine

the primary key of another table, is
called as
A. Foreign Key
B. Secondary key
C. Candidate Key
D. Composite key
Answer>> A. Foreign Key
3. Two attributes can be functionally
_____on /of each other.
A. Dependent
B. Independent
C. Both A and B
D. None of the above

Answer : A. Dependent

4. An attribute that is _________ and

the primary key of a table are
typically functionally dependent on
one another.
A. Key.
B. Non- key
C. One – key
D. Many – key
Answer: B) Non- key
3. Functional dependencies are
classified as _____ on the left.

A. Dependent
B. Determined
C. Determinants
D. Database

Answer: C) Determinants

4. _________ is the right side of making

functional dependency.
A. Determinants
B. Dependency
C. Independency
D. None
Answer: B) Dependency
5. If a relation scheme is in BCNF ,
then it is also in
A. First normal form
B. Second normal form
C. Third normal form
D. Fourth normal form

Answer: C) Third normal form

6. The set of permitted value for

each attribute is called its
A. Attribute set
B. Attribute range
C. Domain
D. Group

Answer: C) Domain
7. Which property ensures that each
function dependency is represented
in some individual some individual
relation resulting after
decomposition?
A. Dependency preservation
property
B. Fully Functional dependency
C. Lossless join
D. None of the above

Answer: a) Dependency preservation

property

8. Every relation in BCNF is also in

A. 3NF
B. 2NF
C. 1NF
D. None of the above
Answer: A) 3NF
9. A table that contains one or more
repeating groups is in which normal
form?
a. 1NF
b. 2NF
c. 3NF
d. Unnormalized form

Answer:d) Unnormalized form

10. The DBMS acts as an interface

what two components of an
enterprise – classdatabase system?
a. Database application and the
database
b. Data and the database
c. The user and the database
application
d. Database application and SQL
Answer:a) Database application and
the database

11. SQL stands for ________________.

a. Structured Query Language
b. Sequential Query Language
c. Structured Question language
d. Sequential Question language

Answer: a) Structured Query

language

12. A DBMS that combines a DBMS

and an application generator is
____________.
a. Microsoft’s SQL server
b. Microsoft’s Access
c. IBM’s DB2
d. Oracle Corporation’s Oracle
Answer: b) Microsoft’s Access

13. Which of the following is related

to information?
a. Data
b. Communication
c. Knowledge
d. All of these

Answer: a) Data

14. Data is
a. A piece of fact
b. Metadata
c. Information
d. None of these
Answer: a) A piece of fact
15. Which of the following is
elements of the database?
a. Data
b. Constraints and schema
c. Relationships
d. All of these

Answer: d) all of these

16. What represent a

correspondence between the various
data elements?
a. Data
b. Constraints
c. Relationships
d. Schema

Answer: c ) Relationships
17. Which of the following is an
advantage of using database
system?
a. Security of redundancy
b. Avoidance of redundancy
c. Reduced inconsistency
d. All of these

Answer: d) All of these

18. Which of the following is

characteristic of the data in a
database?
a. Independent
b. Secure
c. Shared
d. All of these
Answer: d) All of these

19. A______ is normalized after it has

been organized.
a. Table
b. Database
c. Row
d. Column

Answer: b ) Database

20. By normalizing relations sets of

relations, one minimizes_______.
a. Data
b. Fields
c. Redundancy
d. Database

Answer: c) Redundancy
21. In addition to removing
undersirable characteristics,
normalization also eliminates___
anomalies.

a. Insert
b. Update
c. Delete
d. All of these
Answer: d) all of these

22. A common approach to

normalization is to _________ the
larger table into smaller tables and
link them together by using
relationships.

a. Add
b. Subtract
c. Multiply
d. Divide
Answer: d) Divide

23. Redundancy is reduced in a

database table by using the _______
form .

a. Normal
b. Abnormal
c. Special
d. None
Answer: a) Normal
24. In practical applications, how
many types of normal forms are
there?
a. 3
b. 4
c.5
d. 6
Answer: b) 4

25. Which of the following is not a

type of Normal form?
a. 1NF
b. 2NF
c. 3NF
d. 10NF
Answer: d) 10NF
26. Which of the following is a type
of Normal Form?
a. ACNF
b. BCNF
c. CCNF
d. DCNF
Answer: b ) BCNF
27. When a relation contains an
atomic value, it is a _____ relation.
a. 1NF
b. 2NF
c. 3NF
d. BCNF
Answer: a) 1NF

28. 2NF relations are those that are

in 1NF with all the attribute types
dependent on the ________ key
A. Primary
B. Foreign
C. Composite
D. Alternate
Answer: A ) primary
29. Which one of the following is a
set of one or more attributes taken
collectively to uniquely identify a
record?
A) Candidate key
b) Sub key
c) Super key
d) Foreign key
Answer: c) super key
30. Consider attributes ID, CITY and
NAME. Which one of this can be
considered as a super key?
a) NAME
b) ID
c) CITY
d) CITY, ID
Answer: b) ID
31. 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
Answer: a) No proper subset is a
super key
32. A _____ is a property of the entire
relation, rather than of the individual
tuples in which each tuple is unique.
a) Rows
b) Key
c) Attribute
d) Fields
Answer: b) key
33. Which one of the following
attribute can be taken as a primary
key?
A) Name
b) Street
c) Id
d) Department
Answer: c) Id
34.Which one of the following cannot
be taken as a primary key?
A) Id
b) Register number
c) Dept_id
d) Street
Answer: d) street
35. An attribute in a relation is a
foreign key if the _______ key from
one relation is used as an attribute
in that relation.
a) Candidate
b) Primary
c) Super
d) Sub
Answer: b) primary
36. The relation with the attribute
which is the primary key is
referenced in another relation. The
relation which has the attribute as a
primary key is called ______________
a) Referential relation
b) Referencing relation
c) Referenced relation
d) Referred relation
Answer: c) Referenced relation
37. The ______ is the one in which the
primary key of one relation is used
as a normal attribute in another
relation.
a) Referential relation
b) Referencing relation
c) Referenced relation
d) Referred relation
Answer: b) Referencing relation
38. A _________ integrity constraint
requires that the values appearing in
specified attributes of any tuple in
the referencing relation also appear
in specified attributes of at least one
tuple in the referenced relation.
A) Referential
b) Referencing
c) Specific
d) Primary
Answer: a ) Referential
39) We can use the following three
rules to find logically implied
functional dependencies. This
collection of rules is called
A) Axioms
b) Armstrong’s axioms
c) Armstrong
d) Closure
Answer: b) Armstrong’s axioms
40) Which of the following is not
Armstrong’s Axiom?
A) Reflexivity rule
b) Transitivity rule
c) Pseudotransitivity rule
d) Augmentation rule
Answer: c) Pseudotransitivity rule
41) This type of decomposition is
called
a) Lossless decomposition
b) Lossless-join decomposition
c) All of the mentioned
d) None of the mentioned
Answer: d) None of the mentioned
42) Inst_dept (ID, name, salary, dept
name, building, budget) is
decomposed into

Instructor (ID, name, dept name,

salary)
Department (dept name, building,
budget)
This comes under
a) Lossy-join decomposition
b) Lossy decomposition
c) Lossless-join decomposition
d) Both Lossy and Lossy-join
decomposition
Answer: d) Both lossy and lossy- join
decomposition
43) There are two functional
dependencies with the same set of
attributes on the left side of the
arrow:
A->BC
A->B
This can be combined as
a) A->BC
b) A->B
c) B->C
d) None of the mentioned
Answer: a) A->BC
44) Consider a relation R(A,B,C,D,E)
with the following functional
dependencies:
The number of superkeys of R is:
a) 2
b) 7
c) 10
d) 12
Answer: c) 10
45) A functional dependency f on R is
_______ by a set of functional
dependencies F on r if every instance
of r® that satisfies f also satisfies F.
A) Logically Defined
b) Logically Derived
c) Logically implied
d) None of the mentioned
Answer: c) logically implied
46) If F is a set of functional
dependencies, then the closure of F
is denoted by?
a) F*
b) Fo
c) F+
d) F
Answer: c) F+
47) If a functional dependency is
reflexive, B is a subset of A and A is
the set of attributes, then
a) B→A holds
b) A→B holds
c) AB→C holds
d) None of the mentioned
Answer: b) A->B holds
48) State true or false: Armstrong’s
axioms allow us to generate all F+
for any given F
a) True
b) False
Answer: a) True
49) Armstrong axioms are called
sound because?
a) They are expensive
b) They cannot generate correct
functional dependencies
c) They allow us to generate the
complete closure
d) They cannot generate incorrect
functional dependencies
Answer: d) They cannot generate
incorrect functional dependencies
50) State true or false: Functional
dependencies are transitive
a) True
b) False
Answer: a) True
51) If A→B, A→ C then which of the
following is true?
A) A→BC
b) A→B
c) A→C
d) All of the mentioned
Answer: d) All of the mentioned
52) 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
Answer: b) Database Management
System
53) 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
Answer: c) Organized collection of
data or information that can be
accessed, updated, and managed.

54) 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
Answer: d) DBMS stores, modifies
and retrieves data

55) Who created the first DBMS?

a) Edgar Frank Codd
b) Charles Bachman
c) Charles Babbage
d) Sharon B. Codd
Answer: b) Charles Bachman

56) 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
d) All of the above
Answer: d) All of the above

57) In which of the following formats

data is stored in the database
management system?
A) Image
b) Text
c) Table
d) Graph
Answer: c) Table

58) Which of the following is not a

type of database?
a) Hierarchical
b) Network
c) Distributed
d) Decentralized
Answer: d) Decentralized.
59) Which of the following is not an
example of DBMS?
a) MySQL
b) Microsoft Acess
c) IBM DB2
d) Google
Answer: d) Google

60) Which of the following is not 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
Answer: c) Single – User Access only
61) 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
Answer: b) User interface provided

62) 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
Answer: d) Manipulating data.

63) 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
Answer: d) All of the above.

64) Which of the following is a

component of the DBMS?
A) Data
b) Data Languages
c) Data Manager
d) All of the above
Answer: d) All of the above.
65) 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
Answer: c) Entity set.

66) What is information about data

called?
a) Hyper data
b) Tera data
c) Meta data
d) Relations
Answer: c) Meta data

67) What does an RDBMS consist of?

a) Collection of Records
b) Collection of Keys
c) Collection of Tables
d) Collection of Fields
Answer: c) Collection of Tables

70) 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
Answer: a) Referential
71) _____________ 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
Answer: b) High speed, large
capacity disk to store data.

72) The DBMS acts as an interface

between ________________ and
________________ of an enterprise-class
system.
A) Data and the DBMS
b) Application and SQL
c) Database application and the
database
d) The user and the software
Answer: c) Database application and
the database.

73) 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)
Answer: d) DML ( Data Manipulation
Language).
74) ______________ 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
Answer: c) Super key.

75) Which command is used to

remove a relation from an SQL?

a)Drop table
b) Delete
c) Purge
d) Remove
Answer: a) Drop table.
76) 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
Answer: d) Indentifying set.

77) 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;
Answer: a) Delete from teachers.
78) Procedural language among the
following is __________
A) Domain relational calculus
b) Tuple relational calculus
c) Relational algebra
d) Query language
Answer: c) Relational algebra.

79) _________________ operations do not

preserve non-matched tuples.
A) Left outer join
b) Inner join
c) Natural join
d) Right outer join
Answer: b) Inner Join
80) Which forms have a relation that
contains information about a single
entity?
A) 4NF
b) 2NF
c) 5NF
d) 3NF
Answer: d) 3NF

81) 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
Answer: d) Catalogs, Schemas.
82) _______ 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
Answer: c) Maximum cardinality .

83) 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
Answer: b) db_accessadmin.
84) 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
Answer: d) Hierarchical database
management system.

85) 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
Answer: b) Having.

86) Which of the following is not the

utility of DBMS?
A) Backup
b) Data Loading
c) Process Organization
d) File organization

Answer: c) Process Organization.

87) What does a foreign key

combined with a primary key create?
A) Network model between the
tables that connect them
b) Parent-Child relationship between
the tables that connects them
c) One to many relationship between
the tables that connects them
d) All of the mentioned
Answer: b) Parent – child relationship
between the tables that connects
them.

88) Which of the following is correct

according to the technology
deployed by DBMS?
A) Pointers are used to maintain
transactional integrity and
consistency
b) Cursors are used to maintain
transactional integrity and
consistency
c) Locks are used to maintain
transactional integrity and
consistency
d) Triggers are used to maintain
transactional integrity and
consistency
Answer: c) Locks are used to
maintain transactional integrity and
consistency.

89) 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
Answer: a) Can be used as it is by
the DBMS.

90) 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
Answer: c) Deletes Particular tuple
from relation.

91) ______ resembles Create view.

a) Create table . . . as
b) Create view as
c) Create table . . .like
d) With data

Answer: a) Create table… as.

92) The query specifying the SQL

view is said to be updatable if it
meets which of the following
conditions?
A) select clause contains relation
attribute names but not have
expressions, aggregates, or distinct
specification
b) from clause has 1 relation
c) query does not have group by or
having clause
d) All of the mentioned
Answer: d) All of the mentioned.

93) When the “ROLLUP” operator for

expression or columns within a
“GROUP BY” clause is used?
A) Find the groups that make up the
subtotal in a row
b) Create group-wise grand totals for
the groups indicated in a GROUP BY
clause
c) Group expressions or columns
specified in a GROUP BY clause in
one direction, from right to left, for
computing the subtotals
d) To produce a cross-tabular report
for computing subtotals by grouping
phrases or columns given within a
GROUP BY clause in all available
directions
Answer: c) Group expressions or
columns specified in a GROUP BY
clause in one direction , from right to
left, for computing the subtotals.

94) 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
Answer: b) Concatenation.

95) Which of the following is the

subset of SQL commands used to
manipulate Oracle Structures,
including tables?
A) Data Described Language
b) Data Retrieval Language
c) Data Manipulation Language
d) Data Definition Language
Answer: d) Data Definition Language.

96) Which of the following functions

construct histograms and use
buckets for ranking?
A) Ntil()
b) Newtil()
c) Rank()
d) All of the mentioned
Answer: a) Ntil()

97) __________ 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
Answer: c) CREATE SCHEMA.

98) 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
Answer: c) Encryption key.
99) 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
Answer: c) Slicing

100) For designing a normal RDBMS

which of the following normal form is
considered adequate?
A) 4NF
b) 3NF
c) 2NF
d) 5NF
Answer: b) 3NF.