1Z0_497 questions • Exam prepare

Exam contains 149 questions

Page 20 of 25

Question 115 🔥

Which statement about Storage Snapshot Optimization is correct?

Which database solution meets these requirements?

A. It enables you to use third-party technologies to take a storage snapshot of your database without putting the database in BACKUP mode. You can then use the snapshot to recover all or part of the database.

B. It enables you to use RMAN to take a storage snapshot of your database. The database must be in BACKUP mode. You can then use the snapshot to recover all or part of the database.

C. It enables you to use RMAN to take a storage snapshot of your database. The database doesn't have to be in BACKUP mode. You can then use the snapshot to recover all or part of the database.

D. It enables you to use third-party technologies to take a storage snapshot of your database. The database must be in BACKUP mode. You can then use the

Discussion of the question

Question 116 🔥

There are two listeners, LISTENER1 arid LISTENER2, and one service name ORCL available for your database. The database is running and currently, onlyLISIENER1 is started. You issue the command:lsnrctl start listener2What would be the outcome?

Which database solution meets these requirements?

A. It starts the second listener without affecting current sessions.

B. It starts the second listener and terminates all current sessions.

C. It gives an error because multiple listeners cannot run simultaneously.

D. It gives an error because multiple listeners can run simultaneously only if there are multiple net service names.

Discussion of the question

Question 117 🔥

You add the following code in the tnsnames.ora file on a client PC: sales=(DESCRIPTION=(ADDRESS= (PROTOCOL=TCP)(HOST=salesdata) (PORT=1521) )(CONNECT_DATA=(SERVICE_NAME=sales.acme)))Which statement is true about the code with respect to creating a new connect identifier?

Which database solution meets these requirements?

A. It is created for the SALES database in the network domain ACME on the SALESDATA server.

B. It is created for the SALESDATA database on the SALES server in the network domain called ACME.

C. It generates an error because the connect identifier name cannot be a part of SERVICE_NAME.

D. It generates an error because the server configuration mode (dedicated or shared) is not specified.

Discussion of the question

Question 118 🔥

Which three statements are true about database storage structures?

Which database solution meets these requirements?

A. A data file can span across tablespaces.

B. An extent contains one or more segments.

C. Tablespaces contain one or more data files.

D. Data objects are stored as segments in tablespaces.

E. Segments can span across data files within a tablespace.

Discussion of the question

Question 119 🔥

You are about to apply a patch to a database. Which recommended action is incorrect?

Which database solution meets these requirements?

A. You should check the patch conflict with installed patches before applying the patch.

B. You should make sure that you have a good backup of the software, database, and configuration files.

C. You should install the latest O patch before applying the patch.

D. You should check the fifth digit of the release information to confirm that the Patch Set Update (PSU) is applied successfully.

E. You should stop all applications running from the software directory that is being patched.

Discussion of the question

Question 120 🔥

Which type of information is included in dynamic performance views?1 - System and session parameters2 - Memory usage and allocation3 - File states (including RMAN backup files)4 - Progress of jobs and tasks5 - SQL execution6 - Statistics and metrics

Which database solution meets these requirements?

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