create table apartment(ownerID varchar (5), ownername varchar(25), floor numeric(4,0),primary key (ownerID:));Choose the correct option regarding the above statement

It creates a relation with three attributes ownerID, ownername, floor in which ownername must consist of at least 25 characters.

The statement is syntactically wrong

It creates a relation with three attributes ownerID, ownername, floor in which floor cannot be null.

It creates a relation with three attributes ownerID, ownername, floor in which ownerID cannot be null.

It creates a relation with three attributes ownerID, ownername, floor in which ownername must consist of at least 25 characters.

With SQL, how do you select all the records from a table named Persons where the value of the column FirstName ends with an a ?

SELECT * FROM Persons WHERE FirstName= %a%

SELECT * FROM Persons WHERE FirstName= a

SELECT * FROM Persons WHERE FirstName LIKE a%

SELECT * FROM Persons WHERE FirstName LIKE %a

SELECT * FROM Persons WHERE FirstName= %a%

With SQL, how can you return all the records from a table named Persons sorted descending by FirstName ?

SELECT * FROM Persons SORT BY FirstName DESC

SELECT * FROM Persons ORDER FirstName DESC

SELECT * FROM Persons SORT FirstName DESC

SELECT * FROM Persons ORDER BY FirstName DESC

Which question corresponds best to the following query? SELECT CID, CDUR - 1,' = PRICE' FROM COURSES ORDER BY 2

Select two columns from the COURSES table, of which the second one has a constantvalue, i.e. = PRICE . Sort the data according to the second column, in ascending order

Select three columns from the COURSES table, of which the third one has a constantvalue, i.e. = PRICE . Leave an empty line after every second line.

Select two columns from the COURSES table, the second one gets as title =PRICE .Sort the data according to the second column, in ascending order.

Select three columns from the COURSES table, of which the third one has a constantvalue, i.e. = PRICE . Sort the data according to the second column, in ascending order.

Select two columns from the COURSES table, of which the second one has a constantvalue, i.e. = PRICE . Sort the data according to the second column, in ascending order

Statement 1: A tuple is a row in a relation Statement 2: Existence of multiple foreign keys in a same relation is possible

Statement 1 is correct but Statement 2 is false

Statement 1 is false but Statement 2 is correct

Choose the option that correctly explains in words, the function of the following relational algebra expression year 2009 (book borrow)

Selects all the tuples from the natural join of book and student wherever the year is greater than or equal to 2009

Selects all tuples from the Cartesian product of book and borrow

Selects all the tuples from the natural join of book and borrow wherever the year is lesser than 2009

Selects all the tuples from the natural join of book and student wherever the year is greater than or equal to 2009

Selects all tuples from the Cartesian product of book and borrow wherever the year is greater than or equal to 2009

What is the syntax to load data into the database? (Consider D as the database and a, b, c as datA:)

insert into D values (a, b, C:);

insert (a, b, C:) values into D;

If a1, a2, a3 are attributes in a relation and S is another relation, which of the following is an incorrect specification of an integrity constraint?

foreign key(a1, a2) references S

A le produced by a spreadsheet

is generally stored on disk in an ascii text format

Find the names of these cities with temperature and condition whose condition is neither sunny 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 );

Find all the cities with temperature, condition and humidity whose humidity is in the range of 63 to 79.

SELECT * FROM weather WHERE humidity NOT BETWEEN 63 AND 79

SELECT * FROM weather WHERE humidity IN (63 to 79)

SELECT * FROM weather WHERE humidity NOT IN (63 AND 79)

SELECT * FROM weather WHERE humidity BETWEEN 63 AND 79

SELECT * FROM weather WHERE humidity NOT BETWEEN 63 AND 79

While inserting the record into the index, if the search-key value does not appear in the index.

The system adds a pointer to the new record in the index entry

The system places the record being inserted after the other records with the same searchkey values

The system inserts an index entry with the search-key value in the index at the appropriate position

175 + Mcqs in DataBase Management System (DBMS) in Computer Science Engineering (CSE) Page 1 McqOptions

1.	An ________ is a set of entities of the same type that share the same properties, or attributes.
A.	Entity set
B.	Attribute set
C.	Relation set
D.	Entity model
Answer» B. Attribute set

2.	The attribute name could be structured as an attribute consisting of first name, middle initial, and last name. This type of attribute is called
A.	Simple attribute
B.	Composite attribute
C.	Multivalued attribute
D.	Derived attribute
Answer» C. Multivalued attribute

4.	In a relation between the entities the type and condition of the relation should be specified. That is called as______attribute.
A.	Desciptive
B.	Derived
C.	Recursive
D.	Relative
Answer» B. Derived

6.	If you don t specify ASC or DESC after a SQL ORDER BY clause, the following is used by default ______________
A.	ASC
B.	DESC
C.	There is no default value
D.	None of the mentioned
Answer» B. DESC

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

