Examine the parameters for your database instance:
NAMETYPE VALUE
————————– ——————————- —————————
undo_management string AUTO
undo_retentioninteger 12 00
undo_tablespace string UNDOTBS1
You execute the following command:
SQL> ALTER TABLESPACE undotbs1 RETENTION NOGUARANTEE;
Which statement is true in this scenario?
A.
Undo data is written to flashback logs after 1200 seconds.
B.
Inactive undo data is retained for 1200 seconds even if subsequent transactions fail due to lack of
space in the undo tablespace.
C.
You can perform a Flashback Database operation only within the duration of 1200 seconds.
D.
An attempt is made to keep inactive undo for 1200 seconds but transactions may overwrite the undo
before that time has elapsed.
New 1Z0-062 Exam Questions Updated Recently (23/May/2017):
NEW QUESTION 273
SMD is a smallfile locally managed tablespace with manual segment space management. The SH user receives the following error while inserting data into the sales table:
ERROR at line 1:
ORA-01653: unable to extend table SH.SALES by 128 in tablespace SMD.
Which three actions can be taken to enable the user to insert data? (Choose three.)
A. Altering the data file associated with the SMD tablespace to grow automatically.
B. Adding a data file to the SMD tablespace, provided the tablespace has not reached its maximum number of file
C. Changing segment space management for the SMD tablespace to automatic.
D. Resizing the data file associated with the SMD tablespace to make it larger, provided all data files have not yet reached their maximum size.
E. Increasing the space quota on the SMD tablespace for the SH user, provided the files have not yet reached their maximum size.
Answer: CDE
NEW QUESTION 274
In your database instance, the UNDO_RETENTION parameter is set to 1000 and undo retention is not guaranteed for the fixed size undo tablespace. Which statement is true about undo retention?
A. Undo is retained in the UNDO tablespace for 1000 seconds, and then moved to the SYSTEM tablespace to provide read consistency.
B. Inactive undo is retained for at least 1000 seconds if free undo space is available.
C. Inactive undo is retained for 1000 seconds even if new transactions fall due to lack of space in the undo tablespace.
D. Undo becomes expired obsolete after 1000 seconds.
Answer: A
NEW QUESTION 275
Which two files must you copy from the Oracle home of the database that is being upgraded to the new Oracle home for Oracle Database 12c? (Choose three.)
A. the tnsnames.ora file
B. the sqlnet.ora file
C. the initialization parameter file
D. the password file
E. the listener.ora file
Answer: ABE
NEW QUESTION 276
In your Oracle 12c database, you invoke SQL *Loader Express Mode command to load data:
$> sqlldr hr/hr table=employees
Which two statements are true about this command? (Choose two.)
A. It succeeds and creates the EMPLOYEES table in the HR schema if the table does not exist.
B. It fails because the SQL *Loader control file location is not specified.
C. It fails because the SQL *Loader data file location is not specified.
D. It succeeds with default settings if the EMPLOYEES table belonging to the HR schema is already defined in the database.
E. It succeeds even if the HR user does not have the CREATE DIRECTORY privilege.
Answer: DE
NEW QUESTION 277
Backup requirements for a database:
* Level 0 backup on Sunday
* Cumulative incremental level 1 backup on Monday, Wednesday, and Saturday
* Differential incremental level 1 backup on Tuesday, Thursday, and Friday
Which three statements are true about the strategy? (Choose three.)
A. Level 0 backup on Sunday contains all the blocks that have been formatted.
B. Level 0 backup on Sunday contains all the blocks that have been changed since the last level 1 backup.
C. Level 1 backup on Tuesday, Thursday, and Friday contains all the blocks that have been changed since the last level 1 backup.
D. Level 1 backup on Monday, Wednesday, and Saturday contains all the blocks that have been changed since the last level 0 backup.
E. Level 1 backup on Tuesday, Thursday, and Friday contains all the blocks that have been changed since the last level 0 backup.
Answer: BDE
NEW QUESTION 278
When is the UNDO_RETENTION parameter value ignored by a transaction?
A. when there are multiple undo tablespaces available in a database
B. when the data file of the undo tablespace is autoextensible
C. when the undo tablespace is of a fixed size and retention guarantee is not enabled
D. when Flashback Database is enabled
Answer: C
NEW QUESTION 279
Which two statements are true about the Database Configuration Assistant (DBCA)? (Choose two.)
A. It can be used to create a database template from an existing database.
B. It can be used to add a new tablespace.
C. It can generate SQL database creation scripts.
D. It can be used to copy an existing Oracle database to a new host and apply any patches necessary in the new host.
E. It can configure Automatic Storage Management (ASM) diskgroups.
Answer: AE
NEW QUESTION 280
You are managing an Oracle Database 12c database. The database is open, and you plan to perform Recovery Manager (RMAN) backups. Which three statements are true about these backups? (Choose three.)
A. The backups would be consistent.
B. The backups would be possible only if the database is running in ARCHIVELOG mode.
C. The backups need to be restored and the database has to be recovered in case of a media failure.
D. The backups would be inconsistent.
E. The backups by default consist of all the data blocks within the chosen files or the full database.
Answer: BDE
NEW QUESTION 281
Which three tools or tasks are run by default as part automated maintenance tasks? (Choose three.)
A. Automatic Database Diagnostic Monitor
B. optimizer statistics gathering
C. SQL Access Advisor
D. Segment Advisor
E. Automatic SQL Tuning Advisor
Answer: CDE
NEW QUESTION 282
You plan to upgrade your Oracle Database 9i to Oracle Database 12c. Which two methods can you use? (Choose two.)
A. Perform a rolling upgrade.
B. Perform a direct upgrade by running the Database Upgrade Assistant (DBUA).
C. Perform a direct upgrade by manually running the catctl.pl and catupgrd.sql scripts before issuing the STARTUPUPGRADE command.
D. Install the Oracle Database 12c software, create a new Oracle 12c database, and then use the Oracle Data Pump to import data from the source Oracle 9i database to the target Oracle 12c database.
E. Upgrade your current database to Oracle Database release 10.2.0.5, and then upgrade to Oracle Database 12c.
Answer: CD
NEW QUESTION 283
Examine the following command:
SQL> DBMS_STATS. SET_TABLE_PREFS (‘SH’, ‘CUSTOMERS’, ‘PUBLISH’, ‘false’);
What is the effect of executing this command?
A. Existing statistics for the CUSTOMERS table become unusable for the query optimizer.
B. Automatic statistics collection is stopped for the CUSTOMERS table.
C. Statistics for the CUSTOMERS table are locked and cannot be overwritten.
D. Statistics subsequently gathered on the CUSTOMERS table are stored as pending statistics.
Answer: D
NEW QUESTION 284
Which four statements are true about the components of the Oracle Scheduler? (Choose four.)
A. A schedule can be specified to a single job only.
B. A scheduler job can point to a chain instead of pointing to a single program object.
C. A job may get started automatically when a window opens.
D. A program and job can be specified as part of a schedule definition.
E. A job is specified as part of a program specification.
F. A program can be used in the definition of multiple jobs.
G. A program and schedule can be specified as part of a job definition.
Answer: BCFG
NEW QUESTION 285
Which three statements are true about checkpointing? (Choose three.)
A. It prompts the Checkpoint (CKPT) process to write data to the data files and redo information to the online redo log files.
B. It ensures that all dirty buffers are written to data files during consistent shutdown.
C. It reduces the time required for recovery in case of an instance failure.
D. Frequent thread checkpoints can degrade database performance.
E. It prompts the Database Writer (DBWn) process to write checkpoint information into data file headers and the control file.
Answer: BCE
NEW QUESTION 286
Your database instance has Automatic Memory Management enabled and supports shared server connections. Examine the following:
1. Parallel execution messages and control structures
2. Local variables for a process
3. Security and resource usage information
4. Runtime memory values, such as rows retrieved for a SQL statement using a serial execution plan
5. SQL execution work areas
Which option indicates what is allocated from the large pool in this instance?
A. only 1
B. 1, 2, and 5
C. 1, 2, 3, and 5
D. 1, 2, and 4
Answer: D
NEW QUESTION 287
You install Oracle Grid Infrastructure for a standalone server. Which two components are automatically included in the Oracle Restart configuration? (Choose two.)
A. A pre-existing Oracle Net Listener
B. Oracle Notification services
C. A pre-existing database
D. A pre-existing Oracle management agent
E. Oracle CSSD service
Answer: BC
NEW QUESTION 288
……
P.S. These New 1Z0-062 Exam Questions Were Just Updated From The Real 1Z0-062 Exam, You Can Get The Newest 1Z0-062 Dumps In PDF And VCE From — http://www.passleader.com/1z0-062.html (314q VCE and PDF)
Good Luck!
BTW, part of that new 314Q 1Z0-062 dumps FYI:
https://drive.google.com/open?id=0B-ob6L_QjGLpZVhqd2dmaHZoZlE
Best Regards!
New 1Z0-062 Exam Questions Updated Recently (2/Sep/2017):
NEW QUESTION 318
Which statement is true about profiles?
A. Resource limits specified in a profile assigned to a user are always enabled.
B. A user can exist without any profile.
C. A profile can be assigned only to one user.
D. Password management using profiles is always enabled.
Answer: D
NEW QUESTION 319
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.
Answer: ABE
NEW QUESTION 320
Which task is performed by a background process in a database instance?
A. Connecting between a client process and a dispatcher
B. Executing PL/SQL code
C. Creating dedicated server connections
D. Copying online redo log files to offline storage
Answer: D
NEW QUESTION 321
Your database instance is started with a PFILE. You want to increase the size of the buffer cache. Free memory is available to increase the size of the buffer cache. You execute the command:
SQL> ALTER SYSTEM SET DB_CACHE_SIZE=1024M;
Which is the outcome?
A. Change is applied to the current instance, but does not persist after instance restart.
B. The value is changed only in the PFILE and takes effect at the next instance startup.
C. The value is changed for the current instance and in the PFILE.
D. It fails because the SCOPE clause is missing.
Answer: A
NEW QUESTION 322
Which statement is true redo log files during instance recovery?
A. All redo log entries in the current log are applied to data files until the checkpoint position is reached.
B. All redo log entries in the current and active logs are applied to data files to reconstruct changes made after the most recent checkpoint.
C. All current, active, and inactive redo logs are required to complete instance recovery.
D. All current, online, and archived redo logs are required to complete instance recovery.
Answer: B
NEW QUESTION 323
Examine the command:
SQL> ALTER SYSTEM SET ENABLE_DDL_LOGGING=TRUE;
Which two statements are true in this scenario? (Choose two.)
A. All data definition language (DDL) commands ae logged in to the alert log file.
B. All DDL commands are logged in to a text file in Automatic Diagnostic Repository (ADR) home.
C. A subset of executed DDL statements is written into an XML file in ADR home.
D. A subset of executed DDL statements is written to the DDL log in ADR home.
E. All DDL commands are logged in to a trace file in ADR home.
Answer: CD
NEW QUESTION 324
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.
Answer: B
NEW QUESTION 325
Which component resides in the System Global Area (SGA) of a database instance only in shared server connections?
A. User Global Area
B. Programs Global Area
C. SQL Query Result Cache
D. PL/SQL Function Result Cache
Answer: A
NEW QUESTION 326
Identify three situations in which messages are written to the alert log file. (Choose three.)
A. Rebuilding an index using ALTER INDEX . . . REBUILD fails with an ORA-01578: ORACLE data block corrupted (file # 14, block # 50)”
B. Creating a table returns “ORA-00955: name is already in used by an existing object”
C. Inserting a value into a table returns “ORA-01722: invalid number”
D. Updating a record in a table returns “ORA-00060: deadlock detected while waiting for resource”
E. Inserting a value into a table returns “ORA-00001: unique constraint (SYS.PK_XXXX) violated”
F. Running a query on a table returns “ORA-01578: ORACLE data block corrupted (file # 4, block # 131)”
Answer: ADF
NEW QUESTION 327
Which three statements are true about Enterprise Manager Database Express? (Choose three.)
A. It can be used to perform database backup operations.
B. It can use the HTTP protocol.
C. The same port number is used for multiple Database Express configurations on the same host.
D. It can use the HTTPS protocol.
E. It is available only when the database is open.
Answer: BDE
NEW QUESTION 328
When does a database checkpoint occur?
A. When there is an online redo log switch.
B. When a user session terminates abnormally.
C. When a server process terminates abnormally.
D. When the SHUTDOWN ABORT command is issued.
Answer: A
NEW QUESTION 329
What action must you take to ensure complete database recovery till the point of failure?
A. Multiplex the control files.
B. Duplex the RMAN backup sets.
C. Multiplex the online redo log files.
D. Configure the database to run in ARCHIVELOG mode.
Answer: D
NEW QUESTION 330
You want to create a table, DAILY_ORDERS, for an OLTP application, where data should be compressed during both direct path INSERT and conventional DML. The table will also be used for queries. Which compression option should be used?
A. ROW STORE COMPRESS
B. COLUMN STORE COMPRESS FOR QUERY
C. COLUMN STORE COMPRESS FOR ARCHIVE LOW
D. ROW STORE COMPRESS ADVANCED
Answer: D
NEW QUESTION 331
An application repeatedly accesses small lookup tables, causing a lot of physical I/O operations. What do you recommend to minimize this?
A. Configure the nonstandard buffer cache with a buffer size greater than the size of the default buffer cache.
B. Increase the size of the shared pool.
C. Configure the KEEP buffer cache and alter the tables to use the KEEP cache.
D. Configure the RECYCLE buffer cache and alter the tables to use the RECYCLE cache.
Answer: C
NEW QUESTION 332
Examine the command:
SQL> CREATE TABLESPACE test1
DATAFILE ‘/u01/app/oracle/oradata/orc1/test01.dbf’ SIZE 5M AUTOEXTEND ON UNIFORM;
Which statement is true?
A. The data file, TEST01.DBF, can be auto extended to a maximum size of 5M.
B. The tablespace, TEST1, can contain a maximum of one data file.
C. Allocated and free extents are tracked using bitmaps.
D. Segment free space is tracked in the data dictionary.
Answer: C
NEW QUESTION 333
Your database is open in read/write mode and multiple users are connected to the database instance. You execute the following command:
SQL> ALTER SYSTEM ENABLE RESTRICTED SESSION;
What would be the effect on current sessions?
A. They are not terminated but may only issue queries.
B. They are not affected.
C. They are terminated immediately.
D. They are terminated after completing the transaction.
Answer: B
NEW QUESTION 334
You want to distribute a set of structured data to your customers who can integrate this data into their existing databases irrespective of the platform. Which method provides the fastest way of achieving this?
A. using the DBVERIFY utility
B. using direct-path INSERT SQL statements
C. using SQL*Loader
D. using RMAN transportable tablespace operation
Answer: B
NEW QUESTION 335
You create a locally managed tablespace ORDERS_TBS with automatic segment management. You then create the table DAILY_ORDS_LST in the ORDERS_TBS tablespace using the command:
CREATE TABLE daily_ords_1st(ordno NUMBER, ord_date DATE) PCTFREE 20;
How does the PCTFREE storage parameter influence data storage for this table?
A. It allows only 80% of space to be occupied in all data blocks of this table.
B. It minimizes row chaining during row insertion.
C. It minimizes row migration during existing row data updation.
D. It automatically coalesces free space of a data block when it reaches 20% of available space.
Answer: A
NEW QUESTION 336
……
P.S. These New 1Z0-062 Exam Questions Were Just Updated From The Real 1Z0-062 Exam, You Can Get The Newest 1Z0-062 Dumps In PDF And VCE From — https://www.passleader.com/1z0-062.html (354q VCE and PDF)
Good Luck!
BTW, part of new 354Q 1Z0-062 dumps are available here:
https://drive.google.com/open?id=0B-ob6L_QjGLpZVhqd2dmaHZoZlE
Best Regards!
D is the answer I guess