Oracle 1z0-149 Exam Practice Questions (P. 1)
- Full Access (65 questions)
- Six months of Premium Access
- Access to one million comments
- Seamless ChatGPT Integration
- Ability to download PDF files
- Anki Flashcard files for revision
- No Captcha & No AdSense
- Advanced Exam Configuration
Question #1
- APACKAGESMost Voted
- BVARIABLESMost Voted
- CANONYMOUS BLOCK
- DTRIGGER BODY
- EDATABASE LINKS
AB

Hi! Do you need help with this question ?
- Why isn't the A the right answer?
- Traducir la pregunta al español
Contributor get free access to an augmented ChatGPT 4 trained with the latest IT Questions.
Question #2
- AThe ACCESSIBLE BY clause can be used only for procedures.
- BIn a function, every execution path must lead to a RETURN statement.
- CBoth can have only constants as actual parameters for IN mode parameters.
- DBoth can be invoked from within SQL statements.
- EIn a procedure the RETURN statement cannot specify an expression.
- FIn a function every RETURN statement must specify an expression.
BEF

Hi! Do you need help with this question ?
- Why isn't the A the right answer?
- Traducir la pregunta al español
Contributor get free access to an augmented ChatGPT 4 trained with the latest IT Questions.
Question #3
- APL/SQL code can be compiled and executed based on different versions of the operating system.
- BPL/SQL code can be compiled and executed based on different versions of Oracle.
- CIt is newer syntax that works the same way as 'IF , ELSEIF , ELSE, and END IF'.
- DConditional compilation is disabled by default.
- EThe PL/SQL compiler can conditionally include selected parts of a program.
BE

Hi! Do you need help with this question ?
- Why isn't the A the right answer?
- Traducir la pregunta al español
Contributor get free access to an augmented ChatGPT 4 trained with the latest IT Questions.
Question #4
- AThe PARALLEL_ENABLE clause can be used only in the CREATE FUNCTION statement.
- BThe NOCOPY hint asks the compiler to pass the actual parameters by reference.
- CA deterministic function's results always depend on the state of session variables.
- DThe NOCOPY hint asks the compiler to pass the actual parameters by value.
- EA function is deterministic if it always returns the same result for a specific combination of input values.
- FThe PARALLEL_ENABLE clause can be specified for a nested function.
- GA function defined with the PARALLEL_ENABLE clause may be executed in parallel in a SELECT statement or a subquery in a DML statement.
BEG

Hi! Do you need help with this question ?
- Why isn't the A the right answer?
- Traducir la pregunta al español
Contributor get free access to an augmented ChatGPT 4 trained with the latest IT Questions.
Question #5
- AThe index can be integer or string.Most Voted
- BThe index can be integer only.
- CINDEX-BY table types can be created in PL/SQL blocks only.Most Voted
- DINDEX-BY table types can be created both with the CREATE TYPE statement and in PL/SQL blocks.
- EINDEX-BY table types can be created with the CREATE TYPE statement.
AC

Hi! Do you need help with this question ?
- Why isn't the A the right answer?
- Traducir la pregunta al español
Contributor get free access to an augmented ChatGPT 4 trained with the latest IT Questions.
All Pages