2023 Easy Success Oracle 1z1-149 Exam in First Try
Best 1z1-149 Exam Dumps for the Preparation of Latest Exam Questions
The exam consists of 75 multiple-choice questions and has a time limit of 105 minutes. It covers a range of topics, including PL/SQL language fundamentals, programmatic constructs, error handling, and database interaction. Candidates are expected to have a thorough understanding of PL/SQL programming concepts and be able to write efficient, maintainable code that meets business requirements.
NEW QUESTION # 21
Which two are true about INDEX-BY tables? (Choose two.)
- A. INDEX-BY table types can be created both with the CREATE TYPE statement and in PL/SQL blocks.
- B. INDEX-BY table types can be created in PL/SQL blocks only.
- C. INDEX-BY table types can be created with the CREATE TYPE statement.
- D. The index can be integer only.
- E. The index can be integer or string.
Answer: B,E
NEW QUESTION # 22
Examine these statements issued by user SH which execute successfully:
DBMS_OUTPUT.PUT_LINE(p_price(i)); END LOOP; END; END products_pkg; /
Now, examine this anonymous block executed by SH:
Which is true about the anonymous block?
- A. It will fail at lines 6 and 7.
- B. It will fail only at line 7.
- C. It will execute successfully only if PriceList is defined as an associative array in the package and anonymous block.
- D. It will execute successfully only if PriceList is removed from the DECLARE section and defined as a standalone collection type.
Answer: B
NEW QUESTION # 23
Which three are true about DDL triggers? (Choose three.)
- A. They cannot include the WHEN clause.
- B. They fire only when a DDL statement is executed by the owner of the trigger.
- C. They must be created in a disabled state.
- D. They must be created in an enabled state.
- E. They can be fired when a privilege is granted to a user.
- F. They can be fired either before or after a DDL statement executes.
- G. They can be fired when a table is truncated.
Answer: B,F,G
NEW QUESTION # 24
In which type of trigger can :OLD and :NEW identifiers be used?
- A. ROW
- B. AFTER STATEMENT
- C. BEFORE STATEMENT
- D. AFTER SUSPEND
Answer: A
NEW QUESTION # 25
Which is true about counter variables in a FOR loop?
- A. It is accessible outside the body of the loop.
- B. It can be modified in the body of the loop.
- C. It cannot be NULL.
- D. It must explicitly be declared.
Answer: C
NEW QUESTION # 26
Which two are true about collections and RECORD types? (Choose two.)
- A. All collections and RECORD types can be stored in table columns.
- B. A variable of RECORD type can contain fields of another RECORD type or any collection type.
- C. Collections and RECORD types are always dense.
- D. Only associative arrays and nested tables can have elements of RECORD type.
- E. All collections and RECORD types can be defined in PL/SQL blocks, packages, or at the schema level.
- F. VARRAYS, nested tables and each field in %ROWTYPE type variables have a default value of null.
Answer: D,F
NEW QUESTION # 27
Which two are valid MODIFIER values for the PLSQL_WARNINGS parameter? (Choose two.)
- A. SEVERE
- B. DISABLE
- C. ERROR
- D. ENABLE
- E. ALL
Answer: A,E
NEW QUESTION # 28
User ORA41 executes these statements successfully:
Now, examine this statement which is executed successfully by user ORA61 after a successful login:
EXECUTE ora41.update_emp_proc(100,25000);
Which two are true? (Choose two.)
- A. The salary will be changed for employee 100 in the EMPLOYEES table owned by ORA61.
- B. The UPDATE privilege on ORA41.EMPLOYEES is not inherited by ORA61 through the procedure.
- C. No update happens even though the procedure executes successfully.
- D. ORA61 will have been granted the UPDATE privilege explicitly on ORA41.EMPLOYEES before executing the statement.
- E. The salary will be changed for employee 100 in the EMPLOYEES table owned by ORA41.
Answer: A,B
NEW QUESTION # 29
Examine these statements from a block of code:
Which two are true? (Choose two.)
- A. Only the PRICE column can be updated in the PRODUCTS table.
- B. The FOR UPDATE OF clause can be used only if the WHERE CURRENT OF clause is used in the executable part of the block.
- C. An OPEN c1 command will acquire a lock only on the PRICE column in the PRODUCTS table.
- D. The WHERE CURRENT OF clause can be used only if the FOR UPDATE clause is used in the cursor definition.
- E. The lock acquired when executing the OPEN c1 command will be released only after a COMMIT or ROLLBACK statement is issued.
Answer: D,E
NEW QUESTION # 30
Which statement is true about user-defined records?
- A. They can be returned from a function.
- B. Field names must match selected column names.
- 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 # 31
Examine these statements and output:
The procedure is created successfully.
User ora2 has password ora2 in pdb1.
Which script will execute successfully?
- A.
- B.
- C.
- D.
Answer: C
NEW QUESTION # 32
Which three are true regarding code based access control (CBAC)? (Choose three.)
- A. CBAC cannot be used to secure definer's rights.
- B. You can use CBAC to attach database roles to a PL/SQL function, procedure, or package.
- C. CBAC roles can be granted to a program unit only if they are the predefined roles automatically defined by the standard scripts as part of database creation.
- D. In CBAC, the ADMIN and DELEGATE options cannot both be granted to the same user.
- E. CBAC roles can be granted to a program unit only if they are directly granted to its owner.
- F. In a multitenant environment, the DELEGATE option of CBAC cannot be used.
- G. You can use CBAC to attach database roles to a PL/SQL function or procedure only.
Answer: B,D,E
NEW QUESTION # 33
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. A performance compilation warning is generated.
- B. It fails compilation.
- C. A severe compilation warning is generated.
- D. An information compilation warning is generated.
- E. There are no compilation warnings or errors.
Answer: A
NEW QUESTION # 34
Examine these statements:
Which two are true? (Choose two.)
- A. Both tables will have a row inserted and committed.
- B. The bank_activity_proc will not compile because of the commit.
- C. Neither table will have a row inserted and committed.
- D. The transaction for the bank_activity_proc is independent of the bank_transaction_proc.
- E. Only one table will have a row inserted and committed.
Answer: D,E
NEW QUESTION # 35
Which two are true about exception handling? (Choose two.)
- A. Internally defined exceptions can be handled only by the OTHERS exception handler.
- B. User-defined exceptions can be defined in the declarative part of any PL/SQL anonymous block, subprogram, or package.
- C. Only predefined exceptions and user-defined exceptions can have a user-declared name associated with them.
- D. All declared exceptions are raised implicitly by the runtime system.
- E. Predefined exceptions are globally declared in the standard package.
Answer: B,E
NEW QUESTION # 36
Which three are valid PL/SQL variable names? (Choose three.)
- A. yesterday's_date
- B. Number_of_days_between_March_and_April
- C. printer_name#
- D. leap$year
- E. #printer_name
- F. 1to7number
- G. v_fname
Answer: C,D,G
NEW QUESTION # 37
......
1z1-149 Study Material, Preparation Guide and PDF Download: https://testking.practicematerial.com/1z1-149-questions-answers.html
