Question 1

A(n) mutator is similar to a partition or area of the physical disk. _________________________

Accepted Answer

tablespace

Question 2

The code fragment ____ would raise an error.
A) DBMS_ALERT.REGISTER( 'new_bid' );
B) DBMS_ALERT.WAITONE( 'new_bid', v_msg, v_status, 600);
C) DBMS_ALERT( 'new_bid', v_msg, v_status, 600);
D) DBMS_ALERT.SIGNAL( 'new_bid', TO_CHAR(:new.bid));

Accepted Answer

The correct syntax of using DBMS_ALERT is DBMS_ALERT.REGISTER to register a new alert. The WAITONE procedure waits for an alert and returns the message, status, and timeout values. SIGNAL procedure signals the occurrence of the alert. The given code fragment DBMS_ALERT( 'new_bid', v_msg, v_status, 600) is incorrect and will raise an error as it does not specify the procedure to be used.

Question 3

TheOPEN FOR method cannot reuse parsed statements. _________________________

Accepted Answer

, EXECUTE IMMEDIATE

Question 4

In the UTL_FILE package, the ____ program unit is used to read a line from a file.
A) FOPEN
B) PUT_LINE
C) GET_LINE
D) FCLOSE

Accepted Answer

The GET_LINE program unit in the UTL_FILE package is used to read a line from a file. FOPEN is used to open a file, PUT_LINE is used to write a line to a file, and FCLOSE is used to close a file. Hence, the correct choice is C.

Question 5

The UTL_HTTP package provides the capability to make Hypertext Transfer Protocol (HTTP) calls from within PL/SQL programs. _________________________

Accepted Answer

UTL_HTTP package does provide the capability to make HTTP calls from within PL/SQL programs.

Question 6

When the SQL statement is built in the PL/SQL block, placeholders with colon prefixes are used to mark where values are supplied at runtime. _________________________

Accepted Answer

Placeholders with colon prefixes are used to mark where values are supplied at runtime when building SQL statements in PL/SQL blocks.

Question 7

The DBMS_ALERT package allows two or more sessions, in the same instance, to communicate. _________________________

Accepted Answer

DBMS_PIPE

Question 8

When executing a stored program, any DBMS_OUTPUT lines are placed in an output buffer, which dumps its contents to the screen when the program has completed execution. _________________________

Accepted Answer

DBMS_OUTPUT lines are placed in an output buffer and are displayed on the screen only after the completion of the stored program.

Question 9

All of the following procedures are included in the DBMS_ALERT package, except ____.
A) REGISTER
B) SIGNAL
C) WAIT
D) WAITONE

Accepted Answer

WAIT is not a procedure in the DBMS_ALERT package.

Question 10

In the UTL_HTTP package, the ____ function is used to retrieve the HTML source from a specified URL.
A) REQUEST_PIECES
B) NOOP
C) RCPT
D) RSET

Accepted Answer

The UTL_HTTP package has a GET_REQUEST function that is used to retrieve the HTML source from a specified URL. OPTION A is not a valid option in this context.

Question 11

A large object (LOB) can hold ____.
A) 1 GB
B) 2 GB
C) 3 GB
D) 4 GB

Accepted Answer

A large object (LOB) can hold up to 4 GB of data. Therefore, the best choice is D, which represents 4 GB.

Question 12

BEGIN
DBMS_OUTPUT.PUT('This');
DBMS_OUTPUT.PUT(' is a');
DBMS_OUTPUT.PUT(' test');
DBMS_OUTPUT.PUT_LINE('This is test2');
DBMS_OUTPUT.PUT('Working?');
END;
The code fragment above is an example of a(n) ____.
A) cursor
B) alert
C) anonymous block
D) trigger

Accepted Answer

The code is an anonymous block, which is a piece of PL/SQL code that can be executed directly without the need for a stored procedure or function. It is typically used for quick tests or one-time scripts.

Question 13

Alerts are transaction based and are sent only if the transaction is committed. _________________________

Accepted Answer

Alerts are triggered only if the transaction is committed. If the transaction is rolled back or not completed, no alerts will be sent.

Question 14

In the DBMS_LOB package, which of the following represents the programs that add, change, or remove the large objects (LOBs)?
A) BFILE
B) mutator
C) observer
D) tablespace

Accepted Answer

The mutators (also referred to as modifiers) are the programs in DBMS_LOB package that add, change, or remove the large objects (LOBs). BFILE is a datatype that allows LOBs to be stored outside of the database, tablespace is a storage location for database objects, and observer is not a term used within the DBMS_LOB package.

Question 15

The programs within the ____ package can be grouped into two sets: mutators and observers.
A) BLOB
B) DBMS_LOB
C) CLOB
D) BFILE

