Which CREATE TABLE statement is valid?

CREATE TABLE ord_details (ord_no NUMBER(2) PRIMARY KEY, item_no NUMBER(3) PRIMARY KEY, ord_date date NOT NULL); 50

CREATE TABLE ord_details (ord_no NUMBER(2) UNIQUE, NOT NULL, item_no NUMBER(3), ord_date date DEFAULT SYSDATE NOT NULL);

CREATE TABLE ord_details (ord_no NUMBER(2) , item_no NUMBER(3), ord_date date DEFAULT NOT NULL, CONSTRAINT ord_uq UNIQUE (ord_no), CONSTRAINT ord_pk PRIMARY KEY (ord_no));

CREATE TABLE ord_details (ord_no NUMBER(2), item_no NUMBER(3), ord_date date DEFAULT SYSDATE NOT NULL, CONSTRAINT ord_pk PRIMARY KEY (ord_no, item_no));

Aggregate functions are functions that take a as input and return a single value.

both collection of values & single value

Which property ensures that each functional dependency is represented in some individual relations resulting after decomposition?

Dependency preservation property

Dedicated server configuration is

Many server processes – Many user processes

One server process – Many user processes

Many server processes – One user process

One server process – One user process

Many server processes – Many user processes

Find the names of these cities with temperature and condition whose condition is neithersunny nor cloudy.

SELECT city, temperature, condition FROM weather WHERE condition NOT BETWEEN (‘sunny’, ‘cloudy’)

SELECT city, temperature, condition FROM weather WHERE condition NOT IN (‘sunny’, ‘cloudy’)

SELECT city, temperature, condition FROM weather WHERE condition NOT BETWEEN (‘sunny’, ‘cloudy’)

SELECT city, temperature, condition FROM weather WHERE condition IN (‘sunny’, ‘cloudy’)

SELECT city, temperature, condition FROM weather WHERE condition BETWEEN (‘sunny’, ‘cloudy’);

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

A multivalued attribute of an entity set

A many-to-many relationship set

A multivalued attribute of an entity set

The space factor when determining the eﬃciency of an algorithm is measured by

counting the minimum memory needed by the algorithm

counting the maximum memory needed by the algorithm

counting the minimum memory needed by the algorithm

counting the average memory needed by the algorithm

counting the maximum disk space needed by the algorithm

1294 + Mcqs in Database Management System in Computer Science Engineering (CSE) Page 3 McqOptions

101.	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» C. CITY

102.	Which CREATE TABLE statement is valid?
A.	CREATE TABLE ord_details (ord_no NUMBER(2) PRIMARY KEY, item_no NUMBER(3) PRIMARY KEY, ord_date date NOT NULL); 50
B.	CREATE TABLE ord_details (ord_no NUMBER(2) UNIQUE, NOT NULL, item_no NUMBER(3), ord_date date DEFAULT SYSDATE NOT NULL);
C.	CREATE TABLE ord_details (ord_no NUMBER(2) , item_no NUMBER(3), ord_date date DEFAULT NOT NULL, CONSTRAINT ord_uq UNIQUE (ord_no), CONSTRAINT ord_pk PRIMARY KEY (ord_no));
D.	CREATE TABLE ord_details (ord_no NUMBER(2), item_no NUMBER(3), ord_date date DEFAULT SYSDATE NOT NULL, CONSTRAINT ord_pk PRIMARY KEY (ord_no, item_no));
Answer» E.

103.	In which of the following cases will the RDBMS specify a default value for the columnif there are no values for it?
A.	NOT NULL WITH DEFAULT
B.	COLUMN DEFAULT
C.	NOT NULL UNIUE
D.	None of the above
Answer» D. None of the above

104.	allows individual row operation to be performed on a given result set or on the generated by a selected by a selected statement.
A.	procedure
B.	trigger
C.	curser
D.	none of the mentioned
Answer» D. none of the mentioned

105.	In the SQL Cursor, which attribute is TRUE when a cursor has some remaining rows to fetch, and FALSE when a cursor has no rows left to fetch?
A.	%ROWCOUNT
B.	%FOUND
C.	%NOTFOUND
D.	%ISOPEN
Answer» C. %NOTFOUND

106.	The requires that each transaction Ti executes in two or three diﬀerent phases in its lifetime, depending on whether it is a read-only or an update transaction.
A.	validation protocol
B.	validation-based protocol
C.	timestamp protocol
D.	timestamp-ordering protocol
Answer» B. validation-based protocol

107.	using a log record sets the data item speciﬁed in the log record to the old value.
A.	deferred-modiﬁcation
B.	late-modiﬁcation
C.	immediate-modiﬁcation
D.	undo
Answer» E.

