Is this exam completely free?

ExamCademy offers a free preview for every exam, covering around 20% of the total questions. Full access to all questions is available for free by signing up for an account. Optional supporters unlock AstroTutor (AI tutor) and advanced study modes.

Can I practice IT certification exams from Microsoft, AWS, or CompTIA?

Yes! ExamCademy supports a wide range of IT certification exams including Microsoft Azure, AWS Cloud Practitioner, and CompTIA A+ and Security+.

How accurate are the mock exams?

Our practice questions are community-created and moderator-reviewed to align with realistic exam objectives, style, and difficulty.

1Z0-485 by Oracle - Page 1 | ExamCademy

Mode Selection

Sort:

Question 1

Question 2

Question 3

Question 4

Question 5

Question 6

Question 7

Question 8

Question 9

Question 10

Question 11

Question 12

Question 13

Question 14

That's the end of the Preview

Create a free account to unlock all questions for this exam.

Log In / Sign Up

Page 1 of 3 • Questions 1-25 of 69

1 2 3

→

Know a question that should be here? Contribute to this exam

Consider the following software changes that are performed manually on a Linux server:

Changes for Linux kernel firewall configuration
Changes for custom performance monitoring tools
Changes for security scan tools
Changes for Linux system performance optimization
Which of the software changes listed are permitted on Exadata Storage Servers?

A 1, 2, 3, and 4
B only 3 '
C none
D only 2
E only 1 and 2
F only 2 and 3

A customer has three databases named CC. FIN, and DW. The CC database is for their CallCenter. Even a slight decrease in the response time of the database would mean more people "on hold" in their data center. The orders received through the CallCenter are stored in the Finance (FIN) database. Both databases, CC and FIN, serve as sources for the Data Warehouse (DW) database. All databases use the same Automatic Storage Management (ASM) diskgroup and therefore, the same physical disks on Exadata storage. The customer wants to dynamically control the resources that are available for the CallCenter database because this has direct impact on their operations?
Which option should be implemented?

A DBRMon the CC database
B DBRM on all the databases
C IORM, because DBRM cannot be changed for an existing session
D IORM and DBRM

Which is the best location to point your customer to, for finding the latest Exadata patches?

A owner's guide
B Patch database in MyOracle Support
C MyOracle Support note 888828.1
D MyOracle Supportfor database patches, ULN for OS patches, and Sun Support for Server and InfiniBand patches.

Exadata Database Machine offers an Intelligent Platform Management Interface for the various components in the Exadata product. Which option is true?

A IPMI can be used to remotely start and stop servers.
B IPMI can be used to remotely log in to the operating system.
C IPMI commands can be executed by using SNMP traps.
D IPMI settings can be secured by backing up the Oracle Linux installation on the storage system.

Which two statements are true about enabling write-back flash cache?

A When enabling write-back flash cache in a non rolling manner, it is important to ensure that asmdeactivatonoutcome is set to YES and asmModestatus is set to ONLINE for all grid disks.
B Before using write-back flash cache, you need to verify the minimum required versions.
C Before write back-flash cache is enabled, you need to drop the Flash Cache first.
D The setting flashCacheMode should be set to writeback by updating cellinit.ora and restarting cellsrv.
E When enabling write-back flash cache in a rolling manner, dcli should be used to inactivate the grid disks on all cells first.

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?

A Al = 36%, B2=18%, and C3=9%
B Al = 33%, B2=33%, and C3=33%
C AI = 10%, B2=5%, and C3=20%
D Al = 8%, B2=12%, and C3=5%
E Al = 5%, B2=10%, andC3=85%

Consider this CellCLI command:
CellCLI> CREATE GRIDDISK ALL HARDDISK PREFIX=data, size=423G;
Which two statements describe what happens when you execute this command?

A It creates one 423 GB grid disk on the first available cell hard disk.
B It creates one 423 GB grid disk on each available cell hard disk.
C It creates grid disks on the outermost 423 GB that is available on each hard disk.
D It creates grid disks on the innermost 423 GB that is available on each hard disk.
E It creates an Exadata Smart Flash Cache on all flash drives.

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?

A Use the ILOM Web GUI.
B Use the dcli command at the root prompt on a database node.
C Attach a terminal device tothe back panel of the server with a serial cable.
D Connect by using SQL *Plus.
E Log in as root on the database node using the Net1 IP address.

Identify three best practices for applying asmdeactivationoutcome es on Exadata Database Servers and Exadata Storage Servers?

A Backing up database servers and storage cells is not recommended before performing plannedmaintenance.
B Database server updates can be rolled back using the "yum downgrade"procedure.
C Bundle patches do not require testing before being installed on a production system.
D It is recommended that Exadata systems with Data Guard configured use the"Standby First" patching approach.
E Patching should never be interrupted due to a connection drop. It is therefore recommended that you use VNC or the screen utility.
F Before patching cells in a rolling manner, you must check asmdeactivationoutcome amModestatus and make sure that cells on all disks are online and that

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?

A Average the mpstat id1 output from all the nodes.
B Ask application users if they have noticed a slowdown in screen response.
C Look for an increase in batch job servicing times.
D A & B above

Identify three Exadata Storage Server software processes and their purpose?

A CELLSRV: The Cell Server is responsible for servicing disk I/O and predicate processing offload.
B CELLSRV: The Cell Server is responsible for balancing workload to other storage servers.
C MS: The Management Server is responsible for storage cell management and configuration.
D MS: The Management Server is responsible for starting a local Enterprise Manager agent.
E RS: The Restart Server is responsible for Automatic Storage Management (ASM) instance restart.
F RS: The Restart Server is responsible for CELLSRV and MS monitoring and restart.

Which two attributes describe key benefits of the InfiniBand network?

A All Exadata database servers have a direct path link to each Exadata Storage Server.
B Cell-to-cell communication uses Reliable Datagram Sockets (RDS) over InfiniBand to achieve low latency.
C Expanding from two Full racks to four only requires adding an external InfiniBand switch to be at the top of the fat-tree topology.
D Each InfiniBand link provides 10 Gigabits of bandwidth.
E Oracle's interconnect protocol uses direct memory access (DMA) to eliminate buffer copies and reduce CPU use.

Which two statements are true about troubleshooting failed patching activities?

A Dependency issues found during yum updates require rolling back to a previous release before retrying.
B Bundle patches applied using opatch auto cannot roll back only the database or the grid infrastructure home.
C Failed OS patches on database servers can be rolled back.
D Failed storage cell patches are rolled back to the previous release automatically.
E Database server OS updates can be rolled back using opatch auto -rollback.
F Dependency issues found during yum updates should be ignored using the force option.

Which two DML operations will add rows compressed by Hybrid Columnar Compression (HCC) to a table that is created to use HCC?

A INSERT
B insert with an append hint
C UPDATE
D CREATE TABLE AS SELECT