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

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

» 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

Question number: 16

» Databases » Database Design

MCQ▾

Question

The output of the following SQL Statement is

SELECT GREATEST OF (‘ANNIE’, ‘ANGELINA’, ‘ANASTASIA’) FROM DUAL

Choices

Choice (4) Response

a.

ANAST

b.

ANASTASIA

c.

ANGELINA

d.

ANNIE

Question number: 17

» Databases » Database Design

MCQ▾

Question

The output of this SQL Statement is

SELECT INSTR (‘Knowledge Check’, ‘e’, 7), FROM DUAL

Choices

Choice (4) Response

a.

6

b.

8

c.

12

d.

9

Question number: 18

» Databases » Database Design

MCQ▾

Question

The function ADD_MONTHS (TO_DATE (‘12-FEB-2007’, ‘DD-MON-YYYY’), 10) would return

Choices

Choice (4) Response

a.

12-DEC-2007

b.

12-NOV-2006

c.

12-NOV-2007

d.

12-DEC-2008

Question number: 19

» Databases » Database Design

MCQ▾

Question

The output of this SQL Statement is

SELECT LPAD (‘Check’, 8, +), RPAD (‘Check’, 8, +) FROM DUAL;

Choices

Choice (4) Response

a.

Check+++, +++Check

b.

+++Check, Check+++

c.

+++ Check

d.

None of the above

Sign In