108.	The application program typically communicates with a database server, through or other protocols, in order to get or store data.
A.	jdbc
B.	odbc
C.	all of the mentioned
D.	none of the mentioned
Answer» D. none of the mentioned

109.	…………….. is the complex search criteria in the where clause.
A.	Substring
B.	Drop Table
C.	Predict
D.	Predicate
Answer» E.

110.	Consider attributes ID, CITY and NAME. Which one of this can be considered as a superkey?
A.	NAME
B.	ID
C.	CITY
D.	CITY, ID
Answer» C. CITY

111.	4NF is designed to cope with:
A.	Transitive dependency
B.	Join dependency
C.	Multi valued dependency
D.	None of these
Answer» D. None of these

113.	What does a COMMIT statement do to a CURSOR?
A.	Open the Cursor
B.	Fetch the Cursor
C.	Close the Cursor
D.	None of the above
Answer» E.

114.	Which of the following is TRUE? (1) Host variables are declared anywhere in the program (2) Host variables are declared in the DECLARE section
A.	Only 1 is TRUE
B.	Only 2 is TRUE
C.	Both 1 & 2are TRUE
D.	Both are FALSE
Answer» C. Both 1 & 2are TRUE

115.	Drop Table cannot be used to drop a table referenced by a …………… constraint.
A.	Local Key
B.	Primary Key
C.	Composite Key
D.	Foreign Key
Answer» E.

116.	An abstraction concept for building composite object from their component object is called:
A.	Specialization
B.	Normalization
C.	Generalization
D.	Aggregation
Answer» E.

112.	The normal form which satisfies multivalued dependencies and which is in BCNF is
A.	4 NF
B.	3 NF
C.	2 NF
D.	All of the mentioned
Answer» B. 3 NF

117.	Aggregate functions are functions that take a as input and return a single value.
A.	collection of values
B.	single value
C.	aggregate value
D.	both collection of values & single value
Answer» B. single value

118.	……………… clause is an additional filter that is applied to the result.
A.	Select
B.	Group-by
C.	Having
D.	Order by
Answer» D. Order by

119.	System catalog is a system-created database that describes:
A.	Database objects
B.	Data dictionary information
C.	User access information
D.	All of these
Answer» E.

120.	Which property ensures that each functional dependency is represented in some individual relations resulting after decomposition?
A.	Dependency preservation property
B.	Fully Functional dependency
C.	Lossless Join
D.	None of the above
Answer» B. Fully Functional dependency

121.	In which ways two tables may be related:
A.	One-one
B.	One-many
C.	Many-many
D.	All of these
Answer» E.

122.	What is refined data?
A.	Knowledge
B.	Information
C.	Statistics
D.	None of the above
Answer» C. Statistics

123.	Incase the indices values are larger, index is created for these values of the index. Thisis called
A.	Pointed index
B.	Sequential index
C.	Multilevel index
D.	Multiple index
Answer» D. Multiple index

124.	In a relational database a referential integrity constraint can be specified with the helpof
A.	primary key
B.	foreign key
C.	secondary key
D.	none of the above
Answer» C. secondary key

125.	Which forms simplifies and ensures that there is minimal data aggregates and repetitive groups:
A.	1NF
B.	2NF
C.	3NF
D.	All of these
Answer» B. 2NF

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

Consider attributes ID , CITY and NAME . Which one of this can be considered as a super key ?

Which CREATE TABLE statement is valid?

In which of the following cases will the RDBMS specify a default value for the columnif there are no values for it?

allows individual row operation to be performed on a given result set or on the generated by a selected by a selected statement.

In the SQL Cursor, which attribute is TRUE when a cursor has some remaining rows to fetch, and FALSE when a cursor has no rows left to fetch?

The requires that each transaction Ti executes in two or three diﬀerent phases in its lifetime, depending on whether it is a read-only or an update transaction.

using a log record sets the data item speciﬁed in the log record to the old value.

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

…………….. is the complex search criteria in the where clause.

Consider attributes ID, CITY and NAME. Which one of this can be considered as a superkey?

4NF is designed to cope with:

The normal form which satisfies multivalued dependencies and which is in BCNF is

What does a COMMIT statement do to a CURSOR?

Which of the following is TRUE? (1) Host variables are declared anywhere in the program (2) Host variables are declared in the DECLARE section

Drop Table cannot be used to drop a table referenced by a …………… constraint.

An abstraction concept for building composite object from their component object is called:

Aggregate functions are functions that take a as input and return a single value.

……………… clause is an additional filter that is applied to the result.

System catalog is a system-created database that describes:

