Oracle Database 11g Program with PLSQL Practice Set 1

Question - 15 Maximum mark : - 26

Home
All Exams
Oracle Database 11g Program with PLSQL Practice Online Practice Exams
Oracle Database 11g Program with PLSQL Practice Set 1

Which system events can be used to create triggers that fire both at database and schema levels? (Choose all that apply)

AFTER LOGON ✘ AFTER STARTUP ✘ BEFORE SHUTDOWN ✘ AFTER SERVERERROR ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

In which of the following scenarios would you recommend using PL/SQL records?

when you want to retrieve an entire row from a table and perform calculations when you know the number of elements in advance and the elements are usually accessed sequentially when you want to create a separate lookup table with multiple entries for each row of the main table, andaccess it through join queries when you want to create a relatively small lookup table, where the collection can be constructed in memoryeach time a subprogram is invoked

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

Examine the following PL/SQL code:
Which statement is true about the execution of the code if the query in the PL/SQL block returns no rows?

The program abruptly terminates and an exception is raised. ✘ The program executes successfully and the output is No ROWS_FOUND. ✘ The program executes successfully and the query fetches a null value in the V_LNAME variable. ✘ Program executes successfully, fetches a NULL value in the V_LNAME variable and an exception is raised. ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

Consider the following scenario:
Local procedure a calls remote procedure B
Procedure A was compiled at 8 AM.
Procedure A was modified and recompiled at 9 AM.
Remote procedure B was later modified and recompiled at 11 AM.
The dependency mode is set to timestamp.
Which statement correctly describes what happens when procedure A is invoked at 1 PM?

Procedure A is invalidated and recompiled immediately. ✘ There is no effect on procedure A and it runs successfully. ✘ Procedure B is invalidated and recompiled again when invoked. ✘ Procedure A is invalidated and recompiles when invoked the next time. ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

Examine the following snippet of code from the DECLARE section of PL/SQL DECLARE "First Test, FirstPass" - www.lead2pass.com 9 Oracle 1Z0-144 Exam Cut_name VERCHAR2 (20) NOT NULL := `tom jones': Same_name cut_name\TYPE: Which statement is correct about the above snippets of code?

The variable inherits only the data type from the CUT_NAME variable. The same_name variable inherits only the data type and default value from the CUT_NAME variable. The 3ake_nake variable inherits the data type, constraint, and default value from the CUT_NAME variable. The 3ake_nake variable inherits only the data type and constraint from the CUT_NAME variable resulting inan error

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

Examine the following package specification.
SQL>CREATE OR REPLACE PACKAGE emp_pkf IS
PROCEDURE search_emp (empdet NUMBER);
PROCEDURE search_emp (empdet DATE);
PROCEDURE search_emp (empdet NUMBER); RETURN VERCHAR2
PROCEDURE search_emp (empdet NUMBER); RETURN DATE
END emp_pkg
The package is compiled successfully
Why mould it generate an error at run tune?

Because function can not be overload ✘ Because function can not differ only in return type. ✘ Because all the functions and procedures In the package cannot have the same number of parameters withthe same parameter name ✘ Because the search EMP (EMPDET NUMBER) procedure and the SEARCH_DEPT (EMPDET NUMBER)can not have identical parameter names and data types ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

Which tasks must be performed during the installation of the UTL_MAIL package? "First Test, First Pass" - www.lead2pass.com 10 Oracle 1Z0-144 Exam (Choose all that apply.)

setting the UTL_FILE_DIR initialization parameter running the UTLMAIL.SQL and prvtmail.plb scripts setting the SMTP_OUT_SERVER initialization parameter using the CREATE DIRECTORY statement to associate an alias with an operating system directory granting read and WRITE privileges to control the type of access to files in the operating system

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

Examine the following partial declare section from a block of PL/SQL code Which line(s) in the above code are NOT valid? (Choose all that apply.)

line 2 line 3 line 4 line 5

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

Identify situations in which the DBMS_SQL package is the only applicable method of processing dynamic SQL. (Choose all that apply.)

When a query returns multiple rows When a column name in a where clause is unknown at compile time. When the number of columns selected in a query is not known until run time When a table needs to be created based on an existing table structure at run time "First Test, First Pass" -www.lead2pass.com 16 Oracle 1Z0-144 Exam When privileges need to be granted to a new user to access an existing schema at run time

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

10.

Identify the scenario in which you would use the current of clause for an update or delete statement to rows fetched from a cursor.

when you want to lock the rows fetched by the cursor ✘ when you want to update or delete the result set without affecting the rows in the table ' ✘ when you want the database not to wait if the requested rows are locked by another user ✘ when you want to ensure that the current rows fetched by the cursor are updated or deleted ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

Prev Next

Congratulations

you have successfully completed the test

Back to Question View Result

Detail Form

We will send your result on your email id and phone no. please fill detail

Name

Email ID Note: Report will be send to the above Email ID

Phone No

Oracle Database 11g Program with PLSQL Practice Set 1

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Congratulations

COMPANY

Products

OTHERS

Partner