Oracle 1z1-149 Actual Free Exam Questions & Community Discussion
Which three PL/SQL-only data types can be used in queries and native dynamic SQL issued from PL/SQL in the server? (Choose three.)
Correct Answer: B,D,E
Vote an answer
Which three statements can process a dynamic multi-row query? (Choose three.)
Correct Answer: A,E,G
Vote an answer
Examine these statements from a block of code:
Which two are true? (Choose two.)
Which two are true? (Choose two.)
Correct Answer: B,C
Vote an answer
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.)
Examine the table description:
Now, examine this block of code:
Which two lines each result in a compilation error? (Choose two.)
Correct Answer: C,F
Vote an answer
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 row with PDT_ID = 1 exists. Which two blocks of code will execute successfully by user SH and give the same output? (Choose two.)
Correct Answer: A,D
Vote an answer
Which two are true about implicit data type conversion? (Choose two.)
Correct Answer: D,E
Vote an answer
0
0
0
10