Databases (GATE Computer Science): Questions 34 - 41 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: 34

» Databases » Database Design

MCQ▾

Question

Which command classes text file, which has been created using “SET ALTERNA TIVE” “Command”?

Choices

Choice (4) Response

a.

DATABASE

b.

SET ALTERNATE OFF

c.

CLOSE DATABASE

d.

CLEAR ALL

Question number: 35

» Databases » Database Design

MCQ▾

Question

Database functionality can be broadly divided into how many parts

Choices

Choice (4) Response

a.

Three

b.

Two

c.

Five

d.

All of the above

Question number: 36

» Databases » Database Design

MCQ▾

Question

An update log record describes a ________ write.

Choices

Choice (4) Response

a.

triple database

b.

Single database

c.

double database

d.

Both a. and c. are correct

Question number: 37

» Databases » Relational Model

MCQ▾

Question

INSERT SQL command used for-

Choices

Choice (4) Response

a.

drop a row

b.

add a row

c.

add a column

d.

None of the above

Question number: 38

» Databases » Relational Model

MCQ▾

Question

________to add attributes to an existing relation.

Choices

Choice (4) Response

a.

delete table command

b.

alter table command

c.

drop table command

d.

All of the above

Question number: 39

» Databases » Relational Model

MCQ▾

Question

A major purpose of a database system is to provide users with an ________of the data.

Choices

Choice (4) Response

a.

relation

b.

abstract view

c.

Entity set

d.

All of the above

Question number: 40

» Databases » Database Design

MCQ▾

Question

________ can be broadly categorized as transaction servers and data servers.

Choices

Choice (4) Response

a.

Client system

b.

Centralized System

c.

Server System

d.

All of the above

Question number: 41

» Databases » Database Design

MCQ▾

Question

A ________ is a repository (or archive) of information gathered from multiple sources stored under a unified schema at a single site.

Choices

Choice (4) Response

a.

data warehouse

b.

function

c.

data

d.

None of the above

Sign In