July 2016 - Paper 3

1. Home
2. UGC NET Computer Science Solved Papers
3. July 2016
4. Paper 3

6:  

In _____ method, the word is written to the block in both the cache and main memory, in parallel.

A.	Write through
B.	Write back
C.	Write protected
D.	Direct mapping
	Answer Report Discuss
	Option: A Explanation : Click on Discuss to view users comments. Write your comments here: Updating your Comments.. Updating your Comments..

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

A.	Objects in an object-oriented database contain not only data but also methods for processing the data.
B.	Object-oriented databases store computational instructions in the same place as the data.
C.	Object-oriented databases are more adapt at handling structured (analytical) data than relational databases.
D.	Object-oriented databases store more types of data than relational databases and access that data faster.
	Answer Report Discuss
	Option: C Explanation : Click on Discuss to view users comments. Write your comments here: Updating your Comments.. Updating your Comments..

8:  

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 :

A.	Inheritances
B.	Fragments
C.	Locations
D.	Local formats
	Answer Report Discuss
	Option: B Explanation : Click on Discuss to view users comments. Write your comments here: Updating your Comments.. Updating your Comments..

9:  

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 :

A.	I, III and IV are the same query.
B.	II, III and IV are the same query.
C.	I, II and IV are the same query.
D.	I, II and III are the same query.
	Answer Report Discuss
	Option: D Explanation : Click on Discuss to view users comments. Write your comments here: Updating your Comments.. Updating your Comments..

10:  

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.

A.	Both D1 and D2
B.	Neither D1 nor D2
C.	Only D1
D.	Only D2
	Answer Report Discuss
	Option: D Explanation : Click on Discuss to view users comments. Write your comments here: Updating your Comments.. Updating your Comments..

• «
• 1
• 2
• 3
• 4
• 5
• 6
• 7
• 8
• 9
• 10
• 11
• 12
• 13
• 14
• 15
• »