Database Management System

Please wait while the activity loads.
If this activity does not load, try refreshing your browser. Also, this page requires javascript. Please visit using a browser with javascript enabled.

If loading fails, click here to try again

Welcome to NTA NET ASPIRANT ACADEMY

NTA NET ASPIRANT ACADEMY is a training academy for College Lectures, Assistant Professor, Research Scholar and PG Students to make qualified for Assistant Professor & JRF in UGC NET / TNSET

Start

Congratulations - you have completed Database Management System. You scored %%SCORE%% out of %%TOTAL%%. Your performance has been rated as %%RATING%%

Your answers are highlighted below.

Question 1

The process of removing details from a given state representation is called ________ NTA NET JUNE 2020

A	Extraction
B	Mining
C	Selection
D	Abstraction

Question 2

In the context of concurrency control, a given pair of operations in a schedule is called conflict schedule if NTA NET JUNE 2020
A. At least one of the operations is write operation.
B. Both the operations are performed on the same data item.
C. Both the operations are performed by different transactions.
D. Both the operations are performed on different data items.
Choose the correct answer from the options given below:

A	(A) and (B) only
B	(A), (B) and (C) only
C	(A), (C) and (D) only
D	(C) and (D) only

Question 3

An organization needs to maintain database having five attributes A,B,C,D,E. These attributes are functionally dependent on each other for which functionally dependency set F is given as: F:{A→BC, D→E, BC→, A→D}. Consider a universal relation R(A,B,C,D,E) with functional dependency set F. Also all attributes are simple and take atomic values only. NTA NET DECEMBER 2019
Minimal cover F^' of functional dependency set F is
1. F^' = {A→B, A→C, BC→D, D→E}
2. F^' = {A→BC, B→D, D→E}
3. F^' = {A→B, A→C, A→D, D→E}
4. F^' = {A→B, A→C, B→D, C→D, D→E}

A	1
B	2
C	3
D	4

Question 4

An organization needs to maintain database having five attributes A,B,C,D,E. These attributes are functionally dependent on each other for which functionally dependency set F is given as: F:{A→BC, D→E, BC→, A→D}. Consider a universal relation R(A,B,C,D,E) with functional dependency set F. Also all attributes are simple and take atomic values only. NTA NET DECEMBER 2019
Assume that given table R is decomposed in two tables
R₁(A, B, C) with functional dependency set f₁={A→B, A→C} and
R₂(A, D, E) with functional dependency set f₂={A→D, D→E}.
Which of the following option is true w.r.t. given decomposition?
1. Dependency preservation property is followed
2. R₁ and R₂ are both in 2NF
3. R₂ is in 2NF and R₃ is in 3NF
4. R₁ is in 3NF and R₂ is in 2NF

A	1
B	2
C	3
D	4

Question 5

A	BC
B	AD
C	A
D	AB

Question 6

A	BC → D
B	D → E
C	A → D
D	A → BC

Question 7

A	1 NF
B	2 NF
C	3 NF
D	BCNF

Question 8

Given two tables R₁(x,y) and R₂(y,z) with 50 and 30 number of tuples respectively. Find maximum number of tuples in the output of natural join between tables R₁ and R₂ i.e. R₁ * R₂ ? (* Natural Join) NTA NET DECEMBER 2019

A	30
B	20
C	50
D	1500

Question 9

Which of the component module of DBMS does rearrangement and possible ordering of operations, eliminate redundancy in query and use efficient algorithms and indexes during the execution of a query? NTA NET DECEMBER 2019

A	Query Compiler
B	Query Optimizer
C	Stored data manager
D	Database Processor

Question 10

Two concurrent executing transactions T₁ and T₂ are allowed to update same stock item say A^' in an uncontrolled manner. In such scenario, following problems may occur: NTA NET DECEMBER 2019
A. Dirty read problem
B. Lost update problem
C. Transaction failure
D. Inconsistent database state
Which of the following option is correct if database system has no concurrency module and allows concurrent execution of above two transactions?

A	(A), (B) and (C) only
B	(C) and (D) only
C	(A) and (B) only
D	(A), (B) and (D) only

Question 11

In RDBMS, which type of Join returns all rows that satisfy the join condition? CBSE NET JULY 2018

A	Inner Join
B	Outer Join
C	Semi Join
D	Anti Join

Question 12

Consider a relation book(title, price) which contains the titles and prices of different books. Assuming that no two books have the same price, what does the following SQL query list? CBSE NET JULY 2018 Select title from book as B where(select count(*) from book as T where T.price > B.price) < 7

A	Titles of the six most expensive books.
B	Title of the sixth most expensive books.
C	Titles of the seven most expensive books.
D	Title of the seventh most expensive books.

Question 13

In a Hierarchical database, a hashing function is used to locate the _____ CBSE NET JULY 2018

A	Collision
B	Root
C	Foreign Key
D	Records

Question 14

Relations produced from E - R model will always be in _____ . CBSE NET JULY 2018

