Databases [GATE (Graduate Aptitude Test in Engineering) Computer Science]: Questions 1 - 6 of 241

Access detailed explanations (illustrated with images and videos) to 2122 questions. Access all new questions- tracking exam pattern and syllabus. View the complete topic-wise distribution of questions. Unlimited Access, Unlimited Time, on Unlimited Devices!

View Sample Explanation or View Features.

Rs. 550.00 -OR-

How to register? Already Subscribed?

Question 1

Question

MCQ▾

A subschema expresses is a ________.

Choices

Choice (4)Response

a.

The external view

b.

The logical view

c.

The physical view

d.

None of the above

Question 2

Question

MCQ▾

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.

All of the above

Question 3

Question

MCQ▾

ODBC stands for ________.

Choices

Choice (4)Response

a.

Oracle Data Base Connectivity

b.

Open Data Base Connectivity

c.

Object Data Base Connectivity

d.

Oral Data Base Connectivity

Question 4

Question

MCQ▾

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

Choices

Choice (4)Response

a.

Primary Key

b.

Alternative Key

c.

Candidate Key

d.

Question does not provide sufficient data or is vague

Question 5

Question

MCQ▾

TRUNCATE statement in SQL is a ________.

Choices

Choice (4)Response

a.

DCL statement

b.

DDL statement

c.

DML Statement

d.

Question does not provide sufficient data or is vague

Question 6

Question

MCQ▾

Duplicate rows are eliminated using

Choices

Choice (4)Response

a.

DISTINCT

b.

GRANT

c.

NODUPLICATE

d.

None of the above

Developed by: