UGC NET CS 2015 Jun - III

Question 1

For the 8 - bit word 00111001, the check bits stored with it would be 0111. Suppose when the word is read from memory, the check bits are calculated to be 1101. What is the data word that was read from memory?

• 10011001
• 00011001
• 00111000
• 11000110

Question 2

Consider a 32 - bit microprocessor, with a 16 - bit external data bus, driven by an 8 MHz input clock. Assume that this microprocessor has a bus cycle whose minimum duration equals four input clock cycles. What is the maximum data transfer rate for this microprocessor?

• 8 x 10⁶ bytes/sec

• 4 x 10⁶ bytes/sec

• 16 x 10⁶ bytes/sec

• 4 x 10⁹ bytes/sec

Question 3

The RST 7 instruction in 8085 microprocessor is equivalent to:

• CALL 0010 H
• CALL 0034 H
• CALL 0038 H
• CALL 003C H

Question 4

The equivalent hexadecimal notation for octal number 2550276 is:

• FADED
• AEOBE
• ADOBE
• ACABE

Question 5

The CPU of a system having 1 MIPS execution rate needs 4 machine cycles on an average for executing an instruction. The fifty percent of the cycles use memory bus. A memory read/ write employs one machine cycle. For execution of the programs, the system utilizes 90 percent of the CPU time. For block data transfer, an IO device is attached to the system while CPU executes the background programs continuously. What is the maximum IO data transfer rate if programmed IO data transfer technique is used?

• 500 Kbytes/sec
• 2.2 Mbytes/sec
• 125 Kbytes/sec
• 250 Kbytes/sec

Question 6

The number of flip-flops required to design a modulo - 272 counter is:

• 8

• 9

• 27

• 11

Question 7

Let E₁ and E₂ be two entities in E-R diagram with simple single valued attributes. R₁ and R₂ are two relationships between E₁ and E₂ where R₁ is one - many and R₂ is many - many. R₁ and R₂ do not have any attribute of their own. How many minimum number of tables are required to represent this situation in the Relational Model?

• 4
• 3
• 2
• 1

Question 8

The STUDENT information in a university stored in the relation STUDENT (Name, SEX, Marks, DEPT_Name) Consider the following SQL Query SELECT DEPT_Name from STUDENT where SEX = \'M\' group by DEPT_Name having avg (Marks)>SELECT avg (Marks) from STUDENT. It Returns the Name of the Department for which:

• The Average marks of Male students is more than the average marks of students in the same Department
• The average marks of male students is more than the average marks of students in the University
• The average marks of male students is more than the average marks of male students in the University
• The average marks of students is more than the average marks of male students in the University

Question 9

Select the \'False\' statement from the following statements about Normal Forms:

• Lossless preserving decomposition into 3NF is always possible
• Lossless preserving decomposition into BCNF is always possible
• Any Relation with two attributes is in BCNF
• BCNF is stronger than 3NF

Question 10

In the indexed scheme of blocks to a file, the maximum possible size of the file depends on:

• The number of blocks used for index and the size of index
• Size of Blocks and size of Address
• Size of index
• Size of Block