Tag: programming languages

Questions Related to programming languages

ROWNUM is the physical address of the row.
technology programming languages

  1. True

  2. False

Show answer
Correct Option: B

GRANT and REVOKE are part of
technology programming languages

  1. DDL

  2. DML

  3. DCL

  4. None

Show answer
Correct Option: C

What is the result of the query SELECT add_months('15-Jan-2011',-2) from DUAL ?
technology programming languages

  1. 15-Dec-2010

  2. 15-Nov-2010

  3. 15-Mar-2011

  4. 15-Nov-2011

Show answer
Correct Option: B

What is the result of the query SELECT FLOOR(-4.6)+CEIL(3.9) from DUAL ?

technology programming languages

  1. -2

  2. 0

  3. 1

  4. -1

Show answer
Correct Option: D

How many comparisons can be written in a CASE statement ?
technology programming languages

  1. 127

  2. 255

  3. 63

  4. 511

Show answer
Correct Option: B

Which is the Defualt Index ?
technology programming languages

  1. BITMAP

  2. B-TREE

  3. FUNCTION BASED

  4. None

Show answer
Correct Option: B

A Table can have unlimited indexes.

technology programming languages

  1. True

  2. False

Show answer
Correct Option: A

A Table can have Unlimited Columns.

technology programming languages

  1. True

  2. False

Show answer
Correct Option: B

Min, Default and Max size of DBMS Output Buffer is ?
technology programming languages

  1. 1 - 10,000 - 1,000,000

  2. 1 - 10,000 - 100,000

  3. 1 - 20,000 - 100,000

  4. 1 - 20,000 - 1,000,000

Show answer
Correct Option: D

The file init.ora is available at the location ?

technology programming languages

  1. $Oracle_home/data

  2. $Oracle_home/dbs

  3. $Oracle_home/dba

  4. $Oracle_home/db

Show answer
Correct Option: B