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

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

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

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

» 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

Question number: 24

» Databases » Database Design

MCQ▾

Question

To retrieve data that satisfies a particular condition, the clause which is used is

Choices

Choice (4) Response

a.

Where

b.

From

c.

Select

d.

None of the above

Question number: 25

» Databases » Transactions and Concurrency Control

MCQ▾

Question

For the function f (n) =16. Find out the order of this function in Big theta notation.

Choices

Choice (4) Response

a.

Θ (n = 2)

b.

Θ (1)

c.

Θ (n = 3)

d.

All of the above

Question number: 26

» Databases » Database Design

MCQ▾

Question

Which of the following is NOT a type of broadband Internet connection?

Choices

Choice (4) Response

a.

Cable

b.

DSL

c.

Dial -up

d.

satelite

Question number: 27

» Databases » Database Design

MCQ▾

Question

Which of the following is not a valid DBMS data model?

Choices

Choice (4) Response

a.

Network

b.

Relational

c.

Complex

d.

Hierarchical

Sign In