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

» Databases » Query Languages

MCQ▾

Question

________ consists of a collection of interrelated data and a collection of programs to access that data.

Choices

Choice (4) Response
a.

administration

b.

DBMS

c.

DB

d. All of the above

Question number: 76

» Databases » Relational Model

MCQ▾

Question

________users interact with the system without writing programs.

Choices

Choice (4) Response
a.

Specialized users

b.

Naive users

c.

Sophisticated users

d.

user

Question number: 77

» Databases » Query Languages

MCQ▾

Question

How many steps involved in processing a query ________

Choices

Choice (4) Response
a.

1

b.

3

c.

4

d.

2

Question number: 78

» Databases » Database Design

MCQ▾

Question

The ________ is another approach to handling replication.

Choices

Choice (4) Response
a.

protocol

b.

biased protocol

c.

Http protocol

d. None of the above

Question number: 79

» Databases » ER-Model

MCQ▾

Question

________ a key constraint that indicates that many of one entity can be associated with many of another entity.

Choices

Choice (4) Response
a.

Many-to-many relationship

b.

Relationship

c.

Entity set

d.

One-to-many relationship

Question number: 80

» Databases » Relational Model

MCQ▾

Question

The ________operation is an extension of the join operation to deal with missing information.

Choices

Choice (4) Response
a.

inner-join

b.

right-join

c.

left-join

d.

outer-join

Question number: 81

» Databases » Database Design

MCQ▾

Question

________ different queries or transactions execute in parallel with one another.

Choices

Choice (4) Response
a.

Intraquery parallelism

b.

Range-partitioning

c.

Parallel external

d.

Interquery parallelism

Sign In