CertsTopics Logo

Labour Day Special - Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: top65certs

Oracle Database 19c 1z0-083 Exam Dumps

Page: 18 / 21
Total 286 questions
Get 1z0-083 Full Access Download 1z0-083 PDF

Oracle Database Administration II Questions and Answers

Question 69

Choose three. In which three situations can you use threshold server-generated alerts to help diagnose and fix problems?

Options:

A.

when free space in a dictionary managed tablespace falls below a specified percentage

B.

when free space in a locally managed tablespace falls below a specified percentage

C.

when the total number of locked user account exceeds a specific value

D.

when the number of logons per second exceeds a specific value

E.

when a resumable statement is suspended

F.

when the total number of logons exceeds a specific value

Question 70

Choose the best answer. SQL Performance Analyzer (SPA) has reported several regressed SQL statements for one of your databases. Which action could help in the performance management of these regressed SQL statements?

Options:

A.

Create SQL plan directives for each of the regressed statements.

B.

Use The SQL Tuning Advisor for each of the regressed statements.

C.

Create an adaptive execution plan for each of the regressed statements

D.

Use the SQL Access Advisor for each of the regressed statements.

Question 71

Which three methods can be used for heap table data migration after upgrading a database? (Choose three.)

Options:

A.

using Database Replay

B.

using SQL Developer

C.

using Oracle Data Pump

D.

using operating system file copy utilities

E.

using Database Upgrade Assistant

F.

using the CREATE TABLE AS SELECT SQL statement

Question 72

Choose two. Which two are true about diagnosing Oracle Database failure situations using Data Recovery Advisor?

Options:

A.

Data Recovery Advisor can proactively check for failures.

B.

Using the Data Recovery Advisor LIST FAILURE command always requires that the database for which failures are to be listed is in MOUNT state.

C.

ata Recovery Advisor can be used if a database is in the NOMOUNT state.

D.

A failure can be closed only if the database is in MOUNT state.

E.

Data Recovery Advisor can be used if a database is closed.

Page: 18 / 21
Total 286 questions
Get 1z0-083 Full Access Download 1z0-083 PDF