Wednesday, March 13, 2024 6:52 PM

• Database management System NTA UGC NET Question Analysis Part-2

Database management System NTA UGC NET
Question Analysis Part-2
Database management System NTA UGC NET Question Analysis
Part-2
DBMS PYQ Part-1
Q62➡ | UGC NET November 2017 Paper-III
Suppose a database schedule S involves transactions T1, T2, ………….,Tn. Consider the precedence
graph of S with vertices representing the transactions and edges representing the conflicts. If S is
serializable, which one of the following orderings of the vertices of the precedence graph is
guaranteed to yield a serial schedule ?

i ➥ Topological order
ii ➥ Depth – first order
iii ➥ Breadth – first order
iv ➥ Ascending order of transaction indices

Show Answer With Best Explanation

Answer: I
Explanation: Upload Soon
More Discussion Explanation On YouTube Learn Topic Wise Help-Line

Q63➡ | UGC NET November 2017 Paper-III

If every non-key attribute is functionally dependent on the primary key, then the relation is
in ________ .

i ➥ First normal form

ii ➥ Second normal form
iii ➥ Third normal form
iv ➥ Fourth normal form

Show Answer With Best Explanation

Answer: III
Explanation: Upload Soon
More Discussion Explanation On YouTube Learn Topic Wise Help-Line

Q64➡ | UGC NET November 2017 Paper-III

Consider a relation R (A, B, C, D, E, F, G, H), where each attribute is atomic, and following functional
dependencies exist.
CH → G
A → BC
B → CFH
E→A
F → EG
The relation R is __ .

New Section 6 Page 1

i ➥ in 1NF but not in 2NF
ii ➥ in 2NF but not in 3NF
iii ➥ in 3NF but not in BCNF
iv ➥ in BCNF

Show Answer With Best Explanation

Answer: I
Explanation: Upload Soon
More Discussion Explanation On YouTube Learn Topic Wise Help-Line

Q65➡ | UGC NET November 2017 Paper-III

Given two relations R1(A, B) and R2(C, D), the result of following query Select distinct A, B from R1,
R2 is guaranteed to be same as R1 provided one of the following condition is satisfied.

i ➥ R1 has no duplicates and R2 is empty.

ii ➥ R1 has no duplicates and R2 is non – empty.
iii ➥ Both R1 and R2 have no duplicates.
iv ➥ R2 has no duplicates and R1 is non – empty.

Show Answer With Best Explanation

Answer: II
Explanation: Upload Soon
More Discussion Explanation On YouTube Learn Topic Wise Help-Line

Q66➡ | UGC NET November 2017 Paper-III

Consider a schema R(A, B, C, D) and following functional dependencies.
A→B
B→C
C→D
D→B
Then decomposition of R into R1(A, B), R2(B, C) and R3(B, D) is __ .

i ➥ Dependency preserving and lossless join.

ii ➥ Lossless join but not dependency preserving.
iii ➥ Dependency preserving but not lossless join.
iv ➥ Not dependency preserving and not lossless join.

Show Answer With Best Explanation

Answer: I
Explanation: Upload Soon
More Discussion Explanation On YouTube Learn Topic Wise Help-Line

Q67➡ | UGC NET January 2017 Paper-II

An attribute A of data type varchar (20) has value ‘Ram’ and the attribute B of data type char (20)
has value ‘Sita’ in oracle. The attribute A has_______memory spaces and B has_______ memory
spaces.

i ➥ 20,20

New Section 6 Page 2

i ➥ 20,20
ii ➥ 3,20
iii ➥ 3,4
iv ➥ 20,4

Show Answer With Best Explanation

Answer: II
Explanation: Upload Soon
More Discussion Explanation On YouTube Learn Topic Wise Help-Line

Q68➡ | UGC NET January 2017 Paper-II

Integrity constraints ensure that changes made to the database by authorized users do not result
into loss of data consistency. Which of the following statement(s) is (are) true w.r.t. the examples of
integrity constraints ?
(1) An instructor Id. No. cannot be null, provided Instructor Id No. being primary key.
(2) No two citizens have same Adhar-Id.
(3) Budget of a company must be zero.

i ➥ (1), (2) and (3) are true

ii ➥ (1) false, (2) and (3) are true.
iii ➥ (1) and (2) are true; (3) false.
iv ➥ (1), (2) and (3) are false

Show Answer With Best Explanation

Answer: III
Explanation: Upload Soon
More Discussion Explanation On YouTube Learn Topic Wise Help-Line

Q69➡ | UGC NET January 2017 Paper-II

Let M and N be two entities in an E-R diagram with simple single value attributes.
R1 and R2 are two relationship between M and N, where as
R1 is one-to-many and R2 is many-to-many.
The minimum number of tables required to represent M, N, R1 and R2 in the relational model
are ______.

i➥4
ii ➥ 6
iii ➥ 7
iv ➥ 3
3

Show Answer With Best Explanation

Answer: IV
Explanation: Upload Soon
More Discussion Explanation On YouTube Learn Topic Wise Help-Line

Q70➡ | UGC NET January 2017 Paper-II

Consider a schema R(MNPQ) and functional dependencies M → N, P → Q. Then the decomposition

New Section 6 Page 3

Consider a schema R(MNPQ) and functional dependencies M → N, P → Q. Then the decomposition
of R into R1 (MN) and R2 (PQ) is________.

i ➥ Dependency preserving but not lossless join

ii ➥ Dependency preserving and lossless join
iii ➥ Lossless join but not dependency preserving
iv ➥ Neither dependency preserving nor lossless join.

Show Answer With Best Explanation

Answer: I
Explanation: Upload Soon
More Discussion Explanation On YouTube Learn Topic Wise Help-Line

Q71➡ | UGC NET January 2017 Paper-II

The order of a leaf node in a B+ tree is the maximum number of children it can have. Suppose that
block size is 1 kilobytes, the child pointer takes 7 bytes long and search field value takes 14 bytes
long. The order of the leaf node is __.

i ➥ 16
ii ➥ 63
iii ➥ 64
iv ➥ 69

Show Answer With Best Explanation

Answer: * (Marks to all )
Explanation: Upload Soon
More Discussion Explanation On YouTube Learn Topic Wise Help-Line

Q72➡ | UGC NET January 2017 Paper-II

_____refers loosely to the process of semi-automatically analyzing large databases to find useful
patterns.

i ➥ Datamining
ii ➥ Data warehousing
iii ➥ DBMS
iv ➥ Data mirroring

Show Answer With Best Explanation

Answer: I
Explanation: Upload Soon
More Discussion Explanation On YouTube Learn Topic Wise Help-Line

Q73➡ | UGC NET January 2017 Paper-II

Which of the following statements is/are true w.r.t. Enterprise Resource Planning (ERP) ?
(A) ERP automates and integrates majority of business processes.
(B) ERP provides access to information in a Real Time Environment.
(C) ERP is inexpensive to implement

i ➥ (A), (B) and (C) are false.

New Section 6 Page 4

i ➥ (A), (B) and (C) are false.
ii ➥ (A) and (B) false; (C) true.
iii ➥ (A) and (B) true; (C) false.
iv ➥ (A) true ; (B) and (C) are false.

Show Answer With Best Explanation

Answer: III
Explanation: Upload Soon
More Discussion Explanation On YouTube Learn Topic Wise Help-Line

Q74➡ | UGC NET January 2017 Paper-III

Consider following schedules involving two transactions:
S1 : r1(X); r1(Y); r2(X); r2(Y); w2(Y); w1(X)
S2 : r1(X); r2(X); r2(Y); w2(Y); r1(Y); w1(X)
Which of the following statement is true?

i ➥ Both S1 and S2 are conflict serializable.

ii ➥ S1 is conflict serializable and S2 is not conflict serializable.
iii ➥ S1 is not conflict serializable and S2 is conflict serializable.
iv ➥ Both S1 and S2 are not conflict

Show Answer With Best Explanation

Answer: III
Explanation: Upload Soon
More Discussion Explanation On YouTube Learn Topic Wise Help-Line

Q75➡ | UGC NET January 2017 Paper-III

Which one is correct w.r.t. RDBMS ?

i ➥ primary key ⊆ super key ⊆ candidate key

ii ➥ primary key ⊆ candidate key ⊆ super key
iii ➥ super key ⊆ candidate key ⊆ primary key
iv ➥ super key ⊆ primary key ⊆ candidate key

