Databases-Database Design (GATE Computer Science): Questions 8 - 13 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: 8

» Databases » Database Design

MCQ▾

Question

Which mapping exists between the external and conceptual levels?

Choices

Choice (4) Response
a.

Conceptual

b.

Other

c.

Internal

d. Both a. and c. are correct

Question number: 9

» Databases » Database Design

MCQ▾

Question

Why are I/O costs important in a DBMS?

Choices

Choice (4) Response
a. Both c. and d. are correct
b.

increase in time

c.

increase in memory

d.

increase in speed

Question number: 10

» Databases » Database Design

MCQ▾

Question

AN automatic commit occurs under the following circumstances

Choices

Choice (4) Response
a.

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

b.

When a DCL statement is issue

c.

When a DDL statement is issued

d. All a. , b. and c. are correct

Question number: 11

» Databases » Database Design

MCQ▾

Question

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.

similar

b.

USING and ON cannot be used in SQL queries

c.

dissimilar

d. Question does not provide sufficient data or is vague

Question number: 12

» Databases » Database Design

MCQ▾

Question

The following command is issued to make permanent the changes that have been done to the database using DML commands.

Choices

Choice (4) Response
a.

ROLLBACK

b.

GRANT

c.

COMMIT

d. All of the above

Question number: 13

» Databases » Database Design

MCQ▾

Question

The DDL part of SQL is

Choices

Choice (4) Response
a.

count

b.

update

c.

delete

d.

insert

Sign In