E-Quiz on Database Management System

JavaScript isn't enabled in your browser, so this file can't be opened. Enable and reload.

Welcome Dear Participants,

The Department of Computer Science and Engineering& Information Technology, Bharat Institute of Engineering and Technology is pleased to announce the National Level E-Quiz on "DATABASE MANAGEMENT SYSTEM".

Who can attempt the Quiz...???

👉 All the staff members and students of colleges from Engineering & Technology and allied branches.

This will be help full to one and all for creating the awareness on DATABASE MANAGEMENT SYSTEM.

E-CERTIFICATE
Participants will get E-certificate immediately if his / her score is 40% and above.

Stay Home, Stay Safe.

Thank You!!!
Faculty Coordinators:
Mr.K.BHASKAR
Mr.ROMY SINHA
Assistant Professor

DEPARTMENT OF CSE&IT
BHARAT INSTITUTE OF ENGINEERING AND TECHNOLOGY, HYDERABAD, TELANGANA.
http://biet.ac.in/

Email *

Full Name *

NAME OF THE INSTITUTION *

DATE *

YYYY

Select Your Role * *

FACULTY

STUDENT

Required

MOBILE NUMBER

STATE

COUNTRY

Q.1 In the relational modes, cardinality is termed as: *

5 points

Number of tuples.

Number of attributes.

Number of tables.

Number of constraints

Q.2 In tuple relational calculus P1 ®P2 is equivalent to *

5 points

¬P1 Ú P2

P1 Ú P2

P1 Ù P2

P1 Ù¬P2

Q.3 The language which has recently become the Defacto standard for interfacing application programs with relational database system is *

5 points

Oracle.

SQL.

DBase.

4GL.

Q.4 The DBMS language component which can be embedded in a program is *

5 points

The data definition language (DDL).

The data manipulation language (DML).

The database administrator (DBA).

A query language

Q.5 A relational database developer refers to a record as *

5 points

a criteria.

a relation.

a tuple.

an attribute.

Q.6 which one of the following statements is false? *

5 points

The data dictionary is normally maintained by the database administrator.

Data elements in the database can be modified by changing the data dictionary.

The data dictionary contains the name and description of each data element.

The data dictionary is a tool used exclusively by the database administrator.

Q.7 The statement in SQL which allows to change the definition of a table is *

5 points

Alter.

Update.

Create.

select.

Q.8 Which of the following operations need the participating relations to be union compatible? *

5 points

UNION

INTERSECTION

DIFFERENCE

All of the above

Q.9 The users who use easy-to-use menu are called *

5 points

Sophisticated end users.

Naïve users.

Stand-alone users.

Casual end users.

Q.10 Which of the following is another name for weak entity? *

5 points

Child

Owner

Dominant

All of the above

Q.11 Using Relational Algebra the query that finds customers, who have a balance of over 1000 is *

5 points

PCustomer_name(s balance >1000(Deposit))

s Customer_name(Pbalance >1000(Deposit))

PCustomer_name(s balance >1000(Borrow))

s Customer_name(Pbalance >1000(Borrow))

Q.12 In E-R Diagram derived attribute are represented by *

5 points

Ellipse

Dashed ellipse

Rectangle

Triangle

Q.13 Consider the join of a relation R with relation S. If R has m tuples and S has n tuples, then the maximum size of join is: *

5 points

m+n

(m+n)/2

2(m+n)

Q.14 Which one of the following is not true for a view: *

5 points

View is derived from other tables.

View is a virtual table.

A view definition is permanently stored as part of the database.

View never contains derived columns.

Q.15 To delete a particular column in a relation the command used is: *

5 points

UPDATE

DROP

ALTER

DELETE

Q.16 The method of access which uses key transformation is known as *

5 points

Direct

Hash

Random

Sequential

Q.17 _________ data type can store unstructured data *

5 points

RAW

CHAR

NUMERIC

VARCHAR

Q.18 Which of the following is a comparison operator in SQL? *

5 points

BETWEEN

All of the above

Q.19 The result of the UNION operation between R1 and R2 is a relation that includes *

5 points

all the tuples of R1

all the tuples of R2

all the tuples of R1 and R2

all the tuples of R1 and R2 which have common columns

Q.20 Which of the following are the properties of entities? *

5 points

Groups

Table

Attributes

Switchboards

Send me a copy of my responses.

Submit

Clear form

Never submit passwords through Google Forms.

reCAPTCHA

Privacy Terms

This form was created inside of BHARAT INSTITUTE OF ENGINEERING AND TECHNOLOGY. Report Abuse

Forms