Show Answer With Best Explanation

Answer: II
Explanation: Upload Soon
More Discussion Explanation On YouTube Learn Topic Wise Help-Line

Q76➡ | UGC NET January 2017 Paper-III

Let pk(R) denotes primary key of relation R. A many-to-one relationship that exists between two
relations R1 and R2 can be expressed as follows :

i ➥ pk(R2) → pk(R1)
ii ➥ pk(R1) → pk(R2)
iii ➥ pk(R2) → R1 ∩ R2
iv ➥ pk(R1) → R1 ∩ R2

New Section 6 Page 5

iv ➥ pk(R1) → R1 ∩ R2

Show Answer With Best Explanation

Answer: II
Explanation: Upload Soon
More Discussion Explanation On YouTube Learn Topic Wise Help-Line

Q77➡ | UGC NET January 2017 Paper-III

For a database relation R(A, B, C, D) where the domains of A, B, C and D include only atomic values,
only the following functional dependencies and those that can be inferred from them are :
A→C
B→D
The relation R is in________.

i ➥ First normal form but not in second normal form.

ii ➥ Both in first normal form as well as in second normal form.
iii ➥ Second normal form but not in third normal form.
iv ➥ Both in second normal form as well as in third normal form.

Show Answer With Best Explanation

Answer: I
Explanation: Upload Soon
More Discussion Explanation On YouTube Learn Topic Wise Help-Line

Q78➡ | UGC NET January 2017 Paper-III

Works (emp name, company name, salary)
Here, emp_name is primary key. Consider the following SQL query
Select emp name
From works T
Where salary > (select avg (salary)
from works S
where T.company _ name = S.company _name)
The above query is for following :

i ➥ Find the highest paid employee who earns more than the average salary of all employees of his
company
ii ➥ Find the highest paid employee who earns more than the average salary of all the employees
of all the companies.
iii ➥ Find all employees who earn more than the average salary of all employees of all the
companies.
iv ➥ Find all employees who earn more than the Average salary of all employees of their company.

Show Answer With Best Explanation

Answer: IV
Explanation: Upload Soon
More Discussion Explanation On YouTube Learn Topic Wise Help-Line

Q79➡ | UGC NET January 2017 Paper-III

If following sequence of keys are inserted in a B+ tree with K(=3) pointers:

New Section 6 Page 6

If following sequence of keys are inserted in a B+ tree with K(=3) pointers:
8, 5, 1, 7, 3, 12, 9, 6
Which of the following shall be correct B+ tree?

A➥

B➥

C➥

D➥

Show Answer With Best Explanation

Answer: A
Explanation: Upload Soon

Q80➡ | UGC NET July 2016 Paper-II

In RDBMS, the constraint that no key attribute (column) may be NULL is referred to as:

i ➥ Referential integrity
ii ➥ Multi-valued dependency
iii ➥ Entity Integrity
iv ➥ Functional dependency

New Section 6 Page 7

Show Answer With Best Explanation
Answer: III
Explanation: Upload Soon
More Discussion Explanation On YouTube Learn Topic Wise Help-Line

Q81➡ | UGC NET July 2016 Paper-II

Which of the following statement(s) is/are FALSE in the context of Relational DBMS ?
I. Views in a database system are important because they help with access control by allowing users
to see only a particular subset of the data in the database.
II. E-R diagrams are useful to logically model concepts.
III. An update anomaly is when it is not possible to store information unless some other, unrelated
information is stored as well.
IV. SQL is a procedural language.

i ➥ I and IV only
ii ➥ III and IV only
iii ➥ I, II and III only
iv ➥ II, III and IV only

Show Answer With Best Explanation

Answer: IV
Explanation: Upload Soon
More Discussion Explanation On YouTube Learn Topic Wise Help-Line

Q82➡ | UGC NET July 2016 Paper-II

In a relational database model, NULL values can be used for all but which one of the following ?

i ➥ To allow duplicate tuples in the table by filling the primary key column(s) with NULL.
ii ➥ To avoid confusion with actual legitimate data values like 0 (zero) for integer columns and ’’
(the empty string) for string columns.
iii ➥ To leave columns in a tuple marked as ’’unknown’’ when the actual value is unknown.
iv ➥ To fill a column in a tuple when that column does not really ”exist” for that particular tuple.

