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

» Databases » Database Design

MCQ▾

Question

A subschema expresses is a ________.

Choices

Choice (4) Response

a.

The physical view

b.

The logical view

c.

The external view

d.

All of the above

Question number: 2

» Databases » Database Design

MCQ▾

Question

Conceptual design is a ________

Choices

Choice (4) Response

a.

Needs data volume and processing frequencies to determine the size of the database

b.

Involves modeling independent of the DBMS

c.

Is designing the relational model

d.

Question does not provide sufficient data or is vague

Question number: 3

» Databases » Database Design

MCQ▾

Question

Which is proper subset designed to support ‘views’ belonging to different classes of users in order to hid or protect information:

Choices

Choice (4) Response

a.

Non-schema

b.

Subschema

c.

Schema

d.

All of the above

Question number: 4

» Databases » Database Design

MCQ▾

Question

ODBC stands for ________.

Choices

Choice (4) Response

a.

Object Data Base Connectivity

b.

Open Data Base Connectivity

c.

Oracle Data Base Connectivity

d.

Oral Data Base Connectivity

Question number: 5

» Databases » Relational Model

MCQ▾

Question

Candidate key has only one ________in a table but there can be multiple candidates key.

Choices

Choice (4) Response

a.

Primary Key

b.

Alternative Key

c.

Candidate Key

d.

None of the above

Question number: 6

» Databases » Database Design

MCQ▾

Question

TRUNCATE statement in SQL is a ________.

Choices

Choice (4) Response

a.

DDL statement

b.

DCL statement

c.

DML Statement

d.

All of the above

Question number: 7

» Databases » Database Design

MCQ▾

Question

Architecture of the database can be viewed as ________.

Choices

Choice (4) Response

a.

five level

b.

one level

c.

three levels

d.

two levels

Sign In