1294 + Mcqs in Database Management System Page 12 McqOptions

551.	The subsystem responsible for the allocation of buﬀer space is called the
A.	buﬀer
B.	buﬀer manager
C.	storage
D.	secondary storage
Answer» C. storage

Discussion

552.	determines which transactions to undo, which pages were dirty at the time of the crash, and the LSN from which the redo pass should start.
A.	analysis pass
B.	redo pass
C.	undo pass
D.	none of the mentioned
Answer» B. redo pass

Discussion

553.	The predicate in a where clause can involve Boolean operations such as and. The result of true and unknown is false and unknown is while unknown and unknown is
A.	unknown, unknown, false
B.	true, false, unknown
C.	true, unknown, unknown
D.	unknown, false, unknown
Answer» E.

Discussion

554.	Which command creates database objects like tables, views and indexes:
A.	Create command
B.	Update command
C.	Both
D.	None
Answer» B. Update command

Discussion

555.	are used to ensure that transactions access each data item in order of the transactions’ if their accesses conﬂict.
A.	zone
B.	relay
C.	line
D.	timestamps
Answer» E.

Discussion

556.	Who access the database occasionally and have different needs each time:
A.	Naïve users
B.	Casual users
C.	Sophisticated user
D.	All of these
Answer» C. Sophisticated user

Discussion

557.	For select operation the ________ appear in the subscript and the ___________ argumentappears in the paranthesis after the sigmA:)
A.	Predicates, relation
B.	Relation, Predicates
C.	Operation, Predicates
D.	Relation, Operation
Answer» B. Relation, Predicates

Discussion

558.	Which of the following command is used to delete a trigger?
A.	DELETE TRIGGER
B.	REPLACE TRIGGER
C.	DROP TRIGGER
D.	None of the above
Answer» D. None of the above

Discussion

559.	An outstanding functionality of SQL is its support for automatic ………… to the target data.
A.	Programming
B.	Functioning
C.	Navigation
D.	Notification
Answer» D. Notification

Discussion

560.	Given the relation Supplier(s_id, p_order, s_name, qty) Given that there is a unique s_name for each s_id and that s_id, p_order is a composite key, find the correct statement among the following: i. this relation is a BCNF ii. this is 3 NF relation iii. this is a 2 NF relation iv. this is a 1 NF relation
A.	i and ii
B.	ii and iii
C.	i and iv
D.	i and iii
Answer» E.

Discussion

561.	In crabbing protocol, the lock obtained on the root node is in mode.
A.	shared
B.	exclusive
C.	read only
D.	none of the mentioned
Answer» B. exclusive

Discussion

562.	It is difficult to access conventional file system than Database System.
A.	True
B.	False
C.	none
D.	all
Answer» B. False

Discussion

563.	A 3 NF relation is converted to BCNF by
A.	removing composite keys
B.	removing multivalued dependencies
C.	dependent attributes of overlapping composite keys are put in a separateRelation
D.	dependent non-key attributes are put in a separate table
Answer» D. dependent non-key attributes are put in a separate table

Discussion

564.	Which of the following is not a binary operator in relational algebra?
A.	Join
B.	Semi-Join
C.	Assignment
D.	Project
Answer» E.

Discussion

565.	The number of entities to which another entity can be associated via a relationship set is expressed as:
A.	Entity
B.	Cardinality
C.	Schema
D.	Attributes
Answer» C. Schema

Discussion

566.	The primary medium for the long-term online storage of data is the where the entire database is stored on magnetic disk.
A.	semiconductor memory
B.	magnetic disks
C.	compact disks
D.	magnetic tapes
Answer» C. compact disks

Discussion

567.	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» B. A->B

Discussion

568.	What term is used to refer to a speciﬁc record in your music database; for instance; information stored about a speciﬁc album?
A.	relation
B.	instance
C.	table
D.	column
Answer» C. table

Discussion

569.	A _____ is a property of the entire relation, rather than of the individual tuples in whicheach tuple is unique.
A.	Rows
B.	Key
C.	Attribute
D.	Fields
Answer» C. Attribute

Discussion

570.	----------- is a virtual table
A.	Stored procedure
B.	View
C.	Table
D.	Rules
Answer» C. Table

Discussion

571.	BoyeCodd Normal Form (BCNF) is needed when
A.	two non-key attributes are dependent
B.	there is more then one possible composite key
C.	there are two or more possible composite overlapping keys and one attributeof a composite key is dependent on an attribute of another composite key
D.	there are two possible keys and they are dependent on one another
Answer» D. there are two possible keys and they are dependent on one another