Show Answer With Best Explanation

Answer: III
Explanation: Upload Soon
More Discussion Explanation On YouTube Learn Topic Wise Help-Line

Q83➡ | UGC NET July 2016 Paper-II

Consider the following two commands C1 and C2 on the relation R from an SQL database:
C1 : drop table R;
C2 : delete from R;
Which of the following statements is TRUE ?
I. Both C1 and C2 delete the schema for R.
II. C2 retains relation R, but deletes all tuples in R.
III. C1 deletes not only all tuples of R, but also the schema for R.

i ➥ I only
ii ➥ I and II only

New Section 6 Page 8

ii ➥ I and II only
iii ➥ II and III only
iv ➥ I, II and III

Show Answer With Best Explanation

Answer: III
Explanation: Upload Soon
More Discussion Explanation On YouTube Learn Topic Wise Help-Line

Q84➡ | UGC NET July 2016 Paper-II

Consider the following database table having A, B, C and D as its four attributes and four possible
candidate keys (I, II,III and IV) for this table :

I : {B}
II : {B, C}
III : {A, D}
IV : {C, D}
If different symbols stand for different values in the table (e.g., d1 is definitely not equal to d2 ),
then which of the above could not be the candidate key for the database table ?

i ➥ I and III only

ii ➥ III and IV only
iii ➥ II only
iv ➥ I only

Show Answer With Best Explanation

Answer: III
Explanation: Upload Soon
More Discussion Explanation On YouTube Learn Topic Wise Help-Line

Q85➡ | UGC NET July 2016 Paper-II

Consider the following two statements :
(A) Business intelligence and Data warehousing is used for forecasting and Data mining.
(B) Business intelligence and Data warehousing is used for analysis of large volumes of sales data.
Which one of the following options is correct ?

i ➥ (A) is true, (B) is false.

ii ➥ Both (A) and (B) are true.
iii ➥ (A) is false, (B) is true.
iv ➥ Both (A) and (B) are false.

Show Answer With Best Explanation

New Section 6 Page 9

Show Answer With Best Explanation
Answer: II
Explanation: Upload Soon
More Discussion Explanation On YouTube Learn Topic Wise Help-Line

Q86➡ | UGC NET July 2016 Paper-II

Consider the following two statements :
(A) Data scrubling is a process to upgrade the quality of data, before it is moved into Data
warehouse.
(B) Data scrubling is a process of rejecting data from data warehouse to create indexes.
Which one of the following options is correct ?

i ➥ (A) is true, (B) is false.

ii ➥ (A) is false, (B) is true.
iii ➥ Both (A) and (B) are false.
iv ➥ Both (A) and (B) are true.

Show Answer With Best Explanation

Answer: I
Explanation: Upload Soon
More Discussion Explanation On YouTube Learn Topic Wise Help-Line

Q87➡ | UGC NET July 2016 Paper-II

Given the following statements:
(A) Strategic value of data mining is timestamping.
(B) Information collection is an expensive process in building an expert system.
Which of the following options is correct?

i ➥ Both (A) and (B) are false.

ii ➥ Both (A) and (B) are true.
iii ➥ (A) is true, (B) is false.
iv ➥ (A) is false, (B) is true.

Show Answer With Best Explanation

Answer: II
Explanation: Upload Soon
More Discussion Explanation On YouTube Learn Topic Wise Help-Line

Database management System NTA UGC NET Question Analysis

Part-2
Q88➡ | UGC NET July 2016 Paper-III
Which of the following statements is/are True regarding some advantages that an object-oriented
DBMS (OODBMS) offers over a relational database ?
I. An OODBMS avoids the“impedance mismatch” problem.
II. An OODBMS avoids the “phantom” problem.
III. An OODBMS provides higher performance concurrency control than most relational databases.
IV. An OODBMS provides faster access to individual data objects once they have been read from
disk.

i ➥ II and III only

New Section 6 Page 10

i ➥ II and III only
ii ➥ I and IV only
iii ➥ I, II, and III only
iv ➥ I, III and IV only

Show Answer With Best Explanation

Answer: II
Explanation: Upload Soon
More Discussion Explanation On YouTube Learn Topic Wise Help-Line

