[Free] 2018(Jan) Latesttests Dumpsleader Oracle 1z0-052 Dumps with VCE and PDF Download 41-50

Latesttests 2018 Jan Oracle Official New Released 1z0-052
100% Free Download! 100% Pass Guaranteed!
http://www.Latesttests.com/1z0-052.html

Oracle Database 11g: Administration I

Question No: 41 – (Topic 1)

You execute this command to drop the ITEM table, which has the primary key referred in the ORDERS table:

SQLgt; DROP TABLE scott.item CASCADE CONSTRAINTS PURGE;

Which two statements are true about the effect of the command? (Choose two.)

  1. No flashback is possible to bring back the ITEM table.

  2. The ORDERS table is dropped along with the ITEM table.

  3. The dependent referential integrity constraints in the ORDERS table are disabled.

  4. The dependent referential integrity constraints in the ORDERS table are removed.

  5. The table definition of the ITEM table and associated indexes are placed in the recycle bin.

Answer: A,D

Question No: 42 – (Topic 1)

Identify the two situations in which the alert log file is updated with details. (Choose two.)

  1. Running a query on a table returns quot;ORA-600: Internal Errorquot;

  2. Inserting a value in a table returns quot;ORA-01722: Invalid Numberquot;

  3. Creating a table returns quot;ORA-00955: name is already used by an existing object#39;

  4. Inserting a value in a table returns quot;ORA-00001: unique constraint (SYS.PK_TECHP) violated.quot;

  5. Rebuilding an index using ALTER INDEX … REBUILD fails with an error quot;ORA-01578: ORACLE data block corrupted (file # 14, block @ 50).quot;

  6. Rebuilding an index using ALTER INDEX …. REBUILD fails with an error quot;ORA-01578: ORACLE data block corrupted (file #14, block #50).quot;

Answer: A,E

Question No: 43 – (Topic 1)

Examine the following command that is used to create a table:

Latesttests 2018 PDF and VCE

Which two statements are true about the effect of the above command? (Choose two.)

  1. A CHECK constraint is created on the OID column

  2. A NOT NULL constraint is created on the OID column

  3. The ORDERS table is the only object created in the USERS tablespace

  4. The ORDERS table and a unique index are created in the USERS tablespace

  5. The ORDERS table is created in the USERS tablepsace and a unique index is created on the OID column in the SYSTEM tablespace

    Answer: B,D

    Question No: 44 – (Topic 1)

    Note the following points describing various utilities in Oracle Database 11g:

    1. It enables the high-speed transfer of data from one database to another

    2. It provides a complete solution for the backup, restoration and recovery needs of the entire database

    3. It enables the loading of data from an external file into table of an Oracle Database

    4. It provides a tape backup management for the Oracle ecosystem Which point describes Oracle Secure Backup?

      1. 1

      2. 2

      3. 3

      4. 4

      5. 1,2 and 4

F. 1,2,3, and 4

Answer: D

Question No: 45 – (Topic 1)

Examine the command: SQLgt;DBMS_STATS.SET_TABLE_PREFS(#39;SH#39;,#39;CUSTOMERS#39;,#39;PUBLISH#39;,#39;false#39;);

Which statement describes the effect of the above command?

  1. Automatic statistics collection is stopped for the CUSTOMERS table

  2. Statistics for the CUSTOMERS table are locked and cannot be overwritten

  3. Existing statistics for the CUSTOMERS table become unusable for the query optimizer

  4. Subsequently, statistics gathered on the CUSTOMERS table are stored as pending statistics

Answer: D

Question No: 46 – (Topic 1)

You notice that the performance of the database has degraded because of frequent checkpoints.

Which two actions resolve the issue? (Choose two.)

  1. Disable automatic checkpoint tuning

  2. Check the size of the redo log file size and increase the size if it is small

  3. Set the FAST_START_MTTR_TARGET parameter as per the advice given by the MTTR Advisor

  4. Decrease the number of redo log members if there are more than one redo log members available in each redo log group

Answer: B,C

Question No: 47 – (Topic 1)

You executed the following command to create a password file in the database server:

$ orapwd file = orapworcl entries = 5 ignorecase=N

Which statement describes the purpose of the above password file?

  1. It records usernames and passwords of users when granted the DBA role

  2. It contains usernames and passwords of users for whom auditing is enabled

  3. It is used by Oracle to authenticate users for remote database administrator

  4. It records usernames and passwords of all users when they are added to OSDBA or OSOPER operating groups

Answer: C

Question No: 48 – (Topic 1)

Identify the memory component from which memory may be allocated for:

Session memory for the shared serverBuffers for I/O slavesOracle Database Recovery Manager (RMAN) backup and restore operations

  1. Large Pool

  2. Redo Log Buffer

  3. Database Buffer Cache

  4. Program Global Area (PGA)

    Answer: A

    Question No: 49 – (Topic 1)

    You are managing an Oracle Database 11g database with the following backup strategy:

    1. On Sunday, an incremental level 0 tape backup is performed

    2. Monday through Saturday, a cumulative incremental level 1 tape backup is performed Which two statements are true regarding the backups performed? (Choose two.)

      1. The backup performed in step 1 backs up all blocks that have ever been in use in the database

      2. The backup performed in step 2 copies all the blocks changed since the most recent level 0 backup

      3. The backup performed in step 1 backs up all the blocks changed since the most recent level 1 backup

      4. The backup performed in step 2 backs up all blocks that have changed since the most recent incremental backup at level 1

Answer: A,B Explanation: backup-level Description

The backup-level placeholder specifies the level of a backup created with the backup command.

Syntax

backup-level::=

full | incr_level | incr | offsite incr_level::=

1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9

Semantics

full

Specifies that Oracle Secure Backup should back up all files defined in a dataset regardless of when they were last backed up. This option is equivalent to level 0. This is the default value.

incr_level

Specifies an incremental level from 1 to 9 and backs up only those files that have changed since the last backup at a lower level.

incr

Specifies that Oracle Secure Backup should back up any file that has been modified since the last incremental backup at the same level or lower. The incr option is equivalent to level

10. This level is platform dependent and is incompatible with some client operating systems such as the Netapp filer#39;s Data ONTAP.

offsite

Equivalent to a full (level 0) backup except that Oracle Secure Backup keeps a record of this backup in such a way that it does not affect the full or incremental backup schedule. This option is useful when you want to create a backup image for offsite storage without disturbing your schedule of incremental backups.

Question No: 50 – (Topic 1)

You executed this command to create a temporary table:

SQLgt; CREATE GLOBAL TEMPORARY TABLE report_work_area ( startdate DATE,

enddate DATE, class CHAR(20)

) ON COMMIT PRESERVE ROWS;

Which statement is true about the rows inserted into the REPORT_WORK_AREA table during a transaction?

  1. The rows stay in the table only until session termination

  2. The rows stay in the table only until the next transaction starts on the table

  3. The rows are visible to all current sessions after the transaction in committed

  4. The rows stay available for subsequent sessions after the transaction is committed

Answer: A

100% Free Download!
Download Free Demo:1z0-052 Demo PDF
100% Pass Guaranteed!
Download 2018 Latesttests 1z0-052 Full Exam PDF and VCE

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

2018 Latesttests IT Certification PDF and VCE