Free Online Oracle 1Z0-149 Practice Test

Prepare Your Oracle 1Z0-149 Exam Questions with Free online 1Z0-149 Practice Test. Get Brilliant Oracle Database 19c: Program with PL/SQL Exam Results with Valid 1Z0 149 Exam Dumps.

Page: 1 / 78

Total 389 Questions | Updated On: Apr 23, 2024

Question 1

Which of the following is not true about the Constructors?

A : These are functions that return a new object as its value.

B : Every object has a system defined constructor method.

C : The name of the constructor is same as the object type.

D : None of the above.

Answer: D

Question 2

Which two blocks of code execute successfully?

A : DECLARE SUBTYPE new_one IS BINARY_INTERGER RANGE 0..9;
my_val new_one;
BEGIN my_val :=0;
END;

B : DECLARE SUBTYPE new_string IS VARCHAR2 (5) NOT NULL; my_str_new_string;
BEGIN my_str := abc;
END;

C :

    DECLARE SUBTYPE new_one IS NUMBER (2, 1);
    my_val new_one;
    BEGIN my_val :=12.5;
    END;

D : DECLARE SUBTYPE new_one IS INTEGER RANGE 1..10 NOT NULL;
my_val new_one;
BEGIN my_val :=2;
END;

E : DECLARE SUBTYPE new_one IS NUMBER (1, 0);
my_val new_one;
BEGIN my_val := -1

Answer: A

Question 3

Which data dictionary view contains the list of procedures and functions defined within package specification that you can execute?

A : ALL_SOURCE

B : ALL_DEPENDENCIES

C : ALL_OBJECTS

D : ALL_PROCEDURES

E : ALL_PLSQL_OBJECT_SETTINGS

Answer: D

Question 4

Which two are valid MODIFIER values for the PLSQL_WARNINGS parameter? (Choose two.)

A : DISABLE

B : ENABLE

C : ERROR

D : ALL

E : SEVERE

Answer: A,D

Question 5

View the Exhibit and examine the structure of the EMP table.

2021-06-04-19-29-02-aa50ebaef8605bb516f71bdc2da495c5

Examine the code of the packages that you have created.

You issue the following command:
SQL> DROP PACKAGE manage_emp;
What is the outcome?

A : It drops both the MANAGE_EMP AND EMP__DET packages because of the cascading effect.

B : It drops the MANAGE_EMP package and invalidates only the body for the EMP_DET package.

C : It returns an error and does not drop the MAMAGE_EMP package because of the cascading effect.

D : It drops the MANAGE_EMP package and invalidates both the specification and body for the EMP_DET package.

Answer: B

Page: 1 / 78

Total 389 Questions | Updated On: Apr 23, 2024