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

Question

MCQ▾

What is referred to as an identifier in the SQL?

Choices

Choice (4)Response

a.

Views

b.

Primary Key

c.

Candidate Key

d.

All a., b. and c. are correct

Question 1516

Question

MCQ▾

We have been given a flow graph which contains 7 nodes, 10 edges and 1 connected component. Then the number of regions and the number of predicate (decision) nodes in the flow graph will be?

Choices

Choice (4)Response

a.

10,9

b.

8,7

c.

5,4

d.

4,3

Question 1517

Question

MCQ▾

Geocast addressing is a special form of which of these?

Choices

Choice (4)Response

a.

Unicast

b.

Anycast

c.

Broadcast

d.

Multicast

Question 1518

Question

MCQ▾

Imagine an “Employee” table, here we have the field “Full name” , which stores the name of the employee as “First-name Middle-name Last-name” .

Then which of these queries will fetch the First name in the “Full Name” column of “Employee” table.

Choices

Choice (4)Response

a.

SELECT SUBSTRING (CHARINDEX (′ ′ , FullName) ) as FullName FROM Employee Details

b.

SELECT SUBSTRING (FullName, CHARINDEX (′ ′ , FullName) ) FROM Employee Details

c.

SELECT SUBSTRING (FullName, 0, CHARINDEX (′ ′ , FullName) ) FROM Employee Details

d.

SELECT SUBSTRING (FullName, 0, CHARINDEX (′ ′ ) ) FROM Employee Details

Developed by: