Databases (GATE (Graduate Aptitude Test in Engineering) Computer Science): Questions 8 - 14 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: 8

» Databases » Database Design

MCQ▾

Question

Duplicate rows are eliminated using

Choices

Choice (4) Response

a.

GRANT

b.

NODUPLICATE

c.

DISTINCT

d.

Question does not provide sufficient data or is vague

Question number: 9

» 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: 10

» Databases » Query Languages

MCQ▾

Question

This type of key is used to link rows from one table to the rows in another table.

Choices

Choice (4) Response

a.

Foreign key

b.

Encryption key

c.

Primary key

d.

None of the above

Question number: 11

» Databases » Database Design

MCQ▾

Question

Why are I/O costs important in a DBMS?

Choices

Choice (4) Response

a.

memory

b.

increase in time

c.

increase in speed

d.

Both b. and c. are correct

Question number: 12

» Databases » Query Languages

MCQ▾

Question

Which memory card format is most widely used?

Choices

Choice (4) Response

a.

Smart media

b.

Compact Flash (CF)

c.

Secure Digital (SD)

d.

Memory Stick

Question number: 13

» 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: 14

» 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

f Page
Sign In