ExamTopics Logo
Mail Us[email protected]
Menu
Oracle Discussions
exam questions

Exam 1z0-148 All Questions

View all questions & answers for the 1z0-148 exam
Go to Exam

Exam 1z0-148 topic 1 question 54 discussion

Actual exam question from Oracle's 1z0-148
Question #: 54
Topic #: 1
[All 1z0-148 Questions]

Which two statements are correct in Oracle Database 12c?

  • A. For native compilation, PLSQL_OPTIMIZE_LEWVEL should be set to 2.
  • B. Native compilation is the default compilation method
  • C. Native compilation should be used during development.
  • D. Natively compiles code is stored in the SYSTEM tablespace.
  • E. To change a PL/SQL object from interpreted to native code, set the PLSQL_CODE_TYPE to NATIVE and recompile it.
Show Suggested Answer Hide Answer
Suggested Answer: DE 🗳️
Reference:
https://www.google.com/url?sa=t&rct=j&q=&esrc=s&source=web&cd=2&cad=rja&uact=8&ved=0ahUKEwiW9-
2j66rYAhUBORQKHaKOAnsQFggtMAE&url=http%3A%2F%2Fwww.oracle.com%2Ftechnetwork%2Fdatabase%2Ffeatures%2Fplsql%2Fncomp-faq-
087606.html&usg=AOvVaw3H2JhdwNaDzp-Jly5-wtTk
by certyk at Sept. 22, 2020, 11:11 p.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
Rakeshpro
2 years, 4 months ago
Selected Answer: DE
Default Compilation mode: interpreted
upvoted 1 times
...
chrishillinger
2 years, 5 months ago
Selected Answer: DE
DE, agreed
upvoted 1 times
...
jcamt
4 years, 2 months ago
D, E https://logicalread.com/oracle-11g-native-compilation-mc02/#.X7AzjmhKjIU
upvoted 2 times
...
certyk
4 years, 4 months ago
correct -> c,e
upvoted 1 times
certyk
4 years, 4 months ago
sorry, D,E are correct. C is false because of "As a good practice, you may want to compile-interpreted during the regular development cycle and compile-native when development IS COMPLETE" and not during. ref -> https://www.oracle.com/technical-resources/articles/database/sql-11g-plsql.htmlhttps://www.oracle.com/technical-resources/articles/database/sql-11g-plsql.html
upvoted 1 times
...
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago