Databases-Query Languages [GATE (Graduate Aptitude Test in Engineering) Computer Science]: Questions 1 - 6 of 47

Access detailed explanations (illustrated with images and videos) to 2122 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 1

Query Languages

Question

MCQ▾

TRUNCATE statement in SQL is a ________.

Choices

Choice (4)Response

a.

DCL statement

b.

DDL statement

c.

DML Statement

d.

Question does not provide sufficient data or is vague

Question 2

Query Languages

Question

MCQ▾

Duplicate rows are eliminated using

Choices

Choice (4)Response

a.

DISTINCT

b.

GRANT

c.

NODUPLICATE

d.

None of the above

Question 3

Query Languages

Question

MCQ▾

This type of key is used to link rows from one table to the rows in another table.

Choices

Choice (4)Response

a.

Foreign key

b.

Encryption key

c.

Primary key

d.

All of the above

Question 4

Query Languages

Question

MCQ▾

Which memory card format is most widely used?

Choices

Choice (4)Response

a.

Smart media

b.

Compact Flash (CF)

c.

Memory Stick

d.

Secure Digital (SD)

Question 5

Query Languages

Question

MCQ▾

A query is as follows

SELECT DISTINCT LOC_NAME FROM DEPT WHERE DEPT_ID IN (10,20, 30) ;

In the above example, departments 10,20 and 30 are in the city Chicago where as that of 40,50 and 60 are in St. Louis. How many values of LOC_NAME are returned?

Choices

Choice (4)Response

a.

One value of St. Louis

b.

One value of Chicago

c.

Three values of St. Louis

d.

Three values of Chicago

Question 6

Query Languages

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: