1410+ DataBase Management System (DBMS) Solved MCQs

These multiple-choice questions (MCQs) are designed to enhance your knowledge and understanding in the following areas: Computer Science Engineering (CSE) , Bachelor of Science in Computer Science FY (BSc CS) , Bachelor of Science in Computer Science SY (BSc CS) , Bachelor of Science in Information Technology SY (BSc IT) , Bachelor of Computer Applications (BCA) .

Chapters

Take a Test

551.	Which function is used to identify the title with Least scope?
A.	min(credits)
B.	max(credits)
C.	min(title)
D.	min(salary)
Answer» A. min(credits)

552.	A domain is if elements of the domain are considered to be indivisible units.
A.	atomic
B.	subatomic
C.	substructure
D.	subset
Answer» A. atomic

553.	Identify the composite attributes
A.	salary
B.	credits
C.	section_id
D.	none of the mentioned
Answer» D. none of the mentioned

554.	Which one is based on multi-valued dependency:
A.	first
B.	second
C.	third
D.	fourth
Answer» D. fourth

555.	If a relation is in BCNF, then it is also in
A.	1 nf
B.	2 nf
C.	3 nf
D.	all of the mentioned
Answer» D. all of the mentioned

556.	If every non-key attribute is functionally dependent primary key, then the relation will be in
A.	first normal form
B.	second normal form
C.	third form
D.	fourth normal form
Answer» B. second normal form

557.	The term for information that describes what type of data is available in a database is:
A.	data dictionary
B.	data repository
C.	index data
D.	metadata
Answer» D. metadata

558.	A data type that creates unique numbers for key columns in Microsoft Access is:
A.	autonumber
B.	boolean
C.	sequential key
D.	sequential number
Answer» A. autonumber

559.	A dependency exist between two columns when
A.	together they constitute a composite key for the table
B.	knowing the value in one column determines the value stored in another column
C.	the table is in 3nf
D.	together they constitute a foreign key
Answer» A. together they constitute a composite key for the table

560.	In the normal form, a composite attribute is converted to individual attributes.
A.	first
B.	second
C.	third
D.	fourth
Answer» A. first

561.	A table on the many side of a one to many or many to many relationship must:
A.	be in second normal form (2nf)
B.	be in third normal form (3nf)
C.	have a single attribute key
D.	have a composite key
Answer» D. have a composite key

562.	Tables in second normal form (2NF):
A.	eliminate all hidden dependencies
B.	eliminate the possibility of a insertion anomalies
C.	have a composite key
D.	have all non key ﬁelds depend on the whole primary key
Answer» A. eliminate all hidden dependencies

564.	Which is a bottom-up approach to database design that design by examining the relationship between attributes:
A.	functional dependency
B.	database modeling
C.	normalization
D.	decomposition
Answer» C. normalization

566.	What are the desirable properties of a decomposition
A.	partition constraint
B.	dependency preservation
C.	redundancy
D.	security
Answer» B. dependency preservation

567.	R (A,B,C,D) is a relation. Which of the following does not have a lossless join dependency preserving BCNF decomposition?
A.	a->b, b->cd
B.	a->b, b->c, c->d
C.	ab->c, c->ad
D.	a->bcd
Answer» D. a->bcd

563.	Functional Dependencies are the types of constraints that are based on
A.	key
B.	key revisited
C.	superset key
D.	none of the mentioned
Answer» A. key

565.	A relation is in if an attribute of a composite key is dependent on an attribute of other composite key.
A.	2nf
B.	3nf
C.	bcnf
D.	1nf
Answer» B. 3nf

568.	The algorithm that takes a set of dependencies and adds one schema at a time, instead of decomposing the initial schema repeatedly is
A.	bcnf algorithm
B.	2nf algorithm
C.	3nf synthesis algorithm
D.	1nf algorithm
Answer» C. 3nf synthesis algorithm

569.	Which normal form is considered adequate for normal relational database design?
A.	2nf
B.	5nf
C.	4nf
D.	3nf
Answer» D. 3nf

570.	Relation R with an associated set of functional dependencies, F, is decomposed into BCNF. The redundancy (arising out of functional dependencies) in the resulting set of relations is
A.	zero
B.	more than zero but less than that of an equivalent 3nf decomposition
C.	proportional to the size of f+
D.	indeterminate
Answer» B. more than zero but less than that of an equivalent 3nf decomposition

571.	Which of the normal form is based on multivalued dependencies?
A.	first
B.	second
C.	third
D.	fourth
Answer» D. fourth

572.	Which forms has a relation that possesses data about an individual entity?
A.	2nf
B.	3nf
C.	4nf
D.	5nf
Answer» C. 4nf

573.	If a multivalued dependency holds and is not implied by the corresponding functional dependency, it usually arises from one of the following sources.
A.	a many-to-many relationship set
B.	a multivalued attribute of an entity set
C.	a one-to-many relationship set
D.	both a many-to-many relationship set and a multivalued attribute of an entity set
Answer» D. both a many-to-many relationship set and a multivalued attribute of an entity set

574.	Which of the following has each related entity set has its own schema and there is an additional schema for the relationship set?
A.	a many-to-many relationship set
B.	a multivalued attribute of an entity set
C.	a one-to-many relationship set
D.	none of the mentioned
Answer» A. a many-to-many relationship set

575.	Fifth Normal form is concerned with
A.	functional dependency
B.	multivalued dependency
C.	join dependency
D.	domain-key
Answer» C. join dependency

1410+ DataBase Management System (DBMS) Solved MCQs

