PREVIOUS YEAR SOLVED PAPERS - December 2015 Paper 3

Avatto > > UGC NET COMPUTER SCIENCE > > PREVIOUS YEAR SOLVED PAPERS > > December 2015 Paper 3

56. In Unix, the command to enable execution permission for file “mylife” by all is ____________.

  • Option : D
  • Explanation :
    In Unix, the command to enable execution permission for file “mylife” by all are: Chmod + X myfile Chmod a + X myfile Chmod ugo + X myfile So, option (D) is correct.
Cancel reply

Your email address will not be published. Required fields are marked *


Cancel reply

Your email address will not be published. Required fields are marked *


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

  • Option : A
  • Explanation :
    $rm chap0\[1 - 3\] Square bracket surround a choice for single character and hyphen(-) will separate the range of single character. Above command will remove chap 01 or chap 02 or chap 03 file. So, option (A) is correct.
Cancel reply

Your email address will not be published. Required fields are marked *


Cancel reply

Your email address will not be published. Required fields are marked *


58. 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 behavior.
Codes:

  • Option : A
  • Explanation :
    Features of the object-oriented approach to databases: The ability to develop more realistic models of the real world. The ability to represent the world in a non-geometric way. The ability to develop databases using natural language approaches. So, option (A) is correct.
Cancel reply

Your email address will not be published. Required fields are marked *


Cancel reply

Your email address will not be published. Required fields are marked *


59. 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?

  • Option : A
  • Explanation :
    check(one≥1 and ≤10),check(two≥1 and ≤5).
    Here second constraint will decide the no of tuples(record). Or we can say that the common condition will dominate.
    i.e. check(two ≥ 1 and ≤ 5) 5 tuples.
    So, option (A) is correct.
Cancel reply

Your email address will not be published. Required fields are marked *


Cancel reply

Your email address will not be published. Required fields are marked *


60. 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 SQ1 and SQ2 :
SQ1 : Select * From R Full Join S On R.B = S.B;
SQ2 : Select * From R Inner Join S On R.B = S.B;
The numbers of tuples in the result of the SQL query SQ1 and the SQL query SQ2 are given by:

  • Option : D
  • Explanation :
    Full join will give two match for B = 2 and B = 4. and two mismatch So it will give 4 output. Inner join will give output for only matching condition. B = 2 and B = 4. Two output from inner join. So, option (D) is correct.
Cancel reply

Your email address will not be published. Required fields are marked *


Cancel reply

Your email address will not be published. Required fields are marked *


Related Quiz.
December 2015 Paper 3