1Z0_063 questions • Exam prepare

Exam contains 263 questions

Page 21 of 44

Question 121 🔥

A user issues a query on the sales table and receives the following error:ERROR at line 1:ORA-01565: error in identifying file '/u0l/app/oracle/oradata/ORCL/temp01.dbf'ORA-27037: unable to obtain file statusWhich two actions would you take to recover the temporary tablespace?

Which database solution meets these requirements?

A. Drop the tenpOi.dbf file, and then re-create the temp file.

B. Add a new temp file to the temporary tablespace and drop the tempOi.dbf file.

C. Shut down the database instance, start up the database instance in mount state, create a new temporary tablespace, and then open the database.

D. Take the temporary tablespace offline, recover the missing temp file, and then bring the temporary tablespace online.

Highly voted

E. Create a new temporary tablespace and assign it as the default to the user.

Highly voted

Discussion of the question

Question 122 🔥

Your database supports an online transaction processing (OLTP) workload in which one of the applications creates a temporary table for a session and performs transactions on it. This consumes a lot of undo tablespace and is affecting undo retention.Which two actions would you take to solve this problem?

Which database solution meets these requirements?

A. Enable temporary undo for the database.

B. Enable undo retention guarantee.

C. Increase the size of the redo log buffer.

D. Enable Automatic Memory Management (AMM).

Highly voted

E. Increase the size of the temporary tablespace.

Highly voted

Discussion of the question

Question 123 🔥

Which two statements are true about service creation for pluggable databases (PDBs)?

Which database solution meets these requirements?

A. When a PDB is created, a service is automatically started in the instance with the same name as the PDB.

B. The default service that is automatically created by a database at the time of PDB creation can be dropped, provided a new additional service is created.

C. A database managed by Oracle Restart can have additional services created or existing services modified by using the srvctl utility for each PDB.

Highly voted

D. Only a common user can create additional services for a PDB.

Highly voted

E. When a PDB is created, a service with the same name as the PDB is created in the PDB.

Discussion of the question

Question 124 🔥

You want to move your existing recovery catalog to another database.Examine the steps:1) Export the catalog data by using the Data Pump Export utility in the source database.2) Create a recovery catalog user and grant the necessary privileges in the target database.3) Create a recovery catalog by using the create catalog command.4) Import the catalog data into the new recovery catalog by using the Data Pump Import utility in the target database.5) Import the source recovery catalog schema by using the import catalog command.6) Connect to the destination database.7) Connect as catalog to the destination recovery catalog schema.Identify the option with the correct sequence for moving the recovery catalog.

Which database solution meets these requirements?

A. 1, 6, 4

B. 2, 3, 7, 5

C. 1, 2, 6, 4

Highly voted

D. 1, 2, 3, 6, 5

Discussion of the question

Question 125 🔥

Examine the command and its output:SQL> DROP TABLE EMPLOYEE;SQL> SELECT object_name AS recycle_name, original_name, type FROM recyclebin;RECYCLE_NAMEORIGINAL_NAMETYPE --------------------------------------------------------------------- binsgk31sj/3akk5hg3j21kl5j3d==$0EMPLOYEE TABLEYou then successfully execute the command:SQL> FLASHBACK TABLE "BINSgk31sj/3akk5hg3j21kl5j3d==$0" TO BEFORE DROP;Which two statements are true?

Which database solution meets these requirements?

A. It flashes back the employee table and all the constraints associated with the table.

B. It automatically flashes back all the indexes on the employees table.

Highly voted

C. It automatically flashes back any triggers defined on the table.

D. It flashes back only the structure of the table and not the data.

Highly voted

E. It flashes back the data from the recycle bin and the existing data in the original table is permanently lost.

Discussion of the question

Question 126 🔥

Which two statements are true about scheduling operations in a pluggable database (PDB)?

Which database solution meets these requirements?

A. Scheduler jobs for a PDB can be defined only at the container database (CDB) level.

B. A job defined in a PDB runs only if that PDB is open.

Highly voted

C. Scheduler attribute setting is performed only at the CDB level.

D. Scheduler objects created by users can be exported or imported using Data Pump.

Highly voted

E. Scheduler jobs for a PDB can be created only by common users.

Discussion of the question

Ready to Pass Your Certification Test

oracle 1Z0_063

Exam contains 263 questions

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

Company

Product

Resources

Follow us