UGC NET CS 2015 Dec – III

Question 51

The character set used in Windows 2000 operating system is __________

• 8 bit ASCII
• Extended ASCII
• 16 bit UNICODE
• 12 bit UNICODE

Question 52

What will be the output of the following Unix command ? $rm chap0\\[1 - 3\\]

• Remove file chap0[1 - 3]
• Remove file chap01, chap02, chap03
• Remove file chap\\[1 - 3\\]
• None of the above

Question 53

Which of the following statements regarding the features of the object-oriented approach to databases are true? (a)The ability to develop more realistic models of the real world. (b)The ability to represent the world in a non-geometric way. (c)The ability to develop databases using natural language approaches. (d)The need to split objects into their component parts. (e)The ability to develop database models based on location rather than state and behaviour. Codes:

• (a), (b) and (c)
• (b), (c) and (d)
• (a), (d) and (e)
• (c), (d) and (e)

Question 54

Consider the following database table: Create table test( one integer, two integer, primary key(one), unique(two), check(one >= 1 and <= 10), check(two >= 1 and <= 5) ); How many data records/tuples atmost can this table containt?

• 5
• 10
• 15
• 50

Question 55

Suppose ORACLE relation R(A, B) currently has tuples {(1, 2), (1, 3), (3, 4)} and relation S(B, C) currently has {(2, 5), (4, 6), (7, 8)}. Consider the following two SQL queries SQ₁ and SQ₂ : SQ₁ : Select * From R Full Join S On R.B = S.B; SQ₂ : Select * From R Inner Join S On R.B = S.B; The numbers of tuples in the result of the SQL query SQ₁ and the SQL query SQ₂ are given by:

• 2 and 6 respectively
• 6 and 2 respectively
• 2 and 4 respectively
• 4 and 2 respectively

Question 56

Consider the following three SQL queries (Assume the data in the people table): (a)Select Name from people where Age > 21; (b)Select Name from people where Height > 180; (c)Select Name from people where (Age > 21) or (Height > 180); If the SQL queries (a) and (b) above, return 10 rows and 7 rows in the result set respectively, then what is one possible number of rows returned by the SQL query (c) ?

• 3
• 7
• 10
• 21

Question 57

The distributed system is a collection of (P)and communication is achieved in distributed system by(Q), where (P) and (Q) are:

• Loosely coupled hardware on tightly coupled software and disk sharing, respectively.
• Tightly coupled hardware on loosely coupled software and shared memory, respectively
• Tightly coupled software on loosely coupled hardware and message passing, respectively
• Loosely coupled software on tightly coupled hardware and file sharing, respectively.

Question 58

Consider the following three tables R, S and T. In this question, all the join operations are natural joins (⨝). (π) is the projection operation of a relation: (a) (b) (c) (d)

• (a)
• (b)
• (c)
• (d)

Question 59

Consider the two class classification task that consists of the following points: Class C₁ : [21, 21], [21, 1], [1, 21] Class C₂ : [1, 1] The decision boundary between the two classes C₁ and C₂ using single perceptron is given by:

• x₁ - x₂ - 0.5 = 0
• - x₁ + x₂ - 0.5 = 0
• 0.5(x₁ + x₂) - 1.5 = 0
• x₁ + x₂ - 0.5 = 0

Question 60

Consider a standard additive model consisting of rules of the form of If x is A_i AND y is B_i THEN z is C_i. Given crisp inputs x = x₀, y = y₀, the output of the model is:

• 
• 
• 
•