[Free] 2018(Jan) EnsurePass Pass4sure Oracle 1z0-514 Dumps with VCE and PDF 11-20

Ensurepass.com : Ensure you pass the IT Exams
2018 Jan Oracle Official New Released 1z0-514
100% Free Download! 100% Pass Guaranteed!

Oracle Database 11g Essentials

Question No: 11

The DBA of your database informs you that the Oracle instance has started. What does this imply?

  1. Users can access the data in the database.

  2. Only the SGA has been allocated for the database.

  3. Only the background and user processes are running.

  4. Memory areas have been allocated and background processes have been started.

Answer: D

Question No: 12

Which two statements are true regarding SQL*Plus? (Choose two.)

  1. It has commands to perform database administration operations.

  2. It can be used in interactive hut not batch mode for SQL commands.

  3. It has to be installed separately after the Oracle database install installation.

  4. Operating system commands can be executed from the SOL *Plus command prompt

Answer: A,D

Question No: 13

Which statement is true regarding undo tablespace?

  1. Undo tablespace Is a temporary tablespace.

  2. Only one undo tablespace can exist in a database.

  3. Undo tablespace can consist of only one data file that is reused in a cyclic fashion.

  4. Multiple undo tablespaces can exist in a database but only one can be active at a lime.

Answer: D

Question No: 14

Which three statements are true regarding inconsistent backup? (Choose three)

  1. It can be used only for incomplete recovery.

  2. It can be taken only when the database is open.

  3. It can be taken only when the database is closed.

  4. It can be used for complete and incomplete recovery.

  5. The archived redo logs changes must be applied to the data files before the backup.

  6. Both online and archived redo logs can have changes that have not been applied before the backup.

Answer: B,D,F

Question No: 15

Which three options correctly match environment variables with their specific functionalities? (Choose three.)

  1. ORACLE_SID:specifies the instance name

  2. ORACLE_SID: specifies the global database name

  3. ORACLE_ BASE: specifies the toot of the Oracle Database directory tree in all platforms

  4. ORACLE_ BASE: specifies the directory containing the Oracle software executables and network file

  5. ORACLE_HOME: specifies the root of the Oracle Database directory tree only in UNIX and Linux platforms

  6. ORACLE_HOME: specifies the directory containing only the Oracle software executables but not the network files

Answer: A,D,E

Question No: 16

Your test database is currently running in the ARCHIVELOG mode and you plan to switch to the NOARCHIVELOG mode temporarily.

Which type of backup should you perform before switching the mode to ensure database recovery is possible?

  1. whole backup

  2. level o incremental backup of data files

  3. full backup of data files using only backup sets

  4. full backup of data files using only image copies

Answer: A

Question No: 17

You create an index, EMP_IDX, on the ENAME column in the EMP table. Identify the three operations in which FMP_IDX would be used? (Choose three.)

  1. addition of new data to the EMP table

  2. deletion of existing row from the EMP table

  3. modification of data in any column in the EMP table

  4. all queries that display data from the ENAME column

  5. queries that search for data based on a condition on the ENAME column

Answer: A,B,E

Question No: 18

Which three statements are true about database storage structures? (Choose three.)

  1. A data file can span across tablespaces.

  2. An extent contains one or more segments.

  3. Tablespacescontain one or more data files.

  4. Data objects are stored as segments in tablespaces.

  5. Segments can span across data files within a tablespace.

Answer: C,D,E

Question No: 19

Which three statements about the Automatic Database Diagnostic Monitor (ADDM) are true? (Choose three)

  1. requires the database to be open

  2. analyses the performance of specified objects

  3. implements all recommendations automatically

  4. recommends solutions and quantifies expected benefits

  5. retains snapshots in the SYSAUX tablespace until the database is restarted

  6. analyzes the snapshots stored in the Automatic Workload Repository (AWR)

Answer: D,E,F

Question No: 20

You want to use the automatic management of backup and recovery operations feature for your database.Which configuration must you set?

  1. Enable the flash recovery area and specify it as the archived redo log destination

  2. Disable the flash recovery area and start the database instance in ARCHIVELOG mode.

  3. Enable the flash recovery area but do not specify it as the archived redo log destination.

  4. Disable the flash recovery area and start the database instance in NOABCHIVELOG mo.

Answer: A

100% Ensurepass Free Download!
Download Free Demo:1z0-514 Demo PDF
100% Ensurepass Free Guaranteed!
1z0-514 Dumps

EnsurePass ExamCollection Testking
Lowest Price Guarantee Yes No No
Up-to-Dated Yes No No
Real Questions Yes No No
Explanation Yes No No
Free VCE Simulator Yes No No
Instant Download Yes No No

Leave a Reply

