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

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: 61 – (Topic 1)

The instance abnormally terminates because of a power outage. Which statement is true about redo log files during instance recovery?

  1. Inactive and current redo log files are required to accomplish recovery

  2. Online and archived redo files are required to accomplish instance recovery

  3. All redo log entries after the last checkpoint are applied from redo log files to data files

  4. All redo log entries recorded in the current log file until the checkpoint position are applied to data files

Answer: C

Question No: 62 – (Topic 1)

Which two statements correctly describe the relation between a data file and the logical database structures? (Choose two)

  1. An extent cannot spread across data files.

  2. A segment cannot spread across data files.

  3. A data file can belong to only one tablespace.

  4. A data file can have only one segment created in it.

  5. A data block can spread across multiple data files as it can consist of multiple operating system (OS) blocks.

Answer: A,C

Question No: 63 – (Topic 1)

View the Exhibit and examine the attributes of an undo tablespace. In an OLTP system, the user SCOTT has started a query on a large table in the peak transactional hour that performs bulk inserts. The query runs for more than 15 minutes and then SCOTT receives the following error:

ORA-01555: snapshot too old What could be the reason for this error? Exhibit:

Latesttests 2018 PDF and VCE

  1. The query is unable to get a read-consistent image.

  2. There is not enough space in Flash Recovery Area.

  3. There is not enough free space in the flashback archive.

  4. The query is unable to place data blocks in undo tablespace.

Answer: A

Question No: 64 – (Topic 1)

Which two statements are true regarding the usage of the SQL*LOADER utility? (Choose two.)

  1. You can load data into multiple tables during the same load session

  2. You can load data from multiple files to a table during the same load session

  3. You cannot perform selective data loading based on the values available in the records

  4. You can use an export file generated by the EXPDP utility as an input data file to load the data

  5. You can load data only if the input file is available on the disk and tape but not a named pipes

Answer: A,B

Question No: 65 – (Topic 1)

SQLgt; AUDIT DROP ANY TABLE BY scott BY SESSION WHENEVER SUCCESSFUL;

What is the effect of this command?

  1. One audit record is created for every successful DROP TABLE command executed in the session of SCOTT

  2. One audit record is generated for the session when SCOTT grants the DROP ANY TABLE privilege to other users

  3. One audit record is created for the whole session if user SCOTT successfully drops one or more tables in his session

  4. One audit record is created for every session of any other user in which a table owned by SCOTT is dropped successfully

  5. One audit record is created for every successful DROP TABLE command executed by any user to drop tables owned by SCOTT

Answer: C

Question No: 66 – (Topic 1)

Which two files in the database can be configured for automatic backups by using the autobackup feature in Recovery Manager (RMAN)? (Choose two.)

  1. Data Files

  2. Control Files

  3. Parameter Files

  4. Online Redo Log Files

  5. Server Parameter File

Answer: B,E

Question No: 67 – (Topic 1)

Which two operations can be performed on an external table? (Choose two.)

  1. Create a view on the table

  2. Create an index on the table

  3. Create a synonym on the table

  4. Add a virtual column to the table

  5. Update the table using the UPDATE statement

  6. Delete rows in the table using the DELETE command

Answer: A,C

Question No: 68 – (Topic 1)

View the Exhibit to examine the details for an incident.

Latesttests 2018 PDF and VCE

Which statement is true regarding the status of the incident?

  1. The DBA is working on the incident and prefers that the incident be kept in the ADR

  2. The incident is now in the Done state and the ADR can select the incident to be purged

  3. The incident has been newly created and is in the process of collecting diagnostic information

  4. The data collection for the incident is complete and the incident can be packaged and sent to Oracle Support

Answer: D

Question No: 69 – (Topic 1)

You have an ORDERS table with the following structure:

Latesttests 2018 PDF and VCE

The table has data in the ODATE column for all rows. Many orders are placed in a single day. You need to ensure that the ODATE column must contain data for every order in future.

Which method would serve the purpose?

  1. Modify the column using the ALTER TABLE … MODIFY command.

  2. Add a UNIQUE constraint to the column using the ALTER TABLE … ADD CONSTRAINT command.

  3. Add a NOT NULL constraint to the column using the ALTER TABLE … ADD CONSTRAINT command.

  4. Add a PRIMARY KEY constraint to the column using the ALTER TABLE … ADD CONSTRAINT command.

Answer: A

Question No: 70 – (Topic 1)

View the Exhibit and examine the parameters. User A executes the following command to update the TRANS table:

SQLgt; UPDATE B.trans SET tr_amt=tr_amt 500 WHERE c_code=#39;C005#39;;

Before user A issues a COMMIT or ROLLBACK command, user B executes the following command on the TRANS table:

SQLgt; ALTER TABLE trans MODIFY (tr_type VARCHAR2(3));

What would happen in this scenario? Exhibit:

Latesttests 2018 PDF and VCE

  1. The ALTER TABLE command modifies the column successfully

  2. The DDL operation gets higher priority and transaction for user A is rolled back

  3. The ALETER TABLE command waits indefinitely until user A ends the transaction

  4. The ALTER TABLE command fails after waiting for 60 seconds due to the resource being busy

Answer: D

Topic 2, Volume B

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