Get Full Version of the Exam
http://www.EnsurePass.com/1z0-062.html
Question No.301
You configured the Fast Recovery Area (FRA) for your database. The database instance is in ARCHIVELOG mode. The default location for the archived redo log files is the FRA. Which two files are removed automatically if space is required in the FRA as per the retention policy? (Choose two.)
-
Archived redo log files that have multiple copies in a different archive location
-
user-managed backups of data files and control files
-
RMAN backups that are obsolete
-
flashback logs
Correct Answer: CD
Question No.302
Which three statements are true about windows? (Choose three.)
-
Only one window can be open at any given time
-
Consumer groups are associated with windows
-
Windows work with job classes to control resource allocation
-
The database service name must be provided during windows creation
-
Windows can automatically start job or change resource allocation among jobs for various time periods
Correct Answer: ACE
Question No.303
Identify three uses of the CROSSCHECK command? (Choose three.)
-
to validate the database backup
-
to synchronize logical backup records with physical files in backup storage
-
to check the obsolete backups that can be deleted from the file system
-
to update information about backups that are deleted, corrupted, or inaccessible in a recovery catalog or control file
-
to update the recovery catalog or control file if archived log files are deleted with operating system commands
Correct Answer: BDE
Question No.304
Examine the following command:
SQLgt; DBMS_STATS. SET_TABLE_PREFS (#39;SH#39;, #39;CUSTOMERS#39;, #39;PUBLISH#39;, #39;false#39;);
What is the effect of executing this command?
-
Existing statistics for the CUSTOMERS table become unusable for the query optimizer.
-
Automatic statistics collection is stopped for the CUSTOMERS table.
-
Statistics for the CUSTOMERS table are locked and cannot be overwritten.
-
Statistics subsequently gathered on the CUSTOMERS table are stored as pending statistics.
Correct Answer: D
Question No.305
Which two statements are true about availability audit features after migration to unified auditing? (Choose two.)
-
The ability of users to audit their own schema objects is not available in the post-migrated database.
-
Operating system audit trail is available in the post-migrated database.
-
Network auditing is available in the post-migrated database.
-
Mandatory auditing of audit administrative actions is available in the post-migrated database.
Correct Answer: AD
Explanation:
https://docs.oracle.com/database/121/DBSEG/audit_changes.htm#DBSEG341
Question No.306
When does a database checkpoint occur?
-
When there is an online redo log switch.
-
When a user session terminates abnormally.
-
When a server process terminates abnormally.
-
When the SHUTDOWN ABORT command is issued.
Correct Answer: A
Question No.307
Which two statements are true about Oracle Data Pump export and import operations? (Choose two.)
-
You cannot specify how partitioned tables should be handled during an import operation.
-
Only data can be compressed during an export operation.
-
Existing dump files can be overwritten during an export operation.
-
Tables cannot be renamed during an import operation.
-
Metadata that is exported and imported can be filtered based on objects and object types.
Correct Answer: AE
Explanation:
https://docs.oracle.com/cd/B28359_01/server.111/b28300/expimp.htm#UPGRD12560
Question No.308
You install Oracle Grid Infrastructure standalone server and issue the following command: crsctl start has
Which two existing components get automatically added to the Oracle Restart configuration? (Choose two.)
-
Oracle CSSD services
-
the database whose instance is running
-
Oracle Notification services
-
Oracle Healthcheck services
-
Oracle Net Listener
Correct Answer: AC
Question No.309
Which two statements are true about Automatic Storage Management (ASM)? (Choose two.)
-
It mounts databases and diskgroups to make ASM files available to database instances.
-
It spreads files proportionally across all disks in a diskgroup, aiming to ensure that all the disks in a diskgroup have the same I/O load.
-
It automatically places each disk from an external redundancy diskgroup in its own failure group.
-
It divides files into extents and allows an extent to span disks.
-
It mirrors data at the allocation unit (AU) level across failure groups within a normal or high redundancy diskgroup.
Correct Answer: BC
Question No.310
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?
-
Automatic Storage Management (ASM) for storage of data files
-
a file system for storage of data files
-
a Data Warehouse database template
-
a custom database template
Correct Answer: D
Get Full Version of the Exam
1z0-062 Dumps
1z0-062 VCE and PDF