Oracle Exadata X5 Administration - 1z0-070 Exam Practice Test

A. Run the env_test command on the switches after logging in as root.

B. Run the getfanspeed command on the switches after logging in as root.

C. Run the showtemps command on the switches after logging in as the ilom-admin user.

D. Run the env_test command on the switches after logging in as the ilom-admin user.

A. The storage grid may be partitioned when deploying a single-rack Database Machine configuration using virtualization.

B. A single database cluster benefits from accessing multiple storage grids.

C. Multiple database clusters may access the same storage grid.

D. Multiple database clusters never benefit from accessing a single storage grid.

E. The database grid may be partitioned when deploying a multirack Database Machine configuration.

A. The size for the system area on the first two disks in each cell

B. Cluster configuration for up to 32 clusters

C. Virtualized Compute Node configuration

D. Virtualized Storage node configuration

E. OS users that own the Grid Infrastructure installation

A. Enabling Block Change Tracking (BCT) on the database can result in reduced consumption of storage network bandwidth.

B. cellsrv returns only blocks that have changed since the last backup.

C. For level-0 backups, Block Change Tracking (BCT) is most beneficial when more than 25 percent of the blocks have changed since the last backup.

D. For level-1 backups, Block Change Tracking (BCT) is most beneficial when more than 25 percent of the blocks have changed since the last backup.

E. Enabling Block Change Tracking (BCT) on the database can result in a reduction of physical I/O on the cells during incremental backups.

F. Fast incremental backups when 50% or more of the blocks have changed since the last backup, will run as slowly as normal incremental backup.

A. Different storage regions may have different columns indexed for the same table.

B. A maximum of eight table columns for any table are indexed per storage region.

C. The use of Storage Indexes for a particular database can be disabled by using an I/O Resource Manager Database Plan.

D. A Storage Index is automatically maintained by CELLSRV based on the filter columns of the offloaded SQL.

E. The use of Storage Indexes for particular categories of I/O can be displayed by using an I/O Resource Manager Category Plan.

F. Storage Indexes persist across any Exadata storage server reboots.

A. Full table scans on index organized tables executed in parallel

B. Index fast full scans executed in parallel

C. Index unique scan access by primary key to heap organized tables executed serially

D. Full table scans on heap organized tables executed serially

E. Index unique scan access by primary key to heap organized tables executed in parallel

F. Full table scans on heap organized tables executed in parallel

A. It requires the same privileges as the celladmin linux user to create CELLDISKS and GRIDDISKS.

B. It can be executed directly on cells.

C. It supports all CELLCLI commands.

D. It requires access through a cell user that has role-based privileges granted.

E. It can be executed using the EXADCLI utility.

F. It can execute commands on multiple cells in parallel.

A. file permissions on the griddisks in each storage server

B. Exadata storage realms using database-scoped security mode

C. file permissions on the griddisks in each database server

D. Using EXADCLI instead of CELLCLI to create the griddisks

E. Exadata storage realms using ASM-scoped security mode

A. distance between racks for multirack configurations

B. disk types within the expansion racks

C. Database Machine rack size and variants

D. disk types within the storage servers

E. voltage and phase type of the PDUs

F. Database Machine server models for both the storage servers and database servers in the rack

A. It must be accessed using direct path reads.

B. It must be stored in an ASM diskgroup with a 4 MByte AU size.

C. It must be heap organized.

D. Sessions querying the table must set cell_offload_processing = true.

E. The table must not be compressed.