What do you know about the Oracle Certification Exam? Would you like to put your knowledge to the test? The Oracle Certification Program certifies candidates on skills and experience pertaining to Oracle manufactured goods and technologies. Credentials are presented based on a combination of passing exams, training, and performance-based assignments, depending upon the level of certification. If you intend to learn more about the Oracle Certification Exam, look no further than this quiz.
DROP get_budget;
REMOVE get_budget;
DROP FUNCTION get_budget;
ALTER get_budget DROP FUNCTION;
Rate this question:
They are public procedures
They are private procedures
Each procedure is missing code and, therefore, is illegal.
Each procedure contains an argument list and, therefore, is illegal.
Rate this question:
Issue the SHOW ERRORS command.
Issue the DISPLAY ERRORS command.
Query the FUNCTION_ERRORS data dictionary view.
Do nothing. The errors will display after a five-second delay.
Rate this question:
DROP audit_theater;
DROP TRIGGER audit_theater;
ALTER TRIGGER audit_theater DROP;
ALTER TABLE theater DROP TRIGGER audit_theater;
Rate this question:
Restricting pragma references
Passing values to the function
Bypassing directives to the compiler
Prompting the end user for information
Rate this question:
This statement removes only the package body.
The statement removes only the package specification.
The statement removes the package specification and the package body.
This statement contains a syntax error.
Rate this question:
Public
Private
Invalid
Constant
Rate this question:
Row only
Statement only
Statement and row
Oracle Forms trigger
Rate this question:
IN
OUT
IN OUT
IN RETURN
Rate this question:
DROP calc_comm;
REMOVE calc_comm;
DROP PROCEDURE calc_comm;
ALTER calc_comm DROP PROCEDURE;
Rate this question:
SET ECHO ON
SET OUTPUT ON
SET FEEDBACK ON
SET SERVEROUTPUT ON
Rate this question:
This package specification can exist without a body.
This package body can exist without a specification.
This package body cannot exist without a specification.
This package specification cannot exist without a body.
Rate this question:
ALTER TRIGGER check_theater DROP;
MODIFY TRIGGER check_theater DROP;
ALTER TRIGGER check_theater DISABLE;
MODIFY TRIGGER check_theater DISABLE;
Rate this question:
DBMS_SQL
DBMS_TRIGGER
DBMS_CHECK_MANIPULATION_TYPE
DELETING, UPDATING, and INSERTING
Rate this question:
OUTPUT.PUT_LINE(TO_CHAR(SQL%ROWCOUNT));
DBMS_DEBUG.PUT_LINE(TO_CHAR(SQL%ROWCOUNT));
DBMS_OUTPUT.DISPLAY(TO_CHAR(SQL%ROWCOUNT));
DBMS_OUTPUT.PUT_LINE(TO_CHAR(SQL%ROWCOUNT));
Rate this question:
1
30
31
None
Rate this question:
REPLACE PROCEDURE
RECREATE PROCEDURE
UPDATE PROCEDURE WITH
CREATE OR REPLACE PROCEDURE
Rate this question:
A function allows Oracle group functions.
A function can be used in a SQL statement.
A function guarantees read consistency, while a procedure cannot.
A function can only be executed from a previously created procedure.
Rate this question:
Row only
Statement only
Either statement or row
Neither statement or row
Rate this question:
On
Off
After
Before
Rate this question:
%TYPE
Data type
%ROWTYPE
Maximum length
Rate this question:
EXECUTE find_seats_sold (500,11);
Theater_pck.find_seats_sold (500,11);
EXECUTE theater_pck.find_seats_sold (500,11);
SELECT find_seats_sold(movie_id, theater_id) FROM gross_receipt;
Rate this question:
View
Cursor
Variable
Database trigger
Application trigger
Rate this question:
PROCEDURE find_cpt (v_movie_id IN NUMBER, v_cost_per_ticket IN OUT NUMBER);
PUBLIC PROCEDURE find_cpt (v_movie_id IN NUMBER, v_cost_per_ticket IN OUT NUMBER);
PROCEDURE find_cpt (v_movie_id IN NUMBER, v_cost_per_ticket IN OUT NUMBER) IS BEGIN IF v_cost_per_ticket > 8.50 THEN SELECT cost_per_ticket INTO v_cost_per_ticket FROM gross_receipt WHERE movie_id = v_movie_id; END IF; END;
PUBLIC PROCEDURE find_cpt (v_movie_id IN NUMBER, v_cost_per_ticket IN OUT NUMBER) IS BEGIN IF v_cost_per_ticket > 8.50 THEN SELECT cost_per_ticket INTO v_cost_per_ticket FROM gross_receipt WHERE movie_id = v_movie_id; END IF; END;
Rate this question:
DISABLE TRIGGERS ON gross_receipt;
DISABLE ALL TRIGGERS ON gross_receipt;
ALTER TRIGGER ALL DISABLE ON gross_receipt;
ALTER TABLE gross_receipt DISABLE ALL TRIGGERS;
Rate this question:
Add (v_name IN VARCHAR2) immediately after the IS keyword.
Add v_name VARCHAR2(30); immediately after the IS keyword.
Add (v_name IN VARCHAR2) immediately before the IS keyword.
Add (v_name IN VARCHAR2) immediately after the BEGIN keyword.
Rate this question:
A package can be called.
A package can be nested.
A package can be parameterized.
Package contents can be shared by multiple applications.
Rate this question:
Executing the stored function within an INSERT statement
Executing the stored function within a server-side function
Executing the stored function within a client-side function
Executing the stored function within the DEFAULT clause of the CREATE TABLE statement
It must also be declared in the body.
It can only be referenced from inside the package
It can only be referenced from outside the package.
It can be referenced from inside and outside the package.
Rate this question:
It can be referenced within a SQL statement.
It can be referenced from outside of the package.
It can only be referenced from within the package.
It must also be specified in the specification because it is specified in the body.
Rate this question:
When the transaction is committed
During a data manipulation statement
When it is explicitly invoked by another construct
When an Oracle supplied package references the trigger
Rate this question:
Once
Twice
Once for each row deleted or updated
Once for each row deleted or seats_sold_cost_per_ticket updated
Rate this question:
STUDIO table update
YEARLY_BUDGET column update
STUDIO table insert, update, or delete
Any column update other than YEARLY_BUDGET
Rate this question:
RETURN
RETURN get_budget;
OUT v_yearly_budget;
RETURN v_yearly_budget;
Rate this question:
Only data type is required.
Data type and maximum length are required.
Data type and maximum length are not required.
Only maximum length is required for the VARCHAR2 data type.
Rate this question:
It can only be referenced from outside the package
It can be referenced from outside and within the package.
It can be referenced by all constructs within the package.
It must be moved to the specification to compile successfully
Rate this question:
BEFORE (gross_receipt, seats_sold, cost_per_ticket) INSERT, UPDATE
BEFORE INSERT OR UPDATE OF seats_sold, cost_per_ticket ON gross_receipt
BEFORE INSERT OR UPDATE(seats_sold, cost_per_ticket) ON gross_receipt FOR EVERY ROW
BEFORE INSERT OR UPDATE OF seats_sold, cost_per_ticket ON gross_receipt FOR EACH ROW
Rate this question:
GRANT EXECUTE ON get_budget TO jsmith;
GRANT EXECUTE, SELECT ON studio TO jsmith;
GRANT EXECUTE, SELECT ON get_budget TO jsmith;
GRANT SELECT ON studio TO jsmith; GRANT EXECUTE ON get_budget TO jsmith;
Rate this question:
Only the GET_TOTAL_FOR_YEAR variable must exist in the specification of the THEATER_PCK package.
Only the V_TOTAL_SEATS_SOLD_OVERALL variable must exist in the specification of the THEATER_PCK package.
Both the V_TOTAL_SEATS_SOLD_OVERALL variable and the GET_TOTAL_FOR_YEAR function must exist only in the body of the THEATER_PCK package.
Both the V_TOTAL_SEATS_SOLD_OVERALL variable and the GET_TOTAL_FOR_YEAR function must exist in the specification of the THEATER_PCK package.
Rate this question:
Declare V_SEATS_SOLD as an OUT argument.
Declare V_SEATS_SOLD as a RETURN argument.
Add RETURN V_SEATS_SOLD immediately before the IS keyword.
Add RETURN V_SEATS_SOLD immediately before the END keyword.
Rate this question:
It can be referenced within a SQL statement.
It can only be referenced from within the package.
It can be referenced from within and outside of the package.
It cannot also be specified in the specification because it is specified in the body.
Rate this question:
Function
Procedure
Public packaged procedure
Private packaged procedure
Private packaged function
Rate this question:
An exception can propagate across remote procedure calls.
The RAISE; statement in an exception handler ends the current exception.
An exception raised inside an exception handler will not propagate to the enclosing block.
When an exception is raised in a called procedure, control goes to the exception section of that block.
Rate this question:
After
Weekly
Before
Monthly
Rate this question:
Package constructs stored in the database are public.
Package constructs defined within the package specification are private.
Private and public package constructs are both declared and defined within the package body.
A private package construct can only be referenced only by other constructs within the same package.
Rate this question:
VARIABLE g_budget_amount NUMBER EXECUTE :g_budget_amount := get_budget(11);
VARIABLE g_budget_amount NUMBER EXECUTE theater_pck.get_budget(g_budget_amount, 11);
VARIABLE g_budget_amount NUMBER EXECUTE :g_budget_amount := theater_pck.get_budget(11);
This function cannot be referenced from outside the package.
Rate this question:
Remove only the V_TOTAL parameter.
Remove the NVL function from the WHERE clause.
Use (v_total IN sales_order.total%TYPE => 0) as the parameter definition.
Use (v_total IN sales_order.total%TYPE DEFAULT 0) as the parameter definition.
Rate this question:
ROLLBACK ;
ROLLBACK TO PROCEDURE calc_comm;
ALTER PROCEDURE calc_comm COMPILE;
Only the database administrator can recover this procedure using backups.
Rate this question:
Quiz Review Timeline (Updated): Jul 4, 2024 +
Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.
Oracle Final Test Questions And Answers
Hey, check out this amazing 'Oracle Final Test' quiz. We've designed this quiz to test your knowledge about the Oracle subject. If you are planning to give...
Questions:
40 |
Attempts:
3775 |
Last updated:
May 12, 2023
|
OCA And OCP Exam Quiz!
Are you familiar with OCA and OCP? Would you like to try this quiz? OCA stands for Oracle Certified Associate, while OCP stands for Oracle Certification Program. OCA is a...
Questions:
96 |
Attempts:
1658 |
Last updated:
Mar 21, 2023
|
|
English Exam Questions And Answers- 2
If you have an upcoming exam, or just want to enhance your knowledge, just take our amazing online quiz with interesting quiz questions. From the following answers select the...
Questions:
10 |
Attempts:
4063 |
Last updated:
Oct 14, 2024
|
Prelims Exclusive Quiz - Day 1
The idea is to keep the MCQs to a practicable level so that you do not spend an extra minute than required, and have maximum output for the UPSC Prelims Exam 2020. Questions would...
Questions:
10 |
Attempts:
181 |
Last updated:
Mar 14, 2023
|
|
UGC NET PAPER 1
It is an MCQs based on the UGC NET Syllabus. It consists of 10 questions and carries 2 marks each. All questions are compulsory.here.
Questions:
10 |
Attempts:
515 |
Last updated:
Mar 21, 2023
|
MH-CET Online Daily Exam By NIT
This daily online exam by NIT focuses on specific administrative and admission details for 2020, including faculty count and establishment year.
Questions:
6 |
Attempts:
48 |
Last updated:
Nov 20, 2024
|
Wait!
Here's an interesting quiz for you.