10.	An entity set that does not have sufficient attributes to form a primary key is termed a __________
A.	Strong entity set
B.	Variant set
C.	Weak entity set
D.	Variable set
Answer» D. Variable set

11.	For each attribute of a relation, there is a set of permitted values, called the ________ of that attribute.
A.	Domain
B.	Relation
C.	Set
D.	Schema
Answer» B. Relation

12.	Database __________ which is the logical design of the database, and the database _______ which is a snapshot of the data in the database at a given instant in time.
A.	Instance, Schema
B.	Relation, Schema
C.	Relation, Domain
D.	Schema, Instance
Answer» E.

13.	Course(course_id,sec_id,semester) Here the course_id,sec_id and semester are __________ and course is a _________
A.	Relations, Attribute
B.	Attributes, Relation
C.	Tuple, Relation
D.	Tuple, Attributes
Answer» C. Tuple, Relation

14.	Department (dept name, building, budget) and Employee (employee_id, name, dept name, salary) Here the dept_name attribute appears in both the relations. Here using common attributes in relation schema is one way of relating ___________ relations.
A.	Attributes of common
B.	Tuple of common
C.	Tuple of distinct
D.	Attributes of distinct
Answer» D. Attributes of distinct

15.	State true or false: If a relation consists of a foreign key, then it is called a referenced relation of the foreign key dependency.
A.	True
B.	False
C.	none
D.	all
Answer» C. none

22.	What type of join is needed when you wish to include rows that do not have matching values?
A.	Equi-join
B.	Natural join
C.	Outer join
D.	All of the Mentioned
Answer» D. All of the Mentioned

24.	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

25.	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?
A.	Equi-join
B.	Natural join
C.	Outer join
D.	Cartesian join
Answer» E.

26.	___________ is the collection of memory structures and Oracle background processes that operates against an Oracle database.
A.	Database
B.	Instance
C.	Tablespace
D.	Segment
Answer» C. Tablespace

16.	Statement 1: A tuple is a row in a relation Statement 2: Existence of multiple foreign keys in a same relation is possible
A.	Both the statements are true
B.	Statement 1 is correct but Statement 2 is false
C.	Statement 1 is false but Statement 2 is correct
D.	Both the statements are false
Answer» B. Statement 1 is correct but Statement 2 is false

18.	What is the syntax to load data into the database? (Consider D as the database and a, b, c as datA:)
A.	enter into D (a, b, C:);
B.	insert into D values (a, b, C:);
C.	insert into D (a, b, C:);
D.	insert (a, b, C:) values into D;
Answer» C. insert into D (a, b, C:);

19.	If a1, a2, a3 are attributes in a relation and S is another relation, which of the following is an incorrect specification of an integrity constraint?
A.	primary key(a1, a2, a3)
B.	primary key(a1)
C.	foreign key(a1, a2) references S
D.	foreign key(a1, a2)
Answer» E.

20.	A le produced by a spreadsheet
A.	is generally stored on disk in an ascii text format
B.	can be used as is by the dbms
C.	all of the mentioned
D.	none of the mentioned
Answer» B. can be used as is by the dbms

27.	Relational schemas and other metadata about relations are stored in a structure called the ____________
A.	Metadata
B.	Catalog
C.	Log
D.	Data Dictionary
Answer» E.

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

29.	__________ is a contiguous group of blocks allocated for use as part of a table, index, and so forth.
A.	Tablespace
B.	Segment
C.	Extent
D.	Block
Answer» D. Block

30.	A ________ is a logical grouping of database objects, usually to facilitate security, performance, or the availability of database objects such as tables and indexes.
A.	Tablespace
B.	Segments
C.	Extents
D.	Blocks
Answer» B. Segments

31.	An Oracle __________ is a set of tables and views that are used as a read-only reference about the database.
A.	Database dictionary
B.	Dictionary table
C.	Data dictionary
D.	Dictionary
Answer» D. Dictionary

32.	Indices whose search key specifies an order different from the sequential order of the file are called ___________ indices.
A.	Nonclustered
B.	Secondary
C.	All of the mentioned
D.	None of the mentioned
Answer» D. None of the mentioned

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

An ________ is a set of entities of the same type that share the same properties, or attributes.

The attribute name could be structured as an attribute consisting of first name, middle initial, and last name. This type of attribute is called

create table apartment(ownerID varchar (5), ownername varchar(25), floor numeric(4,0),primary key (ownerID:));Choose the correct option regarding the above statement

In a relation between the entities the type and condition of the relation should be specified. That is called as______attribute.

With SQL, how do you select all the records from a table named Persons where the value of the column FirstName ends with an a ?

If you don t specify ASC or DESC after a SQL ORDER BY clause, the following is used by default ______________

With SQL, how can you return all the records from a table named Persons sorted descending by FirstName ?

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

Which question corresponds best to the following query? SELECT CID, CDUR - 1,' = PRICE' FROM COURSES ORDER BY 2

An entity set that does not have sufficient attributes to form a primary key is termed a __________

