Computer Science Engineering (CSE) MCQ

Computer Science Engineering

41- Minimal super key is:

(A) primary key

(B) partial key

(C) candidate key

(D) super key

 

42- Which statement is not correct about “init” process in Unix?

(A) It is generally the parent of the login shell.

(B) It has PID 1.

(C) It is the first process in the system.

(D) Init forks and execs a ‘getty’ process at every port connected to a terminal

 

43- In SQL, which command is used to remove rows from a table:

(A) TRUNCATE

(B) DELETE

(C) REMOVE

(D) Both (A) and (B)

 

44- A thread:

(A) is a light weight process where the context switching is low.

(B) is a light weight process where the context switching is high.

(C) is used to speed up paging

(D) none of the above

 

45- Cascading rollback can be avoided by:

(A) two phase locking protocol

(B) strict two phase locking protocol

(C) cannot be avoided

(D) can be avoided but there is no actual protocol

 

46- Recursive function are executed in a

(A) last in first out order

(B) first in first out order

(C) parallel fashion

(D) all of these

 

47- In RDBMS which data structure is used in internal storage representation?

(A) B+ tree

(B) B tree

(C) Linked list

(D) Hash table

 

48- A web page is located using a

(A) universal record linking

(B) uniform resource locator

(C) universal record locator

(D) uniformly reachable links

 

49- Which of the following allow the use of entire bandwidth simultaneously?

(A) TDMA

(B) FDMA

(C) CDMA

(D) None of the above

 

50- Constructor should be defined in ______section of a class

(A) public

(B) private

(C) protected

(D) anywhere in the class

 

ANSWERS:

41-(C), 42-(C), 43-(D), 44-(B), 45-(B), 46-(A), 47-(A), 48-(B), 49-(C), 50-(A)