comptia it fundamentals fc0-u51 pdf (1 to 10)


♥♥ 2017 NEW RECOMMEND ♥♥

Free VCE & PDF File for Oracle 1z0-147 Real Exam (Full Version!)

★ Pass on Your First TRY ★ 100% Money Back Guarantee ★ Realistic Practice Exam Questions

Free Instant Download NEW 1z0-147 Exam Dumps (PDF & VCE):
Available on: http://www.certleader.com/1z0-147-dumps.html


1z0-147 Product Description:
Exam Number/Code: 1z0-147 vce
Exam name: oracle9i program with pl/sql
n questions with full explanations
Certification: Oracle Certification
Last updated on Global synchronizing

Instant Access to Free VCE Files: Oracle 1z0-147 oracle9i program with pl/sql

1z0-147 examcollection

Accurate of 1z0-147 practice test materials and discount pack for Oracle certification for IT examinee, Real Success Guaranteed with Updated 1z0-147 pdf dumps vce Materials. 100% PASS oracle9i program with pl/sql exam Today!

2016 May 1z0-147 Study Guide Questions:

Q1. You want to create a PL/SQL block of code that calculates discounts on customer orders. –This code will be invoked from several places, but only within the program unit ORDERTOTAL.

What is the most appropriate location to store the code that calculates the discounts?

A. A stored procedure on the server.

B. A block of code in a PL/SQL library.

C. A standalone procedure on the client machine.

D. A block of code in the body of the program unit ORDERTOTAL.

E. A local subprogram defined within the program unit ORDERTOTAL.

Answer: E


Q2. Examine this procedure:

CREATE OR REPLACE PROCEDURE DELETE_PLAYER

(V_ID IN NUMBER)

IS

BEGIN

DELETE FROM PLAYER

WHERE ID = V_ID;

EXCEPTION

WHEN STATS_EXITS_EXCEPTION

THEN DBMS_OUTPUT.PUT_LINE

('Cannot delete this player, child records exist in PLAYER_BAT_STAT table');

END;

What prevents this procedure from being created successfully?

A. A comma has been left after the STATS_EXIST_EXCEPTION exception.

B. The STATS_EXIST_EXCEPTION has not been declared as a number.

C. The STATS_EXIST_EXCEPTION has not been declared as an exception.

D. Only predefined exceptions are allowed in the EXCEPTION section.

Answer: C


Q3. Which three are true regarding error propagation? (Choose three)

A. An exception cannot propagate across remote procedure calls.

B. An exception raised inside a declaration immediately propagates to the current block.

C. The use of the RAISE; statement in an exception handler reraises the current exception.

D. An exception raised inside an exception handler immediately propagates to the enclosing block.

Answer: ACD


1z0-147  practice test

Abreast of the times comptia it fundamentals fc0-u51:

Q4. Examine this code:

CREATE OR REPLACE PROCEDURE audit_action

(p_who VARCHAR2)

AS

BEGIN

INSERT INTO audit(schema_user) VALUES(p_who);

END audit_action;

/

CREATE OR REPLACE TRIGGER watch_it

AFTER LOGON ON DATABASE

CALL audit_action(ora_login_user)

/

What does this trigger do?

A. The trigger records an audit trail when a user makes changes to the database.

B. The trigger marks the user as logged on to the database before an audit statement is issued.

C. The trigger invoked the procedure audit_action each time a user logs on to his/her schema and adds the username to the audit table.

D. The trigger invokes the procedure audit_action each time a user logs on to the database and adds the username to the audit table.

Answer: D


Q5. The OLD and NEW qualifiers can be used in which type of trigger?

A. Row level DML trigger

B. Row level system trigger

C. Statement level DML trigger

D. Row level application trigger

E. Statement level system trigger

F. Statement level application trigger

Answer: A


Q6. You have a table with the following definition:

CREATE TABLE long_tab

(id NUMBER);

long_col LONG)

You need to convert the LONG_COL column from a LONG data type to a LOB data type. Which statement accomplish this task?

A. ALTER TABLE long_tab

MODIFY (LONG_COL CLOB);

B. EXECUTE dbms_lob.migrate(long_tab, long_col, clob)

C. EXECUTE dbms_manage.lob.migrate(long_tab, long_col, clob)

D. EXECUTE utl_lob.migrate(long_tab, long_col, clob)

E. EXECUTE utl_manage_lob.migrate(long_tab, long_col, clob)

Answer: A


1z0-147  practice test

Pinpoint comptia it fundamentals study guide exam fc0-u51:

Q7. Which type of argument passes a value from a procedure to the calling environment?

A. VARCHAR2

B. BOOLEAN

C. OUT

D. IN

Answer: C


Q8. There is a CUSTOMER table in a schema that has a public synonym CUSTOMER and you are granted all object privileges on it. You have a procedure PROCESS_CUSTOMER that processes customer information that is in the public synonym CUSTOMER table. You have just created a new table called CUSTOMER within your schema.

Which statement is true?

A. Creating the table has no effect and procedure PROCESS_CUSTOMER still accesses data from public synonym CUSTOMER table.

B. If the structure of your CUSTOMER table is the same as the public synonym CUSTOMER table then the procedure PROCESS_CUSTOMER is invalidated and gives compilation errors.

C. If the structure of your CUSTOMER table is entirely different from the public synonym CUSTOMER table then the procedure PROCESS_CUSTOMER successfully recompiles and accesses your CUSTOMER table.

D. If the structure of your CUSTOMER table is the same as the public synonym CUSTOMER table then the procedure PROCESS_CUSTOMER successfully recompiles when invoked and accesses your CUSTOMER table.

Answer: D


Q9. Examine this code:

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 EMP table that results in changing 10 rows.

How many rows are inserted into the AUDIT_TABLE?

A. 1

B. 10

C. None

D. A value equal to the number of rows in the EMP table.

Answer: A


Q10. The creation of which database objects will cause a DDL trigger to fire? (Choose all that apply)

A. Index

B. Cluster 

C. Package 

D. Function

E. Synonyms

F. Dimensions

G. Database links

Answer: ABCDE



see more oracle9i program with pl/sql