1Z0_497 questions • Exam prepare

Exam contains 149 questions

Page 21 of 25

Question 121 🔥

Which three statements are true about System Global Area (SGA)?

Which database solution meets these requirements?

A. SGA contains shared memory structures for all Oracle processes running on a single server.

B. Each server process has its own SGA.

C. SGA is allocated automatically when a database is started.

D. SGA is used to speed up queries by caching data blocks, program data, information about database objects, and query results

E. SGA is allocated automatically when a database is mounted.

F. SGA is read and written by server and background processes.

Discussion of the question

Question 122 🔥

Why does performance degrade when many UPDATE, INSERT, or DELETEstatements are issued on a table that has an associated bitmap index?

Which database solution meets these requirements?

A. The DML operations re-create the bitmap index blocks.

B. The bitmap index is rebuilt automatically after a DML operation.

C. The smallest amount of a bitmap that can be locked is a bitmap segment.

D. Additional time is taken to remove NULL values from the bitmap index alter a DML operation.

Discussion of the question

Question 123 🔥

Which two options can you use to list Oracle Database 12c patches by using Queryable Patch Inventory?

Which database solution meets these requirements?

A. select patch from vSoption where opatch_data=' 333333' ;

B. select xmltransform(dbms_qopatch.get_opatch_data(3333333), dbms_qopatch.GET_OPATCH_XSLT()) from dual

C. select opatch from vSpatchsets where opatch_number = '333333';

D. opatchlsinventory -xml

Discussion of the question

Question 124 🔥

What new role in Oracle Database 12c encompasses the administrative privileges required for backup and recovery?

Which database solution meets these requirements?

A. SYSBKP

B. SYSBKPRMAN

C. SYSRMAN

D. SYSBACKUP

Discussion of the question

Question 125 🔥

Which statement is true about Enhanced Real-Time ADDM in Oracle Database 12c?

Which database solution meets these requirements?

A. The analyzed result is lost when the database instance is restarted.

B. It runs every 1 hour automatically.

C. It is shipped only with Oracle Enterprise Manager 12c.

D. It analyzes high CPU trend and identifies problems before they can threaten application performance.

Discussion of the question

Question 126 🔥

Examine the error:GSM-45054: GSM error or NET-40006: unable to start GSHWhat is the cause of this error, and what troubleshooting steps should you perform?

Which database solution meets these requirements?

A. The GDS catalog database of its listener may be down. Verify that the GDS catalog database and its local listener are running.

B. The GDS pool database may be down. Make sure that the GDS pool databases are up and the service is enabled and started.

C. The GDS pool database's local listener may be down. Make sure that it is running.

D. The global service may be down. Verify that the pool databases are up and the service is started.

E. The global service may be disabled. Make sure that the pool databases are up and the service is enabled and started.

Discussion of the question

Ready to Pass Your Certification Test

oracle 1Z0_497

Exam contains 149 questions

Lorem ipsum dolor sit amet consectetur. Eget sed turpis aenean sit aenean. Integer at nam ullamcorper a.

Company

Product

Resources

Follow us