Tag: databases

Questions Related to databases

When you try to save 34567.2255 into a column defined as NUMBER(7,2) what value is actually saved?
technology databases

  1. 34567.00

  2. 34567.22

  3. 34567.23

  4. 3456.22

Show answer
Correct Option: C

What is the default display length of the DATE datatype column?
technology databases

  1. 8

  2. 9

  3. 6

  4. 16

Show answer
Correct Option: B

Which clause in a query limits the rows selected?
technology databases

  1. ORDER BY

  2. FROM

  3. SELECT

  4. WHERE

Show answer
Correct Option: D

The INTO clause is mandatory for SELECT statements within PL/SQL blocks.
technology databases

  1. True

  2. False

Show answer
Correct Option: B

PL/SQL blocks may be nested within exception block.

technology databases

  1. True

  2. False

Show answer
Correct Option: A

The following block statement will run successfully SCOTT.EMP.EMPNO := 1234;

technology databases

  1. True

  2. False

Show answer
Correct Option: B

5 + NULL evaluates to 5 and ‘PL/’ || NULL || ‘SQL’ evaluates to ‘PL/SQL’

technology databases

  1. True

  2. False

Show answer
Correct Option: B

what is the concatenation operator in dbms_output.put_line() function
technology databases

  1. +

  3. ||

  4. .

Show answer
Correct Option: C

what will be the output of the following block: set serveroutput on; declare a int; b int; begin a:=NULL; b:=NULL; if a< b then dbms_output.put_line('y'); else dbms_output.put_line('n'); end if; end;
technology databases

  1. y

  2. n

  3. error

  4. no output

Show answer
Correct Option: B

which statement is used to break a loop in pl/sql
technology databases

  1. exit

  2. break

  3. stop

  4. continue

Show answer
Correct Option: A