20:00

PDF|

Guide for Oracle Database 19c: Program with PL/SQL

Quiz Oracle Database 19c: Program with PL/SQL

Free Test
/ 10

Quiz

1/10
Which two are true about using the ACCESSIBLE BY clause? (Choose two.)
Select the answer
2 correct answers
A.
It can be used in the declaration of object types.
B.
It must be specified in the heading of a package specification.
C.
The check is enforced by this clause for direct access and access through dynamic SQL.
D.
It can be used for individual procedures and functions declared in a package specification.
E.
It must be specified in the heading of a package body.

Quiz

2/10
Which two PL/SQL elements can be deprecated using the DEPRECATE pragma? (Choose two.)
Select the answer
2 correct answers
A.
PACKAGES
B.
VARIABLES
C.
ANONYMOUS BLOCK
D.
TRIGGER BODY
E.
DATABASE LINKS

Quiz

3/10
Which three are true about functions and procedures? (Choose three.)
Select the answer
3 correct answers
A.
The ACCESSIBLE BY clause can be used only for procedures.
B.
In a function, every execution path must lead to a RETURN statement.
C.
Both can have only constants as actual parameters for IN mode parameters.
D.
Both can be invoked from within SQL statements.
E.
In a procedure the RETURN statement cannot specify an expression.
F.
In a function every RETURN statement must specify an expression.

Quiz

4/10
Which two are true about Conditional Compilation in PL/SQL using $IF, $ELSE, $END, and $ERROR?
(Choose two.)
Select the answer
2 correct answers
A.
PL/SQL code can be compiled and executed based on different versions of the operating system.
B.
PL/SQL code can be compiled and executed based on different versions of Oracle.
C.
It is newer syntax that works the same way as 'IF , ELSEIF , ELSE, and END IF'.
D.
Conditional compilation is disabled by default.
E.
The PL/SQL compiler can conditionally include selected parts of a program.

Quiz

5/10
Which three are true about the NOCOPY hint, the PARALLEL ENABLE hint, and the DETERMINISTIC
clause? (Choose three.)
Select the answer
3 correct answers
A.
The PARALLEL_ENABLE clause can be used only in the CREATE FUNCTION statement.
B.
The NOCOPY hint asks the compiler to pass the actual parameters by reference.
C.
A deterministic function's results always depend on the state of session variables.
D.
The NOCOPY hint asks the compiler to pass the actual parameters by value.
E.
A function is deterministic if it always returns the same result for a specific combination of input values.
F.
The PARALLEL_ENABLE clause can be specified for a nested function.
G.
A function defined with the PARALLEL_ENABLE clause may be executed in parallel in a SELECT statement or a subquery in a DML statement.

Quiz

6/10
Which two are true about INDEX-BY tables? (Choose two.)
Select the answer
2 correct answers
A.
The index can be integer or string.
B.
The index can be integer only.
C.
INDEX-BY table types can be created in PL/SQL blocks only.
D.
INDEX-BY table types can be created both with the CREATE TYPE statement and in PL/SQL blocks.
E.
INDEX-BY table types can be created with the CREATE TYPE statement.

Quiz

7/10
Which three are true about anonymous blocks and subprograms? (Choose three.)
Select the answer
3 correct answers
A.
Named subprograms cannot be called from other packages.
B.
PROCEDURE subprograms can accept parameters.
C.
A FUNCTION subprogram must return one or more values.
D.
Anonymous blocks cannot use packaged variables.
E.
Named subprograms are stored in the database server.
F.
Anonymous blocks must always start with the Declare keyword.
G.
FUNCTION subprograms must be called and passed through one or more parameters.

Quiz

8/10
Which two statements are true about using the OR REPLACE clause when creating named
subprograms? (Choose two.)
Select the answer
2 correct answers
A.
Function based indexes remain usable when replacing the function on which the index depends.
B.
Object privileges to execute a replaced function must be regranted to those users who had the privilege.
C.
This clause can be used only for procedures and functions.
D.
A function definition can be modified without dropping and re-creating it.
E.
Object privileges to execute a replaced function are retained by those users who had the privileges.

Quiz

9/10
Examine the SH.PRODUCTS table:

Certification Exam Oracle Database 19c: Program with PL/SQL Oracle Oracle-1Z0-149 1-913532190

