Quizack carries 200+ Oracle PL/SQL 10g MCQs that focus on the latest techniques. It means every professional or student is going to get the absolute and latest information. Oracle PL/SQL 10g Multiple choice questions will touch each terminology being used. Now all this practical knowledge will be easy to diagnose through our online simulations.
Use the DBMS_MANAGE_LOB.MIGRATE procedure
Use the UTL_MANAGE_LOB.MIGRATE procedure
Use the DBMS_LOB.MIGRATE procedure
You cannot migrate from a LONG to a LOB data type for a column
Using ALTER TABLE statement
Using ALTER TABLE statement
2. Examine the following code: CREATE OR REPLACE PACKAGE comm_package IS g_comm NUMBER := 10; PROCEDURE reset_comm(p_comm IN NUMBER); END comm_package; User MILLER executes the following code at 9:01am: EXECUTE comm_package.g_comm := 15 User Smith executes the following code at 9:05am: EXECUTE comm_package.g_comm := 20 Which of the following statement is true?
6. Examine the following code: 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' AND '18:00') THEN RAISE_APPLICATION_ERROR (-20500, 'You may insert into the EMPLOYEES table only during business hours.'); END IF; END; / What type of trigger is it?
8. Examine the following package specification: CREATE OR REPLACE PACKAGE combine_all IS v_string VARCHAR2(100); PROCEDURE combine (p_num_val NUMBER); PROCEDURE combine (p_date_val DATE); PROCEDURE combine (p_char_val VARCHAR2, p_num_val NUMBER); END combine_all; / Which overloaded COMBINE procedure declaration can be added to this package specification?
12. 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 (p_sal NUMBER) RETURN NUMBER; END manage_emp; / CREATE OR REPLACE PACKAGE BODY manage_emp IS PROCEDURE update_sal (p_raise_amt NUMBER) IS BEGIN UPDATE emp SET sal = (sal * p_raise_emt) + sal WHERE empno = v_id; END; PROCEDURE insert_emp (p_deptno NUMBER, p_sal NUMBER) IS BEGIN INSERT INTO emp(empno, deptno, sal) VALUES (v_id, p_depntno, p_sal); END insert_emp; PROCEDURE delete_emp IS BEGIN DELETE FROM emp WHERE empno = v_id; END delete_emp; PROCEDURE update_emp IS v_sal NUMBER(10,2); v_raise NUMBER(10, 2); BEGIN SELECT sal INTO v_sal FROM emp WHERE empno = v_id; IF v_sal < 500 THEN v_raise := .05; ELSIP v_sal < 1000 THEN v_raise := .07; ELSE v_raise := .04; END IF; update_sal(v_raise); END update_emp; FUNCTION cal_tax (p_sal NUMBER)RETURN NUMBER IS BEGIN RETURN p_sal * tax_rate; END cal_tax; END manage_emp; / What is the name of the private procedure in this package?
13. Examine the following code: 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_name, 1, 1) || SUBSTR(last_name, 1, 7) ||[email protected] .; UPDATE employees SET email = email_name WHERE employee_id = id; RETURN email_name; END; Which of the following statements removes the function?
14. Examine the following trigger: CREATE OR REPLACE TRIGGER Emp_count AFTER DELETE ON Employee FOR EACH ROW DECLARE n INTEGER; BEGIN SELECT COUNT(*) INTO n FROM employee; DMBS_OUTPUT.PUT_LINE( 'There are now' || n || 'employees'); END; This trigger results in an error after this SQL statement is entered: DELETE FROM Employee WHERE Empno = 7499; How should the error be corrected?
Quizack experts have successfully devised integrated testing tools for the sake of effective online practice. Our practicing tools resemble real exam patterns. So it will be easy for you to diagnose real exam patterns and typical scenarios. Once you are done with PL/SQL test questions and answers online practice, you are welcome to test your knowledge via Oracle PL/SQL online test.
Amazingly, you don’t need to prepare different sets of questions for the sake of different types of assessments. Quizack carries optimal PL/SQL questions for practice that is enough for any type of assessment. This specific pool of questions will prepare you for an online test, IT exam, interview, or Employment assessment at the same time.
Quizack does not only provide relief in terms of optimistic content but in terms of learning options too. Quizack’s users are free to go for online exercise, Oracle PL/SQL 10g PDF, or Quizack App. no one else is going to offer you an adequate number of questions good for any type of assessment along with multiple learning options. Quizack will admire your efforts if you promote its services to your friends and colleagues via social media channels.
Quizack always aims to provide absolute knowledge for the sake of effective learning. So it is always open to suggestions. You will be free to report any type of issue within the content at any time via the contact us page.
Quizack can be the platform where you can demonstrate your skills by contributing some authentic MCQs, Q&A, Explanations, or anything like this. If your contributed information is authentic and accurate, Quizack will award you a badge and your name will be included among its top contributors and experts.