Q89➡ | UGC NET July 2016 Paper-III

The Global conceptual Schema in a distributed database contains information about global
relations. The condition that all the data of the global relation must be mapped into the fragments,
that is, it must not happen that a data item which belongs to a global relation does not belong to
any fragment, is called:

i ➥ Disjointness condition
ii ➥ Completeness condition
iii ➥ Reconstruction condition
iv ➥ Aggregation condition

Show Answer With Best Explanation

Answer: II
Explanation: Upload Soon
More Discussion Explanation On YouTube E-R Diagram Help-Line

Q90➡ | UGC NET July 2016 Paper-III

Suppose database table T1(P,R) currently has tuples (10,5),(15,8),(25,6) and table T2(A,C) currently
has (10,6),(25,3),(10,5). Consider the following three relational algebra queries RA1,RA2 and RA3:

The number of tuples in the resulting table of RA1, RA2 and RA3 are given by :

i ➥ 2,4,2 respectively
ii ➥ 2,3,2 respectively
iii ➥ 3,3,1 respectively
iv ➥ 3,4,1 respectively

Show Answer With Best Explanation

Answer: IV
Explanation: Upload Soon
More Discussion Explanation On YouTube Learn Topic Wise Help-Line

New Section 6 Page 11

Q91➡ | UGC NET July 2016 Paper-III
Consider the table R with attributes A, B and C. The functional dependencies that hold on R are : A
→ B, C → AB. Which of the following statements is/are True ?
I. The decomposition of R into R1(C, A) and R2(A, B) is lossless.
II. The decomposition of R into R1(A, B) and R2(B, C) is lossy.

i ➥ Only I
ii ➥ Only II
iii ➥ Both I and II
iv ➥ Neither I nor II

Show Answer With Best Explanation

Answer: III
Explanation: Upload Soon
More Discussion Explanation On YouTube Learn Topic Wise Help-Line

Q92➡ | UGC NET July 2016 Paper-III

Consider the following ORACLE relations : One (x, y) = {<2, 5>, <1, 6>, <1, 6>, <1, 6>, <4, 8>, <4, 8>}
Two (x, y) = {<2, 55>, <1, 1>, <4, 4>, <1, 6>, <4, 8>, <4, 8>, <9, 9>, <1, 6>}
Consider the following two SQL queries SQ1 and SQ2 :
SQ1 : SELECT * FROM One)
EXCEPT
(SELECT * FROM Two);
SQ2 : SELECT * FROM One)
EXCEPT ALL
(SELECT * FROM Two);
For each of the SQL queries, what is the cardinality (number of rows) of the result obtained when
applied to the instances above ?

i ➥ 2 and 1 respectively
ii ➥ 1 and 2 respectively
iii ➥ 2 and 2 respectively
iv ➥ 1 and 1 respectively

Show Answer With Best Explanation

Answer: II
Explanation: Upload Soon
More Discussion Explanation On YouTube Learn Topic Wise Help-Line

Q93➡ | UGC NET July 2016 Paper-III

Which one of the following pairs is correctly matched in the context of design?

New Section 6 Page 12

i ➥ A I-D, II-A, III-B, IV-C
ii ➥ I-D, II-C, III-B, IV-A
iii ➥ I-C, II-D, III-A, IV-B
iv ➥ I-C, II-A, III-D, IV-B

Show Answer With Best Explanation

Answer: IV
Explanation: Upload Soon
More Discussion Explanation On YouTube E-R Diagram Help-Line

Q94➡ | UGC NET August 2016 Paper-II

DBMS provides the facility of accessing data from a database through

i ➥ DDL
ii ➥ DML
iii ➥ DBA
iv ➥ Schema

Show Answer With Best Explanation

Answer: II
Explanation: Upload Soon
More Discussion Explanation On YouTube Learn Topic Wise Help-Line

Q95➡ | UGC NET August 2016 Paper-II

Relational database schema normalization is NOT for:

i ➥ reducing the number of joins required to satisfy a query.

ii ➥ eliminating uncontrolled redundancy of data stored in the database.

New Section 6 Page 13

iii ➥ eliminating number of anomalies that could otherwise occur with inserts and deletes.
iv ➥ ensuring that functional dependencies are enforced.

Show Answer With Best Explanation

