Question 1

A Database Procedure is stored in the Database

technology databases

In compiled form
As source code
Both A & B
Not stored

Answer

Correct Option: A

Question 2

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

technology databases

will
won't
sometimes possible
None of the above

Answer

Correct Option: B

Question 3

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

technology databases

Error
NULL
AXA US
AXAUS

Answer

Correct Option: D

Question 4

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

technology databases

3500,5000,2850
5000,2850
2850,5750
5000,5750

Answer

Correct Option: A

Question 5

What is a trigger?

technology databases

A piece of logic written in PL/SQL
Executed at the arrival of a SQL event
Both A & B
None of the above

Answer

Correct Option: C

Question 6

A Transaction ends

technology databases

Only when it is Committed
Only when it is Rolled back
When it is Committed or Rolled back
None of the above

Answer

Correct Option: C

Question 7

What are the different events in Triggers?

technology databases

Define, Create
Insert, Update, Delete
Drop, Comment
All of the above

Answer

Correct Option: B

Question 8

Use these data for the following Questions EMPNO ENAME SAL E100 John 3250 E200 Praveen 2000 E300 Mahesh E400 Prasanth 5500 E500 Vikram 6650 Select count (sal) from Emp will retrieve

technology databases

1
0
3
4
None of the above

Answer

Correct Option: D

Question 9

The Data Manipulation Language statements are

technology databases

INSERT
UPDATE
SELECT
All of the above

Answer

Correct Option: D

Question 10

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?

technology databases

50
NULL
5
None of the above

Answer

Correct Option: C

Question 11

Find the ODD Datatype out

technology databases

VARCHAR2
RECORD
BOOLEAN
RAW

Answer

Correct Option: B

Question 12

A Database Procedure is stored in the Database

technology databases

In compiled form
As source code
Both A & B
Not stored

Answer

Correct Option: A

Question 13

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

technology databases

will
won't
sometimes possible
None of the above

Answer

Correct Option: B

Question 14

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

technology databases

Error
NULL
AXA US
AXAUS

Answer

Correct Option: D

Question 15

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

technology databases

3500,5000,2850
5000,2850
2850,5750
5000,5750

Answer

Correct Option: A

Question 16

What is a trigger?

technology databases

A piece of logic written in PL/SQL
Executed at the arrival of a SQL event
Both A & B
None of the above

Answer

Correct Option: C

Question 17

A Transaction ends

technology databases

Only when it is Committed
Only when it is Rolled back
When it is Committed or Rolled back
None of the above

Answer

Correct Option: C

Question 18

In "Select 1 from dual;" who is the owner of Dual table?

technology databases

scott
john
sys
system

Answer

Correct Option: C

Question 19

Dropping a table causes its synonym to drop.

technology databases

True
False

Answer

Correct Option: B

Question 20

can we rename a Synonym?

technology databases

True
False

Answer

Correct Option: A

Description: databases Online Quiz - 109
Number of Questions: 20
Created by: Aliensbrain Bot
Tags: databases

databases Online Quiz - 109

Find more quizzes from top tags