Database || DBMS || Database Section 1 page-1

Database Section 1

Which symbol denote derived attributes in ER Model?

A.	Double ellipse
B.	Dashed ellipse
C.	Squared ellipse
D.	Ellipse with attribute name underlined

Answer: B

Details:

Dashed ellipse

Which of the following is NOT a superkey in a relational schema with attributes V, W, X, Y, Z and primary key V Y?

A.	VXYZ
B.	VWXYZ
C.	VWXZ
D.	VWXY

Answer: C

Details:

VWXZ doesn't contain the primary key VY. So, it is not a superkey.

Consider the relation schema: Author(authorName, bookName). What is the highest normal form satisfied by the "Author" relation schema?

A.	2NF
B.	3NF
C.	1NF
D.	BCNF

Answer: D

Details:

BCNF :

Every Binary Relation ( a Relation with only 2 attributes ) is always in BCNF. If a relation is BCNF then it should be in 3NF, 2NF, 1NF.

Which of the following language is used to access data from a database?

A.	ASP.Net
B.	SQL
C.	Java
D.	C++

Answer: B

Details:

SQL

Which of the following components is not a part of Entity Relationship Diagrams?

A.	Double lines
B.	Double rectangle
C.	Ellipse
D.	Hexagons

Answer: D

Details:

Hexagons

The process of removing deficiencies and loopholes in the data is called as____?

A.	Cleaning of data
B.	Compression of data
C.	Extraction of data
D.	Data aggregation

Answer: A

Details:

Cleaning of data

«12 »

Quick Links