For each attribute of a relation, there is a set of permitted values, called the ________ of that attribute.

Database __________ which is the logical design of the database, and the database _______ which is a snapshot of the data in the database at a given instant in time.

Course(course_id,sec_id,semester) Here the course_id,sec_id and semester are __________ and course is a _________

Department (dept name, building, budget) and Employee (employee_id, name, dept name, salary) Here the dept_name attribute appears in both the relations. Here using common attributes in relation schema is one way of relating ___________ relations.

State true or false: If a relation consists of a foreign key, then it is called a referenced relation of the foreign key dependency.

Statement 1: A tuple is a row in a relation Statement 2: Existence of multiple foreign keys in a same relation is possible

Choose the option that correctly explains in words, the function of the following relational algebra expression year 2009 (book borrow)

What is the syntax to load data into the database? (Consider D as the database and a, b, c as datA:)

If a1, a2, a3 are attributes in a relation and S is another relation, which of the following is an incorrect specification of an integrity constraint?

A le produced by a spreadsheet

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

What type of join is needed when you wish to include rows that do not have matching values?

Find all the cities with temperature, condition and humidity whose humidity is in the range of 63 to 79.

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?

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?

___________ is the collection of memory structures and Oracle background processes that operates against an Oracle database.

Relational schemas and other metadata about relations are stored in a structure called the ____________

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

__________ is a contiguous group of blocks allocated for use as part of a table, index, and so forth.

A ________ is a logical grouping of database objects, usually to facilitate security, performance, or the availability of database objects such as tables and indexes.

An Oracle __________ is a set of tables and views that are used as a read-only reference about the database.

Indices whose search key specifies an order different from the sequential order of the file are called ___________ indices.

The database design that consists of multiple tables that are linked together through matching data stored in each table is called

In ordered indices the file containing the records is sequentially ordered, a ___________ is an index whose search key also defines the sequential order of the file.

An ____________ consists of a search-key value and pointers to one or more records with that value as their search-key value.

The traditional storage of data that is organized by customer, stored in separate folders in filing cabinets is an example of what type of database system?

In a _______ clustering index, the index record contains the search-key value and apointer to the first data record with that search-key value and the rest of the records will be inthe sequential pointers.

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

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

Insertion of a large number of entries at a time into an index is referred to as __________ of the index.

While inserting the record into the index, if the search-key value does not appear in the index.

Which of the following schemas does define a view or views of the database for particular users?

Which of the following are the process of selecting the data storage and data access characteristics of the database?

Which of the following terms does refer to the correctness and completeness of the data in a database?

If the state of the database no longer reflects a real state of the world that the database is supposed to capture, then such a state is called

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

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 ______________

Relational Algebra is a __________ query language that takes two relations as input and produces another relation as an output of the query.

The ___________ operation, denoted by , allows us to find tuples that are in one relation but are not in another.

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

Database ____ which is the logical design of the database, and the database _ which is a snapshot of the data in the database at a given instant in time.

Course(course_id,sec_id,semester) Here the course_id,sec_id and semester are __ and course is a _

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

33.	The database design that consists of multiple tables that are linked together through matching data stored in each table is called
A.	Hierarchical database
B.	Network database
C.	Object oriented database
D.	Relational database
Answer» E.

34.	In ordered indices the file containing the records is sequentially ordered, a ___________ is an index whose search key also defines the sequential order of the file.
A.	Clustered index
B.	Structured index
C.	Unstructured index
D.	Nonclustered index
Answer» B. Structured index

35.	An ____________ consists of a search-key value and pointers to one or more records with that value as their search-key value.
A.	Index entry
B.	Index hash
C.	Index cluster
D.	Index map
Answer» B. Index hash

36.	The traditional storage of data that is organized by customer, stored in separate folders in filing cabinets is an example of what type of database system?
A.	Hierarchical
B.	Network
C.	Object oriented
D.	Relational
Answer» B. Network

37.	In a _______ clustering index, the index record contains the search-key value and apointer to the first data record with that search-key value and the rest of the records will be inthe sequential pointers.
A.	Dense
B.	Sparse
C.	Straight
D.	Continuous
Answer» B. Sparse

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

39.	A search key containing more than one attribute is referred to as a _________ search key.
A.	Simple
B.	Composite
C.	Compound
D.	Secondary
Answer» C. Compound

40.	Insertion of a large number of entries at a time into an index is referred to as __________ of the index.
A.	Loading
B.	Bulk insertion
C.	Bulk loading
D.	Increase insertion
Answer» D. Increase insertion

42.	Which of the following schemas does define a view or views of the database for particular users?
A.	Internal schema
B.	Conceptual schema
C.	Physical schema
D.	External schema
Answer» E.

43.	Which of the following are the process of selecting the data storage and data access characteristics of the database?
A.	Logical database design
B.	Physical database design
C.	Testing and performance tuning
D.	Evaluation and selecting
Answer» C. Testing and performance tuning