Answer: I
Explanation: Upload Soon
More Discussion Explanation On YouTube Learn Topic Wise Help-Line

Q96➡ | UGC NET August 2016 Paper-II

Consider the following statements regarding relational database model:
(a) NULL values can be used to opt a tuple out of enforcement of a foreign key.
(b) Suppose that table T has only one candidate key. If Q is in 3NF, then it is also in BCNF.
(c) The difference between the project operator (Π) in relational algebra and the SELECT keyword in
SQL is that if the resulting table/set has more than one occurrences of the same tuple, then Π will
return only one of them, while SQL SELECT will return all.
One can determine that:

i ➥ (a) and (b) are true.

ii ➥ (a) and (b) are true
iii ➥ (b) and (c) are true
iv ➥ (a), (b) and (c) are true

Show Answer With Best Explanation

Answer: IV
Explanation: Upload Soon
More Discussion Explanation On YouTube Learn Topic Wise Help-Line

Database management System NTA UGC NET Question Analysis

Part-2
Q97➡ | UGC NET August 2016 Paper-II

Consider the following Entity-Relationship (E-R) diagram and three possible relationship sets (I, II and III) for this E-R
diagram:

New Section 6 Page 14

If different symbols stand for different values (e.g., t1 is definitely not equal to t2 ) , then which of the above could not be
the relationship set for the E-R diagram ?

i ➥ I only
ii ➥ I and II only
iii ➥ II only
iv ➥ I, II and III

Show Answer With Best Explanation

Answer: I
Explanation: Upload Soon
More Discussion Explanation On YouTube Learn Topic Wise Help-Line

Q98➡ | UGC NET August 2016 Paper-II

Consider a database table R with attributes A and B. Which of the following SQL queries is illegal ?

i ➥ SELECT A FROM R;
ii ➥ SELECT A, COUNT(*) FROM R;
iii ➥ SELECT A, COUNT(*) FROM R GROUP BY A;
iv ➥ SELECT A, B, COUNT(*) FROM R GROUP BY A, B;

Show Answer With Best Explanation

Answer: II
Explanation: Upload Soon
More Discussion Explanation On YouTube Learn Topic Wise Help-Line

Q99➡ | UGC NET August 2016 Paper-II

__________ is subject oriented, integrated, time variant, nonvolatile collection of data in support of
management decisions.

New Section 6 Page 15

management decisions.

i ➥ Data mining
ii ➥ Web mining
iii ➥ Data warehouse
iv ➥ Database Management System

Show Answer With Best Explanation

Answer: III
Explanation: Upload Soon
More Discussion Explanation On YouTube Learn Topic Wise Help-Line

Q100➡ | UGC NET August 2016 Paper-II

In Data mining, classification rules are extracted from________.

i ➥ Data
ii ➥ Information
iii ➥ Decision Tree
iv ➥ Database

Show Answer With Best Explanation

Answer: III
Explanation: Upload Soon
More Discussion Explanation On YouTube Learn Topic Wise Help-Line

Q101➡ | UGC NET August 2016 Paper-II

In Data mining,_____________is a method of incremental conceptual clustering.

i ➥ STRING
ii ➥ COBWEB
iii ➥ CORBA
iv ➥ OLAD

Show Answer With Best Explanation

Answer: II
Explanation: Upload Soon
More Discussion Explanation On YouTube Learn Topic Wise Help-Line

Q102➡ | UGC NET August 2016 Paper-III

Which of the following statements concerning Object-Oriented databases is FALSE?

i ➥ Objects in an object-oriented database contain not only data but also methods for processing
the data.
ii ➥ Object-oriented databases store computational instructions in the same place as the data.
iii ➥ Object-oriented databases are more adept at handling structured (analytical) data than
relational databases.
iv ➥ Object-oriented databases store more types of data than relational databases and access that

New Section 6 Page 16

iv ➥ Object-oriented databases store more types of data than relational databases and access that
data faster.

Show Answer With Best Explanation

Answer: III
Explanation: Upload Soon
More Discussion Explanation On YouTube Learn Topic Wise Help-Line

Q103➡ | UGC NET August 2016 Paper-III

In distributed databases, location transparency allows for database users, programmers and
administrators to treat the data as if it is at one location. A SQL query with location transparency
needs to specify:

