[Jan 19, 2024] Fully Updated 1Z0-149 Dumps - 100% Same Q&A In Your Real Exam
Latest 1Z0-149 Exam Dumps - Valid and Updated Dumps
NEW QUESTION # 21
Which two blocks of code display a numerical zero? (Choose two.)
- A.
- B.
- C.
- D.
Answer: A,C
NEW QUESTION # 22
Which two statements are true about using the OR REPLACE clause when creating named subprograms? (Choose two.)
- A. Function based indexes remain usable when replacing the function on which the index depends.
- B. This clause can be used only for procedures and functions.
- C. Object privileges to execute a replaced function must be regranted to those users who had the privilege.
- D. Object privileges to execute a replaced function are retained by those users who had the privileges.
- E. A function definition can be modified without dropping and re-creating it.
Answer: D,E
NEW QUESTION # 23
Examine these statements:
Which is true?
- A. It will result in a successful compilation because objects referenced in an ACCESSIBLE BY clause are not checked at compile time.
- B. It will result in a compilation error for protected_proc because calling_proc does not exist.
- C. With adequate privileges, PROTECTED_PROC procedure can be called by other programs apart from CALLING_PROC.
- D. It will result in a compilation error for protected_proc because calling_proc must be prefixed with the schema name.
Answer: B
NEW QUESTION # 24
Which two are true about INDEX-BY tables? (Choose two.)
- A. The index can be integer or string.
- B. The index can be integer only.
- C. INDEX-BY table types can be created both with the CREATE TYPE statement and in PL/SQL blocks.
- D. INDEX-BY table types can be created in PL/SQL blocks only.
- E. INDEX-BY table types can be created with the CREATE TYPE statement.
Answer: A,D
NEW QUESTION # 25
Which is the correct method to implement a local subprogram in an anonymous block?
- A.
- B.
- C.
- D.
Answer: B
NEW QUESTION # 26
Which three are true about functions and procedures? (Choose three.)
- A. Both can have only constants as actual parameters for IN mode parameters.
- B. Both can be invoked from within SQL statements.
- C. In a procedure the RETURN statement cannot specify an expression.
- D. The ACCESSIBLE BY clause can be used only for procedures.
- E. In a function, every execution path must lead to a RETURN statement.
- F. In a function every RETURN statement must specify an expression.
Answer: C,E,F
NEW QUESTION # 27
Which three are true about the NOCOPY hint, the PARALLEL ENABLE hint, and the DETERMINISTIC clause? (Choose three.)
- A. A function is deterministic if it always returns the same result for a specific combination of input values.
- B. The PARALLEL_ENABLE clause can be used only in the CREATE FUNCTION statement.
- C. A deterministic function's results always depend on the state of session variables.
- D. The PARALLEL_ENABLE clause can be specified for a nested function.
- E. A function defined with the PARALLEL_ENABLE clause may be executed in parallel in a SELECT statement or a subquery in a DML statement.
- F. The NOCOPY hint asks the compiler to pass the actual parameters by reference.
- G. The NOCOPY hint asks the compiler to pass the actual parameters by value.
Answer: A,E,F
NEW QUESTION # 28
Examine the SH.PRODUCTS table:
A row exists in SH.PRODUCTS with PDT_ID = 1.
Now, examine this code and output executed by SH:
Now, examine this block of code:
Which error message(s) does it display on execution by user SH?
- A. Error in inner block
- B. Error in inner block Error in outer block Error in calling block
- C. Error in inner block Error in calling block
- D. Error in inner block Error in outer block
Answer: A
NEW QUESTION # 29
Which three statements can process a dynamic multi-row query? (Choose three.)
- A. OPEN
- B. CLOSE
- C. FETCH
- D. OPEN-FOR
- E. DECLARE
- F. WHEN
- G. INTO
Answer: B,C,D
NEW QUESTION # 30
Which three are true about user-defined functions? (Choose three.)
- A. They can be used in CONNECT BY and START WITH clauses.
- B. They can appear in the select list of a SELECT statement.
- C. They must be defined with at least one parameter.
- D. They can be executed as standalone commands.
- E. They can be used in ORDER BY and GROUP BY clauses.
- F. They need not return any values.
- G. Functions can call only other functions.
Answer: A,B,E
NEW QUESTION # 31
Examine this code:
ALTER SESSION SET plsql_warnings='ENABLE:ALL';
/
You compile this function:
What happens when the function is created with PLSQL_WARNINGS set to 'ENABLE: ALL'?
- A. There are no compilation warnings or errors.
- B. It fails compilation.
- C. A performance compilation warning is generated.
- D. An information compilation warning is generated.
- E. A severe compilation warning is generated.
Answer: C
NEW QUESTION # 32
Which two are valid MODIFIER values for the PLSQL_WARNINGS parameter? (Choose two.)
- A. ALL
- B. SEVERE
- C. DISABLE
- D. ERROR
- E. ENABLE
Answer: A,B
NEW QUESTION # 33
Examine this DECLARE section:
Which two lines are valid? (Choose two.)
- A. line 5
- B. line 2
- C. line 4
- D. line 7
- E. line 6
- F. line 3
Answer: A,B
NEW QUESTION # 34
Which two are true about implicit data type conversion? (Choose two.)
- A. Implicit data type conversion can negatively impact performance.
- B. ROWIDS are always implicitly converted to a number when used in a query.
- C. Comparison between character value and a number value always implicitly converts the character value to the number data type.
- D. RAW data types are always implicitly converted to a CLOB when used in a query.
- E. Collections can be implicitly converted to records.
Answer: A,C
NEW QUESTION # 35
Examine this statement which is submitted for compilation:
Which three are true? (Choose three.)
- A. This is a PACKAGE specification. A PACKAGE BODY is needed to use this.
- B. Initialization of min_bal can be done while using this packaged constant in another program.
- C. This is BODILESS PACKAGE. A PACKAGE BODY is not required to use this.
- D. Initialization of loan_amount can be done while using this packaged variable in another program.
- E. This will not compile successfully because the min_bal constant must be initialized.
- F. This program unit will compile successfully.
- G. This will not compile successfully because the loan_amount variable is declared NOT NULL but lacks an initialization assignment.
Answer: C,E,G
NEW QUESTION # 36
Examine these facts:
Table EMP exists in schema USERA with columns SALARY and EMP_ID.
EMP_ID is the primary key with values ranging from 1 to 100.
USERA now executes these statements successfully:
USERA then grants execute privilege on procedure MYPROC to USERB.
USERB exists in the database identified by pdb1 but does not have select privilege on USERA.EMP.
USERB now executes these statements:
conn userB/userB@pdb1
execute userA.myproc;
Which is true?
- A. It results in an error because USERB doesn't have select privilege on USERA.EMP.
- B. It executes successfully.
- C. It results in an error because Authid Current_User is missing from MYPROC.
- D. It results in an error because Authid Definer is missing from MYPROC.
Answer: B
NEW QUESTION # 37
Which two are true about the PLSQL_CODE_TYPE parameter? (Choose two.)
- A. Changing the parameter setting automatically changes the setting for existing PL/SQL library units.
- B. The default value is NATIVE.
- C. If set to NATIVE, programs are stored in platform dependent machine code.
- D. It can use the REUSE SETTINGS clause to recompile a program unit without changing to the current session settings.
- E. If set to NATIVE, programs are stored in a PL/SQL bytecode format.
Answer: C,D
NEW QUESTION # 38
Which two are true about collections and RECORD types? (Choose two.)
- A. All collections and RECORD types can be stored in table columns.
- B. VARRAYS, nested tables and each field in %ROWTYPE type variables have a default value of null.
- C. Collections and RECORD types are always dense.
- D. All collections and RECORD types can be defined in PL/SQL blocks, packages, or at the schema level.
- E. Only associative arrays and nested tables can have elements of RECORD type.
- F. A variable of RECORD type can contain fields of another RECORD type or any collection type.
Answer: B,E
NEW QUESTION # 39
Which statement is true about user-defined records?
- A. Field names must match selected column names.
- B. They can be returned from a function.
- C. The number of fields must match the number of columns in a table.
- D. Field types must match column types.
Answer: C
NEW QUESTION # 40
Which two statements are true about the RETURNING clause when used with DML? (Choose two.)
- A. The RETURNING clause can be used for remote or parallel deletes.
- B. The RETURNING INTO clause and bulk binds may not be used together.
- C. The RETURNING INTO clause returns column values for rows affected by DML statements.
- D. The RETURNING INTO clause can be used with DML that affects multiple rows, if the BULK COLLECT clause is used.
- E. When using the RETURNING INTO clause, the data returned can be only single column or expression.
Answer: A,D
NEW QUESTION # 41
......
Free Sales Ending Soon - 100% Valid 1Z0-149 Exam: https://www.briandumpsprep.com/1Z0-149-prep-exam-braindumps.html
Verified 1Z0-149 Exam Questions Certain Success: https://drive.google.com/open?id=1m_NGGJLL2hFagMPJHgRk8poYnoFjwaKW
