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

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

Database Design

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

Database Design

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

Database Design

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

Database Design

Question

MCQ▾

Why are I/O costs important in a DBMS?

Choices

Choice (4)Response

a.

increase in time

b.

increase in memory

c.

memory

d.

increase in speed

Question 5

Database Design

Question

MCQ▾

AN automatic commit occurs under the following circumstances

Choices

Choice (4)Response

a.

When a DDL statement is issued

b.

When a DCL statement is issue

c.

Normal exit from SQL ⚹ Plus, with out any data being written into it or rolling back the transaction

d.

All a., b. and c. are correct

Question 6

Database Design

Question

MCQ▾

The output of the following queries are

SELECT e. empno, e. ename, d. dept_name FROM emp e, dept d USING (dept_id) ;

SELECT e. empno, e. ename, d. dept_name FROM emp e JOIN dept d ON (e. dept_id = d. dept_id)

Choices

Choice (4)Response

a.

dissimilar

b.

similar

c.

USING and ON cannot be used in SQL queries

d.

All of the above

Developed by: