Examine the following query output:
You issue the following command to import tables into the hr schema:
$ > impdp hr/hr directory = dumpdir dumpfile = hr_new.dmp schemas=hr
TRANSFORM=DISABLE_ARCHIVE_LOGGING: Y
Which statement is true?
A.
All database operations performed by the impdp command are logged.
B.
Only CREATE INDEX and CREATE TABLE statements generated by the import are logged.
C.
Only CREATE TABLE and ALTER TABLE statements generated by the import are logged.
D.
None of the operations against the master table used by Oracle Data Pump to coordinate its
activities are logged.
Explanation:
Oracle Data Pump disable redo logging when loading data into tables and when
creating indexes.
The new TRANSFORM option introduced in data pumps import provides the flexibility to turn off
the redo generation for the objects during the course of import. The Master Table is used to track
the detailed progress information of a Data Pump job.
The Master Table is created in the schema of the current user running the Pump Dump export or
import, and it keeps tracks of lots of detailed information.
the answer is “B”
“DISABLE_ARCHIVE_LOGGING:[Y | N]
If set to Y, then the logging attributes for the specified object types (TABLE and/or INDEX) are disabled before the data is imported. If set to N (the default), then archive logging is not disabled during import. After the data has been loaded, the logging attributes for the objects are restored to their original settings. If no object type is specified, then the DISABLE_ARCHIVE_LOGGING behavior is applied to both TABLE and INDEX object types. This transform works for both file mode imports and network mode imports. It does not apply to transportable tablespace imports.”
http://docs.oracle.com/database/121/SUTIL/dp_import.htm#SUTIL939
Correct Answer is “C”!!!
“The new TRANSFORM option, DISABLE_ARCHIVE_LOGGING, to the impdp command line causes Oracle Data Pump to disable redo logging when loading data into tables and when creating indexes. It also adds the same option as part of the PL/SQL DBMS_DATAPUMP package. With redo logging disabled, the disk space required for redo logs during an Oracle Data Pump import is smaller. However, to ensure recovery from media failure, the DBA should do an RMAN backup after the import completes.
Even with this parameter specified, there is still redo logging for other operations of Oracle Data Pump. This includes all CREATE and ALTER statements, except CREATE INDEX, and all operations against the master table used by Oracle Data Pump during the import.”
http://docs.oracle.com/database/121/NEWFT/chapter12101.htm#NEWFT253
D
Without “Only”, answer C is also correct.
But from docu
This includes all CREATE and ALTER statements, except CREATE INDEX, and all operations against the master table used by Oracle Data Pump during the import.
http://docs.oracle.com/database/121/NEWFT/chapter12101.htm#NEWFT253
Answer D for me is correct
C
D
C
C is correct
D incorrect!!!
A small amount of logging will still happen when the objects are created
in the database. If the database is running in FORCE LOGGING mode, setting this parameter
has no effect.
Logging is disabled by using the TRANSFORM parameter. The syntax is
TRANSFORM=DISABLE_ARCHIVE_LOGGING:Y|N[:TABLE|INDEX]
You can choose to disable logging for tables, indexes, or both. If you specify Y:TABLE,
logging is disabled for table loads. If you specify Y:INDEX, logging is disabled only for index
creation. If you do not specify TABLE or INDEX along with Y, logging is disabled for both
tables and indexes.
B.
C
New 1Z0-062 Exam Questions and Answers Updated Recently (12/July/2016):
NEW QUESTION 181
Which three statements are true about the Pre-Upgrade Information Tool?
A. It clears all user recycle bins in a database and releases their storage space.
B. It writes a list of invalid SYS and SYSTEM objects to the registry$sys_inv_objs table.
C. It evaluates the dependencies of network utility packages.
D. It identifies any deprecated and unsupported parameters.
E. It generates fix-up scripts and automatically runs them to resolve issues that are flagged in the source database.
Answer: BCD
NEW QUESTION 182
Which activity is audited by default and recorded in the operating system audit trail irrespective of whether or not database auditing is enabled?
A. configuration of unified auditing mode
B. execution of SQL statements by users connected with the SYSDBA privilege
C. usage of the AUDIT statement
D. creation of a fine grained audit policy
Answer: B
NEW QUESTION 183
Which two tasks must you perform before you begin the upgrade process to Oracle Database 12c?
A. Put all readonly tablespaces in read write mode
B. Recompile all invalid objects
C. Set the compatible parameter to 12 1 0 1
D. Gather dictionary statistics
E. Empty all user recycle bins
Answer: CD
NEW QUESTION 184
Which two tools can be used to configure static service information in the listener.ora file?
A. Oracle Net Manager
B. Oracle Enterprise Manager Cloud Control
C. Oracle Net Configuration Assistant
D. Listener Control Utility (LSNRCTL)
E. Oracle Enterprise Manager Database Express
Answer: AC
NEW QUESTION 185
In your database, the STATISTICS_LEVEL parameter is set to TYPICAL and a Automatic Workload Repository (AWR) snapshot is taken every 30 minutes. Which two statements are true about the Automatic Database Diagnostic Monitor (ADDM)?
A. It runs after each AWR snapshot is created and it requires at least two snapshots for analysis.
B. It measures database performance by analyzing the wait time and CPU time of all non-idle user sessions.
C. It calls other advisors if required, but does not provide recommendations about the advisors to be used.
D. It always compares the latest snapshot with the baseline snapshot for analysis.
E. It requires at least four AWR snapshots for analysis.
Answer: AB
NEW QUESTION 186
Which three file types are stored in the Fast Recovery Area by default in a traditional nonOMF file system?
A. online redo log files
B. parameter file
C. multiplexed copies of the current control file
D. archived log files
E. Flashback Data Archive files
F. Flashback logs
Answer: ACD
NEW QUESTION 187
You want to create a database with a block size other than the default 8 KB by using the Database Configuration Assistant (DBCA). Which option should you use?
A. A custom database template
B. A Data Warehouse database template
C. Automatic Storage Management (ASM) for storage of data files
D. A file system for storage of data files
Answer: A
NEW QUESTION 188
Which two statements are true about the Database Configuration Assistant (DBCA)?
A. It can be used to add an new tablespace
B. It can be used to copy an existing Oracle database to a new host and apply any patches necessary in the new host
C. It can configure Automatic Storage Management (ASM) diskgroups
D. It can be used to create a database template from an existing database
E. It can generate SQL database creation scripts
Answer: CD
NEW QUESTION 189
Identify two prerequisites for configuring Enterprise Manger Database Express (EM Express).
A. Grant the APEX_PUBLIC_USER role to the SYSMAN user
B. Install Oracle HTTP Server
C. Use the DBMS_XDB_CONFIG.SETHTTPPORT procedure to configure a port number for Oracle HTTP Server
D. Configure at least one dispatcher for the TCP/IP protocol
E. Create a SYSMAN user with the SYSDBA privilege as an administration for EM Express
Answer: CE
NEW QUESTION 190
Which three tools or tasks are run by default as part of automated maintenance tasks?
A. SQL Access Advisor
B. Optimizer statistics gathering
C. Segment Advisor
D. Automatic SQL Tuning Advisor
E. Automatic Database Diagnostic Monitor
Answer: BCD
NEW QUESTION 191
Which three statements are true about automated maintenance tasks?
A. Predefined maintenance tasks consist of automatic optimizer statistics collection, running Automatic Segment Advisor, and running Automatic SQL Tuning Advisor
B. A repository is maintained in the SYSTEM tablespace to store the history of execution of all tasks
C. They run at predefined time intervals that are intended to occur during a period of low system loads
D. An Oracle Scheduler job is created for each maintenance tasks that is scheduled to run in a maintenance window
E. A maintenance window is automatically extended until all the maintenance tasks defined are completed
Answer: ACD
NEW QUESTION 192
……
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://bit.ly/1z0-062-dumps-vce-pdf (210q)
Good Luck !!!
BTW, NEW 1Z0-062 PDF Dumps from Google Drive for Free: https://drive.google.com/open?id=0B-ob6L_QjGLpZVhqd2dmaHZoZlE
[Update]
New 1Z0-062 Exam Questions and Answers Updated Recently (21/Feb/2017):
NEW QUESTION 211
Your database instance has the following parameter setting:
OS_AUTHENT_PREFIX = OPS$
You execute the following command:
Image URL: examgod.com/plimages/f3ccc3dc6dfc_FCD9/passleader-1z0-062-dumps-2111.jpg
And then grantOPS$GUEST_USER the CREATE SESSION privilege. Which two statements are true?
A. GUEST_USER can query the tables created in the USERS tablespace by default.
B. The authentication details for GUEST_USER are stored in the database password file.
C. A local GUEST_USER OS account should exist before GUEST_USER can log on to the database.
D. GUEST_USER can log on to the database without specifying a username and password.
E. GUEST_USER is forced to change the password at the first login.
Answer: DE
NEW QUESTION 212
Your database is configured for ARCHIVELOG mode, and a daily full database backupis taken. RMAN is configured to perform control file autobackup. In which three scenarios do you need media recovery?
A. loss of all the copies of the control file
B. loss of all the inactive online redo log group members
C. loss of a data file that belongs to the active undo tablespace
D. loss of data files that belong to the SYSTEM tablespace
E. logical corruption of data that is caused by a wrong transaction
F. abnormal termination of the database instance
Answer: ABC
NEW QUESTION 213
Your database has been running with a peak load for the past hour. You want to preserve the performance statistics collected during this period forcomparison when you analyze the performance of the database later. What must you do to achieve this?
A. Increase the window size of the moving window baseline so that it equals the Automatic Workload Repository (AWR) snapshot retention period.
B. Createa baseline on a pair of snapshots that span the peak load period.
C. Generate Active Session History reports for the peak load period.
D. Set the snapshot retention period in AWR to 60 to avoid automatic purging of snapshots for the past hour.
Answer: B
NEW QUESTION 214
Which three statements are true about space usage alerts?
A. Alerts are issued only when the critical threshold for space available in a tablespace is breached.
B. The sum of active extents and allocated user quotas is considered to compute space usage for an undo tablespace.
C. Databasealerts can provide warnings about low space availability at both tablespace and segment levels.
D. Alerts are not issued for locally managed tablespaces that are offline or in read-only mode.
E. A newly created locally managed tablespace is automatically assigned the default threshold values defined for a database.
Answer: ADE
NEW QUESTION 215
You use multiple temporary tables frequently in your database. Which two are benefits of configuring temporary undo?
A. Performance improves because less redo is writtento the redo log.
B. Temporary undo reduces the amount of undo stored in undo tablespaces.
C. Performance improves because data manipulation language (DML) operations performed on temporary tables do not use the buffer cache.
D. Performance improves because no redo and undo are generated for the temporary tables.
Answer: BD
NEW QUESTION 216
Which two statements are true about Oracle Data Pump export and import operations?
A. You cannot specify how partitioned tables shouldbe handled during an import operation.
B. Only data can be compressed during an export operation.
C. Existing dump files can be overwritten during an export operation.
D. Tables cannot be renamed during an import operation.
E. Metadata that is exported andimported can be filtered based on objects and object types.
Answer: DE
NEW QUESTION 217
Your database is running in NOARCHIVING mode. Examine the following parameters:
Image URL: examgod.com/plimages/f3ccc3dc6dfc_FCD9/passleader-1z0-062-dumps-2171.jpg
You execute the following command after performing a STARTUP MOUNT:
SQL> ALTER DATABASE ARCHIVELOG;
Which statement is true about the execution of the command?
A. It executes successfully and sets the Fast Recovery Area as the local archive destination.
B. It executes successfully and issues a warning to set LOG_ARCHIVE_DEST while opening the database.
C. It fails and returns an error about LOG_ARCHIVE_DEST not being set.
D. It executes successfully and sets $ORACLE_HOME/dbs as the default archive destination.
Answer: C
NEW QUESTION 218
Your production database uses file system storage. You want to move storage to Oracle Automatic Storage Management (ASM). How would you achieve this?
A. by using a transportable database
B. by using the Database Upgrade Assistant (DBUA)
C. by using Data Pump
D. by using RMAN
Answer: D
NEW QUESTION 219
Which two statements are true about Oracle network connections?
A. A listener may listen on behalf of only one database instance at a time.
B. A server process checks a user’s authentication credentials and creates a session if the credentials are valid.
C. The listener continuously monitors a connection after the user process connects to a service handler.
D. The listener always spawns a new server process to deal with each new connection.
E. A connection request from a client is always first received by a listener running on the port that is used for the connection request for the database server.
Answer: BD
NEW QUESTION 220
Which two actions does an incremental checkpoint perform?
A. It signals CKPT to write thecheckpoint 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.
Answer: CD
NEW QUESTION 221
Which statement is true aboutusing the Database Upgrade Assistant (DBUA) to upgrade your database from Oracle Database 11g to Oracle Database 12c?
A. It terminates if the SYSTEM tablespace in the source database is not autoextensible.
B. It automatically makes necessary changes to Oracle environment variables.
C. It automatically enables unified auditing in the upgraded database.
D. It automatically adds new data files if there is not enough disk space to grow.
Answer: D
NEW QUESTION 222
Examine the parameters for a database instance:
Image URL: examgod.com/plimages/f3ccc3dc6dfc_FCD9/passleader-1z0-062-dumps-2221.jpg
Your database has three undo tablespaces and the default undo tablespace is not autoextensible. Resumable space allocation is not enabled for any sessions in the database instance. What is the effect on new transactions when all undo space in the default undo tablespace is in use by activetransactions?
A. Transactions write their undo in the SYSTEM undo segment.
B. Transactions fail.
C. Transactions wait until space becomes available in UNDOTBS1.
D. Transactions write their undo in a temporary tablespace.
Answer: B
NEW QUESTION 223
What should you do to ensure that a job stored minimal job metadata and runtime data on disk, and uses only existing PL/SQL programs?
A. Create an event-based job.
B. Create a lightweight job.
C. Specify the job as amember of a job class.
D. Use a job array.
Answer: B
NEW QUESTION 224
You want to schedule a job to rebuild atable’s indexes after a bulk insert, which must be scheduled as soon as a file containing data arrives on the system. What would you do to accomplish this?
A. Create a file watcher and an event-based job for bulk insert and then create another job to rebuild indexes on the table.
B. Create a file watcher for the bulk inserts and then create a job to rebuild indexes.
C. Create a job array and add a job for bulk insert and a job to rebuild indexes to the job array.
D. Create an event-based job for the filearrival event, then create a job for bulk insert, and then create a job to rebuild indexes.
Answer: A
NEW QUESTION 225
You plan to install the Oracle Database 12c software on a new server. The database will use Automatic Storage Management (ASM) and Oracle Restart. Oracle Grid Infrastructure for a standalone server is already installed on the server. You want to configure job role separation. You create the following operating system users and groups:
– The user oracle as the owner of the Oracle database installation
– The user grid as the owner of Oracle Grid Infrastructure
– The group oinstall as an Oracle Inventory group
– The group dba as the OSDBA group for Oracle database
– The group asmdbaas the OSDBA group for Oracle ASM
– The group asmadmin as the administration privileges group for Oracle ASM
– The group asmoper as the group for Oracle ASM
Which two additional tasks should you perform with regard to the OS-level owners and groups?
A. creating a separate central inventory group for the Oracle Database 12c installation
B. assigning oinstall as the primary group for the oracle user
C. assigning asmadmin and asmoper as primary groups for the oracle user
D. creating OS groups associated with the OSBACKUPDBA, OSDGDBA, and OSKMDBA system privileges
E. assigning asmdba as the secondary group for the oracle user
Answer: CD
NEW QUESTION 226
Which two statements are true about the (PMON) background process in Oracle Database 12c?
A. It records checkpoint information in the control file.
B. It frees unused temporary segments.
C. It kills sessions that exceed idle time.
D. It registers database services with all local and remote listeners known to the database instance.
E. It frees resources held by abnormally terminated processes.
Answer: DE
NEW QUESTION 227
You want to upgrade an Oracle Database running Oracle Database 11g to Oracle Database 12c. Which three tasks should be performed before a manual upgrade?
A. running preupgrad.sql in Oracle Database 11g to generate fix-up scripts and a log file
B. running utlu121s.sql from the new Oracle home to display information about the required initialization parameters
C. copying the initialization parameter file to the new Oracle home
D. copying the password file to the new Oracle home
E. copying net configuration files to the new Oracle home
Answer: ACE
NEW QUESTION 228
You want to create a database and you have the following:
– Oracle Grid Infrastructure is installed and configured
– Oracle Database Vault is installed in ORACLE_HOME to be used for this database
– Oracle Enterprise Manager Cloud Control isavailable and an agent is deployed on the database server
Examine the requirements:
1. configuring the database instance to support shared server mode
2. using Automatic Storage Management (ASM) for storing database files
3. configuring a naming methodto help a remote user connect to a database instance
4. configuring the Fast Recovery Area
5. configuring Database Vault
6. configuring Enterprise Manager (EM) Database Express
7. registering with EM Cloud Control
8. configuring remote log archive destinations
9. enabling daily incremental backups
10. configuring a nondefault block size for nondefault block size tablespaces
Which of these requirements can be met while creating a database by using the Database Configuration Assistant (DBCA)?
A. 1, 2, 4, 5,7, 8, 9 and 10
B. 1, 2, 4, 5, 6 and 7
C. 1, 2, 3, 8, 9 and 10
D. 1, 2, 3, 4, 6, 8, 9 and 10
E. 1, 2, 4, 5, 6, 7 and 8
Answer: D
NEW QUESTION 229
Which two options can be configured for an existing database by using the Database Configuration Assistant (DBCA)?
A. Configure Label Security
B. Database Vault in ORACLE_HOME
C. Oracle Suggested BackupStrategy
D. Database Resident Connection Pooling
E. Nondefault blocksize tablespaces
Answer: BD
NEW QUESTION 230
Which two statements are true about availability audit features after migration to unified auditing?
A. The ability of users to audit their own schema objects is not available in the post- migrated database.
B. Operating systemaudit trail is available in the post-migrated database.
C. Network auditing is available in the post-migrated database.
D. Mandatory auditing of audit administrative actions is available in the post-migrated database.
Answer: AD
NEW QUESTION 231
What can be automatically implemented after the SQL Tuning Advisor is run as part of the Automated Maintenance Task?
A. statistics recommendations
B. SQL profile recommendations
C. SQL statement restructure recommendations
D. creation of materialized views toimprove query performance
Answer: B
NEW QUESTION 232
……
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 (272q VCE and PDF)
Good Luck!
Besides, that new 272Q 1Z0-062 Dumps Collection are Available here for Free:
https://drive.google.com/open?id=0B-ob6L_QjGLpZVhqd2dmaHZoZlE
Best Regards!
C
Answer on question 184
=======================
Configure static service registration.
Oracle Enterprise Manager
Oracle Net Manager
So the answer is A and B
New 1Z0-062 Exam Questions Updated Recently (2/Sep/2017):
NEW QUESTION 316
Your database is in NOARCHIVELOG mode. You want to enable archiving for the database. Examine the steps:
1. Execute the ALTER DATABASE ARCHIVELOG command.
2. Execute SHUTDOWN IMMEDIATE.
3. Execute STARTUP MOUNT.
4. Set the DB_RECOVERY_FILE_DEST parameter to $ORACLE_HOME/dbs/.
5. Execute STARTUP NOMOUNT.
6. Open the database.
Identify the required steps in the correct sequence.
A. 4, 2, 5, 1, 6
B. 1, 2, 3, 4, 6
C. 2, 3, 1, 6
D. 2, 5, 1, 6
Answer: C
NEW QUESTION 317
Identify the access that is initially available to connect to your Database as a Service (DBaaS) environment.
A. Enterprise Manager on port 1158
B. telnet on port 23
C. Cloud Control on port 7799
D. SSH on port 22
E. SSL/TLS on port 443
Answer: D
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
……
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 that new 354Q 1Z0-062 dumps for your reference:
https://drive.google.com/open?id=0B-ob6L_QjGLpZVhqd2dmaHZoZlE
Regards!