Tag: databases

Questions Related to databases

The Data Manipulation Language statements are
technology databases

  1. INSERT

  2. UPDATE

  3. SELECT

  4. All of the above

Show answer
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?
technology databases

  1. 50

  2. NULL

  3. 5

  4. None of the above

Show answer
Correct Option: C

Find the ODD Datatype out
technology databases

  1. VARCHAR2

  2. RECORD

  3. BOOLEAN

  4. RAW

Show answer
Correct Option: B

A Database Procedure is stored in the Database
technology databases

  1. In compiled form

  2. As source code

  3. Both A & B

  4. Not stored

Show answer
Correct Option: A

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

technology databases

  1. will

  2. won't

  3. sometimes possible

  4. None of the above

Show answer
Correct Option: B

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

  1. Error

  2. NULL

  3. AXA US

  4. AXAUS

Show answer
Correct Option: D

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

  1. 3500,5000,2850

  2. 5000,2850

  3. 2850,5750

  4. 5000,5750

Show answer
Correct Option: A

What is a trigger?

technology databases

  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

Show answer
Correct Option: C

A Transaction ends

technology databases

  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

Show answer
Correct Option: C

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

  1. scott

  2. john

  3. sys

  4. system

Show answer
Correct Option: C
Explanation:

To solve this question, the user needs to know about the DUAL table in Oracle databases.

The DUAL table is a one-row, one-column table that is automatically created by Oracle. It is owned by the SYS user and is accessible to all users.

Therefore, the correct answer is:

The Answer is: C. sys