Oracle 1z0-485 Exam Practice Questions (P. 2)
- 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 #6
Consider the following setup:
User A1 belongs to resource group High on Database A.
User B2 belongs to resource group Low on Database B.
User C3 is a user on Database C without any DBRM setup.
DBRM setup:
Database A: Resource group High gets 80% and Low gets 20%.
Database B: Resource group High gets 60% and Low gets 40%.
IORM setup:
Database A: Share=20, limit=5 -
Database B: Share=30, limit=10 -
Database C: 5 shares -
Total number of shares in the IORM setup = 100
What percent of I/O will each database user theoretically be using when the Exadata storage unit I/O throughout is used 100% and no other databases but A, B, and C are running?
User A1 belongs to resource group High on Database A.
User B2 belongs to resource group Low on Database B.
User C3 is a user on Database C without any DBRM setup.
DBRM setup:
Database A: Resource group High gets 80% and Low gets 20%.
Database B: Resource group High gets 60% and Low gets 40%.
IORM setup:
Database A: Share=20, limit=5 -
Database B: Share=30, limit=10 -
Database C: 5 shares -
Total number of shares in the IORM setup = 100
What percent of I/O will each database user theoretically be using when the Exadata storage unit I/O throughout is used 100% and no other databases but A, B, and C are running?
- AAl = 36%, B2=18%, and C3=9%
- BAl = 33%, B2=33%, and C3=33%
- CAI = 10%, B2=5%, and C3=20%
- DAl = 8%, B2=12%, and C3=5%
- EAl = 5%, B2=10%, andC3=85%
Correct Answer:
E
IORM setup limits Database A to 5%, and Database B is limited to 10%, while Database C has not IORM limit.
Note that the resource groups are for CPU allocation.
E
IORM setup limits Database A to 5%, and Database B is limited to 10%, while Database C has not IORM limit.
Note that the resource groups are for CPU allocation.
send
light_mode
delete
Question #7
Consider this CellCLI command:
CellCLI> CREATE GRIDDISK ALL HARDDISK PREFIX=data, size=423G;
Which two statements describe what happens when you execute this command?
CellCLI> CREATE GRIDDISK ALL HARDDISK PREFIX=data, size=423G;
Which two statements describe what happens when you execute this command?
- AIt creates one 423 GB grid disk on the first available cell hard disk.
- BIt creates one 423 GB grid disk on each available cell hard disk.
- CIt creates grid disks on the outermost 423 GB that is available on each hard disk.
- DIt creates grid disks on the innermost 423 GB that is available on each hard disk.
- EIt creates an Exadata Smart Flash Cache on all flash drives.
Correct Answer:
BC
* Example:
CellCLI> create griddisk all harddisk prefix=temp_dg, size=570G
This command will create 12 Griddisks, each of 570G in size from the outer (fastest)sectors of the underlying Harddisks. It fills up the first 2 Celldisks entirely, because they have just 570G space free the rest is already consumed by the OS partition.
BC
* Example:
CellCLI> create griddisk all harddisk prefix=temp_dg, size=570G
This command will create 12 Griddisks, each of 570G in size from the outer (fastest)sectors of the underlying Harddisks. It fills up the first 2 Celldisks entirely, because they have just 570G space free the rest is already consumed by the OS partition.
send
light_mode
delete
Question #8
You get a Host Unreachable error when you attempt to connect to a server through a network terminal command line. What are two other ways in which you can connect?
- AUse the ILOM Web GUI.
- BUse the dcli command at the root prompt on a database node.
- CAttach a terminal device tothe back panel of the server with a serial cable.
- DConnect by using SQL *Plus.
- ELog in as root on the database node using the Net1 IP address.
Correct Answer:
AC
In addition to gaining shell access via SSH to manage your Exadata servers, you can also access them from the Integrated Lights Out Management (ILOM) console or KVM console. and should typically not require modifications unless you have changed network information inside your database machine.
Note: A KVM switch (with KVM being an abbreviation for "keyboard, video and mouse") is a hardware device that allows a user to control multiple computers from one or more[1] keyboard, video monitor and mouse. Although multiple computers are connected to the KVM, typically a smaller number of computers can be controlled at any given time
AC
In addition to gaining shell access via SSH to manage your Exadata servers, you can also access them from the Integrated Lights Out Management (ILOM) console or KVM console. and should typically not require modifications unless you have changed network information inside your database machine.
Note: A KVM switch (with KVM being an abbreviation for "keyboard, video and mouse") is a hardware device that allows a user to control multiple computers from one or more[1] keyboard, video monitor and mouse. Although multiple computers are connected to the KVM, typically a smaller number of computers can be controlled at any given time
send
light_mode
delete
Question #9
Identify three best practices for applying asmdeactivationoutcome es on Exadata Database Servers and Exadata Storage Servers?
- ABacking up database servers and storage cells is not recommended before performing plannedmaintenance.
- BDatabase server updates can be rolled back using the "yum downgrade"procedure.
- CBundle patches do not require testing before being installed on a production system.
- DIt is recommended that Exadata systems with Data Guard configured use the"Standby First" patching approach.
- EPatching should never be interrupted due to a connection drop. It is therefore recommended that you use VNC or the screen utility.
- FBefore patching cells in a rolling manner, you must check asmdeactivationoutcome amModestatus and make sure that cells on all disks are online and that
Correct Answer:
DEF
DEF
send
light_mode
delete
Question #10
The mpstat output from OS Watcher shows a database node as being 90% idle on an average. What would you do to get a full picture of CPU utilization on the entire Exadata RAC cluster?
- AAverage the mpstat id1 output from all the nodes.
- BAsk application users if they have noticed a slowdown in screen response.
- CLook for an increase in batch job servicing times.
- DA & B above
Correct Answer:
A
A
send
light_mode
delete
All Pages