Free Oracle 1z1-497 Exam Dumps Questions & Answers

Which logical storage relationship is correct?

• A.Tablespace< Extent < Segment < Oracle Datablock
• B.Data File <Tablespace< Segment < Extent < Oracle Datablock
• C.B) Segment < Extent < Oracle Datablock<Tablespace
• D.Tablespace< Segment < Extent < Oracle Datablock

What must you do to an application for it to take advantage of partitioning?

• A.relink
• B.rewrite its SQL queries
• C.rework the applications schema
• D.nothing; it is transparent
• E.recompile it

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 Which four options would you recommend?

• A.Oracle GoldenGate
• B.Oracle Advanced Queuing
• C.Data Recovery Advisor
• D.Oracle Flashback technology
• E.Global Data Services
• F.Oracle Data Guard

Which statement about CDB architecture is true?

• A.A seed PDB can sometimes be opened for particular operations.
• B.Oracle-supplied metadata resides only in the root container.
• C.You can create common users in PDBs.
• D.A CDB can have an infinite number of PDBs.
• E.Multiple PDBs with the same name can reside in the same CDB.

Which three statements are true about System Global Area (SGA)?

• A.SGA contains shared memory structures for all Oracle processes running on a single server.
• B.SGA is allocated automatically when a database is started.
• C.SGA is allocated automatically when a database is mounted.
• D.Each server process has its own SGA.
• E.SGA is used to speed up queries by caching data blocks, program data, information about database objects, and query results
• F.SGA is read and written by server and background processes.