Create Next App

Exam contains 149 questions

Page 12 of 25

Question 67 🔥

Which statement about Online Move Data file is true?

Which database solution meets these requirements?

A. Moving a data file online prevents DML operations on segments stored in the data file.

Highly voted

B. Flashing back a database to a point in time before a data file had been renamed online retains the new name.

Highly voted

C. Moving a data file online can be performed if the data file is in OFFLINE mode.

Highly voted

D. Moving a data file online cannot be performed if the data file is under BEGIN BACKUP.

Highly voted

Discussion of the question

Question 68 🔥

You execute the following command:SQL> ALTER USER skd ACCOUNT LOCK;Which two statements are correct?

Which database solution meets these requirements?

A. The SKD user cannot log in to the database instance.

Highly voted

B. The objects owned by the SKD user are not accessible to any user.

Highly voted

C. Other users can access objects owned by the SKD user, to which they have access.

Highly voted

D. The SKD user's password expires and the user is forced to change the password at the next login.

Highly voted

Discussion of the question

Question 69 🔥

Examine the statements:SQL> CREATE TABLESPACE MYTBS DATAFILE '/disk1/mytbs_l.dbf ' SIZE 10M;SQL> CREATE TABLE mytab (id NUMBER, descr VARCHAR2 (100) )PARTITION BY RANGE(id) (partition pi values loss than (100000) tablespacemytbs storage (initial lm), partition p2 values less than (MAXVALUE) tablespacemytbs storage (initial 1m));When inserting data, you get the error:ORA-01688: unable to extend table SYS.MYTAB partition P2 by 128 in tablespace MYTBSWhich three operations would allow you to insert data without getting the error message?

Which database solution meets these requirements?

A. Extend the logical volume by 10 MB where the data files are stored;# lvextend -L+10M /diskl

Highly voted

B. Add a data file:SQL>ALTER TABLESPACE MYTBS ADD DATAFILE ' /disk1/mytbs_2 .dbf SIZE 10M;

Highly voted

C. Move a partition to another tablespace:SQL> CREATE TABLESPACE ADDITIONAL_TBS DATAFILE '/disk1/additional_tbs_1 .dbf' SIZE 10M;SQL> ALTER TABLE MYTAB MOVE PARTITION P2 TABLESPACE ADDlTIONAL_TBS;

Highly voted

D. Resize the existing data file:SQL> ALTER DATABASE DATAFILE '/diskl/mytbs_l .dbf' RESIZE 20M;E) Remove a data file:SQL> ALTER TABLESPACE MYTBS DROP DATAFILE '/diskl/mytbs_l - dbf';

Highly voted

Discussion of the question

Question 70 🔥

Which two statements about Automatic Data Optimization (ADO) are true?

Which database solution meets these requirements?

A. ADO policies can automatically compress data when it qualifies.

Highly voted

B. ADO policies can automatically move segments when necessary.

Highly voted

C. ADO is not dependent on Heat Map, and works even if Heat Map is disabled.

Highly voted

D. You cannot compress at block level, but you can compress at segment level.

Highly voted

E. You can compress at row level only for QUERY LOW.

Highly voted

Discussion of the question

Question 71 🔥

Which statement about Oracle patches is false?

Which database solution meets these requirements?

A. Interim patches, also known as "one-off" patches, are created to provide a specific fix between the releases of patch sets.

Highly voted

B. Security Patch Update (SPU) is the primary means of releasing security fixes for Oracle products. SPUs are cumulative with respect to prior SPUs and generally contain only security fixes.

Highly voted

C. Patch Set Update (PSU) is a collection of proactive, stabilizing, cumulative patches for a particular product version (base release or patch set). PSUs are cumulative and include all the security fixes from CPU patches, plus additional fixes.

Highly voted

D. Patch Set is the main way in which Oracle provides bug fixes in between releases. Oracle bundles a number of fixes, tests them thoroughly together, and packages, then together for easy download and installation.

Highly voted

E. Terminal Patch Set is an unsupported patch set by Oracle Lifetime Support policies.

Highly voted

Discussion of the question

Question 72 🔥

Which statement about CDB architecture is true?

Which database solution meets these requirements?

A. Oracle-supplied metadata resides only in the root container.

Highly voted

B. A seed PDB can sometimes be opened for particular operations.

Highly voted

C. Multiple PDBs with the same name can reside in the same CDB.

Highly voted

E. You can create common users in PDBs.

Highly voted

D. A CDB can have an infinite number of PDBs.

Highly voted

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