Oracle 1z0-485 Exam Practice Questions (P. 4)
- Full Access (71 questions)
- Six months of Premium Access
- Access to one million comments
- Seamless ChatGPT Integration
- Ability to download PDF files
- Anki Flashcard files for revision
- No Captcha & No AdSense
- Advanced Exam Configuration
Question #16
What are two choices that a customer must make that impact diskgroup creation?
- AWhat is the level of redundancy required?
- BWhat OS will be run?
- CWhere will disk backups be written?
- DHow many databases will run on the cluster?
Correct Answer:
AC
Once you identify candidate grid disks, use the CREATE DISKGROUP command to create your ASM disk groups.
Here are some of the more important considerations to think about when creating ASM disk groups on Exadata:
* (A) When capacity planning, take your redundancy specification into consideration. Normal redundancy will have the effect of reducing your usable storage to half the raw capacity, and high redundancy will shrink it to a third of your raw disk capacity.
* Simplicity is best on Exadata. Using wild-carded CREATE DISKGROUP syntax not only offers the most terse command syntax, but also ensures your ASM disk groups are spread evenly across your Exadata Storage Server disks.
* Take the time to plan grid disk prefix names and overall grid disk configuration in the context of your desired ASM disk group design.
* Make sure to set the appropriate compatible.asm and compatible.rdbms attributes when creating ASM disk groups.
* Whenever possible, use a 4 MB extent size when creating disk groups on ASM storage.
AC
Once you identify candidate grid disks, use the CREATE DISKGROUP command to create your ASM disk groups.
Here are some of the more important considerations to think about when creating ASM disk groups on Exadata:
* (A) When capacity planning, take your redundancy specification into consideration. Normal redundancy will have the effect of reducing your usable storage to half the raw capacity, and high redundancy will shrink it to a third of your raw disk capacity.
* Simplicity is best on Exadata. Using wild-carded CREATE DISKGROUP syntax not only offers the most terse command syntax, but also ensures your ASM disk groups are spread evenly across your Exadata Storage Server disks.
* Take the time to plan grid disk prefix names and overall grid disk configuration in the context of your desired ASM disk group design.
* Make sure to set the appropriate compatible.asm and compatible.rdbms attributes when creating ASM disk groups.
* Whenever possible, use a 4 MB extent size when creating disk groups on ASM storage.
send
light_mode
delete
Question #17
When would be the best time to run an Exadata health check (exachk)?
- Abefore patching, before upgrades, before backups, and on a regular basis
- Bafter patching, after upgrades, and after backups
- Conly when advised by Oracle Support
- Dbefore and after patching, when advised by Oracle Support, andona regular basis
- Eonly after a hardware failure
- Fmonthly and after a hardware failure
Correct Answer:
D
#1: Check for updates frequently.
#2: Execute before & after system changes.
#3: Make part of regular planned maintenance
D
#1: Check for updates frequently.
#2: Execute before & after system changes.
#3: Make part of regular planned maintenance
send
light_mode
delete
Question #18
Which two statements describe correct network configuration for Exadata Database Machine?
- AThe InfiniBand network subnet manager runs on all database servers to achieve High Availability.
- BOracle Clusterware communication is configured to use the management network.
- CThe InfiniBand network interfaces on Linux servers are configured using active-passive bonding.
- DDatabase connections to the SCAN listener route through the Ethernet switch in the Exadata rack.
- EDatabase servers are deployed with three logical network interfaces configured: management, client access, and private.
Correct Answer:
CD
CD
send
light_mode
delete
Question #19
How would you execute CellCLI commands and scripts?
- Ausing SQL*Plus on database nodes
- Bby CellCLI commands executed on the database nodes
- Cusing third party tools after installing the CellCLI RPM plug-in
- Ddirectly executing the commands and scripts on the Exadata storage cell
- Eremotely by connecting to Port 1521 using SSL
Correct Answer:
D
The storage cells in Exadata Database Machine are managed via two tools called CellCLI and DCLI.
D
The storage cells in Exadata Database Machine are managed via two tools called CellCLI and DCLI.
send
light_mode
delete
Question #20
Which two statements are true about migrating your database to Exadata?
- ABecause Exadata uses InfiniBand, in order to migrate your database to Exadata, you must have InfiniBand on the system that you are migrating from.
- BUsing Data Guard Physical Standby to migrate from an 11.1 database to Exadata is beneficial because it allows you to adopt HCC during migration.
- CASM and database best practice configuration supplied during Exadata deployment should be retained during and after migration,
- DLogical migration methods allow more flexibility than physical methods to change the database structure for best performance.
- EAll indexes should be dropped when migrating to Exadata.
Correct Answer:
CD
References:
CD
References:
send
light_mode
delete
All Pages