1Z1-050 by Oracle Actual Free Exam Questions And Answers

Question 1

You are managing the APPPROD database as a DBA. You plan to duplicate this database in the same system with the name DUPDB. You issued the following RMAN commands to create a duplicate database: RMAN> CONNECT target sys/sys@APPPROD RMAN> DUPLICATE TARGET DATABASE
TO dupdb FROM ACTIVE DATABASE DB_FILE_NAME_CONVERT '/oracIe/oradata/prod/1, '/scratch/oracIe/oradata/dupdb/1 SPILE PARAMETER_VALUE_CONVERT'/oracle/oradata/prod/1, '/scratch/oracIe/oradata/dupdb/1 SET SGA_MAX_SIZE = '300M1 SET SGA_TARGET = '250M' SET LOG_FILE_NAME_CONVERT '/oracle/oradata/prod/redo/', '/scratch/oracIe/oradata/dupdb/redo/1;
Which three are the prerequisites for the successful execution of the above command? (Choose three.)

A. The source database should be open.

B. RMAN should be connected to both the instances as SYSDBA

C. The password file must exist for the source database and have the same SYS user password as the target.

D. The target database should be in ARCHIVELOG mode if it is open.

E. The target database backups should be copied to the source database backup directories.

Discussion 0

Correct Answer: A,B,C Vote an answer

Question 2

You are working on a CATDB database that contains an Oracle Database version 11.1 catalog schema owned by the userRC011. 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 RC011. You executed the following commands:
RMAN> CONNECT CATALOG rco11/password@catdb RMAN> IMPORT CATALOG rcat1 0/oracle@inst1 NO UNREGISTER;
Which two statements are true regarding the tasks accomplished with these commands? (Choose two.)

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

B. They unregister the database from the RCAT10 catalog.

C. They import all metadata from the RCAT10 catalog.

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

Discussion 0

Correct Answer: C,D Vote an answer

Question 3

Which two statements about Oracle Direct Network File System (NFS) are true? (Choose two.)

A. It uses the operating system kernel NFS layer for user tasks and network communication modules.

B. It bypasses the OS file system cache

C. Oracle Disk Manager can manage NFS on its own, without using the operating system kernel NFS driver.

D. File systems need not be mounted by the kernel NFS system when being served through Direct NFS.

E. A separate NFS interface is required for use across Linux, UNIX, and Windows platforms.

Discussion 0

Correct Answer: B,D Vote an answer

Question 4

You executed the following commands in an RMAN session for your database instance that has failures:
RMAN> LIST FAILURE;
After some time, you executed the following command in the same session:
RMAN> ADVISE FAILURE;
But there are new failures recorded in the Automatic Diagnostic Repository (ADR) after the execution of the last LIST FAILURE command. Which statement is true for the above ADVISE FAILURE command in this scenario?

A. It produces advice only for new failures and the failures listed in the last LIST FAILURE
command are ignored.

B. It produces a warning for new failures before advising for CRITICAL and HIGH failures.

C. It ignores new failures and considers the failures listed in the last LIST FAILURE command only.

D. It produces an error with recommendation to run the LIST FAILURE command before the ADVISE FAILURE command.

Discussion 0

Correct Answer: B Vote an answer

Question 5

Evaluate the following command and Its output:
SQL>SELECT * FROM dba_temp_free_space;
TABLESPACE_NAME TABLESPACE_SIZE ALLOCATED_SPACE FREE_SPACE
LMTEMP 250609664 101048576 149561088
Which two statements correctly interpret the output? (Choose two.)

A. FREE_SPACE indicates both the space that is currently allocated and available for reuse, and the space that is currently unallocated.

B. FREE_SPACE indicates only the space that is currently unallocated.

C. ALLO CAT ED_S PACE indicates only the space currently allocated and in use.

D. FREE_SPACE indicates only the space that is currently allocated and available for reuse.

E. ALLO CAT ED_S PACE indicates both the space currently allocated and used, and the space that is available for reuse.

Discussion 0

Correct Answer: A,E Vote an answer

Question 6

You have the following requirements in relation to the detection of block corruption for your database instance:
1.Check for logical self-consistency of data blocks when modified in memory.
2.Checksums are calculated before and after the block change.
3.Checks are performed for the lost writes to the physical standby database.
Which method would help you perform the above checks automatically?

