Databases-Query Languages (GATE Computer Science): Questions 1 - 5 of 19

Get 1 year subscription: Access detailed explanations (illustrated with images and videos) to 913 questions. Access all new questions we will add tracking exam-pattern and syllabus changes. View Sample Explanation or View Features.

Rs. 450.00 or

Question number: 1

» Databases » Query Languages

MCQ▾

Question

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.

None of the above

Question number: 2

» Databases » Query Languages

MCQ▾

Question

Which memory card format is most widely used?

Choices

Choice (4) Response

a.

Smart media

b.

Compact Flash (CF)

c.

Secure Digital (SD)

d.

Memory Stick

Question number: 3

» Databases » Query Languages

MCQ▾

Question

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.

Three values of St. Louis

c.

Three values of Chicago

d.

One value of Chicago

Question number: 4

» Databases » Query Languages

MCQ▾

Question

The Secure Electronic Transaction (SET) specification:

Choices

Choice (4) Response

a.

uses a public key encryption to secure credit-card transaction systems

b.

provides private key encryption of all data that passes between a client and a server

c.

is a notice, issued and verified by a certificate authority, that guarantees a user or Website is legitimate < /VALUE

d.

allows users to choose an encryption scheme for the data that passes between a client and a server

Question number: 5

» Databases » Query Languages

MCQ▾

Question

The … component is used by the data analyst to create the queries that access the database. < / question-text

Choices

Choice (4) Response

a.

Data extraction

b.

End-user query tool

c.

Data store

d.

End-user presentation tool

Sign In