OCA Exam Quizzes & Trivia


Description: This online OCA Oracle database administration quiz is aim to test your knowledge on 11g administration and help you prepare for OCA certification.

Questions: 6  |  Attempts: 4013   |  Last updated: Sep 9, 2019
  • Sample Question
    Which of these languages can run within the database ? (choose all correct answers).

Description: This online OCA Oracle database administration quiz is aim to test your knowledge on 11g administration and help you prepare for OCA certification. This is a free online quiz to help broaden your knowledge...

Questions: 9  |  Attempts: 1220   |  Last updated: Dec 26, 2012
  • Sample Question
    What statements regarding instance memory and session memory are correct? (choose the best answer)

FOR THOSE WHO ARE GOING TO TAKE THE oca/ocp EXAM

Questions: 96  |  Attempts: 986   |  Last updated: Sep 9, 2019
  • Sample Question
    1 Examine this function: CREATE OR REPLACE FUNCTION CALC_PLAYER_AVG (V_ID in PLAYER_BAT_STAT.PLAYER_ID%TYPE) RETURN NUMBER IS V_AVG NUMBER; BEGIN SELECT HITS / AT_BATS INTO V_AVG FROM PLAYER_BAT_STAT WHERE PLAYER_ID = V_ID; RETURN (V_AVG); END; Which statement will successfully invoke this function in SQL *Plus?

OCA 1Z0-147 EXAM

Questions: 75  |  Attempts: 128   |  Last updated: Dec 26, 2012
  • Sample Question
    CREATE OR REPLACE PACKAGE theater_pck IS PROCEDURE find_seats_sold (v_movie_id IN NUMBER DEFAULT 34, v_theater_id IN NUMBER); END theater_pck; CREATE OR REPLACE PACKAGE BODY theater_pck IS current_avg_cost_per_ticket NUMBER; PROCEDURE find_seats_sold (v_movie_id IN NUMBER DEFAULT 34, v_theater_id IN NUMBER) IS v_seats_sold gross_receipt.seats_sold%TYPE; v_budget studio.yearly_budget%TYPE; BEGIN SELECT seats_sold INTO v_seats_sold FROM gross_receipt WHERE movie_id = v_movie_id AND theater_id = v_theater_id; END find_seats_sold; FUNCTION get_budget (v_studio_id IN NUMBER) RETURN number IS v_yearly_budget NUMBER; BEGIN SELECT yearly_budget INTO v_yearly_budget FROM studio WHERE id = v_studio_id; RETURN v_yearly_budget; END get_budget; END theater_pck; Which statement about the CURRENT_AVG_COST_PER_TICKET variable is true?

Exam for the oracle oca

Questions: 30  |  Attempts: 106   |  Last updated: Jun 28, 2018
  • Sample Question
    Examine this procedure: CREATE PROCEDURE add_theater IS BEGIN INSERT INTO theater VALUES (35, 'Riverplace Theatre', '1222 River Drive, Austin, Tx.'); END; Which three statements about this procedure are true? (Choose three.)




OCA Exam Questions & Answers


Which of the following are legal entry point methods that can be run from the command line?
It might seem in the beginning that option E is the best option but if you would look at it closely, you will realize that it is not the lowercase public that was used for this. The best answer is none of the above. Do remember that Java is case sens
What can you do with the DBMS_LOB package?
1. use the dbms_lob.fileclose procedure to close the file being accessed. -a. dbms_lob.write is used to write to internal lobs. the internal lob is stored inside the oracle server. a blob, nclob, or clob can be one of the following: an attribute of
Which of the following statements are true? 1: public class Rabbit {2: public static void main(String[] args) {3: Rabbit one = new Rabbit(); 4: Rabbit two = new Rabbit(); 5: Rabbit three =...
The Rabbit object from line 3 is first eligible for garbage collection immediately following line 8. The Rabbit object from line 4 is first eligible for garbage collection immediately following line 9.B, D. The Rabbit object from line 3 has two refer
Which statement will successfully invoke the following function in SQL *Plus? CREATE OR REPLACE FUNCTION CALC_PLAYER_AVG (V_ID in PLAYER_BAT_STAT.PLAYER_ID%TYPE) RETURN NUMBER IS V_AVG...
1. select calc_player_avg(player_id) from player_bat_stat; -b. you cant call a function in this way, in this way you can call a procedure, because function must return a value, to call a function using execute command you should declare a bind variab
More