Which property ensures that each functional dependency is represented in some individual relations resulting after decomposition?

In which ways two tables may be related:

What is refined data?

Incase the indices values are larger, index is created for these values of the index. Thisis called

In a relational database a referential integrity constraint can be specified with the helpof

Which forms simplifies and ensures that there is minimal data aggregates and repetitive groups:

The function that an entity plays in a relationship is called that entity’s _____________

Dedicated server configuration is

In index instead of storing all the columns for a record together, each column is stored separately with all other rows in an index.

Find the names of these cities with temperature and condition whose condition is neithersunny nor cloudy.

Which of the following command makes the updates performed by the transactionpermanent in the database?

…………..defines the structure of a relation which consists of a fixed set of attribute-domain pairs.

In the phase, the system replays updates of all transactions by scanning the log forward from the last checkpoint.

If a transaction does not modify the database until it has committed, it is said to use the technique.

combines the data manipulating power of SQL with the data processing power of Procedural languages.

The CREATE TRIGGER statement is used to create the trigger. THE _____ clause specifies the table name on which the trigger is to be attached. The ______ specifies that this is an AFTERINSERT trigger.

A(n) can be used to preserve the integrity of a document or a message.

Which of the following is not Armstrong’s Axiom?

If an entity appears in only one relationship then it is

A database is divided into logical storage units called as

Which of the information is not redundant.

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

In query processing, the is the lowest-level operator to access data.

A search key containing more than one attribute is referred to as a _________ searchkey.

In an ER model, ……………. is described in the database by storing its data.

The space factor when determining the eﬃciency of an algorithm is measured by

All transactions are controlled and executed by the DBMS (subject to somelimitations) to guarantee database ____.

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

is popular for applications such as storage of log ﬁles in a database system since it oﬀers the best write performance.

The operation performs a set union of two “similarly structured” tables

Which is incorporated to create an appropriate physical database that is transformed by a logical datamodel:

The CREATE TRIGGER statement is used to create the trigger. THE _ clause specifies the table name on which the trigger is to be attached. The __ specifies that this is an AFTERINSERT trigger.

126.	The function that an entity plays in a relationship is called that entity’s _____________
A.	Participation
B.	Position
C.	Role
D.	Instance
Answer» D. Instance

127.	Dedicated server configuration is
A.	One server process – Many user processes
B.	Many server processes – One user process
C.	One server process – One user process
D.	Many server processes – Many user processes
Answer» D. Many server processes – Many user processes

128.	In index instead of storing all the columns for a record together, each column is stored separately with all other rows in an index.
A.	clustered
B.	column store
C.	non clustered
D.	row store
Answer» C. non clustered

129.	Find the names of these cities with temperature and condition whose condition is neithersunny nor cloudy.
A.	SELECT city, temperature, condition FROM weather WHERE condition NOT IN (‘sunny’, ‘cloudy’)
B.	SELECT city, temperature, condition FROM weather WHERE condition NOT BETWEEN (‘sunny’, ‘cloudy’)
C.	SELECT city, temperature, condition FROM weather WHERE condition IN (‘sunny’, ‘cloudy’)
D.	SELECT city, temperature, condition FROM weather WHERE condition BETWEEN (‘sunny’, ‘cloudy’);
Answer» B. SELECT city, temperature, condition FROM weather WHERE condition NOT BETWEEN (‘sunny’, ‘cloudy’)

130.	Which of the following command makes the updates performed by the transactionpermanent in the database?
A.	ROLLBACK
B.	COMMIT
C.	TRUNCATE
D.	DELETE
Answer» C. TRUNCATE

131.	…………..defines the structure of a relation which consists of a fixed set of attribute-domain pairs.
A.	Instance
B.	Schema
C.	Program
D.	Super Key
Answer» C. Program

132.	In the phase, the system replays updates of all transactions by scanning the log forward from the last checkpoint.
A.	repeating
B.	redo
C.	replay
D.	undo
Answer» C. replay

133.	If a transaction does not modify the database until it has committed, it is said to use the technique.
A.	deferred-modiﬁcation
B.	late-modiﬁcation
C.	immediate-modiﬁcation
D.	undo
Answer» B. late-modiﬁcation

134.	combines the data manipulating power of SQL with the data processing power of Procedural languages.
A.	pl/sql
B.	sql
C.	advanced sql
D.	pql
Answer» B. sql

135.	The CREATE TRIGGER statement is used to create the trigger. THE _____ clause specifies the table name on which the trigger is to be attached. The ______ specifies that this is an AFTERINSERT trigger.
A.	for insert, on
B.	On, for insert
C.	For, insert
D.	Both a and c
Answer» C. For, insert