Act now and download your Oracle 1z0-050 test today! Do not waste time for the worthless Oracle 1z0-050 tutorials. Download Most recent Oracle Oracle Database 11g: New Features for Administrators exam with real questions and answers and begin to learn Oracle 1z0-050 with a classic professional.

2016 Dec 1z0-050 exam cram

Q51. Which statements are true regarding system-partitioned tables? (Choose all that apply.)

A. Only a single partitioning key column can be specified.

B. All DML statements must use partition-extended syntax.

C. The same physical attributes must be specified for each partition.

D. Unique local indexes cannot be created on a system-partitioned table.

E. Traditional partition pruning and partitionwise joins are not supported on these tables.

Answer: DE


Q52. You are working on a CATDB database that contains an Oracle Database version 11.1 catalog schema owned by the user RCO11. The INST1 database contains an Oracle Database version 10.1 catalog schema owned by the user RCAT10.

You want the RMAN to import metadata for database IDs 1423241 and 1423242, registered in RCAT10, into the recovery catalog owned by RCO11. You executed the following commands:

RMAN> CONNECT CATALOG rco11/password@catdb

RMAN> IMPORT CATALOG rcat10/oracle@inst1 NO UNREGISTER; 

Which two statements are true regarding the tasks accomplished with these commands? (Choose two.)

A. They import all metadata from the RCAT10 catalog.

B. They unregistered the database from the RCAT10 catalog.

C. They do not register the databases registered in the RCAT10 catalog.

D. They register all databases registered in the RCAT10 catalog.

Answer: AD


Q53. The Database Resource Manager is automatically enabled in the maintenance window that runs the Automated Maintenance Task. 

What is the reason for this?

A. to prevent the creation of an excessive number of scheduler job classes

B. to allow the Automated Maintenance Tasks to use system resources without any restriction

C. to allow resource sharing only among the Automated Maintenance Tasks in the maintenance window

D. to prevent the Automated Maintenance Tasks from consuming excessive amounts of system resources

Answer: D


Q54. Which statement describes the information returned by the DBMS_SPACE.SPACE_USAGE procedure for LOB space usage?

A. It returns space usage of only BasicFile LOB chunks.

B. It returns space usage of only SecureFile LOB chunks.

C. It returns both BasicFile and SecureFile LOB space usage for only nonpartitioned tables.

D. It returns both BasicFile and SecureFile LOB space usage for both partitioned and nonpartitioned tables.

Answer: B


Q55. You enabled Flashback Data Archive on the INVENTORY table. 

Which DDL operation is supported on the table after enabling Flashback Data Archive?

A. Drop the table.

B. Partition the table

C. Truncate the table.

D. Add a column to the table.

E. Rename a column in the table.

Answer: D


Most up-to-date 1z0-050 download:

Q56. Which two kinds of failures make the Data Recovery Advisor (DRA) generate a manual checklist? (Choose two.)

A. failures because a data file is renamed by error

B. failures when no standby database is configured

C. failures that require no archive logs to be applied for recovery

D. failures due to loss of connectivity-for example, an unplugged disk cable

Answer: AD


Q57. You issued the following RMAN command to back up the database:

RMAN> RUN{

ALLOCATE CHANNEL c1

DEVICE TYPE sbt

BACKUP DATABASE

TAG quarterly

KEEP FOREVER

RESTORE POINT FY06Q4;}

Which two statements are true regarding the backup performed? (Choose two.)

A. Archived redo log files are backed up along with data files.

B. Only data files are backed up and a restore point named FY06Q4 is created.

C. Archived log files are backed up along with data files, and the archived log files are deleted.

D. The command creates a restore point named FY06Q4 to match the SCN at which this backup is consistent.

Answer: AD


Q58. Evaluate the following command:

SQL> CREATE TABLE design_data (id NUMBER,

doc CLOB)

LOB(doc) STORE AS SECUREFILE(DEDUPLICATE);

Which statement is true regarding the above command?

A. The LOB values are automatically compressed.

B. The LOB values are cached by default in the buffer cache.

C. The LOB values are automatically stored in encrypted mode.

D. All LOB data that is identical in two or more rows in a LOB column share the same data blocks.

Answer: D


Q59. Which two statements about workload capture and replay operations are true? (Choose two.)

A. The clients must be created manually on the test machines to perform more realistic testing.

B. Restart the database in RESTRICTED mode before beginning workload replay to enable a clean state for workload replay.

C. Restart the database in RESTRICTED mode before beginning workload capture to enable a clean state for capturing the workload.

D. The application state of the capture system must be identical to the application state of the replay system when the workload replay begins.

Answer: CD


Q60. View the Exhibit to examine the parameter values.

You are planning to set the value for the MEMORY_TARGET parameter of your database instance.

What value would you assign?

A. 90 MB

B. 272 MB

C. 362 MB

D. 1440 MB

Answer: C