Question 1

View the Exhibit and examine the structure of the customer table. 2021-06-04-19-34-43-bbbe9e3ac276119b5b1b2648c6325d40 You create the following trigger to ensure that customers belonging to category "A" or "B"in the customer table can have a credit limit of more than 8000.What is the outcome?

Options :

A : The trigger is fired, a message is displayed, and the update is successful

B : The trigger is fired and a message is displayed, but the update is rolled back.

C : The trigger is not fired because the when clause should be used to specify the condition, however, the update is successful.

D : The trigger is not fired because column names must be specified with the update event to identify which columns must be changed to cause the trigger to fire, however, the update is successful.

Answer: A

Question 2

Which of the following is not true about the Constructors?

Options :

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 3

Examine the following DECLARE section of PL/SQL block:

Which line in the above declaration would generate an error?

Options :

A : Line 2

B : Line 3

C : Line 4

D : Line 5

E : Line 6

Answer: A

Question 4

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

2021-06-04-19-34-43-bbbe9e3ac276119b5b1b2648c6325d40

You create the following trigger to ensure that customers belonging to category "A" or "B"
in the customer table can have a credit limit of more than 8000.

What is the outcome?

Options :

A : The trigger is fired, a message is displayed, and the update is successful

B : The trigger is fired and a message is displayed, but the update is rolled back.

C : The trigger is not fired because the when clause should be used to specify the condition, however, the update is successful.

D : The trigger is not fired because column names must be specified with the update event to identify which columns must be changed to cause the trigger to fire, however, the update is successful.

Answer: A

Question 5

In which of the following scenarios would you recommend using associative arrays?

Options :

A : When you want to retrieve an entire row from a table and perform calculations

B : When you know the number of elements in advance and the elements are usually accessed sequentially

C : When you want to create a separate lookup table with multiple entries for each row of the main table, and access it through join queries

D : When you want to create a relatively small lookup table, where the collection can be constructed on memory each time a subprogram is invoked

Answer: D

Free 1Z0-149 Mock Exam – Practice Online Confidently

Buying Options: