Databases-Database Design (GATE Computer Science): Questions 69 - 72 of 72

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

» 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: 70

» 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: 71

» 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: 72

» Databases » Database Design

MCQ▾

Question

The “DBMS” acts as an interface between what two components of an enterprise-class database system?

Choices

Choice (4) Response

a.

Data and Database

b.

Database application and the database

c.

The user and database application

d.

Database application and SQL

Sign In