i ➥ Inheritances
ii ➥ Fragments
iii ➥ Locations
iv ➥ Local formats

Show Answer With Best Explanation

Answer: II
Explanation: Upload Soon
More Discussion Explanation On YouTube Learn Topic Wise Help-Line

Q104➡ | UGC NET August 2016 Paper-III

Consider the relations R(A, B) and S(B, C) and the following four relational algebra queries over R
and S:
I. ΠA, B (R ⨝ S)
II. R ⨝ ΠB(S)
III. R ∩ (ΠA(R) × ΠB(S))
IV. ΠA, R.B (R × S)
where R⋅B refers to the column B in table R.
One can determine that:

i ➥ I, III and IV are the same query.

ii ➥ II, III and IV are the same query.
iii ➥ I, II and IV are the same query.
iv ➥ I, II and III are the same query.

Show Answer With Best Explanation

Answer: IV
Explanation: Upload Soon
More Discussion Explanation On YouTube Learn Topic Wise Help-Line

Q105➡ | UGC NET August 2016 Paper-III

Which of the following statements is TRUE?
D1 : The decomposition of the schema R(A, B, C) into R1(A, B) and R2 (A, C) is always lossless.
D2 : The decomposition of the schema R(A, B, C, D, E) having AD → B, C → DE, B → AE and AE → C,
into R1 (A, B, D) and R2 (A, C, D, E) is lossless.

i ➥ Both D1 and D2

New Section 6 Page 17

i ➥ Both D1 and D2
ii ➥ Neither D1 nor D2
iii ➥ Only D1
iv ➥ Only D2

Show Answer With Best Explanation

Answer: IV
Explanation: Upload Soon
More Discussion Explanation On YouTube Learn Topic Wise Help-Line

Q106➡ | UGC NET August 2016 Paper-III

Consider the following ORACLE relations :
R (A, B, C) = {<1, 2, 3>, <1, 2, 0>, <1, 3, 1>, <6, 2, 3>, <1, 4, 2>, <3, 1, 4> }
S (B, C, D) = {<2, 3, 7>, <1, 4, 5>, <1, 2, 3>, <2, 3, 4>, <3, 1, 4>}.
Consider the following two SQL queries SQ1 and SQ2 :
SQ1 : SELECT R⋅B, AVG (S⋅B) FROM R, S WHERE R⋅A = S⋅C AND S⋅D < 7 GROUP BY R⋅B;
SQ2 : SELECT DISTINCT S⋅B, MIN (S⋅C) FROM S GROUP BY S⋅B HAVING COUNT (DISTINCT S⋅D) > 1;
If M is the number of tuples returned by SQ1 and N is the number of tuples returned by SQ2 then

i ➥ M = 4, N = 2
ii ➥ M = 5, N = 3
iii ➥ M = 2, N = 2
iv ➥ M = 3, N = 3

Show Answer With Best Explanation

Answer: I
Explanation: Upload Soon
More Discussion Explanation On YouTube Learn Topic Wise Help-Line

Q107➡ UGC NET August 2016 Paper-III

Semi-join strategies are techniques for query processing in distributed database system. Which of
the following is a semi-join technique ?

i ➥ Only the joining attributes are sent from one site to another and then all of the rows are
returned.
ii ➥ All of the attributes are sent from one site to another and then only the required rows are
returned.
iii ➥ Only the joining attributes are sent from one site to another and then only the required rows
are returned.
iv ➥ All of the attributes are sent from one site to another and then only the required rows are
returned.

Show Answer With Best Explanation

Answer: III
Explanation: Upload Soon
More Discussion Explanation On YouTube Learn Topic Wise Help-Line

Q108➡ | UGC NET August 2016 Paper-III

New Section 6 Page 18

Q108➡ | UGC NET August 2016 Paper-III
Which of the following is characteristic of an MIS?

i ➥ Provides guidance in identifying problems, finding and evaluating alternative solutions, and
selecting or comparing alternatives.
ii ➥ Draws on diverse yet predictable data resources to aggregate and summarize data.
iii ➥ High volume, data capture focus.
iv ➥ Has as its goal the efficiency of data movement and processing and interfacing different TPS.

Show Answer With Best Explanation

Answer: II

>

New Section 6 Page 19