This page was exported from All The Latest MCTS Exam Questions And Answers For Free Share [ https://www.mctsdump.com ] Export date:Tue Dec 3 17:10:09 2024 / +0000 GMT ___________________________________________________ Title: [Feb-2017 Dumps] Pass 1Z0-062 Exam By Training PassLeader Free 1Z0-062 Study Materials --------------------------------------------------- New Updated 1Z0-062 Exam Questions from PassLeader 1Z0-062 PDF dumps! Welcome to download the newest PassLeader 1Z0-062 VCE dumps: http://www.passleader.com/1z0-062.html (272 Q&As) Keywords: 1Z0-062 exam dumps, 1Z0-062 exam questions, 1Z0-062 VCE dumps, 1Z0-062 PDF dumps, 1Z0-062 practice tests, 1Z0-062 study guide, 1Z0-062 braindumps, Oracle Database 12c: Installation and Administration Exam P.S. Free 1Z0-062 dumps download from Google Drive: https://drive.google.com/open?id=0B-ob6L_QjGLpZVhqd2dmaHZoZlE NEW QUESTION 211Your database instance has the following parameter setting:OS_AUTHENT_PREFIX = OPS$You execute the following command: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 212Your 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 fileB.    loss of all the inactive online redo log group membersC.    loss of a data file that belongs to the active undo tablespaceD.    loss of data files that belong to the SYSTEM tablespaceE.    logical corruption of data that is caused by a wrong transactionF.    abnormal termination of the database instance Answer: ABC NEW QUESTION 213Your 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 214Which 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: ADEExplanation:https://docs.oracle.com/cd/B28359_01/server.111/b28310/schema001.htm#ADMIN10120 NEW QUESTION 215You 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: BDExplanation:https://oracle-base.com/articles/12c/temporary-undo-12cr1 NEW QUESTION 216Which 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 217Your database is running in NOARCHIVING mode. Examine the following parameters: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 218Your 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 databaseB.    by using the Database Upgrade Assistant (DBUA)C.    by using Data PumpD.    by using RMAN Answer: DExplanation:http://docs.oracle.com/cd/E11882_01/server.112/e18951.pdf (p.184) NEW QUESTION 219Which 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 220Which 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: CDExplanation:http://www.dba-oracle.com/t_incremental_checkpoint.htm NEW QUESTION 221Which 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: DExplanation:https://docs.oracle.com/cd/E18283_01/server.112/e17222/upgrade.htm#insertedID5 NEW QUESTION 222Examine the parameters for a database instance: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 223What 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: BExplanation:https://docs.oracle.com/cd/B28359_01/server.111/b28310/schedover004.htm#BGBJGHBH NEW QUESTION 224You 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 225You 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 ASMWhich 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 installationB.    assigning oinstall as the primary group for the oracle userC.    assigning asmadmin and asmoper as primary groups for the oracle userD.    creating OS groups associated with the OSBACKUPDBA, OSDGDBA, and OSKMDBA system privilegesE.    assigning asmdba as the secondary group for the oracle user Answer: CD NEW QUESTION 226Which 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: DEExplanation:https://docs.oracle.com/database/122/CNCPT/process-architecture.htm#CNCPT9840 NEW QUESTION 227You 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 fileB.    running utlu121s.sql from the new Oracle home to display information about the required initialization parametersC.    copying the initialization parameter file to the new Oracle homeD.    copying the password file to the new Oracle homeE.    copying net configuration files to the new Oracle home Answer: ACE NEW QUESTION 228You 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 serverExamine the requirements:1. configuring the database instance to support shared server mode2. using Automatic Storage Management (ASM) for storing database files3. configuring a naming methodto help a remote user connect to a database instance4. configuring the Fast Recovery Area5. configuring Database Vault6. configuring Enterprise Manager (EM) Database Express7. registering with EM Cloud Control8. configuring remote log archive destinations9. enabling daily incremental backups10. configuring a nondefault block size for nondefault block size tablespacesWhich 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 10B.    1, 2, 4, 5, 6 and 7C.    1, 2, 3, 8, 9 and 10D.    1, 2, 3, 4, 6, 8, 9 and 10E.    1, 2, 4, 5, 6, 7 and 8 Answer: D NEW QUESTION 229Which two options can be configured for an existing database by using the Database Configuration Assistant (DBCA)? A.    Configure Label SecurityB.    Database Vault in ORACLE_HOMEC.    Oracle Suggested BackupStrategyD.    Database Resident Connection PoolingE.    Nondefault blocksize tablespaces Answer: BD NEW QUESTION 230Which 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: ADExplanation:https://docs.oracle.com/database/121/DBSEG/audit_changes.htm#DBSEG341 NEW QUESTION 231What can be automatically implemented after the SQL Tuning Advisor is run as part of the Automated Maintenance Task? A.    statistics recommendationsB.    SQL profile recommendationsC.    SQL statement restructure recommendationsD.    creation of materialized views toimprove query performance Answer: BExplanation:http://docs.oracle.com/cd/B28359_01/server.111/b28274/sql_tune.htm#i36217 NEW QUESTION 232…… Download the newest PassLeader 1Z0-062 dumps from passleader.com now! 100% Pass Guarantee! 1Z0-062 PDF dumps & 1Z0-062 VCE dumps: http://www.passleader.com/1z0-062.html (272 Q&As) (New Questions Are 100% Available and Wrong Answers Have Been Corrected! Free VCE simulator!) P.S. Free 1Z0-062 Exam Dumps Collection On Google Drive: https://drive.google.com/open?id=0B-ob6L_QjGLpZVhqd2dmaHZoZlE --------------------------------------------------- Images: --------------------------------------------------- --------------------------------------------------- Post date: 2017-02-21 10:47:28 Post date GMT: 2017-02-21 10:47:28 Post modified date: 2017-02-21 10:47:28 Post modified date GMT: 2017-02-21 10:47:28 ____________________________________________________________________________________________ Export of Post and Page as text file has been powered by [ Universal Post Manager ] plugin from www.gconverters.com