Latest 2024 Realistic Verified 1Z0-149 Dumps - 100% Free 1Z0-149 Exam Dumps
Get 2024 Updated Free Oracle 1Z0-149 Exam Questions and Answer
Information about the Salary of an Oracle 1Z0-149 Certified professional:
The salary of an Oracle 1Z0-149 certified expert depends on his/her experience. The salary for the Oracle Database Administrator is very high after passing with the help of the 1Z0-149 exam dumps. Moreover, the certification helps in getting better job offers. The certified professionals are paid more than the non-certified professionals. The average salary of an Oracle 1Z0-149 Certified professional is:
- In the UK: 70,000 - 80,000 GBP
- In the United States: 90,000 - 100,000 USD
- In India: 80,000 - 90,000 INR
- In China: 30,000 - 40,000 CNY
NEW QUESTION # 31
Which two statements are true about using the OR REPLACE clause when creating named subprograms? (Choose two.)
- A. Object privileges to execute a replaced function must be regranted to those users who had the privilege.
- B. This clause can be used only for procedures and functions.
- C. A function definition can be modified without dropping and re-creating it.
- D. Function based indexes remain usable when replacing the function on which the index depends.
- E. Object privileges to execute a replaced function are retained by those users who had the privileges.
Answer: C,E
NEW QUESTION # 32
Examine these statements which execute successfully:
Which anonymous block executes successfully?
- A.
- B.
- C.
- D.
Answer: B
NEW QUESTION # 33
Examine these statements:
Which is true?
- A. It will result in a compilation error for protected_proc because calling_proc does not exist.
- B. It will result in a compilation error for protected_proc because calling_proc must be prefixed with the schema name.
- C. It will result in a successful compilation because objects referenced in an ACCESSIBLE BY clause are not checked at compile time.
- D. With adequate privileges, PROTECTED_PROC procedure can be called by other programs apart from CALLING_PROC.
Answer: A
NEW QUESTION # 34
Examine this table definition in the SH schema.
A row with PDT_ID = 1 exists. Which two blocks of code will execute successfully by user SH and give the same output? (Choose two.)
- A.
- B.
- C.
- D.
Answer: A,D
NEW QUESTION # 35
Sequence S and table PRODUCTS exist in your schema.
Examine the table description:
Now, examine this block of code:
Which two lines each result in a compilation error? (Choose two.)
- A. line 7
- B. line 2
- C. line 6
- D. line 3
- E. line 1
- F. line 8
Answer: C,E
NEW QUESTION # 36
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: D
NEW QUESTION # 37
Examine this statement which is submitted for compilation:
Which three are true? (Choose three.)
- A. This will not compile successfully because the min_bal constant must be initialized.
- B. This program unit will compile successfully.
- C. Initialization of min_bal can be done while using this packaged constant in another program.
- D. This is a PACKAGE specification. A PACKAGE BODY is needed to use this.
- E. Initialization of loan_amount can be done while using this packaged variable in another program.
- F. This will not compile successfully because the loan_amount variable is declared NOT NULL but lacks an initialization assignment.
- G. This is BODILESS PACKAGE. A PACKAGE BODY is not required to use this.
Answer: A,F,G
NEW QUESTION # 38
Which three are true about PL/SQL subprograms? (Choose three.)
- A. Reuse of parsed PL/SQL code from the shared SQL area reduces parsing overhead.
- B. A subprogram's session state is retained even if any of the session's instantiated subprograms are invalidated and revalidated.
- C. Users granted execute privilege on a procedure compiled with definer's rights require grants to access objects belonging to the definer that are referenced in the procedure.
- D. Results of a subprogram can be cached in the SGA such that sessions connected to the same instance can reuse these results when available.
- E. A PL/SQL procedure can invoke an external code block written in a different programming language.
- F. Host variables can be referenced inside any PL/SQL subprogram.
- G. Subprograms are cached by default and shared among users, thereby reducing memory requirements.
Answer: A,E,G
NEW QUESTION # 39
Examine this table in the SH schema:
Now, examine this code:
Which two changes are required to ensure that PDT_REPORT executes successfully? (Choose two.)
- A. In line 1, change IN OUT mode to IN mode.
- B. In line 6, replace P_PDT_PRICE parameter name with CUR_PRICE.
- C. In line 1, add the default parameter DEFAULT 2000.
- D. In line 2, change IN OUT mode to IN mode.
- E. In line 3, replace CUR_PRICE with P_PDT_PRICE in the query condition.
- F. In line 2, add the default parameter DEFAULT 2000.
Answer: C,D
NEW QUESTION # 40
Examine the structure of the ora1.depts table:
Now, examine these statements issued by user ora1 which execute successfully:
Create or replace view dep_vu as select * from depts;
Alter table depts add dep_email varchar2(20);
Finally, examine this block of code executed by user ora1:
Which is true?
- A. It will run successfully producing a result of 4.
- B. DEP_VU must be manually recompiled to successfully run this code.
- C. It will run successfully producing a result of 5.
- D. It will result in an error because table depts has been altered.
Answer: A
NEW QUESTION # 41
Which three are true about functions and procedures? (Choose three.)
- A. Both can have only constants as actual parameters for IN mode parameters.
- B. In a function, every execution path must lead to a RETURN statement.
- C. In a procedure the RETURN statement cannot specify an expression.
- D. Both can be invoked from within SQL statements.
- E. The ACCESSIBLE BY clause can be used only for procedures.
- F. In a function every RETURN statement must specify an expression.
Answer: B,C,F
NEW QUESTION # 42
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 execute successfully only if PriceList is removed from the DECLARE section and defined as a standalone collection type.
- C. It will fail only at line 7.
- D. It will execute successfully only if PriceList is defined as an associative array in the package and anonymous block.
Answer: C
NEW QUESTION # 43
Which is true about the PLSCOPE_SETTINGS parameter?
- A. It is deprecated in Oracle 12c.
- B. It can be used to control a user's privileges on PL/SQL objects at run time.
- C. It can be used to control execution of specific portions of the PL/SQL code conditionally.
- D. It can be used to obtain information about all identifiers when compiling a procedure.
Answer: D
NEW QUESTION # 44
Which three statements are true about Implicit Cursor and Explicit Cursor? (Choose three.)
- A. %Isopen is always false in Implicit Cursor.
- B. %Isopen is always false in Explicit Cursor.
- C. %Isopen, %Rowcount, %Notfound, and %Found are the attributes of Explicit Cursor.
- D. %Isopen, %Type, %Notfound, and %Found are the attributes of Explicit Cursor.
- E. %Isopen, %Rowtype, %Notfound, and %Found are the attributes of Explicit Cursor.
- F. Explicit cursor can return more than one record.
- G. Implicit cursor returns only one record.
Answer: A,E,F
NEW QUESTION # 45
SERVEROUTPUT is enabled.
Which code block will display the values from 1 to 10 in descending order?
- A.
- B.
- C.
- D.
Answer: C
NEW QUESTION # 46
The SH schema contains the PRODUCTS table with column PDT_NAME defined as VARCHAR2(10).
Which two blocks of code execute successfully when invoked by user SH? (Choose two.)
- A.
- B.
- C.
- D.
- E.
Answer: A,C
NEW QUESTION # 47
Examine these statements:
Which two are true? (Choose two.)
- A. The bank_activity_proc will not compile because of the commit.
- B. Only one table will have a row inserted and committed.
- C. The transaction for the bank_activity_proc is independent of the bank_transaction_proc.
- D. Neither table will have a row inserted and committed.
- E. Both tables will have a row inserted and committed.
Answer: B,C
NEW QUESTION # 48
Examine this DECLARE section:
Which line will cause an error upon execution?
- A. line 5
- B. line 2
- C. line 4
- D. line 6
- E. line 3
Answer: D
NEW QUESTION # 49
......
1Z0-149 Dumps PDF and Test Engine Exam Questions: https://www.actualcollection.com/1Z0-149-exam-questions.html
Get New 1Z0-149 Certification – Valid Exam Dumps Questions: https://drive.google.com/open?id=1lqeZ-HeEF_407vltZ8ilie2IntHewL9b