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

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

See the Exhibit:

Latesttests 2018 PDF and VCE

Which statements are true regarding the USERS tablespace? (Choose all that apply.)

  1. A bitmap is used to record free extents

  2. Free extents information is managed within the tablespace

  3. Free extents information is managed in the SYSAUX tablespace

  4. The data dictionary tables are updated when extents are allocated or deallocated

Answer: A,B

Question No: 2 – (Topic 1)

Identify two situations in which you can use Data Recovery Advisor for recovery. (Choose two.)

  1. The database files are corrupted when the database is open

  2. The user has dropped an important table that needs to be recovered

  3. The archived redo log files are missing for which the backup is not available

  4. The database is not opening because the required database files are missing

Answer: A,D

Question No: 3 – (Topic 1)

You plan to move data from a flat file to a table in your database. You decide to use SQL*Loader direct path load method to perform this task. The table in which you plan to load data in an important table having various integrity constraint defined on it.

Which constraints will remain enabled by default during this operation? (Choose all that apply.)

  1. CHECK

  2. UNIQUE

  3. NOT NULL

  4. PRIMARY KEY

  5. FOREIGN KEY

Answer: B,C,D

Question No: 4 – (Topic 1)

Examine the command that is used to create a table:

SQLgt; CREATE TABLE orders ( oid NUMBER(6) PRIMARY KEY,

odate DATE,

ccode NUMBER (6), oamt NUMBER(10,2)

) TABLESPACE users;

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 tablespace and a unique index is created on the OID column in the SYSTEM tablespace.

Answer: B,D

Question No: 5 – (Topic 1)

After performing a clean shut down of the database instance for maintenance, you mount the database and then execute a command to open the database:

SQLgt; ALTER DATABASE OPEN;

Which two statements are true? (Choose two.)

  1. The online redo log files and online data files are opened

  2. All the online data files headers are checked for consistency

  3. Instance recovery is performed before opening the database

  4. The path and existence of all the log file members are checked

Answer: A,B

Question No: 6 – (Topic 1)

Which two statements are true regarding a tablespace? (Choose two.)

  1. It can span multiple databases

  2. It can consist of multiple data files

  3. It can contain blocks of different files

  4. It can contains segments of different sizes

  5. It can contains a part of nonpartitioned segment

Answer: B,D

Question No: 7 – (Topic 1)

Which three statements are correct about temporary tables? (Choose three.)

  1. Indexes and views can be created on temporary tables

  2. Both the data and structure of temporary tables can be exported

  3. Temporary tables are always created in a user#39;s temporary tablespace

  4. The data inserted into a temporary table in a session is available to other sessions

  5. Data Manipulation Language (DML) locks are never acquired on the data of temporary tables

Answer: A,C,E

Question No: 8 – (Topic 1)

You executed the following command to create a tablespace called SALES_DATA:

SQLgt; CREATE TABLESPACE sales_data DATAFILE SIZE 100M

SEGMENT SPACE MANAGEMENT AUTO;

Which two statements are true about the SALES_DATA tablespace? (Choose two)

  1. The database automatically determines the extent-sizing policy for the tablespace.

  2. The segments are automatically shrunk when the contents are removed from them.

  3. The allocation of extents within the tablespace is managed through the dictionary tables.

  4. The space utilization description of the data blocks in segments is recorded in bitmap blocks.

  5. The space utilization description of the data blocks in segments is managed through free lists.

Answer: A,D

Question No: 9 – (Topic 1)

The database instance has the following parameter setting: OS_AUTHENT_PREFIX = OPS$

OS_ROLES = FALSE REMOTE_OS_AUTHENT = FALSE REMOTE_OS_ROLES = FALSE TIMED_OS_STATISTICS = 0

You have a local operating system user SKD. You create a database user OPS$SKD, and then assign external authentication. The user OPS$SKD has the CREATE SESSION privilege.

What would you achieve by the above process?

  1. The database user OPS$SKD will be able to administer the database.

  2. The authentication detail for the database user OPS$SKD is recorded in the password file.

  3. The local operating system user SKD will be able to access the database instance without specifying the username and password.

  4. The database user OPS$SKD has to login with the password of the local operating system user SKD to access the database instance.

Answer: C

Question No: 10 – (Topic 1)

Examine the values for the following initialization parameters:

FAST_START_MTTR_TARGET=0 LOG_CHECKPOINT_INTERVAL=0

Which two will be the implications of these values in your database? (Choose two.)

  1. The SGA advisor will be disabled

  2. The MTTR advisor will be disabled

  3. Automatic checkpoint tuning will be disabled

  4. Checkpoint information will not be written to the alert log file

Answer: B,C

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