Which function is used to identify the title with Least scope?

A domain is if elements of the domain are considered to be indivisible units.

Identify the composite attributes

Which one is based on multi-valued dependency:

If a relation is in BCNF, then it is also in

If every non-key attribute is functionally dependent primary key, then the relation will be in

The term for information that describes what type of data is available in a database is:

A data type that creates unique numbers for key columns in Microsoft Access is:

A dependency exist between two columns when

In the normal form, a composite attribute is converted to individual attributes.

A table on the many side of a one to many or many to many relationship must:

Tables in second normal form (2NF):

Functional Dependencies are the types of constraints that are based on

Which is a bottom-up approach to database design that design by examining the relationship between attributes:

A relation is in if an attribute of a composite key is dependent on an attribute of other composite key.

What are the desirable properties of a decomposition

R (A,B,C,D) is a relation. Which of the following does not have a lossless join dependency preserving BCNF decomposition?

The algorithm that takes a set of dependencies and adds one schema at a time, instead of decomposing the initial schema repeatedly is

Which normal form is considered adequate for normal relational database design?

Relation R with an associated set of functional dependencies, F, is decomposed into BCNF. The redundancy (arising out of functional dependencies) in the resulting set of relations is

Which of the normal form is based on multivalued dependencies?

Which forms has a relation that possesses data about an individual entity?

If a multivalued dependency holds and is not implied by the corresponding functional dependency, it usually arises from one of the following sources.

Which of the following has each related entity set has its own schema and there is an additional schema for the relationship set?

Fifth Normal form is concerned with

In 2NF

can help us detect poor E- R design.

Which of the following has each related entity set has its own schema and there is an additional schema for the relationship set.

In which of the following, a separate schema is created consisting of that attribute and the primary key of the entity set.

What is the best way to represent the attributes in a large database?

Designers use which of the following to tune the performance of systems to support time-critical operations?

Relation dept year(dept name, total inst 2007, total inst 2008, total inst 2009). Here the only functional dependencies are from dept name to the other attributes. This relation is in

Thus a of course data gives the values of all attributes, such as title and department, of all courses at a particular point in time.

Representations such as the in the dept year relation, with one column for each value of an attribute, are called they are widely used in spreadsheets and reports and in data analysis tools.

An approach to website design with the emphasis on converting visitors to outcomes required by the owner is referred to as:

A method of modelling and describing user tasks for an interactive application is referred to as:

Information architecture inﬂuences:

Also known as schematics, a way of illustrating the layout of an individual webpage is a:

A graphical or text depiction of the relationship between diﬀerent groups of content on a website is referred to as a:

Blueprints are intended to:

Storyboards are intended to:

Which of the following occupies boot record of hard and ﬂoppy disks and activated during computer startup?

A graphical or text depiction of the relationship between diﬀerent groups of content on a website is a:

Which of the following is a valid uniform resource locator?

HTTP deﬁnes two ways in which values entered by a user at the browser can be sent to the Web server. The method encodes the values as part of the URL.

A is a program running on the server machine, which accepts requests from a Web browser and sends back results in the form of HTML documents.

The application program typically communicates with a database server, through or other protocols, in order to get or store data.

This extra information is usually maintained in the form of a at the client.

Which of the following is not true about HTML ?

Html code contains:

576.	In 2NF
A.	no functional dependencies (fds) exist
B.	no multivalued dependencies (mvds) exist
C.	no partial fds exist
D.	no partial mvds exist
Answer» C. no partial fds exist

577.	can help us detect poor E- R design.
A.	database design process
B.	e-r design process
C.	relational scheme
D.	functional dependencies
Answer» D. functional dependencies

578.	Which of the following has each related entity set has its own schema and there is an additional schema for the relationship set.
A.	a many-to-many relationship set
B.	a multivalued attribute of an entity set
C.	a one-to-many relationship set
D.	all of the mentioned
Answer» A. a many-to-many relationship set

579.	In which of the following, a separate schema is created consisting of that attribute and the primary key of the entity set.
A.	a many-to-many relationship set
B.	a multivalued attribute of an entity set
C.	a one-to-many relationship set
D.	all of the mentioned
Answer» B. a multivalued attribute of an entity set

580.	What is the best way to represent the attributes in a large database?
A.	relational-and
B.	concatenation
C.	dot representation
D.	all of the mentioned
Answer» B. concatenation

581.	Designers use which of the following to tune the performance of systems to support time-critical operations?
A.	denormalization
B.	redundant optimization
C.	optimization
D.	realization
Answer» A. denormalization

582.	Relation dept year(dept name, total inst 2007, total inst 2008, total inst 2009). Here the only functional dependencies are from dept name to the other attributes. This relation is in
A.	fourth nf
B.	bcnf
C.	third nf
D.	second nf
Answer» B. bcnf

583.	Thus a of course data gives the values of all attributes, such as title and department, of all courses at a particular point in time.
A.	instance
B.	snapshot
C.	both instance and snapshot
D.	all of the mentioned
Answer» B. snapshot

584.	Representations such as the in the dept year relation, with one column for each value of an attribute, are called they are widely used in spreadsheets and reports and in data analysis tools.
A.	cross-tabs
B.	snapshot
C.	both cross-tabs and snapshot
D.	all of the mentioned
Answer» A. cross-tabs

585.	An approach to website design with the emphasis on converting visitors to outcomes required by the owner is referred to as:
A.	web usability
B.	persuasion
C.	web accessibility
D.	none of the mentioned
Answer» B. persuasion