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

» Databases » Relational Model

MCQ▾

Question

A database system provides a ________ to specify the database schema

Choices

Choice (4) Response

a.

data definition language

b.

SQL

c.

Lines

d.

data manipulation language

Question number: 96

» Databases » Database Design

MCQ▾

Question

2PC stands for________

Choices

Choice (4) Response

a.

Phase commission protocol

b.

three-phase commit protocol

c.

two-phase commit protocol

d.

All of the above

Question number: 97

» Databases » Relational Model

MCQ▾

Question

The JDBC standard defines a ________.

Choices

Choice (4) Response

a.

API

b.

ODBC

c.

JSP

d.

None of the above

Question number: 98

» Databases » Relational Model

MCQ▾

Question

The collection of information stored in the database at a particular moment is called an ________ of the database.

Choices

Choice (4) Response

a.

schema

b.

instance

c.

sub schemas

d.

Question does not provide sufficient data or is vague

Question number: 99

» Databases » Database Design

MCQ▾

Question

A ________ sites may use different schemas.

Choices

Choice (4) Response

a.

Transaction

b.

Heterogeneous distributed database

c.

Homogeneous distributed database

d.

None of the above

Question number: 100

» Databases » ER-Model

MCQ▾

Question

Database System Applications are-

Choices

Choice (4) Response

a.

Finance

b.

Banking

c.

Human resources

d.

All a. , b. and c. are correct

Question number: 101

» Databases » Database Design

MCQ▾

Question

Records are stored in sequential order according to the value of a “ search key ” of each record is called________

Choices

Choice (4) Response

a.

Sequential file organization.

b.

Heap file organization.

c.

Hashing file organization.

d.

Clustering File

Sign In