A	1 NF
B	2 NF
C	3 NF
D	4 NF

Question 15

Consider the following schedules involving two transactions. CBSE NET JULY 2018
S₁: r₁(X); r₁(Y);r₂(X); r₂(Y);w₂(Y); w₁(X)
S₂: r₁(X); r₂(X);r₂(Y); w₂(Y);r₁(Y); w₁(X)
Which one of the following statements is correct with respect to above?

A	Both S1 and S2 are conflict serializable.
B	Both S1 and S2 are not conflict serializable.
C	S1 is conflict serializable and s2 is not conflict serializable.
D	S1 is not conflict serializable and s2 is conflict serializable.

Question 16

For a database relation R(a,b,c,d) where the domains of a,b,c and d include only atomic values, and only the following functional dependencies and those that can be inferred from them hold: CBSE NET JULY 2018

a → c

b → d
The relation is in ______.

A	First normal form but not in second normal form
B	Second normal form but not in third normal form
C	Third normal form
D	BCNF

Question 17

A many-to-one relationship exists between entity sets r₁ and r₂. How will it be represented using functional dependencies of Pk(r) denotes the primary key attribute of relation r? CBSE NET JULY 2018

A	Pk(r1) → Pk(r2)
B	Pk(r2) → Pk(r1)
C	Pk(r2) → Pk(r1) and Pk(r1) → Pk(r2)
D	Pk(r2) → Pk(r1) or Pk(r1) → Pk(r2)

Question 18

Database systems that store each relation in a separate operating system file may use the operating system's authorization scheme, instead of defining a special scheme themselves. In this case, Which of the following is false? CBSE NET JULY 2018

A	The administrator enjoys more control on the grant option.
B	It is difficult to differentiate among the update, delete and insert authorizations.
C	Cannot store more than one relation in a file.
D	Operations on the database are speeded up as the authorization procedure is carried out at the operating system level.

Question 19

Let R₁(a,b,c) and R₂(x,y,z) be two relations in which a is the foreign key of R₁ that refers the primary key of R₂. Consider the following four options. CBSE NET JULY 2018

A. Insert into R₁

B. insert into R₂

C. Delete from R₁

D. Delete from R₂

Which of the following is correct about the referential integrity constraint with respect to above?

A	Operations of (A) and (B) will cause violation.
B	Operations of (B) and (C) will cause violation.
C	Operations of (C) and (D) will cause violation.
D	Operations of (D) and (A) will cause violation.

Question 20

An attribute A of datatype varchar(20) has the value 'xyz', and the attribute B of datatype char(20) has the value "lmnop", then the attribute A has ____ spaces and attribute B has _____ spaces. CBSE NET JULY 2018

A	3,5
B	20,20
C	3,20
D	20,5

Question 21

Data warehouse contains ____ data that is never found in operational environment. CBSE NET JULY 2018

A	Summary
B	Encoded
C	Encrypted
D	Scripted

Question 22

___________ command is used to remove a relation from an SQL database. CBSE NET JULY 2018

A	Drop table
B	Delete table
C	Remove table
D	Update table

Question 23

Which of the following statements is / are true? CBSE NET JULY 2018

(i) Facebook has the world's largest Hadoop Cluster.

(ii) Hadoop 2.0 allows live stream processing of Real time data.

Choose the correct answer from the code given below:

A	(i) only
B	(ii) only
C	Both (i) and (ii)
D	Neither (i) nor (ii)

Question 24

Data scrubbing is CBSE NET JULY 2018

A	A process to reject data from the data warehouse and to create the necessary indexes.
B	A process to load the data in the data warehouse and to create the necessary indexes.
C	A process to upgrade the quality of data after it is moved into a data warehouse.
D	A process to upgrade the quality of data before it is moved into a data warehouse.

Question 25

Consider a relation schema R=(A,B,C,D,E,F) on which the following functional dependencies hold: CBSE NET JULY 2018

A → B

B,C → D

E → C

D → A

What are the candidate keys of R?

A	AE and BE
B	AE, BE and DE
C	AEF, BEF and BCF
D	AEF, BEF and DEF

Question 26

Consider the following tables (relations): CBSE NET JULY 2018
Students

Roll_no	Name
18CS101	Ramesh
18CS102	Mukesh
18cs103	Ramesh

Performance

Roll_no	Course	Marks
18CS101	DBMS	60
18CS101	Compiler Design	65
18cs102	DBMS	80
18cs103	DBMS	85
18cs102	Compiler Design	75
18cs103	Operating System	70

Primary keys in the tables are shown using underline. Now, consider the following query:

SELECT S.Name, Sum (P.Marks) FROM Students S, Performance P WHERE S.Roll_No = P.Roll_No GROUP BY S.Name

The number of rows returned by above query is

A	0
B	1
C	2
D	3

Once you are finished, click the button below. Any items you have not completed will be marked incorrect. Get Results

There are 26 questions to complete.