Online Access Free 1Z1-027 Practice Test

Which two may act as building blocks fior the creation ofi two or more griddisks residing on the same physical device
and which have more balanced perfiormance characteristics?

• A.griddisk on hard drive-based intervleaved celldisks.
• B.griddisk on hard drive-based celldisks consumed by ASM when creating diskgroups using ASM-based intelligent
  Data Placement (IDP)
• C.griddisk on hard drive-based non-interleaved celldisks.
• D.griddisk on Flash-base celldisks.

You plan to migrate your Oracle Version 11.1.0.2 database to your Exadata Database Machine.
The database supports an online transaction processing (OLTP) workload and is currently hosted on a Little Endian
platform
Which two are the supported and appropriate migration methods to minimize downtime?

• A.Migrate using cross platform Transportable Database.
• B.Migrate using Data Pump.
• C.Migrate using ASM online migration.
• D.Migrate using GoldenGate.
• E.Upgrade source database to 11.2.0 and migrate using a physical standby database.

Which three storage components are available after the standard initial Database machine deployment?

• A.The DATA_<DBM_Name> ASM diskgroup
• B.Exadata Smart Flash Cache using all ofi the flashdisk space
• C.Mirrored system partitions on hard disk 0 and hard disk 1
• D.The RECO_<DBM_Name> ASM diskgroup
• E.The DBFS_DG diskgroup with external redundancy

A read-only application is in development and is using a test database on a Database Machine. You are examining SQL
statements firom this application in an attempt to determine which ones will benefit firom the Exadata Smart scan
capability.
The fiollowing is true about the tables used by the application:
1. The data fior the tables has just been loaded.
2. There are no applications accessing the tables currently.
3. None ofi the indexes are compressed or reverse key indexes.
4. The tables use the defiault organization type data.
5. The only data types fior the table are varchar (2), number, or date.
6. The largest number ofi columns fior any table is 29.
7. No access is based on ROWID, or virtual columns.
Which two access paths will always generate either a set ofi "cell smart table scan" or a set ofi "cell smart index scan"
requested?

• A.Full scans on sorted hash clustered tables executed in parallel
• B.fiull scans on hash clustered tables executed in serially
• C.Full table scans on index organized tables executed in parallel.
• D.Full scans on index clustered tables executed in parallel
• E.Full table scans on heap tables executed in parallel
• F.fiull index scans on B*Tree indexes executed in parallel
• G.fiast fiull scans on B*Tree indexes executed in parallel

Which three must be true fior Smart Scans to be done?

• A.Setting _serial_direct_read=true in the session issuing the SQL statements
• B.Having a 4 meg AU size fior the ASM diskgroup containing the tablespace in which tables accessed by a query are
  stored
• C.Executing a query in parallel
• D.Having direct path reads used at run time
• E.cell.smart_scan_capable=true fior the ASM diskgroup containing the tablespace in which tables accessed by a query
  are stored.
• F.Cell_offload_process = true fior the ASM diskgroup containing the tablespace in which tables accessed by a query
  are stored.