Discussion

572.	In decomposition technique of splitting a relation into_____ relation:
A.	ONE or MORE
B.	TWO or MORE
C.	THREE or MORE
D.	FOUR or MORE
Answer» C. THREE or MORE

Discussion

573.	A 3 NF relation is split into 4 NF
A.	by removing overlapping composite keys
B.	by splitting into relations which do not have more than one independent multi valued dependency
C.	removing multivalued dependency
D.	by putting dependent non-key attribute in a separate table
Answer» C. removing multivalued dependency

Discussion

574.	A relational database system needs to maintain data about the relations, such as theschema of the relations. This is called
A.	Metadata
B.	Catalog
C.	Log
D.	Dictionary
Answer» B. Catalog

Discussion

575.	We indicate roles in E-R diagrams by labeling the lines that connect to
A.	diamond , diamond
B.	rectangle, diamond
C.	rectangle, rectangle
D.	diamond, rectangle
Answer» E.

Discussion

576.	The surface area of a tape is the surface area of a disk.
A.	much lesser than
B.	much larger than
C.	equal to
D.	none of the mentioned
Answer» C. equal to

Discussion

577.	The main interface that a naive user uses is a form interface using___:
A.	DDL
B.	GUI
C.	OLAP
D.	DML
Answer» C. OLAP

Discussion

578.	Because it contains a description of its own structure, a database is considered to be ________
A.	Described
B.	metadata compatible
C.	self-describing
D.	an application program
Answer» D. an application program

Discussion

579.	Which are the types of data independence:
A.	Physical
B.	Logical
C.	Both
D.	All of these
Answer» D. All of these

Discussion

580.	The term is used to refer to a row.
A.	attribute
B.	tuple
C.	field
D.	instance
Answer» C. field

Discussion

581.	operator is used for appending two strings.
A.	&
Answer» D.

Discussion

582.	The following SQL is which type of join: SELECT CUSTOMER_T. CUSTOMER_ID,ORDER_T. CUSTOMER_ID, NAME, ORDER_ID FROM CUSTOMER_T,ORDER_T WHERE CUSTOMER_T. CUSTOMER_ID = ORDER_T. CUSTOMER_ID?
A.	Equi-join
B.	Natural join
C.	Outer join
D.	Cartesian join
Answer» B. Natural join

Discussion

583.	How many attributes are associated with cursors?
A.	1
B.	2
C.	3
D.	4
Answer» E.

Discussion

584.	We indicate roles in E-R diagrams by labeling the lines that connect ___________ to__________
A.	Diamond , diamond
B.	Rectangle, diamond
C.	Rectangle, rectangle
D.	Diamond, rectangle
Answer» E.

Discussion

585.	In ER model the details of the entities are hidden from the user. This process is called:
A.	Generalization
B.	Specialization
C.	Abstraction
D.	none of these above
Answer» D. none of these above

Discussion

586.	……………….. contains information that defines valid values that are stored in a column or datatype.
A.	View
B.	Rule
C.	Index
D.	Default
Answer» D. Default

Discussion

587.	The clause is used to list the attributes desired in the result of a query.
A.	where
B.	select
C.	from
D.	distinct
Answer» C. from

Discussion

588.	The command such tables are available only within the transaction executing the query and are dropped when the transaction ﬁnishes.
A.	create table
B.	create temporary table
C.	create view
D.	create label view
Answer» C. create view

Discussion

589.	PL/SQL has two types of subprograms, procedures and functions. Which subprogram isused to compute a value?
A.	Procedure
B.	Function
C.	Both A & B
D.	None of the above
Answer» C. Both A & B

Discussion

590.	A consists of a sequence of query and/or update statements.
A.	transaction
B.	commit
C.	rollback
D.	flashback
Answer» B. commit

Discussion

591.	To select all column from the table the syntax is:
A.	Select all from table_name
B.	Select * from table_name
C.	Select from table_name
D.	Non of the above
Answer» C. Select from table_name

Discussion

592.	Find the ODD one out of the following:
A.	OPEN
B.	CLOSE
C.	INSERT
D.	FETCH
Answer» D. FETCH

Discussion

593.	Which forms are based on the concept of functional dependency:
A.	1NF
B.	2NF
C.	3NF
D.	4NF
Answer» D. 4NF

Discussion

594.	A non-correlated subquery can be deﬁned as
A.	a set of sequential queries, all of which must always return a single value
B.	a set of sequential queries, all of which must return values from the same table
C.	a select statement that can be embedded in a clause of another select statement only
D.	a set of one or more sequential queries in which generally the result of the inner query is used as the search value in the outer query
Answer» E.

