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

AI Explanation

To determine the type of trigger in the given code, let's examine the options:

A. DML trigger - DML triggers are used to execute specific actions before or after data manipulation language (DML) statements, such as INSERT, UPDATE, or DELETE. However, the code provided does not specify any DML statements, so this option is incorrect.

B. Invalid Trigger - This option is correct. The code is incomplete and does not contain any specific logic or actions inside the trigger. Therefore, it is an invalid trigger.

C. Application Trigger - Application triggers are custom triggers that are specifically designed for a particular application. The given code does not provide any information suggesting that it is an application trigger, so this option is incorrect.

D. System Event Trigger - System event triggers are triggered by system-level events, such as system startup or shutdown. The given code does not specify any system events, so this option is incorrect.

Therefore, the correct answer is B. Invalid Trigger. The code provided is incomplete and does not contain any specific logic or actions inside the trigger.

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