Tag: databases

Questions Related to databases

Examine this code CREATE OR REPLACE TRIGGER SECURE_emp BEFORE LOGON ON EMP BEGIN ............. END WHAT TYPE OF TRIGGER IS IT ?
technology databases

  1. DML trigger

  2. Invalid Trigger

  3. Application Trigger

  4. System Event trigger

Show answer
Correct Option: B

CREATE OR REPLACE TRIGGER update_emp AFTER UPDATE ON EMP BEGIN INSERT INTO AUDIT_TABLE values(user ,sysdate ); END ; you issue an update command in the EMP tables that result in a update of 10 rows. How many rows are inserted into the AUDIT_TABLE ?
technology databases

  1. 1

  2. 10

  3. none

  4. Value equal to number of rows in EMP table

Show answer
Correct Option: A

Which statment about trigger is TRUE ?
technology databases

  1. we can use Application Trigger to fire when a DELETE statement occurs

  2. we can use database Trigger to fire when a INSERT statement occurs

  3. we can use System event Trigger to fire when a DELETE statement occurs

  4. we can use INSTEAD OF trigger to fire when a INSERT statement occurs

Show answer
Correct Option: B

Which is valid in creating DML triggers ?
technology databases

  1. DURING

  2. INSTEAD

  3. ON SHUTDOWN

  4. BEFORE

Show answer
Correct Option: D

CALL statement inside the trigger body enable to call ?
technology databases

  1. Package

  2. Stored function

  3. Stored procedure

  4. Another DB trigger

Show answer
Correct Option: C

which command do u used to remove trigger(business_hour) in iSQL environment ?
technology databases

  1. DELETE TRIGGER business_hour

  2. DROP TRIGGER business_hour

  3. REMOVE TRIGGER business_hour

  4. ALTER TRIGGER business_hour remove

Show answer
Correct Option: B

The OLD and NEW Qualifier is used in which type of trigger?
technology databases

  1. Row level DML trigger

  2. Statement level DML trigger

  3. System trigger

  4. Application Trigger

Show answer
Correct Option: A

The command to disable all the triggers on the EMP table
technology databases

  1. ALTER TRIGGERS ON TABLE EMP DISABLE

  2. ALTER EMP DISABLE ALL TRIGGERS

  3. NOT POSSIBLE TO DISABLE TRIGGERS

  4. ALTER TABLE EMP DISABLE ALL TRIGGERS

Show answer
Correct Option: D

How many columns are presented after executing this query: SELECT address1||','||address2||','||address2 "Adress" FROM employee;
technology databases

  1. 1

  2. 2

  3. 3

  4. 4

Show answer
Correct Option: C

Which Oracle access method is the fastest way for Oracle to retrieve a single row?
technology databases

  1. Full table scan

  2. Table access by ROWID

  3. Access via unique index

  4. Primary key access

Show answer
Correct Option: B