Oracle 1Z0-062 Online Practice Questions and Exam Preparation

Oracle 1Z0-062 Online Questions & Answers

• Question 291:

  Examine the contents of SQL loader control file:

  

  Which three statements are true regarding the SQL* Loader operation performed using the control file? (Choose three.)

  A. An EMP table is created if a table does not exist. Otherwise, if the EMP table is appended with the loaded data.
  B. The SQL* Loader data file myfile1.dat has the column names for the EMP table.
  C. The SQL* Loader operation fails because no record terminators are specified.
  D. Field names should be the first line in the both the SQL* Loader data files.
  E. The SQL* Loader operation assumes that the file must be a stream record format file with the normal carriage return string as the record terminator.
  A. An EMP table is created if a table does not exist. Otherwise, if the EMP table is appended with the loaded data.
  B. The SQL* Loader data file myfile1.dat has the column names for the EMP table.
  E. The SQL* Loader operation assumes that the file must be a stream record format file with the normal carriage return string as the record terminator.

  ---

  A: The APPEND keyword tells SQL*Loader to preserve any preexisting data in the table. Other options allow you to delete preexisting data, or to fail with an error if the table is not empty to begin with.

  B (not D): Note:

  * SQL*Loader-00210: first data file is empty, cannot process the FIELD NAMES record

  Cause: The data file listed in the next message was empty. Therefore, the FIELD NAMES FIRST FILE directive could not be processed.

  Action: Check the listed data file and fix it. Then retry the operation

  E:

  *

  A comma-separated values (CSV) (also sometimes called character-separated values, because the separator character does not have to be a comma) file stores tabular data (numbers and text) in plain-text form. Plain text means that the

  file is a sequence of characters, with no data that has to be interpreted instead, as binary numbers. A CSV file consists of any number of records, separated by line breaks of some kind; each record consists of fields, separated by some other

  character or string, most commonly a literal comma or tab. Usually, all records have an identical sequence of fields.

  *

  Fields with embedded commas must be quoted.

  Example:

  1997,Ford,E350,"Super, luxurious truck"

  Note:

  *

  SQL*Loader is a bulk loader utility used for moving data from external files into the Oracle database.

• Question 292:

  What is the outcome of the SHUTDOWN ABORT command?

  A. Pending transactions are committed and the database is closed.
  B. Dirty buffers in the buffer cache and unwritten redo are not written to the data files and redo log files respectively.
  C. Uncommitted transactions are rolled back
  D. Instance recovery must be requested by the DBA at the next startup
  B. Dirty buffers in the buffer cache and unwritten redo are not written to the data files and redo log files respectively.

• Question 293:

  Which two actions does an incremental checkpoint perform? (Choose two.)

  A. It signals CKPT to write the checkpoint position to the data file headers.
  B. It writes the checkpoint position to the data file headers.
  C. It advances the checkpoint position in the checkpoint queue.
  D. It writes the checkpoint position to the control file.
  C. It advances the checkpoint position in the checkpoint queue.
  D. It writes the checkpoint position to the control file.

  ---

  References: http://www.dba-oracle.com/t_incremental_checkpoint.htm

• Question 294:

  You must upgrade your Oracle 11g to Database to Oracle 12c R2. Which method can you use?

  A. Perform a rolling upgrade.
  B. Perform a direct upgrade by running the Database Upgrade Assistant (DBUA).
  C. Use Enterprise Manager Express.
  D. Use SQL*Developer
  E. Use the Database Creation Assistant (DBCA) to upgrade
  B. Perform a direct upgrade by running the Database Upgrade Assistant (DBUA).

  ---

  Reference: https://oracle-base.com/articles/12c/upgrading-to-12c

• Question 295:

  You want to create a database with a block size other than the default 8 kilobytes (KB) by using the Database Configuration Assistant (DBCA).

  Which option should you use?

  A. Automatic Storage Management (ASM) for storage of data files
  B. a file system for storage of data files
  C. a Data Warehouse database template
  D. a custom database template
  D. a custom database template

• Question 296:

  Which three resources might be prioritized between competing pluggable databases when creating a multitenant container database plan (CDB plan) using Oracle Database Resource Manager? (Choose three.)

  A. Maximum Undo per consumer group
  B. Maximum Idle time
  C. Parallel server limit
  D. CPU
  E. Exadata I/O
  F. Local file system I/O
  C. Parallel server limit
  D. CPU
  E. Exadata I/O

