Databases (GATE Computer Science): Questions 63 - 68 of 154

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: 63

» Databases » Relational Model

MCQ▾

Question

if introduce another class of storage that is called ________

Choices

Choice (4) Response
a.

transaction

b.

storage class

c.

stable storage

d. None of the above

Question number: 64

» Databases » Database Design

MCQ▾

Question

Consider a relation r that is to be stored in the database. hwo many approaches to storing this relation in the distributed database?

Choices

Choice (4) Response
a.

Four

b.

Six

c.

Two

d.

Three

Question number: 65

» Databases » Database Design

MCQ▾

Question

The user of a distributed database system should not be required to know either where the data are physically located or how the data can be accessed at the specific local site and this property is called-

Choices

Choice (4) Response
a.

data transparency

b.

transaction

c.

transfer

d. Question does not provide sufficient data or is vague

Question number: 66

» Databases » Database Design

MCQ▾

Question

The state of the art in recovery methods is best illustrated by the ________

Choices

Choice (4) Response
a.

log based recovery

b.

ARIES recovery method

c.

transaction based recovery

d. All of the above

Question number: 67

» Databases » Relational Model

MCQ▾

Question

________are described in a database by a set of attributes.

Choices

Choice (4) Response
a.

a table

b.

relation

c.

Entities

d. All of the above

Question number: 68

» Databases » Relational Model

MCQ▾

Question

Creates a new table is used for SQL command-

Choices

Choice (4) Response
a.

CREATE DATABASE

b.

ALTER DATABASE

c.

CREATE TABLE

d. Question does not provide sufficient data or is vague

Sign In