Databases (GATE Computer Science): Questions 15 - 19 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: 15

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

» Databases » Database Design

MCQ▾

Question

The DDL part of SQL is

Choices

Choice (4) Response

a.

count

b.

update

c.

delete

d.

insert

Question number: 17

» Databases » Database Design

MCQ▾

Question

Which of the following is a wrong type of insert statement?

Choices

Choice (4) Response

a.

INSERT INTO DEPT (deptno, dept_name, manager_id, loc_name) VALUES (10, ‘Accounting’, 10004, ‘Chicago’)

b.

INSERT INTO DEPT (deptno, dept_name, manager_id, loc_name) VALUES (10, Accounting, 10004, Chicago)

c.

INSERT INTO DEPT (deptno, dept_name, manager_id, loc_name) (10, Accounting, 10004, Chicago)

d.

None of the above

Question number: 18

» Databases » Query Languages

MCQ▾

Question

A query is as follows

SELECT DISTINCT LOC_NAME FROM DEPT WHERE DEPT_ID IN (10, 20, 30);

In the above example, departments 10, 20 and 30 are in the city Chicago where as that of 40, 50 and 60 are in St. Louis. How many values of LOC_NAME are returned?

Choices

Choice (4) Response

a.

One value of St. Louis

b.

Three values of St. Louis

c.

Three values of Chicago

d.

One value of Chicago

Question number: 19

» Databases » Database Design

MCQ▾

Question

The output of this SQL Statement is

SELECT LENGTH (‘Knowledge’) – 1, LENGTH (‘Knowledge’), LENGTH (‘Knowledge’) + 1 FROM DUAL

Choices

Choice (4) Response

a.

9, 9, 9

b.

10, 9, 8

c.

8, 9, 10

d.

Question does not provide sufficient data or is vague

Sign In