Oracle Oracle Certifications 1Z0-497 Questions & Answers

• Question 81:

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

  Correct Answer: BCD

• Question 82:

  Which statement about Online Move Data file is true?

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

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

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

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

  Correct Answer: A

• Question 83:

  Your customer needs server availability that provides uninterrupted access to database services, handling any unexpected failure of one or more machines hosting the database server, due to a hardware or software fault. Which product should your customer use?

  A. Oracle Data Guard

  B. Oracle Streams

  C. Oracle Real Application Clusters

  D. Oracle GoldenGate

  Correct Answer: C

  Reference: http://www.oracle.com/technetwork/database/availability/maximum-availability-wp- 12c1896116.pdf (page 5, Server HA: Oracle Real Application Clusters)

• Question 84:

  Your customer has three data centers in three different locations, location A has their production database running on Oracle Database 12c. They want to replicate the data from location A to location B. which is 50 miles away and is used for disaster protection and database rolling upgrades. They also want to create a replica database at location C, which must be open in read- write mode, while synchronizing with the primary database. Which two solutions would you recommend to your customer?

  A. Oracle GoldenGate

  B. Oracle Advanced Replication

  C. Oracle Active Data Guard

  D. Oracle Streams

  Correct Answer: BD

• Question 85:

  Your database instance is running. db01 is a net service name. You issue a connection request by using the command:

  SQL> CONNECT scott/tiger@db01

  Which component receives the request and establishes the appropriate connection?

  A. listener

  B. user process

  C. service name

  D. server process

  Correct Answer: A

  Reference: http://docs.oracle.com/cd/E11882_01/network.112/e41945/trouble.htm#NETAG394

• Question 86:

  An Oracle instance is a combination of______.

  A. database files and parameter file (initialization parameter file or server parameter file)

  B. System Global Area (SGA) and background processes

  C. a listener process, server processes, and background processes

  D. System Global Area (SGA), server processes, and background processes

  E. database files, System Global Area (SGA), and background processes

  Correct Answer: B

  Reference: http://docs.oracle.com/cd/A57673_01/DOC/server/doc/SCN73/ch9.htm#o instance

• Question 87:

  You have two database servers EMP and EXP. A user of the database from the EXP server wants to extract some information from the database in the EMP server for cross-verification. Which schema object enables the user to access the information from the remote database?

  A. cluster

  B. database link

  C. mapping table

  D. materialized view

  Correct Answer: B

  Reference: http://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_5005.htm

• Question 88:

  Which two are client-side components of Oracle Data Guard Broker?

  A. Oracle Enterprise Manager Cloud Control

  B. Oracle Data Guard monitor

  C. Oracle Data Guard command-line interface (DGMGRL)

  D. Oracle Data Guard Broker Manager

  Correct Answer: CD

  Reference: http://books.google.com.pk/books?id=qKbiQrYzAUCandpg=PA55andlpg=PA55anddq=clientside+components+of+Oracle+Data+Guard+Brokerandsource=blandots=hHTjqx70n7andsig=1Skypki GuUR1uPpy0QLGFPqy4mwandhl=enandsa=Xandei=qsT7Us7VDMWN7AavYCgCgandved=0CEQQ6AEwAw#v=onepageandq=client-side%20components%20of%20Oracle %20Data% 20Guard%20Brokerandf=false

• Question 89:

  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

  Correct Answer: A

• Question 90:

  You are installing OracleDatabase 12c on a machine. When you run the installer; Oracle Universal installer

  (OUI) shows a message that says one of the product-specific prerequisite checks has failed:

  Checking available swap space requirements...

  Expected result: 1512MB

  Actual Result: 1018MB

  Check complete. The overall result of this check is: failed «« Problem: The system does not have the

  required swap space.

  What happens to the installation in this situation?

  A. It can be continued.

  B. It resizes the swap space automatically when you proceed further.

  C. It can be continued, but the instance cannot be started without increasing swap space.

  D. It shows a message saying one or more prerequisite checks have failed and the installation aborts.

  Correct Answer: C

  Reference: https://bugs.kde.org/show_bug.cgi?id=111460