Oracle 1Z0-497 dumps - 100% Pass Guarantee!

Which two statements are true regarding SQL*Plus?

A. It has commands for performing database administration operations.

B. It can be used in interactive but not batch mode for SQL commands.

C. It has to be installed separately after the Oracle Database 12c installation.

D. Operating system commands can be executed from the SQL*Plus command prompt.

Which option represents a function of Global Data Services (GDS)?

A. performs data replication

B. performs database failovers

C. replaces the functionality of Oracle Clusterware and Oracle RAC

D. coordinates site failovers

E. works seamlessly with Oracle Site Guard

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 MYTBS

Which three operations would allow you to insert data without getting the error message?

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

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

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;

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';

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

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

B. ADO policies can automatically move segments when necessary.

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

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

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

Which statement regarding Oracle Active Data Guard 12c is false?

A. Any application compatible with a read-only database can run on an Oracle Active Data Guard standby.

B. It provides new support for DML to global temporary tables and the use of sequences in the standby database.

C. It repairs block corruptions detected in the primary or standby database.

D. It supports different software patch levels between a primary database and its physical standby database for the purpose of applying and validating Oracle patches in a rolling fashion.

E. It supports multi master and bidirectional replication architectures where there are multiple databases that all contain the same data, even if they are not synchronized.