Databases-Query Languages (GATE (Graduate Aptitude Test in Engineering) 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
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
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
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
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
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
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
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
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 |
|