EXECUTE ADD_PLAYER (10,a);
ADD_PLAYER (10,a);
RUN ADD_PLAYER (10,a);
START ADD_PLAYER (10,a);
CREATE OR REPLACE PROCEDURE calc (p_no IN NUMBER) RETURN tax IS V_sal NUMBER; Tax NUMBER; BEGIN SELECT sal INTO v_sal FROM emp WHERE EMPNO=p_no; Tax:=v_sal * 0. 05; END;
CREATE OR REPLACE FUNCTION calctax(p_no NUMBER) RETURN NUMBER IS V_sal NUMBER; BEGIN SELECT sal INTO v_sal FROM emp WHERE empno =p_no; RETURN(v_sal* 0. 05); END;
CRETAE OR REPLACE FUNCTION calctax(p_no NUMBER) RETURN NUMBER IS V_sal NUMBER; Tax NUMBER; BEGIN SELECT sal INTO v_sal FROM emp WHERE empno =p_no; Tax:=v_sal * 0. 05; END;
CREATE OR REPLACE FUNCTION calctax(p_no NUMBER)IS V_sal NUMBER; Tax NUMBER; BEGIN SELECT sal INTO v_sal FROM emp WHERE empno =p_no; Tax :=v_sal * 0. 05; RETURN(tax); END;
VARCHER2.
BOOLEAN.
OUT.
IN.
Statement-level trigger on the EMP table.
For each row trigger on the EMP table.
Statement-level trigger on the AUDIT_TABLE table.
For each row statement level trigger on the EMP table.
For each row trigger on the AUDIT_TABLE table.
1
10
None
Value equal to the number of rows in the emp table
Row
Statement
ORACLE FORM trigger
Before
ROW_UPDATE('SALARY')
UPDATING('SALARY')
CHANGING('SALARY')
COLUMN_UPDATE('SALARY')
When the NEW_PRODUCT_VIEW is dropped.
When rows of the product table are updated through SQI Plus.
When the internal logic of the QUERY_PRODUCT procedure is modified.
When a new column that can contain null values is added to the product table.
When a new procedure s created that updates rows in the product table directly.
When the procedure contains no SQL statements.
When the procedure contains no PL/SQL commands.
When the procedure needs to be used by many client applications accessing several remote databases.
When the procedure needs to be used by many users accessing the same schema objects on a local database.
In the package body
In a database trigger
In the package specification
In each procedure's DECLARE section, using the exact same name in each
The value of DISCOUNT_RATE always remain 0. 00 in a session.
The value of DISCOUNT_RATE is set to 0. 10 each time the package are invoked in a session.
The value of DISCOUNT_RATE is set to 1 each time the procedure DISPLAY_PRICE is invoked.
The value of DISCOUNT_RATE is set to 0. 10 when the package is invoked for first time in a session.
The rows are selected and ordered.
The validity of the SQL statement is established.
An area of memory is established to process the SQL statement.
The SQL statement is run and the number of rows processed is returned.
The area of memory established to process the SQL statement is released.
Querying with the SELECT * notation
Declaring variables with the %TYPE attribute
Specifying schema names when referencing objects
Declaring records by using the %ROWTYPE attribute
Specifying package.procedure notation while executing procedures
Packages can be nested.
You can pass parameters to packages.
A package is loaded into memory each time it is invoked.
The contents of packages can be shared by many applications.
You can achieve information hiding by making package constructs private.
Only local or packaged sub programs can be overloaded.
Overloading allows different functions with the same name that differ only in their return types.
Overloading allows different subprograms with the same number, type and order of the parameter.
Overloading allows different subprograms with the same name and same number or type of the parameters.
Overloading allows different subprograms with the same name but different in either number or type or order of parameter.
GRANT SELECT ON ADD_PLAYER TO PUBLIC;
GRANT EXECUTE ON ADD_PLAYER TO PUBLIC;
GRANT INSERT ON PLAYER TO PUBLIC;
GRANT EXECUTE, INSERT ON ADD_PLAYER TO PUBLIC;
REVOKE INSERT ON PLAYER FROM PUBLIC;
Only varrays must start with the subscript 1.
Only varrays can be used as column types in database tables.
Both associative arrays and varrays must start with the subscript 1.
Both associative arrays and varrays can be used as column types in database tables.
Quiz Review Timeline (Updated): Jan 24, 2013 +
Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.
Oracle Performance Tuning Trivia Quiz!
Do you know about performance tuning in the Oracle databases? Take this "Oracle Performance Tuning trivia quiz" and assess yourself. Performance tuning is the process of...
Questions:
19 |
Attempts:
905 |
Last updated:
Aug 18, 2023
|
Intelligent Oracle Apps DBA Assessment Test
As an Oracle Apps DBA (Oracle Applications Database Administrator), you must be specialized in Oracle Applications Server architectures like a normal Oracle DBA but skills...
Questions:
10 |
Attempts:
178 |
Last updated:
Mar 21, 2023
|
Intelligent Oracle EBS Assessment Test
Proudly developed by Oracle, the Oracle E-Business Suite is a comprehensive suite which consists of applications used for integrated and global businesses to help organizations...
Questions:
10 |
Attempts:
218 |
Last updated:
Mar 20, 2023
|
Oracle Data Integrator Test Quiz! Trivia
Have you studied or learned about Oracle Data Integrator? Take this Oracle Data Integrator test quiz to know how well updated your knowledge is. Oracle Data Integrator is...
Questions:
10 |
Attempts:
995 |
Last updated:
Aug 23, 2023
|
Can You Pass The OBIEE Test? Quiz!
The Oracle Business Intelligence Enterprise Edition is a business intelligence tool. This tool has several applications that are designed to ease the transfer, presentation, and...
Questions:
10 |
Attempts:
364 |
Last updated:
Mar 21, 2023
|
The Oracle ADF Test
This Oracle ADF test would help you prepare for the Oracle ADF job tests as it perfectly examine your knowledge and proficiency in the application development framework.
Questions:
10 |
Attempts:
394 |
Last updated:
Mar 20, 2023
|
Wait!
Here's an interesting quiz for you.