Accepted Answer

The DBMS_LOB package in Oracle provides functions and procedures to operate on large objects (LOBs) such as CLOBs and BLOBs. Within this package, there are mutators (such as empty_blob and writeappend), which modify the LOB data, and observers (such as getlength and instr), which provide information about the LOB data. The other options (A, C, and D) either do not relate to the concept of mutators and observers or are specific to a certain type of LOB.

Question 16

The DBMS_OUTPUT procedure ____ places an end-of-line marker in the buffer.
A) ENABLE
B) PUT_LINE
C) NEW_LINE
D) GET_LINE

Accepted Answer

The DBMS_OUTPUT.NEW_LINE procedure places an end-of-line marker in the buffer, and is used to separate different output lines in the DBMS_OUTPUT buffer.

Question 17

The UTL_LINE package allows access to files that reside on an operating system and are accessible from the database server. _________________________

Accepted Answer

UTL_FILE

Question 18

All of the following programs are available in the UTL_FILE package, except ____.
A) FOPEN
B) RSET
C) PUT_LINE
D) GET_LINE

Accepted Answer

The UTL_FILE package includes the procedures FOPEN, PUT_LINE, and GET_LINE to manipulate files in PL/SQL. However, RSET is not a valid procedure in the UTL_FILE package.

Question 19

Native dynamic SQL is simpler to code and processes statements more efficiently than the DBMS_SQL package. _________________________

Accepted Answer

Native dynamic SQL uses SQL statements directly in PL/SQL code, making it simpler to write and potentially more efficient than using the DBMS_SQL package. However, there may still be cases where the DBMS_SQL package is preferred, such as when dealing with dynamic SQL that cannot be expressed directly in SQL statements.

Question 20

The ____ package can be used to analyze the HTML source of Web sites in order to accomplish tasks such as tracking competitor pricing on products, gathering pricing for raw materials, and collecting relevant business news for a particular industry.
A) UTL_HTTP
B) UTL-SMTP
C) DBMS_ALERT
D) DBMS_PIPE

Accepted Answer

The UTL_HTTP package in Oracle can be used to analyze the HTML source of Web sites. It provides functionality to perform HTTP requests and receive responses, which can then be parsed and analyzed to extract the relevant information. This can be useful for tasks such as tracking competitor pricing, gathering pricing for raw materials, and collecting industry news. The other options (UTL-SMTP, DBMS_ALERT, and DBMS_PIPE) are not relevant for this particular task.

Quiz 10: Oracle-Supplied Packages, Dynamic SQL, and Hiding Source Code

A(n) mutator is similar to a partition or area of the physical disk. _________________________

The code fragment ____ would raise an error.

TheOPEN FOR method cannot reuse parsed statements. _________________________

In the UTL_FILE package, the ____ program unit is used to read a line from a file.

The UTL_HTTP package provides the capability to make Hypertext Transfer Protocol (HTTP) calls from within PL/SQL programs. _________________________

When the SQL statement is built in the PL/SQL block, placeholders with colon prefixes are used to mark where values are supplied at runtime. _________________________

The DBMS_ALERT package allows two or more sessions, in the same instance, to communicate. _________________________

When executing a stored program, any DBMS_OUTPUT lines are placed in an output buffer, which dumps its contents to the screen when the program has completed execution. _________________________

All of the following procedures are included in the DBMS_ALERT package, except ____.

In the UTL_HTTP package, the ____ function is used to retrieve the HTML source from a specified URL.

A large object (LOB) can hold ____.

BEGIN DBMS_OUTPUT.PUT('This') ; DBMS_OUTPUT.PUT(' is a') ; DBMS_OUTPUT.PUT(' test') ; DBMS_OUTPUT.PUT_LINE('This is test2') ; DBMS_OUTPUT.PUT('Working?') ; END; The code fragment above is an example of a(n) ____.

Alerts are transaction based and are sent only if the transaction is committed. _________________________

In the DBMS_LOB package, which of the following represents the programs that add, change, or remove the large objects (LOBs) ?

The programs within the ____ package can be grouped into two sets: mutators and observers.

The DBMS_OUTPUT procedure ____ places an end-of-line marker in the buffer.

The UTL_LINE package allows access to files that reside on an operating system and are accessible from the database server. _________________________

All of the following programs are available in the UTL_FILE package, except ____.

Native dynamic SQL is simpler to code and processes statements more efficiently than the DBMS_SQL package. _________________________

The ____ package can be used to analyze the HTML source of Web sites in order to accomplish tasks such as tracking competitor pricing on products, gathering pricing for raw materials, and collecting relevant business news for a particular industry.