Oracle 1Z0-497 Online Practice Questions and Exam Preparation

Oracle 1Z0-497 Online Questions & Answers

• Question 61:

  You want to clone PDB1 and PDB2 into the same CDB. Which statement is correct?

  A. You cannot do this, because you can only clone PDBs into another CDB.
  B. You can clone only one PDB (either PDB1 or PDB2) into the same CDB.
  C. Cloning a PDB can use the source files copy method to the target PDB files.
  D. Cloning a PDB can use the NOCOPY clause if the target PDB files use the source files.
  D. Cloning a PDB can use the NOCOPY clause if the target PDB files use the source files.

• Question 62:

  Which is the default port number for Database Express?

  A. 7801
  B. 5500
  C. 2243
  D. 1521
  E. 22
  D. 1521

  ---

  Reference: http://docs.oracle.com/cd/B25329_01/doc/install.102/b25143.pdf (page 4, first bulleted point)

• Question 63:

  Oracle Database 12c provides new task-specific privileges (SYSBACKUP, SYSDG, and SYSKM) to handle standard administration duties.

  Which two statements about these standard administration privileges are true?

  A. These administrative privileges enable you to connect to the database only if the database is open.
  B. After connecting with these privileges, you are connected under a predefined user whose name is the privilege name.
  C. These administrative privileges allow a user to view DBA_xxx, GV$, VS, and SELECT on application tables.
  D. Without being a member of OSBACKUP. OSDG, and OSKM OS groups, users cannot connect as administrative users by using OS authentication.
  A. These administrative privileges enable you to connect to the database only if the database is open.
  B. After connecting with these privileges, you are connected under a predefined user whose name is the privilege name.

• Question 64:

  Your customer wants to migrate their production database from Oracle Database 10gon AIX to Oracle Database 12con Solaris, and is concerned about the downtime. Which Oracle solution would you recommend?

  A. Active Data Guard
  B. Oracle GoldenGate
  C. Oracle Real Application Clusters
  D. Oracle Transportable Tablespaces
  E. Oracle Cloud Platform as a Service
  A. Active Data Guard

• Question 65:

  A standby database is in mounted state and you are required to perform a failover to the physical standby. Which solution is best suited forthis scenario?

  A. ALTER DATABASE RECOVER MANAGED STANDBY DATABASE statement with the FINISH keyword
  B. ALTER DATABASE PREPARE TO SWITCHOVER and ALTER DATABASE COMMIT TO SWITCHOVER statements
  C. ALTER DATABASE RECOVER TO STANDBY DATABASE statement with the FINISH keyword
  D. D) ALTER DATABASE PREPARE SWITCHOVER and ALTER DATABASE COMMIT TO SWITCHOVER Statements
  A. ALTER DATABASE RECOVER MANAGED STANDBY DATABASE statement with the FINISH keyword

• Question 66:

  Which two statements about Data Recovery Advisor are true?

  A. Data Recovery Advisor can be used to diagnose and repair data corruptions in non-CDBs.
  B. Data Recovery Advisor cannot be used to diagnose and repair data corruptions in the root of a CDB.
  C. Data Recovery Advisor can be used to diagnose and repair data corruptions in PDBs.
  D. You can use the ADVISE FAILURE command to display repair options after running LIST FAILURE in an RMAN session.
  A. Data Recovery Advisor can be used to diagnose and repair data corruptions in non-CDBs.
  D. You can use the ADVISE FAILURE command to display repair options after running LIST FAILURE in an RMAN session.

  ---

  A (not B): In the current release, Data Recovery Advisor can only be used to diagnose and repair data corruptions in non-CDBs and the root of a multitenant container database (CDB). Not C: Data Recovery Advisor is not supported for pluggable databases (PDBs).

  D: A failure is detected either automatically by the database or through a manual check such as the VALIDATE command. You can use the LIST FAILURE command to view problem statements for failures and the effect of these failures on database operations. Each failure is uniquely identified by a failure number. In the same RMAN session, you can then use the ADVISE FAILURE command to view repair options, which typically include both automated and manual options.

  Reference: Oracle Database Backup and Recovery User's Guide, 12c, Diagnosing and Repairing Failures with Data Recovery Advisor

