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

Access detailed explanations (illustrated with images and videos) to 2290 questions. Access all new questions- tracking exam pattern and syllabus. View the complete topic-wise distribution of questions. 3 Year Validity- Access Unlimited Times on Unlimited Devices.

View Sample Explanation or View Features.

Rs. 600.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

Edit

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

Edit

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

Edit

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

Edit

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

Edit

Question 6

Question MCQ▾

Duplicate rows are eliminated using

Choices

Choice (4)Response

a.

DISTINCT

b.

GRANT

c.

NODUPLICATE

d.

None of the above

Edit