Question 1

Which statment about trigger is TRUE ?

technology databases

we can use Application Trigger to fire when a DELETE statement occurs
we can use database Trigger to fire when a INSERT statement occurs
we can use System event Trigger to fire when a DELETE statement occurs
we can use INSTEAD OF trigger to fire when a INSERT statement occurs

Answer

Correct Option: B

Question 2

Which is valid in creating DML triggers ?

technology databases

DURING
INSTEAD
ON SHUTDOWN
BEFORE

Answer

Correct Option: D

Question 3

CALL statement inside the trigger body enable to call ?

technology databases

Package
Stored function
Stored procedure
Another DB trigger

Answer

Correct Option: C

Question 4

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

technology databases

DELETE TRIGGER business_hour
DROP TRIGGER business_hour
REMOVE TRIGGER business_hour
ALTER TRIGGER business_hour remove

Answer

Correct Option: B

Question 5

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

technology databases

Row level DML trigger
Statement level DML trigger
System trigger
Application Trigger

Answer

Correct Option: A

Question 6

The command to disable all the triggers on the EMP table

technology databases

ALTER TRIGGERS ON TABLE EMP DISABLE
ALTER EMP DISABLE ALL TRIGGERS
NOT POSSIBLE TO DISABLE TRIGGERS
ALTER TABLE EMP DISABLE ALL TRIGGERS

Answer

Correct Option: D

Question 7

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

technology databases

1
2
3
4

Answer

Correct Option: C

Question 8

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

technology databases

Full table scan
Table access by ROWID
Access via unique index
Primary key access

Answer

Correct Option: B

Question 9

Which of the following can be a valid column name?

technology databases

Column
1966_Invoices
Catch_#22
#Invoices

Answer

Correct Option: C

Question 10

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

technology databases

drop
truncate
delete
cascade

Answer

Correct Option: B

Question 11

Which character function can be used to return a specified portion of a character string?

technology databases

instr
substr
substring
pos

Answer

Correct Option: B

Question 12

The primary key on table EMP is the EMPNO column. Which of the following statements will not use the associated index on EMPNO?

technology databases

select * from EMP where nvl(EMPNO, '00000') = '59384';
select 1 from EMP where EMPNO = '59834';
select EMPNO, LASTNAME from EMP where EMPNO = '59384'
select * from EMP where EMPNO = '59384';

Answer

Correct Option: A

Question 13

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

technology databases

System tablespace
Users tablespace
Default tablespace for the user
Oracle will give an error

Answer

Correct Option: C

Question 14

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

technology databases

*
-
/
@

Answer

Correct Option: B

Question 15

Assuming today is Monday, 10 July 2000, what is returned by this statement: SELECT to_char(NEXT_DAY(sysdate, 'MONDAY'), 'DD-MON-RR') FROM dual;

technology databases

03-JUL-00
10-JUL-00
11-JUL-00
17-JUL-00

Answer

Correct Option: C

Question 16

To produce a meaningful result set without any cartesian products, what is the minimum number of conditions that should appear in the WHERE clause of a four-table join?

technology databases

8
2
3
4

Answer

Correct Option: C

Question 17

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

technology databases

DB2 Everyplace
DB2 Express Edition
DB2 Workgroup Server Edition
DB2Enterprise Server Edition

Answer

Correct Option: B

Question 18

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

technology databases

DB2 Personal Edition
DB2 Workgroup Server Edition
DB2Enterprise Server Edition
DB2 Data Warehouse Edition

Answer

Correct Option: A

Question 19

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?

technology databases

DB2 Connect Enterprise Edition
DB2 Workgroup Server Edition
DB2 Workgroup Server Edition and DB2 Connect Enterprise Edition
DB2Enterprise Server Edition and DB2 Connect Enterprise Edition

Answer

Correct Option: D

Question 20

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

technology databases

DB2 Express-C
DB2 Express
DB2 Personal Edition
DB2Enterprise Server Edition

Answer

Correct Option: D

Description: databases Online Quiz - 81
Number of Questions: 20
Created by: Aliensbrain Bot
Tags: databases

databases Online Quiz - 81

Find more quizzes from top tags