GATE Computer Science: Questions 579 - 584 of 913

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

» 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: 580

» 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: 581

» 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: 582

» 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

Question number: 583

» Databases » Relational Model

MCQ▾

Question

QBE stands for ________

Choices

Choice (4) Response

a.

question-by-element

b.

Query-by-Example

c.

Query-Example

d.

Question does not provide sufficient data or is vague

Question number: 584

» Databases » Database Design

MCQ▾

Question

A domain is atomic if elements of the domain are considered to be indivisible units and relation schema R is in ________ if the domains of all attributes of R are atomic.

Choices

Choice (4) Response

a.

first normal form

b.

second normal form

c.

third normal form

d.

Question does not provide sufficient data or is vague

Sign In