• Question 297:

  Which two statements are true about the Oracle Direct Network File system (DNFS)? (Choose two.)

  A. It utilizes the OS file system cache.
  B. A traditional NFS mount is not required when using Direct NFS.
  C. Oracle Disk Manager can manage NFS on its own, without using the operating kernel NFS driver.
  D. Direct NFS is available only in UNIX platforms.
  E. Direct NFS can load-balance I/O traffic across multiple network adapters.
  C. Oracle Disk Manager can manage NFS on its own, without using the operating kernel NFS driver.
  E. Direct NFS can load-balance I/O traffic across multiple network adapters.

  ---

  E: Performance is improved by load balancing across multiple network interfaces (if available).

  Note:

  *

  To enable Direct NFS Client, you must replace the standard Oracle Disk Manager (ODM) library with one that supports Direct NFS Client.

  Incorrect:

  Not A: Direct NFS Client is capable of performing concurrent direct I/O, which bypasses any operating system level caches and eliminates any operating system write-ordering locks Not B:

  *

  To use Direct NFS Client, the NFS file systems must first be mounted and available over regular NFS mounts.

  *

  Oracle Direct NFS (dNFS) is an optimized NFS (Network File System) client that provides faster and more scalable access to NFS storage located on NAS storage devices (accessible over TCP/IP). Not D: Direct NFS is provided as part of the database kernel, and is thus available on all supported database platforms - even those that don't support NFS natively, like Windows.

  Note:

  *

  Oracle Direct NFS (dNFS) is an optimized NFS (Network File System) client that provides faster and more scalable access to NFS storage located on NAS storage devices (accessible over TCP/IP). Direct NFS is built directly into the database kernel - just like ASM which is mainly used when using DAS or SAN storage.

  *

  Oracle Direct NFS (dNFS) is an internal I/O layer that provides faster access to large NFS files than traditional NFS clients.

• Question 298:

  Which three statements are true about naming methods? (Choose three.)

  A. Local naming supports multiple protocols, but for any one connection, the client and server must use the same protocol.
  B. In the Easy Connect method, clients can connect to a database server by using the host name of the database with an optional port and service name.
  C. In the Easy Connect method, the listener port and IP address must be provided for the connection to be successful.
  D. The local naming method does not support connect-time failover and load-balancing options.
  E. The directory naming method supports connect-time failover and load-balancing options.
  A. Local naming supports multiple protocols, but for any one connection, the client and server must use the same protocol.
  B. In the Easy Connect method, clients can connect to a database server by using the host name of the database with an optional port and service name.
  E. The directory naming method supports connect-time failover and load-balancing options.

• Question 299:

  A database is stored in an Automatic Storage Management (ASM) disk group, disk group, DGROUP1 with SQL:

  

  There is enough free space in the disk group for mirroring to be done.

  What happens if the CONTROLLER1 failure group becomes unavailable due to error of for maintenance?

  A. Transactions and queries accessing database objects contained in any tablespace stored in DGROUP1 will fall.
  B. Mirroring of allocation units will be done to ASM disks in the CONTROLLER2 failure group until the CONTROLLER1 for failure group is brought back online.
  C. The data in the CONTROLLER1 failure group is copied to the controller2 failure group and rebalancing is initiated.
  D. ASM does not mirror any data until the controller failure group is brought back online, and newly allocated primary allocation units (AU) are stored in the controller2 failure group, without mirroring.
  E. Transactions accessing database objects contained in any tablespace stored in DGROUP1 will fail but queries will succeed.
  D. ASM does not mirror any data until the controller failure group is brought back online, and newly allocated primary allocation units (AU) are stored in the controller2 failure group, without mirroring.

• Question 300:

  Which naming method enables clients to connect to a database instance without any client side configuration in sqlnet.ora or tnsnames.ora?

  A. the external naming method
  B. the easy connect method
  C. the local naming method
  D. the directory naming method
  A. the external naming method

  ---

  Reference: https://docs.oracle.com/cd/F49540_01/DOC/network.815/a67440/ch6.htm