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

The command to disable all the triggers on the EMP table

  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

Which character is used to continue a statement in SQL*Plus?

  1. *

  2. -

  3. /

  4. @


Correct Option: B

Which of the following is the lowest cost DB2 product that can be legally installed on a Windows server that has 2 CPUs?

  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

A client application on z/OS must access a DB2 database on a Solaris Server. At a Minimum, which of the following products must be installed on the Solaris Workstation?

  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

Which of the following is the lowest cost DB2 product that can be legally installed on an HP-UX server?

  1. DB2 Express-C

  2. DB2 Express

  3. DB2 Personal Edition

  4. DB2Enterprise Server Edition


Correct Option: D
- Hide questions