1Z0_068 questions • Exam prepare

Exam contains 149 questions

Page 18 of 25

Question 103 🔥

Examine this command:SQL> ALTER TABLESPACE TBS1 ADD DATAFILE '+DATA(newtemplate)/ORCL/USERS/mytab.dbf' SIZE 100M;Which two statements are required for this command to succeed? (Choose two.)

Which database solution meets these requirements?

A. The DB_CREATE_FILE_DEST parameter must be set to +DATA(newtemplate).

B. newtemplate must be defined for the +DATA disk group.

Highly voted

C. Existing data files in TBS1 must also use the same template.

D. The +DATA disk group should not be part of Flex ASM.

E. User-defined subdirectories ORCL and USERS must already exist.

Highly voted

Discussion of the question

Question 104 🔥

Which three statements are true about ASM Cloud File System (ACFS) encryption? (Choose three.)

Which database solution meets these requirements?

A. A copy of an encrypted file is not encrypted unless it is created in an encrypted directory.

B. acfsutil encr init is used to establish role separation between encryption managers and encryption auditors.

C. acfsutil encr off can be run by an encryption manager who may not have system administrator privileges.

D. acfsutil encr on can be used to specify the encryption key length for a directory or file.

E. An ACFS snapshot can be ACFS encrypted.

Discussion of the question

Question 105 🔥

Which three file types can be stored in an ASM Cluster file system (ACFS) and used by the relevant software? (Choose three.)

Which database solution meets these requirements?

Discussion of the question

Question 106 🔥

You administer an Oracle 12c RAC database whose clients connect to the database instances using SCAN listeners.Which two statements are true regarding client-side connect-time load balancing? (Choose two.)

Which database solution meets these requirements?

A. You must add SCAN VIPs to the REMOTE_LISTENER parameter to enable correct listener cross-registration.

B. Client connection requests are automatically load balanced across the IP addresses defined for the SCAN listeners.

C. You must explicitly set LOAD_BALANCE=ON in the client-side TNS entry being used.

D. The LOCAL_LISTENER parameter for each instance must be manually set to point to the node listener on each node.

E. SCAN listeners redirect connection requests to a node listener for the appropriate instance.

Discussion of the question

Question 107 🔥

Which three statements are true about Oracle 12c multitenant RAC databases created using the Database Configuration Assistant (DBCA) on a cluster from aRAC database home? (Choose three.)

Which database solution meets these requirements?

A. They are automatically configured to use Enterprise Manager Express.

B. They have their pluggable databases (PDBs) opened in each container database (CDB) instance automatically after CDB creation.

C. They can be policy managed.

D. They can be administrator managed.

E. They have a unique service name created for each pluggable database (PDB) automatically registered as a cluster service resource.

F. They can have multiple pluggable databases (PDB) when the container database (CDB) is created.

Discussion of the question

Question 108 🔥

Examine this command:$ srvctl modify service -db RACDB -service SRVBl -clbgoal LONGThis three-Instance RAC database uses Flex ASM.Which two statements are true regarding server-side connect-time load balancing using SCAN listeners for this service? (Choose two.)

Which database solution meets these requirements?

A. It is enabled only when LOAD_BALANCE=YES is coded in the client-side TNS entry used by the client.

B. The SCAN listeners redirect clients to the node listener serving the instance that has the fewest sessions for the SRVB1 service.

C. The SCAN listeners automatically balance the connections across the instances accepting logins for the SRVB1 service.

D. It is disabled because the -c1bgoal attribute is set to LONG.

E. The SCAN listeners redirect clients to the node listener serving the instance that has the fastest response time for the SRVB1 service.

Discussion of the question

Ready to Pass Your Certification Test

oracle 1Z0_068

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