GATE (Graduate Aptitude Test in Engineering) Computer Science: Questions 123 - 127 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 123

Question

MCQ▾

The output of the following queries are

SELECT e. empno, e. ename, d. dept_name FROM emp e, dept d USING (dept_id) ;

SELECT e. empno, e. ename, d. dept_name FROM emp e JOIN dept d ON (e. dept_id = d. dept_id)

Choices

Choice (4)Response

a.

dissimilar

b.

similar

c.

USING and ON cannot be used in SQL queries

d.

All of the above

Question 124

Question

MCQ▾

The following command is issued to make permanent the changes that have been done to the database using DML commands.

Choices

Choice (4)Response

a.

COMMIT

b.

ROLLBACK

c.

GRANT

d.

None of the above

Question 125

Question

MCQ▾

Which of the following access lists will allow only HTTP traffic into network 196.15. 7.0?

Choices

Choice (4)Response

a.

access-list 100 permit tcp any 196.15. 7.0 0.0. 0.255 eq www

b.

access-list 10 deny tcp any 196.15. 7.0 eq www

c.

access-list 100 permit 196.15. 7.0 0.0. 0.255 eq www

d.

access-list 110 permit ip any 196.15. 7.0 0.0. 0.255

Question 126

Question

MCQ▾

A system program that combines the separately compiled modules of a program into a form suitable for execution?

Choices

Choice (4)Response

a.

cross compiler

b.

linking loader

c.

assembler

d.

load and go

Question 127

Question

MCQ▾

Overloaded functions are required to

Choices

Choice (4)Response

a.

perform the same basic functions

b.

have the same number of parameters

c.

have the same return type

d.

None of the above

Developed by: