Create Next App

Exam contains 381 questions

Page 7 of 64

Question 37 🔥

Examine the memory-related parameters set in the SPFILE of an Oracle database:Which statement is true?

Which database solution meets these requirements?

A. Only SGA components are sized automatically.

Highly voted

B. Memory is dynamically re-allocated between the SGA and PGA as needed.

Highly voted

C. The size of the PGA cannot grow automatically beyond 500 MB.

Highly voted

D. The value of the MEMORY_TARGET parameter cannot be changed dynamically.

Highly voted

Discussion of the question

Question 38 🔥

All of your database instances use SPFILES.You executed this command in one of them:ALTER SYSTEM SET MEMORY_MAX_TARGET=1024M;Which statement is true?

Which database solution meets these requirements?

A. The parameter is modified in memory and in the parameter file.

Highly voted

B. The command returns an error.

Highly voted

C. The parameter is modified in the parameter file only.

Highly voted

D. The parameter is modified in memory only.

Highly voted

Discussion of the question

Question 39 🔥

Which two statements are true about extents? (Choose two.)

Which database solution meets these requirements?

A. Blocks belonging to an extent can be spread across multiple data files.

Highly voted

B. Data blocks in an extent are logically contiguous but can be non-contiguous on disk.

Highly voted

C. The blocks of a newly allocated extent, although free, may have been used before.

Highly voted

D. Data blocks in an extent are automatically reclaimed for use by other objects in a tablespace when all the rows in a table are deleted.

Highly voted

Discussion of the question

Question 40 🔥

Which two utilities can NOT configure a new listener on port 1526? (Choose two.)

Which database solution meets these requirements?

Discussion of the question

Question 41 🔥

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

Which database solution meets these requirements?

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

Highly voted

B. when the number of logons per second exceeds a specific value

Highly voted

C. when a database instance has been running for a period greater than a threshold value

Highly voted

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

Highly voted

E. when a database instance has been running for a period greater than a threshold value

Highly voted

Discussion of the question

Question 42 🔥

Examine this command executed on a client that is remote from the database server.SQL> CONNECT hr/hr@orcl -Which two are required for this command to connect the SQLPLUS client to a database instance? (Choose two.)

Which database solution meets these requirements?

A. An orcl TNS entry must be defined in the client-side and server-side tnsnames.ora files

Highly voted

B. An orcl TNS entry must be defined in the client-side tnsnames.ora file

Highly voted

C. A service name must be defined to the listener that matches the service name in the orcl TNS entry

Highly voted

D. An orcl TNS entry must be defined in the server-side tnsnames.ora file

Highly voted

E. The service name orcl must be defined to the listener

Highly voted

Discussion of the question

Ready to Pass Your Certification Test

oracle 1Z0_062

Exam contains 381 questions

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

Company

Product

Resources

Follow us