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

» Databases » Relational Model

MCQ▾

Question

________ A combination of date and time

Choices

Choice (4) Response

a.

int

b.

time

c.

timestamp

d.

var

Question number: 138

» Databases » Database Design

MCQ▾

Question

The logical model of the database is the correct level for database user to focus on.

For example- at the conceptual or logical level it viewed the database in the relational model, as a collection of tables.

Choices

Choice (4) Response

a.

memory

b.

main memory

c.

cache

d.

Flash memory

Question number: 139

» Databases » Relational Model

MCQ▾

Question

________ ensures that a value that appears in one relation for a given set of attributes.

Choices

Choice (4) Response

a.

Integrity constraints

b.

Referential Integrity

c.

Domain

d.

Domain constraints

Question number: 140

» Databases » Database Design

MCQ▾

Question

________ is an index record appears for every search-key value in the file.

Choices

Choice (4) Response

a.

Sparse index

b.

Hashing file organization

c.

Clustering File Organization

d.

Dense index

Question number: 141

» Databases » Relational Model

MCQ▾

Question

DDL stand for

Choices

Choice (4) Response

a.

Data dictionary language

b.

Data dictio language

c.

data definition language

d.

All of the above

Question number: 142

» Databases » Database Design

MCQ▾

Question

In RDBMS, what is the efficient data structure used in the internal storage representation?

Choices

Choice (4) Response

a.

B + tree

b.

Heap tree

c.

B tree

d.

All of the above

Question number: 143

» Databases » Relational Model

MCQ▾

Question

What command used for delete a particular row

Choices

Choice (4) Response

a.

Truncate

b.

delete

c.

Drop

d.

Question does not provide sufficient data or is vague

Sign In