• Question 67:

  Which three statements about replication options are true?

  A. The Oracle Streams information flow consists of three components: capture, redo transfer, arid consumption.
  B. Oracle Streams is deprecated in Oracle Database 12c Release 1.
  C. Oracle Database Advanced Replication is deprecated in Oracle Database 12c Release 1, including multimaster replication, updatable materialized views, multitier materialized views, and deployment templates.
  D. Oracle Database Advanced Queuing is independent of Oracle Streams.
  E. The Oracle GoldenGate software architecture is composed of three primary components: capture, propagate, and trail files.
  B. Oracle Streams is deprecated in Oracle Database 12c Release 1.
  C. Oracle Database Advanced Replication is deprecated in Oracle Database 12c Release 1, including multimaster replication, updatable materialized views, multitier materialized views, and deployment templates.
  E. The Oracle GoldenGate software architecture is composed of three primary components: capture, propagate, and trail files.

• Question 68:

  Examine the command:

  SQL> CREATE TABLE orders(oid NUMBER (6) PRIMARY KEY, odato DATE, ccode NUMBER (6), oamt NUMBER (10, 2)) TABLESPACE users ;

  Which two statements are true about the execution of the command?

  A. A CHECK constraint is created on the OID column.
  B. A NOT NULL constraint is created on the OID column.
  C. The ORDERS table is the only object created in the USERS tablespace.
  D. The ORDERS table and a unique index are created in the USERS tablespace.
  E. The ORDERS table is created in the USERS tablespace and a unique index is created on the OID column in the SYSTEM tablespace.
  B. A NOT NULL constraint is created on the OID column.
  D. The ORDERS table and a unique index are created in the USERS tablespace.

  ---

  B: A NOT NULL constraint is put on the primary key.

  D:

  *

  To enable a unique or primary key constraint, you must have the privileges necessary to create an index on the table. You need these privileges because Oracle Database creates an index on the columns of the unique or primary key in the schema containing the table.

  *

  TABLESPACE Specify the tablespace in which Oracle Database creates the table, object table OIDINDEX, partition, LOB data segment, LOB index segment, or index-organized table overflow data segment. If you omit TABLESPACE, then the database creates that item in the default tablespace of the owner of the schema containing the table.

  Reference: Oracle Database SQL Language Reference 12c , CREATE TABLE

• Question 69:

  Which two statements about Global Data Services (GDS) are correct?

  A. GDS allows scaling replication-aware application workloads beyond the cluster (that is, across replicated clusters).
  B. GDS helps in performing data replication.
  C. GDS works seamlessly with any combination of Oracle RAC databases, single-instance databases, Oracle Data Guard, Oracle Active Data Guard, and Oracle Golden Gate.
  D. GDS helps to perform database failovers, and does not require Data Guard Broker.
  E. The GDSMGRL utility is a command-line interface for configuring and managing the Global Data Services framework.
  A. GDS allows scaling replication-aware application workloads beyond the cluster (that is, across replicated clusters).
  C. GDS works seamlessly with any combination of Oracle RAC databases, single-instance databases, Oracle Data Guard, Oracle Active Data Guard, and Oracle Golden Gate.

  ---

  Reference: http://www.oracle.com/technetwork/database/availability/global-data-services-12c- wp-1964780.pdf (page 8)

• Question 70:

  What happens when you execute these SQL statements?

  ALTER SYSTEM SET SGA_TARGET = 992M; ALTER SYSTEM SET SHARED_POOL_SIZE = 0; ALTER SYSTEM SET LARGE_POOL_SIZE = 0; ALTER SYSTEM SET JAVA_POOL_SIZE = 0; ALTER SYSTEM SET DB_CACHE_SIZE = 0; ALTER SYSTEM SET STREAMS POOL SIZE = 0;

  A. The database stops (shutdown abort).
  B. B) The database Stops (shutdown immediate).
  C. You activate Automatic Shared Memory Management.
  D. You get an error message.
  C. You activate Automatic Shared Memory Management.

  ---

  Reference: http://www.orafaq.com/forum/t/67825/0/ (see the second post)