Oracle Oracle Partner Network 1Z0-497 Questions & Answers

• Question 31:

  Which three statements are true about database storage structures?

  A. A data file can span across tablespaces.

  B. An extent contains one or more segments.

  C. Tablespaces contain one or more data files.

  D. Data objects are stored as segments in tablespaces.

  E. Segments can span across data files within a tablespace.

  Correct Answer: CDE

  Not B: Segments contain extents.

• Question 32:

  You are about to apply a patch to a database. Which recommended action is incorrect?

  A. You should check the patch conflict with installed patches before applying the patch.

  B. You should make sure that you have a good backup of the software, database, and configuration files.

  C. You should install the latest O patch before applying the patch.

  D. You should check the fifth digit of the release information to confirm that the Patch Set Update (PSU) is applied successfully.

  E. You should stop all applications running from the software directory that is being patched.

  Correct Answer: B

• Question 33:

  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.

  Correct Answer: A

  *

  Example, Basic Format of tnsnames.ora File

  net_service_name=

  (DESCRIPTION=

  (ADDRESS=(protocol_address_information))

  (CONNECT_DATA=

  (SERVICE_NAME=service_name)))

  *

  This tnsnames.ora file is a configuration file that contains net service names mapped to connect descriptors for the local naming method, or net service names mapped to listener protocol addresses.

  A net service name is an alias mapped to a database network address contained in a connect descriptor. A connect descriptor contains the location of the listener through a protocol address and the service name of the database to which to connect. Clients and database servers (that are clients of other database servers) use the net service name when making a connection with an application.

  Reference: Oracle Database Net Services Reference

• Question 34:

  There are two listeners, LISTENER1 arid LISTENER2, and one service name ORCL available for your database. The database is running and currently, only LISIENER1 is started. You issue the command:

  lsnrctl start listener2

  What would be the outcome?

  A. It starts the second listener without affecting current sessions.

  B. It starts the second listener and terminates all current sessions.

  C. It gives an error because multiple listeners cannot run simultaneously.

  D. It gives an error because multiple listeners can run simultaneously only if there are multiple net service names.

  Correct Answer: A

  Reference: https://blogs.oracle.com/rtsai/entry/how_to_configure_multiple_oracle

• Question 35:

  Which two statements correctly distinguish between undo and redo data?

  A. Undo reverses a change, whereas redo re-creates a change.

  B. Redo reverses a change, whereas undo re-creates a change.

  C. Undo protects against inconsistent reads, whereas redo protects against data loss.

  D. Redo protects against inconsistent reads, whereas undo protects against data loss.

  Correct Answer: AC

• Question 36:

  After a ___________ statement is issued, a transaction ends. (select three)

  A. COMMIT

  B. ROLLBACK

  C. SAVEPOINT

  D. SELECT

  E. CREATE

  Correct Answer: ABE

  A transaction ends when any of the following actions occurs:

  *

  (AB) A user issues a COMMIT or ROLLBACK statement without a SAVEPOINT clause.

  *

  (E) A user runs a DDL command such as CREATE, DROP, RENAME, or ALTER.

  Etc.

  Reference: Oracle Database Concepts, 12c, End of a Transaction

• Question 37:

  Which statement about Storage Snapshot Optimization is correct?

  A. It enables you to use third-party technologies to take a storage snapshot of your database without putting the database in BACKUP mode. You can then use the snapshot to recover all or part of the database.

  B. It enables you to use RMAN to take a storage snapshot of your database. The database must be in BACKUP mode. You can then use the snapshot to recover all or part of the database.

  C. It enables you to use RMAN to take a storage snapshot of your database. The database doesn't have to be in BACKUP mode. You can then use the snapshot to recover all or part of the database.

  D. It enables you to use third-party technologies to take a storage snapshot of your database. The database must be in BACKUP mode. You can then use the snapshot to recover all or part of the database.

  Correct Answer: A

  Reference: http://docs.oracle.com/cd/E16655_01/backup.121/e17630/release_changes.htm#BRADV276 (new features, third bullet)

• Question 38:

  Your customer is planning for a maximum-availability architecture at their data center to address their planned downtime, unplanned downtime, and replication needs.

  Consider these options:

  -Instance, site recovery, and heterogeneous setup

  -Inter-region and intra-region load balancing across replicated databases

  -Fine-grained error investigation of incorrect results

  -Integrated client and application failover

  -

  Fastest and simplest database replication

  A.

  Oracle GoldenGate

  B.

  Global Data Services

  C.

  Oracle Data Guard

  D.

  Data Recovery Advisor

  E.

  Oracle Flashback technology

  F.

  Oracle Advanced Queuing

  Which four options would you recommend?

  Correct Answer: ABCE

  Reference: http://docs.oracle.com/cd/E16655_01/server.121/e17601/unplanned.htm#HAOVW11824

• Question 39:

  Which two statements are true about Oracle Data Pump?

  A. EXPDP and IMPDP are the client components of Oracle Data Pump.

  B. DBMS_DATAPUMP PL/SQL packages can be used independently of Data Pump clients.

  C. Oracle Data Pump export and import operations can be performed only by users with the SYSDBA privilege.

  D. Oracle Data Pump imports can be done from the export files generated in Original Export Release 9.x.

  E. EXPDP and IMPDP use the procedures provided by DBMS_METADATA to execute export and import commands.

  Correct Answer: AB

  Reference: http://docs.oracle.com/cd/B19306_01/server.102/b14215/dp_overview.htm

• Question 40:

  Consider an application in which memory required for each session is 400 KB and memory required for each server process is 4 MB. The pool size is 100 and the number of shared servers used is 100. If there are 5000 client connections, what is the amount of memory used by a dedicated server?

  A. 615 MB

  B. 2.5 GB

  C. 4 GB

  D. 12 GB

  E. 22 GB

  Correct Answer: B