This page was exported from Free Cisco Training & Resources - Certification Exam Preparation [ https://www.ciscobibles.com ] Export date:Thu Mar 28 18:43:04 2024 / +0000 GMT ___________________________________________________ Title: [May-2017 Dumps] Premium 314q 1Z0-062 Exam Questions Download From PassLeader --------------------------------------------------- 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 (314 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. New 1Z0-062 dumps PDF: https://drive.google.com/open?id=0B-ob6L_QjGLpZVhqd2dmaHZoZlE 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 Explanation: https://docs.oracle.com/cd/B19306_01/server.102/b14231/undo.htm 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 Explanation: https://docs.oracle.com/cd/E11882_01/server.112/e23633/afterup.htm#UPGRD52747 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 Explanation: https://docs.oracle.com/cd/B19306_01/server.102/b14231/undo.htm (undo retention) 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 Explanation: https://docs.oracle.com/cd/E17559_01/em.111/e16599/appdx_creating_db_templates.htm#CJACEDCD 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 Explanation: https://docs.oracle.com/cd/E18283_01/server.112/e10897/backrest.htm#insertedID4 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 Explanation: https://docs.oracle.com/database/121/ADMIN/tasks.htm#ADMIN11836 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 Explanation: https://docs.oracle.com/cd/B19306_01/server.102/b14231/schedover.htm 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 Explanation: https://docs.oracle.com/cd/E11882_01/server.112/e40540/startup.htm#CNCPT89043 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 Explanation: https://docs.oracle.com/database/121/LADBI/oraclerestart.htm#LADBI999 NEW QUESTION 288 …… 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 (314 Q&As) (New Questions Are 100% Available and Wrong Answers Have Been Corrected! Free VCE simulator!) P.S. New 1Z0-062 dumps PDF: https://drive.google.com/open?id=0B-ob6L_QjGLpZVhqd2dmaHZoZlE --------------------------------------------------- Images: --------------------------------------------------- --------------------------------------------------- Post date: 2017-05-23 18:11:18 Post date GMT: 2017-05-23 10:11:18 Post modified date: 2017-05-23 18:11:18 Post modified date GMT: 2017-05-23 10:11:18 ____________________________________________________________________________________________ Export of Post and Page as text file has been powered by [ Universal Post Manager ] plugin from www.gconverters.com