Databases-Database Design (GATE (Graduate Aptitude Test in Engineering) Computer Science): Questions 48 - 53 of 72
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: 48
» Databases » Database Design
Question
CAD stands for________
Choices
| Choice (4) | Response | |
|---|---|---|
| a. | Computer-aided-diagram |
|
| b. | Computer-aided-design |
|
| c. | Computer-add-design |
|
| d. | Question does not provide sufficient data or is vague |
|
Question number: 49
» Databases » Database Design
Question
The ________allows database modifications to be output to the database while the transaction is still in the active state.
Choices
| Choice (4) | Response | |
|---|---|---|
| a. | immediate-modification technique |
|
| b. | deferred-modification technique |
|
| c. | immediate technique |
|
| d. | None of the above |
|
Question number: 50
» Databases » Database Design
Question
2PC stands for________
Choices
| Choice (4) | Response | |
|---|---|---|
| a. | Phase commission protocol |
|
| b. | three-phase commit protocol |
|
| c. | two-phase commit protocol |
|
| d. | All of the above |
|
Question number: 51
» Databases » Database Design
Question
A ________ sites may use different schemas.
Choices
| Choice (4) | Response | |
|---|---|---|
| a. | Transaction |
|
| b. | Heterogeneous distributed database |
|
| c. | Homogeneous distributed database |
|
| d. | None of the above |
|
Question number: 52
» Databases » Database Design
Question
Records are stored in sequential order according to the value of a ” search key ” of each record is called________
Choices
| Choice (4) | Response | |
|---|---|---|
| a. | Sequential file organization. |
|
| b. | Heap file organization. |
|
| c. | Hashing file organization. |
|
| d. | Clustering File |
|
Question number: 53
» Databases » Database Design
Question
The ________ is the rate at which data can be retrieved from or stored to the disk.
Choices
| Choice (4) | Response | |
|---|---|---|
| a. | Rotational latency time |
|
| b. | Average seek time |
|
| c. | Access time |
|
| d. | data-transfer rate |
|