__________ is present in Oralce9i only.
Timestamp 0%
Date 0%
Rowid 0%
A CALL statement inside the trigger body enables you to call:
A package 0%
A stored function 0%
A stored procedure 0%
Another database trigger 0%
A function CALTAX is given below: CREATE OR REPLACE FUNCTION caltax (sal NUMBER) RETURN NUMBER IS BEGIN RETURN (sal * 0.05); END CALTAX; Which of the following statements is correct in case you wan...
You need to execute the command CALTAX(1000); 0%
You need to execute the command EXECUTE FUNCTION caltax; 0%
You need to create a SQL *Plus environment variable X and issue the command :X := CALTAX(1000); 0%
You need to create a SQL *Plus environment variable X and issue the command EXECUTE :X := CALTAX(1000); 0%
All the packages can be recompiled by using an Oracle utility called:
Dbms_Output 0%
Dbms_Lob 0%
Dbms_utility 0%
Dbms_Error 0%
An internal LOB is _____.
A table 0%
Stored in the database 0%
A file stored outside the database 0%
None of the above 0%
Consider the following code: declare v_id number(3):=50; V_message(30):='Product 10012'; begin declare v_id number(3):=40; V_message(30):='welcome to world'...
CREATE OR REPLACE PACKAGE manage_emp IS tax_rate CONSTANT NUMBER(5,2) := .28; v_id NUMBER; PROCEDURE insert_emp (p_deptno NUMBER, p_sal NUMBER); PROCEDURE delete_emp; PROCEDURE update_emp; FUNCTION...
CAL_TAX 0%
INSERT_EMP 0%
UPDATE_SAL 0%
DELETE_EMP 0%
UPDATE_EMP 0%
Database triggers are designed:
To duplicate the functionality of other triggers 0%
To guarantee that the related actions are performed when a specific operation is performed 0%
Both a and b 0%
None of the above 0%
Examine the Block given below: declare v_no number:=2; v_msg varchar2(20):='Goodbye'; begin case When v_no=1 then ��������dbms_output.put_line('One!'); ��������dbms_output.put_line('Another One!')...
>1! Still>1! 0%
Goodbye Adios 0%
1! 0%
Adios 0%
Examine the code given below: CREATE OR REPLACE FUNCTION gen_email (first_name VARCHAR2, last_name VARCHAR2, id NUMBER) RETURN VARCHAR2 IS email_name VARCHAR2(19); BEGIN email_name := SUBSTR(first...
DROP gen_email; 0%
REMOVE gen_email; 0%
DELETE gen_email; 0%
DROP FUNCTION gen_email; 0%
Examine the code given below: CREATE OR REPLACE PACKAGE comm_package IS g_comm NUMBER := 10; PROCEDURE reset_comm(g_comm IN NUMBER); END comm_package; User Jones executes the following code at 9:0...
g_comm has a value of 15 at 9:06am for Smith 0%
g_comm has a value of 15 at 9:06am for Jones 0%
g_comm has a value of 20 at 9:06am for both Jones and Smith 0%
g_comm has a value of 15 at 9:03 am for both Jones and Smith 0%
Examine the code given below: CREATE OR REPLACE TRIGGER secure_emp BEFORE LOGON ON employees BEGIN IF (TO_CHAR(SYSDATE, 'DY') IN ('SAT', 'SUN')) OR (TO_CHAR(SYSDATE, 'HH24:MI') NOT BETWEEN '08:00' ...
DML trigger 0%
INSTEAD OF trigger 0%
Application trigger 0%
This is an invalid trigger 0%
Examine the code given below: CREATE OR REPLACE TRIGGER update_emp AFTER UPDATE ON emp BEGIN INSERT INTO audit_table (who, dated) VALUES (USER, SYSDATE); END; / You issue an UPDATE command in the E...
Examine the code given below: Declare cursor emps is select Empno,ename,sal,deptno,job from emp; begin for rec in emps loop open emps; dbms_output.put_line(rec.empno||rec.ename||rec.sal||rec.deptno...
Record Rec is not defined 0%
Fetch statement is not specified 0%
Close cursor in not specified 0%
There is no need to open cursor in the for loop 0%
Examine the following code: CREATE OR REPLACE PROCEDURE add_dept ( p_name dept.dname%TYPE DEFAULT 'unknown', p_loc dept.locE DEFAULT 1700) IS BEGIN INSERT INTO dept VALUES (dept_seq.NEXTVAL,p_name,...
EXECUTE add_dept(p_loc=>2500) 0%
EXECUTE add_dept( 'Education', 2500) 0%
EXECUTE add_dept( .2500 ,p_loc =>2500) 0%
EXECUTE add_dept(p_name=>'Education', 2500) 0%
Examine the following code: CREATE OR REPLACE PROCEDURE add_dept ( p_name dept.dname%TYPE DEFAULT 'unknown', p_loc dept.locE%TYPE DEFAULT 1700) IS BEGIN INSERT INTO dept VALUES (dept_seq.NEXTVAL,p_...
EXECUTE add_dept(p_loc=>2500) 0%
EXECUTE add_dept( 'Education', 2500) 0%
EXECUTE add_dept( .2500 ,p_loc =>2500) 0%
EXECUTE add_dept(p_name=>'Education', 2500) 0%
Examine the following function: CREATE OR REPLACE FUNCTION PLAYER_AVG (V_ID in PLAYER.PLAYER_ID%TYPE) RETURN NUMBER IS V_AVG NUMBER; BEGIN SELECT HITS INTO V_AVG FROM PLAYER WHERE PLAYER_ID = V_ID;...
SELECT PLAYER_AVG(PLAYER_ID) FROM PLAYER; 0%
EXECUTE PLAYER_AVG(31); 0%
PLAYER_AVG('RUTH'); 0%
PLAYER_AVG(31); 0%
Examine the package given below: CREATE OR REPLACE PACKAGE discounts IS g_id NUMBER := 7829; discount_rate NUMBER := 0.00; PROCEDURE display_price (p_price NUMBER); END discounts; / CREATE OR REPL...
The value of DISCOUNT_RATE always remains 0.00 in a session 0%
The value of DISCOUNT_RATE is set to 0.10 each time the package is invoked in a session 0%
The value of DISCOUNT_RATE is set to 1.00 each time the procedure DISPLAY_PRICE is invoked 0%
The value of DISCOUNT_RATE is set to 0.10 when the package is invoked for the first time in a session 0%
How can you migrate from a LONG to a LOB data type for a column?
By using the DBMS_MANAGE_LOB.MIGRATE procedure 0%
By using the UTL_MANAGE_LOB.MIGRATE procedure 0%
By using the DBMS_LOB.MIGRATE procedure 0%
By using DBMS_REDEFINITION.START_REDEF_TABLE procedure 0%
In Explicit lock, two database operations wait for each other to release a lock.
SQL%ISOPEN always evaluates to false in case of:
Explicit Cursor 0%
Implicit Cursor 0%
Parameterized Cursor 0%
Cursor with Arguments 0%
The OLD and NEW qualifiers can be used in Row level system trigger.
The oracle server implicitly opens a cursor to process:
Sql select statement 0%
PL/SQL Select statement 0%
DML Statements 0%
DDL Statements 0%
The process of Breaking Sql sentence into words and then checking them for syntax and object privileges is called:
Binding 0%
Parsing 0%
Sequence 0%
Control Flow 0%
The Technique employed by the Oracle engine to protect table data when several people are accessing is called:
Concurrency Control 0%
Program Control 0%
PL/SQL Control 0%
Locking 0%
When the procedure or function is invoked, Oracle engine loads the compiled procedure or function in the memory area called:
PGA 0%
SGA 0%
Redo Log Buffer 0%
Data base buffer cache 0%
Which cursor allows passing values dynamically to a cursor?
Implicit Cursor 0%
User Defined Cursor 0%
Parameterized Cursor 0%
Explicit Cursor 0%
Which cursor attribute returns the number of rows fetched from the active set in the case of an explicit cursor?
%ISOPEN 0%
%ROWCOUNT 0%
%FOUND 0%
%NOTFOUND 0%
Which lock is used in Pl/Sql if the where clause evaluates to a set of data?
Row Level Lock 0%
Page Level lock 0%
Column Level lock 0%
Exclusive Lock 0%
Which of the following commands is used to disable all the triggers on an EMP table?
ALTER TRIGGERS ON TABLE emp DISABLE; 0%
ALTER e mp l o y e e s DI SABLE ALL TRI GGERS; 0%
ALTER TABLE emp DISABLE ALL TRIGGERS; 0%
None of the above 0%
Which of the following commands is used to disable all the triggers on the EMPLOYEES table?
ALTER TRI GGERS ON TABLE employees DI SABLE; 0%
ALTER employees DISABLE ALL TRI GGERS; 0%
ALTER TABLE employees DISABLE ALL TRIGGERS; 0%
None of the above 0%
Which of the following exceptions is raised when the data type or data size is invalid?
VALUE_ERROR 0%
NO_DATA_FOUND 0%
STORAGE_ERROR 0%
PROGRAM_ERROR 0%
Which of the following is not a legal declaration?
declare v_id number(4); 0%
declare v_x,V_y varchar2(10); 0%
declare V_birthdate date not null; 0%
declare V_Sex boolean:=1; 0%
Which of the following program declarations are correct for a stored program unit?
CREATE OR REPLACE FUNCTION tax(p_id NUMBER) RETURN NUMBER 0%
CREATE OR REPLACE PROCEDURE tax(p_id NUMBER) RETURN NUMBER 0%
CREATE OR REPLACE PROCEDURE tax(p_id NUMBER, p_amount OUT NUMBER) 0%
CREATE OR REPLACE FUNCTION tax(p_id NUMBER) RETURN NUMBER(10,2) 0%
Which of the following statements are correct with regard to packages?
The package specification is optional, but the package body is required 0%
The package specification is required, but the package body is optional 0%
The specification and body of the package are stored separately in the database 0%
None of the above 0%
Which of the following statements is correct with regard to stored procedures?
A stored procedure uses the DECLARE keyword in the procedure specification to declare formal parameters 0%
A stored procedure is named PL/SQL block with at least one parameter declaration in the procedure specification 0%
A stored procedure must have at least one executable statement in the procedure body 0%
A stored procedure uses the DECLARE keyword in the procedure body to declare formal parameters 0%
Which of the following statements is correct?
You can use the DBMS_LOB.WRITE procedure to write data to a BFILE 0%
You can use the DBMS_LOB.BFILENAME function to locate an external BFILE 0%
You can use the DBMS_LOB.FILEEXISTS function to find the location of a BFILE 0%
You can use the DBMS_LOB.FILECLOSE procedure to close the file being accessed 0%
Which of the following Triggers is fired each time a row in the table is affected by the triggering statement?
Statement Trigger 0%
Application Trigger 0%
Row 0%
Database Trigger 0%
Which of the following types of argument passes a value from a procedure to the calling environment?
VARCHAR2 0%
BOOLEAN 0%
OUT 0%
IN 0%
Which part of a database trigger determines the number of times a trigger body executes?
Trigger type 100.0%
Trigger body 0.0%
Trigger event 0.0%
Trigger timing 0.0%
Which procedure is called after a row has been fetched to transfer the value from the select list of the cursor to a local variable?
Row_value 0%
Column_value 0%
Raise_application 0%
Exception_init 0%
Which table should be queried to determine when a procedure was last compiled?
USER_PROCEDURES 0%
USER_PROCS 0%
USER_OBJECTS 0%
USER_PLSQL_UNITS 0%
Which two programming constructs can be grouped within a package?
Cursor 0%
Constant 0%
Trigger 0%
Sequence 0%
View 0%
You need to create a trigger on the EMP table, which monitors every row that is changed and places this information in the AUDIT_TABLE. What type of trigger would you create?
FOR EACH ROW trigger on the EMP table 0%
Statement-level trigger on the EMP table 0%
FOR EACH ROW trigger on the AUDIT_TABLE table 0%
Statement-level trigger on the AUDIT_TABLE table 0%
You need to drop a table from within a stored procedure. How would you do this?
You cannot drop a table from a stored procedure 0%
By using the DROP command 0%
By using the DBMS_DDL packaged routines 0%
By using the DBMS_DROP packaged routines 0%