A. Set the DB_ULTRA_SAFE parameter to DATAJDNLY.

B. Set the DB_LOCK_CHECKSUM parameter to TYPICAL.

C. Set the DB_LOST_WRITE_PROTECT parameter to TYPICAL.

D. Set the DB_SECUREFILE parameter to PERMITTED.

Discussion 0

Correct Answer: A Vote an answer

Question 7

You issued the following command:
CREATE GLOBAL TEMPORARY TABLE admin_work_area
(startdate DATE,
enddate DATE,
class CHAR(20))
ON COMMIT DELETE ROWS
TABLESPACE tbs_t1;
An index is then created on the ADMIN_WORK_AREA temporary table.
Which two statements are true regarding the TBS_T1 tablespace in the above command? (Choose two.)

A. It must be the default temporary tablespace of the user who issues the command.

B. It can be a default or nondefault temporary tablespace for the database.

C. It must be a nondefault temporary tablespace for the database.

D. It stores both the temporary table as well as its indexes.

E. It stores only the temporary table but not its indexes.

Discussion 0

Correct Answer: B,D Vote an answer

Question 8

You have applications that have frequently executed queries, and produce small and static result sets.
You configure the sqlnet.ora file in the client machine to set a nonzero value for the OCI_RESULT_CACHE_MAX_SIZE parameter.
What is the purpose of this configuration?

A. to avoid the storing of query plans and results in the server by creating a cache in the client memory

B. to enhance the query performance by creating a cache in the client memory for sorting operations

C. to improve performance by storing a copy of the data from the private SQL area of the PGA

D. to avoid round trips to the server by enabling caching of query results in client memory

Discussion 0

Correct Answer: D Vote an answer

Question 9

SQL> EXECUTE
DBMS_WORKLOAD_REPOSITORY.CREATE_BASELINE_TEMPLATE(START_TIME=>
TO_TIMESTAMP(SYSDATE+2),
END_TIME=>TO_TIMESTAMP(SYSDATE+10),
BASELINE_NAME=>'Mybase4',
TEMPLATE_NAME=>'Mytemp4l,
EXPIRATION=>NULL);
Which statement is true about the effect of the above command?

A. It creates a repeating baseline template that repeats after the Automatic Workload Repository (AWR) retention period.

B. It creates a baseline template that never expires.

C. It produces an error because no snapshot information is provided to create the baseline.

D. It creates a baseline template that expires after the Automatic Workload Repository (AWR) retention period.

Discussion 0

Correct Answer: B Vote an answer

Question 10

You plan to collect the Automatic Workload Repository (AWR) data every Monday morning for a month. You want Oracle Database to automatically create a baseline every Monday and remove the old baseline. What is the correct action to achieve this?

A. Insert a finding directive for future ADDM tasks.

B. Create a repeating baseline template.

C. Change the RETENTION setting for the AWR snapshots to 7 days on Monday.

D. Create and populate a SQL Tuning Set from the AWR on every Monday.

Discussion 0

Correct Answer: B Vote an answer

Question 11

The Oracle Database 11g database is running in the ARCHIVELOG mode. The archived redo log files are stored on three locations. The Flash Recovery Area is one of the locations. The details are given below:
LOG_ARCHIVE_DEST_1 = 'LOCATION = /disk1 /archive1
LOG_ARCHIVE_DEST_2 = 'SERVICE = Stdb1
DB_RECOVERY_FILE_DEST = 7u01/oradata'
Examine the following RMAN command issued to set the deletion policy for archived log files:
RMAN> CONFIGURE ARCHIVELOG DELETION POLICY TO BACKED UP 2 TIMES TO sbt;
Which statement is true regarding what this command accomplishes?

A. All archived redo log files in local archiving destinations and the flash recovery area backed up at least twice to tape are eligible for deletion.

B. All archived redo log files backed up at least twice to tape are deleted from the flash recovery area.

C. All archived redo log files backed up at least twice to tape are deleted.

D. All archived redo log files backed up at least once to tape are eligible for deletion.

Discussion 0

Correct Answer: A Vote an answer

Oracle Database 11g: New Features for Administrators - 1Z1-050 Exam Practice Test

Contact Us

Useful Links

Latest Updated