Databases-Query Languages (GATE Computer Science): Questions 6 - 13 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: 6

» Databases » Query Languages

MCQ▾

Question

“Zipping” a fie means-

Choices

Choice (4) Response

a.

Transfer the message

b.

Encrypting the message

c.

Compressing the file

d.

All of the above

Question number: 7

» Databases » Query Languages

MCQ▾

Question

OLAP stands for

Choices

Choice (4) Response

a.

One analytical processing

b.

Online analytical process

c.

Online analytical processing

d.

All of the above

Question number: 8

» Databases » Query Languages

MCQ▾

Question

DML stands for

Choices

Choice (4) Response

a.

Date Manipulation Language

b.

Data Manuscript Language

c.

Database Manipulation Language

d.

None of the above

Question number: 9

» Databases » Query Languages

MCQ▾

Question

________ consists of a collection of interrelated data and a collection of programs to access that data.

Choices

Choice (4) Response

a.

administration

b.

DBMS

c.

DB

d.

All of the above

Question number: 10

» Databases » Query Languages

MCQ▾

Question

How many steps involved in processing a query ________

Choices

Choice (4) Response

a.

1

b.

3

c.

4

d.

2

Question number: 11

» Databases » Query Languages

MCQ▾

Question

An ________ is a log of all changes (inserts/deletes/updates) to the database along with information.

Choices

Choice (4) Response

a.

transformation

b.

transaction

c.

audit trail

d.

transfer

Question number: 12

» Databases » Query Languages

MCQ▾

Question

A ________ consists of a sequence of query and/or update statements.

Choices

Choice (4) Response

a.

transformation

b.

transaction

c.

transfer

d.

Question does not provide sufficient data or is vague

Question number: 13

» Databases » Query Languages

MCQ▾

Question

Any record can be placed anywhere in the file where there is space for the record is called as________

Choices

Choice (4) Response

a.

Heap file organization

b.

Clustering File Organization

c.

Sequential file organization

d.

Hashing file organization

Sign In