0

databases Online Quiz - 109

Description: databases Online Quiz - 109
Number of Questions: 20
Created by:
Tags: databases
Attempted 0/20 Correct 0 Score 0

A Database Procedure is stored in the Database

  1. In compiled form

  2. As source code

  3. Both A & B

  4. Not stored


Correct Option: A

If an UNIQUE KEY constraint on DATE column is created, will it accept the rows that are inserted with SYSDATE?

  1. will

  2. won't

  3. sometimes possible

  4. None of the above


Correct Option: B

What is the Result of the following 'AXA'||NULL||'US' ?

  1. Error

  2. NULL

  3. AXA US

  4. AXAUS


Correct Option: D

What is a trigger?

  1. A piece of logic written in PL/SQL

  2. Executed at the arrival of a SQL event

  3. Both A & B

  4. None of the above


Correct Option: C
  1. Only when it is Committed

  2. Only when it is Rolled back

  3. When it is Committed or Rolled back

  4. None of the above


Correct Option: C
  1. Define, Create

  2. Insert, Update, Delete

  3. Drop, Comment

  4. All of the above


Correct Option: B

The Data Manipulation Language statements are

  1. INSERT

  2. UPDATE

  3. SELECT

  4. All of the above


Correct Option: D

Declare a number := 5; b number := null; c number := 10; Begin if a > b AND a < c then a := c * a; end if; End; What will be the value of 'a' after execution?

  1. 50

  2. NULL

  3. 5

  4. None of the above


Correct Option: C

Find the ODD Datatype out

  1. VARCHAR2

  2. RECORD

  3. BOOLEAN

  4. RAW


Correct Option: B
  1. In compiled form

  2. As source code

  3. Both A & B

  4. Not stored


Correct Option: A

If an UNIQUE KEY constraint on DATE column is created, will it accept the rows that are inserted with SYSDATE?

  1. will

  2. won't

  3. sometimes possible

  4. None of the above


Correct Option: B

Use these data for the following Questions EMPNO ENAME SAL A822 RAMASWAMY 3500 A812 NARAYAN 5000 A973 UMESH 2850 A500 BALAJI 5750 Select SAL from EMP E1 where 3 > ( Select count(*) from Emp E2 where E1.SAL > E2.SAL ) will retrieve

  1. 3500,5000,2850

  2. 5000,2850

  3. 2850,5750

  4. 5000,5750


Correct Option: A

What is a trigger?

  1. A piece of logic written in PL/SQL

  2. Executed at the arrival of a SQL event

  3. Both A & B

  4. None of the above


Correct Option: C
  1. Only when it is Committed

  2. Only when it is Rolled back

  3. When it is Committed or Rolled back

  4. None of the above


Correct Option: C

Dropping a table causes its synonym to drop.

  1. True

  2. False


Correct Option: B
- Hide questions