0

databases Online Quiz - 81

Description: databases Online Quiz - 81
Number of Questions: 20
Created by:
Tags: databases
Attempted 0/20 Correct 0 Score 0
  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


Correct Option: B
  1. DURING

  2. INSTEAD

  3. ON SHUTDOWN

  4. BEFORE


Correct Option: D
  1. Package

  2. Stored function

  3. Stored procedure

  4. Another DB trigger


Correct Option: C
  1. DELETE TRIGGER business_hour

  2. DROP TRIGGER business_hour

  3. REMOVE TRIGGER business_hour

  4. ALTER TRIGGER business_hour remove


Correct Option: B
  1. Row level DML trigger

  2. Statement level DML trigger

  3. System trigger

  4. Application Trigger


Correct Option: A
  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


Correct Option: D
  1. Full table scan

  2. Table access by ROWID

  3. Access via unique index

  4. Primary key access


Correct Option: B
  1. Column

  2. 1966_Invoices

  3. Catch_#22

  4. #Invoices


Correct Option: C

Which command will delete all data from a table and will not write to the rollback segment?

  1. drop

  2. truncate

  3. delete

  4. cascade


Correct Option: B
  1. select * from EMP where nvl(EMPNO, '00000') = '59384';

  2. select 1 from EMP where EMPNO = '59834';

  3. select EMPNO, LASTNAME from EMP where EMPNO = '59384'

  4. select * from EMP where EMPNO = '59384';


Correct Option: A

When a user creates an object without a TABLESPACE clause, where will Oracle store the segment

  1. System tablespace

  2. Users tablespace

  3. Default tablespace for the user

  4. Oracle will give an error


Correct Option: C
  1. DB2 Everyplace

  2. DB2 Express Edition

  3. DB2 Workgroup Server Edition

  4. DB2Enterprise Server Edition


Correct Option: B

Which of the following products is allowed to access other DB2 servers, but cannot accept requests from other remote clients?

  1. DB2 Personal Edition

  2. DB2 Workgroup Server Edition

  3. DB2Enterprise Server Edition

  4. DB2 Data Warehouse Edition


Correct Option: A
  1. DB2 Connect Enterprise Edition

  2. DB2 Workgroup Server Edition

  3. DB2 Workgroup Server Edition and DB2 Connect Enterprise Edition

  4. DB2Enterprise Server Edition and DB2 Connect Enterprise Edition


Correct Option: D
  1. DB2 Express-C

  2. DB2 Express

  3. DB2 Personal Edition

  4. DB2Enterprise Server Edition


Correct Option: D
- Hide questions