Discussion

595.	For like predicate which of the following is true. i) % matches zero of more characters. ii) _ matches exactly one character.
A.	i-only
B.	ii-only
C.	Both of them
D.	None of them
Answer» D. None of them

Discussion

596.	The iterator maintains the of its execution in between calls so that successive next() requests receive successive result tuples.
A.	state
B.	transition
C.	rate
D.	block
Answer» B. transition

Discussion

597.	Which is installs, configures, troubleshoots and maintains a database system:
A.	DBA
B.	DDL
C.	DML
D.	SDL
Answer» B. DDL

Discussion

598.	ARIES uses a to identify log records, and stores it in database pages.
A.	log sequence number
B.	log number
C.	lock number
D.	sequence
Answer» C. lock number

Discussion

599.	Designers use which of the following to tune the performance of systems to support timecritical operations?
A.	Denormalization
B.	Redundant optimization
C.	Optimization
D.	Realization
Answer» B. Redundant optimization

Discussion

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

Discussion

Explore topic-wise MCQs in Computer Science Engineering (CSE).

The subsystem responsible for the allocation of buﬀer space is called the

determines which transactions to undo, which pages were dirty at the time of the crash, and the LSN from which the redo pass should start.

The predicate in a where clause can involve Boolean operations such as and. The result of true and unknown is false and unknown is while unknown and unknown is

Which command creates database objects like tables, views and indexes:

are used to ensure that transactions access each data item in order of the transactions’ if their accesses conﬂict.

Who access the database occasionally and have different needs each time:

For select operation the ________ appear in the subscript and the ___________ argumentappears in the paranthesis after the sigmA:)

Which of the following command is used to delete a trigger?

An outstanding functionality of SQL is its support for automatic ………… to the target data.

In crabbing protocol, the lock obtained on the root node is in mode.

It is difficult to access conventional file system than Database System.

A 3 NF relation is converted to BCNF by

Which of the following is not a binary operator in relational algebra?

The number of entities to which another entity can be associated via a relationship set is expressed as:

The primary medium for the long-term online storage of data is the where the entire database is stored on magnetic disk.

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

What term is used to refer to a speciﬁc record in your music database; for instance; information stored about a speciﬁc album?

A _____ is a property of the entire relation, rather than of the individual tuples in whicheach tuple is unique.

----------- is a virtual table

BoyeCodd Normal Form (BCNF) is needed when

In decomposition technique of splitting a relation into_____ relation:

A 3 NF relation is split into 4 NF

A relational database system needs to maintain data about the relations, such as theschema of the relations. This is called

We indicate roles in E-R diagrams by labeling the lines that connect to

The surface area of a tape is the surface area of a disk.

The main interface that a naive user uses is a form interface using___:

Because it contains a description of its own structure, a database is considered to be ________

Which are the types of data independence:

The term is used to refer to a row.

operator is used for appending two strings.

The following SQL is which type of join: SELECT CUSTOMER_T. CUSTOMER_ID,ORDER_T. CUSTOMER_ID, NAME, ORDER_ID FROM CUSTOMER_T,ORDER_T WHERE CUSTOMER_T. CUSTOMER_ID = ORDER_T. CUSTOMER_ID?

How many attributes are associated with cursors?

We indicate roles in E-R diagrams by labeling the lines that connect ___________ to__________

In ER model the details of the entities are hidden from the user. This process is called:

……………….. contains information that defines valid values that are stored in a column or datatype.

The clause is used to list the attributes desired in the result of a query.

The command such tables are available only within the transaction executing the query and are dropped when the transaction ﬁnishes.

PL/SQL has two types of subprograms, procedures and functions. Which subprogram isused to compute a value?

A consists of a sequence of query and/or update statements.

To select all column from the table the syntax is:

Find the ODD one out of the following:

Which forms are based on the concept of functional dependency:

A non-correlated subquery can be deﬁned as

For like predicate which of the following is true. i) % matches zero of more characters. ii) _ matches exactly one character.

The iterator maintains the of its execution in between calls so that successive next() requests receive successive result tuples.

Which is installs, configures, troubleshoots and maintains a database system:

ARIES uses a to identify log records, and stores it in database pages.

Designers use which of the following to tune the performance of systems to support timecritical operations?

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

For select operation the appear in the subscript and the ___ argumentappears in the paranthesis after the sigmA:)

We indicate roles in E-R diagrams by labeling the lines that connect _ to