Cisco®
Oracle
CompTIA
Checkpoint
ISC
EC-Council
EXIN
Fortinet
ITIL®
Juniper
Microsoft
VMware
Avaya
SAP
Google
Salesforce
Amazon
Palo Alto Networks
All Vendors
  2. Home
  3. Exams
  4. Oracle
  5. 1Z0-062

Free Oracle 1Z0-062 Exam Questions (page: 11)

Page 11 of 87
PDF with 419 Questions

Which statement is true about the Log Writer process?

  1. It writes when it receives a signal from the checkpoint process (CKPT).
  2. It writes concurrently to all members of multiplexed redo log groups.
  3. It writes after the Database Writer process writes dirty buffers to disk.
  4. It writes when a user commits a transaction.

Answer(s): D


Reference:

http://docs.oracle.com/cd/B19306_01/server.102/b14220/process.htm (see log writer process (LGWR))



A user establishes a connection to a database instance by using an Oracle Net connection.
You want to ensure the following:
1. The user account must be locked after five unsuccessful login attempts.
2. Data read per session must be limited for the user.
3. The user cannot have more than three simultaneous sessions.
4. The user must have a maximum of 10 minutes session idle time before being logged off automatically.
How would you accomplish this?

  1. by granting a secure application role to the user
  2. by implementing Database Resource Manager
  3. by using Oracle Label Security options
  4. by assigning a profile to the user

Answer(s): D



You administer an online transaction processing (OLTP) system whose database is stored in Automatic Storage Management (ASM) and whose disk group use normal redundancy.
One of the ASM disks goes offline, and is then dropped because it was not brought online before DISK_REPAIR_TIME elapsed.
When the disk is replaced and added back to the disk group, the ensuing rebalance operation is too slow.
Which two recommendations should you make to speed up the rebalance operation if this type of failure happens again? (Choose two.)

  1. Increase the value of the ASM_POWER_LIMIT parameter.
  2. Set the DISK_REPAIR_TIME disk attribute to a lower value.
  3. Specify the statement that adds the disk back to the disk group.
  4. Increase the number of ASMB processes.
  5. Increase the number of DBWR_IO_SLAVES in the ASM instance.

Answer(s): A,D

Explanation:

A: ASM_POWER_LIMIT specifies the maximum power on an Automatic Storage Management instance for disk rebalancing. The higher the limit, the faster rebalancing will complete. Lower values will take longer, but consume fewer processing and I/O resources.
D: * Normally a separate process is fired up to do that rebalance. This will take a certain amount of time. If you want it to happen faster, fire up more processes. You tell ASM it can add more processes by increasing the rebalance power.
* ASMB
ASM Background Process
Communicates with the ASM instance, managing storage and providing statistics Incorrect:
Not B: A higher, not a lower, value of DISK_REPAIR_TIME would be helpful here. Not E: If you implement database writer I/O slaves by setting the DBWR_IO_SLAVES parameter, you configure a single (master) DBWR process that has slave processes that are subservient to it. In addition, I/O slaves can be used to "simulate" asynchronous I/O on platforms that do not support asynchronous I/O or implement it inefficiently. Database I/O slaves provide non-blocking, asynchronous requests to simulate asynchronous I/O.



Which two statements are true about Oracle Managed Files (OMF)? (Choose two.)

  1. OMF cannot be used in a database that already has data files created with user- specified directions.
  2. The file system directions that are specified by OMF parameters are created automatically.
  3. OMF can be used with ASM disk groups, as well as with raw devices, for better file management.
  4. OMF automatically creates unique file names for table spaces and control files.
  5. OMF may affect the location of the redo log files and archived log files.

Answer(s): D,E

Explanation:

D: The database internally uses standard file system interfaces to create and delete files as needed for the following database structures:
Tablespaces
Redo log files
Control files
Archived logs
Block change tracking files
Flashback logs
RMAN backups
Note:
* Using Oracle-managed files simplifies the administration of an Oracle Database. Oracle- managed files eliminate the need for you, the DBA, to directly manage the operating system files that make up an Oracle Database. With Oracle-managed files, you specify file
system directories in which the database automatically creates, names, and manages files at the database object level. For example, you need only specify that you want to create a tablespace; you do not need to specify the name and path of the tablespace's datafile with the DATAFILE clause.
http://www.oracle-base.com/articles/9i/oracle-managed-files.php http://docs.oracle.com/cd/B10500_01/server.920/a96521/omf.htm



Viewing page 11 of 87



Post your Comments and Discuss Oracle 1Z0-062 exam prep with other Community members:

1Z0-062 Exam Discussions & Posts