GATE (Graduate Aptitude Test in Engineering) Computer Science: Questions 323 - 327 of 2080

Access detailed explanations (illustrated with images and videos) to 2080 questions. Access all new questions- tracking exam pattern and syllabus. View the complete topic-wise distribution of questions. Unlimited Access, Unlimited Time, on Unlimited Devices!

View Sample Explanation or View Features.

Rs. 550.00 -OR-

How to register? Already Subscribed?

Question 323

Appeared in Year: 2015 (UGC-NET)

Question

MCQ▾

The hash function used in double hashing is of the form: (December)

Choices

Choice (4)Response

a.

b.

c.

d.

Question 324

Appeared in Year: 2015 (UGC-NET)

Question

MCQ▾

A system has four processes and five allocatable resources. The current allocation and maximum needs are as follows:

Current Allocation and Maximum Needs Are Given
AllocatedMaximumAvailable
Process A1 0 2 1 11 1 2 1 3
Process B2 0 1 1 02 2 2 1 0
Process C1 1 0 1 02 1 3 1 0
Process D1 1 1 1 01 1 2 2 1

The smallest value of x for which the above system in safe state is … (December)

Choices

Choice (4)Response

a.

3

b.

1

c.

2

d.

0

Question 325

Appeared in Year: 2015 (UGC-NET)

Question

MCQ▾

Data which improves the performance and accessibility of the database are called: (December)

Choices

Choice (4)Response

a.

User Data

b.

Application Metadata

c.

Data Dictionary

d.

Indexes

Question 326

Appeared in Year: 2015 (UGC-NET)

Question

MCQ▾

Which of the following is not a congestion policy at network layer? (December)

Choices

Choice (4)Response

a.

Routing Algorithm

b.

Flow Control Policy

c.

Packet Lifetime Management Policy

d.

Packet Discard Policy

Question 327

Appeared in Year: 2015 (UGC-NET)

Question

MCQ▾

Consider a “CUSTOMERS” database table having a column “CITY” filled with all the names of Indian cities (in capital letters) . The SQL statement that finds all cities that have “GAR” somewhere in its name, is: (December)

Choices

Choice (4)Response

a.

Select ⚹ from customers where city as ‘% GAR’ ;

b.

Select ⚹ from customers where city = ‘% GAR %’ ;

c.

Select ⚹ from customers where city = ‘$ GAR $’ ;

d.

Select ⚹ from customers where city like ‘% GAR %’ ;

Developed by: