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

» Databases » Relational Model

MCQ▾

Question

To remove a relation from an SQL database which command?

Choices

Choice (4) Response
a.

after table

b.

delete table

c.

alter table

d.

drop table

Question number: 50

» Databases » Database Design

MCQ▾

Question

________ refers to reducing the time required to retrieve relations from disk by partitioning the relations on multiple disks

Choices

Choice (4) Response
a.

I/O parallelism

b.

transaction

c.

parallelism

d. None of the above

Question number: 51

» Databases » Relational Model

MCQ▾

Question

________ are sophisticated users who write specialized database applications that do not fit into the traditional data-processing framework.

Choices

Choice (4) Response
a.

Sophisticated users

b.

Specialized users

c.

Naive users

d. None of the above

Question number: 52

» Databases » ER-Model

MCQ▾

Question

What are different properties of data base over the file processing system-?

Choices

Choice (4) Response
a.

Entity set

b.

Atomicity problems

c.

Concurrent-access anomalies

d. None of the above

Question number: 53

» Databases » Query Languages

MCQ▾

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

» Databases » Relational Model

MCQ▾

Question

Few people use a ________to directly interacts with a database system.

Choices

Choice (4) Response
a.

c language

b.

query language

c.

data

d. All of the above

Question number: 55

» Databases » Relational Model

MCQ▾

Question

The overall design of the database is called the database ________.

Choices

Choice (4) Response
a.

sub schemas

b.

instance

c.

schema

d. All of the above

Sign In