1Z0-497 Online Practice Questions and Answers

Which three operations can the PUBLIC user with the SYSOPER privilege perform?

A. STARTUP

B. SHUTDOWN

C. CREATE DATABASE

D. DROP DATABASE

E. ALTER DATABASE RECOVER

Which two statements are true regarding undo data records?

A. They are required to support Flashback features.

B. They are not required if Flashback features are enabled.

C. They are retained until the session making the changes ends.

D. Undo records contain copies of data as it appears after a change is made.

E. Undo records contain copies of data as it appears before a change is made.

Your customer is looking for a solution that meets these four needs:

1 - Replicate data from source to target for reporting purposes. 2 -Replicate data from one source to multiple targets. 3 - Replicate data between two databases for instant failover. 4 - Replicate data from multiple sources to a single target for a data warehouse.

Which GoldenGate-supported topology would you recommended?

A. Uni-directional for 1 Peer-to-peer for 2 Bi-directional for 3 Consolidation for 4

B. Peer-to-peer for 1 Broadcast for 2 Bi-directional for 3

Consolidation for 4

C. Uni-directional for 1 Broadcast for 2 Bi-directional for 3 Consolidation for 4

D. Peer-to-peer for 1 Consolidation for 2 Broadcast for 3 Cascading for 4

Consider 10 scenarios that result in database downtime. Which five of them are considered as planned downtime?

A. addition or removal of nodes, memory, or disks

B. changing configuration parameters, upgrading, or patching Oracle software

C. file deletion

D. migrating to cluster architecture

E. dropped database object

F. table definition changes

G. runaway processes that consume system resources

H. adding table partitioning

I. operating system or storage device / driver failure

J. database or application deadlocks

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 three options correctly match environment variables with their specific functionality?

A. ORACLE_SID specifies the instance name.

B. ORACLE_SID specifies the global database name.

C. ORACLE_BASE specifies the root of the Oracle Database directory tree in all platforms.

D. ORACLE_BASE specifies the root of the Oracle Database directory tree only in UNIX and Linux platforms.

E. ORACLE_HOME specifies the directory containing the Oracle software executables and network files.

F. ORACLE_HOME specifies the directory containing only the Oracle software executables, but not the network files.

Which two statements about switchover and failover are true?

A. A snapshot standby can be the target of a switchover or fast-start failover operation.

B. Neither a switchover nor a failover is possible to a far sync instance.

C. For fast-start failover, you must preselect the target standby database that will be used.

D. You can activate a standby database to test whether it is being updated correctly.

Which statement about a server parameter file (SPFILE) is false?

A. An SPFILE is a binary file that cannot be edited by using a text editor.

B. You can create an SPFILE from an existing text initialization parameter file or from memory.

C. You can use the SHOW PARAMETERS command to display the values of initialization parameters in an SPFILE.

D. The instance first searches for an SPFILE named spfileoRACLE_SID.ora and, if this is not found. It searches for spfile.ora.

Which statement about the Queryable Patch inventory feature is false?

A. It is used to retrieve installed patch information from a SQL prompt.

B. It uses the PREPROCESSOR feature, which allows users to preprocess input data before it is sent to the access drivers.

C. DBMS_QOPATCH provides a PL/SQL or SQL interface to view the database patches installed.

D. It works in an Oracle database instance that is mounted. Therefore, it works in ASM instances and DG instances.

You add the following code in the tnsnames.ora file on a client PC:

sales=

(DESCRIPTION=

(ADDRESS= (PROTOCOL=TCP)(HOST=salesdata) (PORT=1521) ) (CONNECT_DATA=

(SERVICE_NAME=sales.acme)))

Which statement is true about the code with respect to creating a new connect identifier?

A. It is created for the SALES database in the network domain ACME on the SALESDATA server.

B. It is created for the SALESDATA database on the SALES server in the network domain called ACME.

C. It generates an error because the connect identifier name cannot be a part of SERVICE_NAME.

D. It generates an error because the server configuration mode (dedicated or shared) is not specified.