A row exists in SH.PRODUCTS with PDT_ID = 1.
Now, examine this code and output executed by SH:
Certification Exam Oracle Database 19c: Program with PL/SQL Oracle Oracle-1Z0-149 2-2499309658



Now, examine this block of code:

Certification Exam Oracle Database 19c: Program with PL/SQL Oracle Oracle-1Z0-149 3-676168674

Which error message(s) does it display on execution by user SH?
Select the answer
1 correct answer
A.
Error in inner block
B.
Error in inner block Error in outer block
C.
Error in inner block Error in calling block
D.
Error in inner block Error in outer block Error in calling block

Quiz

10/10
Which two blocks of code display a numerical zero? (Choose two.)
Select the answer
2 correct answers
A.
Certification Exam Oracle Database 19c: Program with PL/SQL Oracle Oracle-1Z0-149 4-3047327022
B.
Certification Exam Oracle Database 19c: Program with PL/SQL Oracle Oracle-1Z0-149 6-3562327720
C.
Certification Exam Oracle Database 19c: Program with PL/SQL Oracle Oracle-1Z0-149 5-2251628181
D.
Certification Exam Oracle Database 19c: Program with PL/SQL Oracle Oracle-1Z0-149 7-2747082630
Looking for more questions?Buy now

Oracle Database 19c: Program with PL/SQL Practice test unlocks all online simulator questions

Thank you for choosing the free version of the Oracle Database 19c: Program with PL/SQL practice test! Further deepen your knowledge on Oracle Simulator; by unlocking the full version of our Oracle Database 19c: Program with PL/SQL Simulator you will be able to take tests with over 65 constantly updated questions and easily pass your exam. 98% of people pass the exam in the first attempt after preparing with our 65 questions.

BUY NOW

What to expect from our Oracle Database 19c: Program with PL/SQL practice tests and how to prepare for any exam?

The Oracle Database 19c: Program with PL/SQL Simulator Practice Tests are part of the Oracle Database and are the best way to prepare for any Oracle Database 19c: Program with PL/SQL exam. The Oracle Database 19c: Program with PL/SQL practice tests consist of 65 questions and are written by experts to help you and prepare you to pass the exam on the first attempt. The Oracle Database 19c: Program with PL/SQL database includes questions from previous and other exams, which means you will be able to practice simulating past and future questions. Preparation with Oracle Database 19c: Program with PL/SQL Simulator will also give you an idea of the time it will take to complete each section of the Oracle Database 19c: Program with PL/SQL practice test . It is important to note that the Oracle Database 19c: Program with PL/SQL Simulator does not replace the classic Oracle Database 19c: Program with PL/SQL study guides; however, the Simulator provides valuable insights into what to expect and how much work needs to be done to prepare for the Oracle Database 19c: Program with PL/SQL exam.

BUY NOW

Oracle Database 19c: Program with PL/SQL Practice test therefore represents an excellent tool to prepare for the actual exam together with our Oracle practice test . Our Oracle Database 19c: Program with PL/SQL Simulator will help you assess your level of preparation and understand your strengths and weaknesses. Below you can read all the quizzes you will find in our Oracle Database 19c: Program with PL/SQL Simulator and how our unique Oracle Database 19c: Program with PL/SQL Database made up of real questions:

Info quiz:

  • Quiz name:Oracle Database 19c: Program with PL/SQL
  • Total number of questions:65
  • Number of questions for the test:50
  • Pass score:80%

You can prepare for the Oracle Database 19c: Program with PL/SQL exams with our mobile app. It is very easy to use and even works offline in case of network failure, with all the functions you need to study and practice with our Oracle Database 19c: Program with PL/SQL Simulator.

Use our Mobile App, available for both Android and iOS devices, with our Oracle Database 19c: Program with PL/SQL Simulator . You can use it anywhere and always remember that our mobile app is free and available on all stores.

Our Mobile App contains all Oracle Database 19c: Program with PL/SQL practice tests which consist of 65 questions and also provide study material to pass the final Oracle Database 19c: Program with PL/SQL exam with guaranteed success. Our Oracle Database 19c: Program with PL/SQL database contain hundreds of questions and Oracle Tests related to Oracle Database 19c: Program with PL/SQL Exam. This way you can practice anywhere you want, even offline without the internet.

BUY NOW