Online 1Z0-062 Practice TestMore Oracle Products >

Free Oracle 1Z0-062 Exam Dumps Questions

Oracle 1Z0-062: Oracle Database 12c: Installation and Administration

- Get instant access to 1Z0-062 practice exam questions

- Get ready to pass the Oracle Database 12c: Installation and Administration exam right now using our Oracle 1Z0-062 exam package, which includes Oracle 1Z0-062 practice test plus an Oracle 1Z0-062 Exam Simulator.

- The best online 1Z0-062 exam study material and preparation tool is here.

4.5

(1080 ratings)

Question 1

A user establishes a connection to a database instance by using an Oracle Net. You want to ensure that:
1. The user account must be locked after five consecutive unsuccessful login attempts.
2. Data read per session must be limited for the user.
3. The user cannot have more than three simultaneous sessions.
4. The user must have a maximum minutes session idle time before being logged off automatically. Which two would you do to implement this? (Choose two.)

A. by alerting the appropriate user attributes with an ALTER USER command

B. by using appropriate PASSWORD parameters set in the profile assigned to the user

C. by implementing Database Resource Manager and assign it a profile for the user

D. by implementing Database Resource Manager and assign it a role for the user

E. by using appropriate KERNEL parameters set in the profile assigned to the user

Correct Answer:BE

Question 2

Which three file types are stored in the Fast Recovery Area by default in a traditional nonOMF file system? (Choose three.)

A. online redo log files

B. parameter file

C. multiplexed copies of the current control file

D. archived log files

E. Flashback Data Archive files

F. Flashback logs

Correct Answer:ADF

Question 3

You want to flash back a test database by five hours. You issue this command:
SQL > FLASHBACK DATABASE TO TIMESTAMP (SYSDATE - 5/24);
Which two statements are true about this flashback scenario? (Choose two.)

A. The database must have multiplexed redo logs for the flashback to succeed.

B. The database must be MOUNTED for the flashback to succeed.

C. The database must use block change tracking for the flashback to succeed.

D. The database must be opened in restricted mode for the flashback to succeed.

E. The database must be opened with the RESETLOGS option after the flashback is complete.

F. The database must be opened in read-only mode to check if the database has been flashed back to the correct SC

Correct Answer:BE

Question 4

A database is stored in an Automatic Storage Management (ASM) disk group, disk group, DGROUP1 with SQL:
1Z0-062 dumps exhibit
There is enough free space in the disk group for mirroring to be done.
What happens if the CONTROLLER1 failure group becomes unavailable due to error of for maintenance?

A. Transactions and queries accessing database objects contained in any tablespace stored in DGROUP1 will fall.

B. Mirroring of allocation units will be done to ASM disks in the CONTROLLER2 failure group until the CONTROLLER1 for failure group is brought back online.

C. The data in the CONTROLLER1 failure group is copied to the controller2 failure group and rebalancing is initiated.

D. ASM does not mirror any data until the controller failure group is brought back online, and newly allocated primary allocation units (AU) are stored in the controller2 failure group, without mirroring.

E. Transactions accessing database objects contained in any tablespace stored in DGROUP1 will fail but queries will succeed.

Correct Answer:D

Question 5

Examine these two statements:
1Z0-062 dumps exhibit
Which three are true about the MRKT tablespace? (Choose three.)

A. The MRKT tablespace is created as a small file tablespace, because the file size is less than the minimum required for big file files.

B. The MRKT tablespace may be dropped if it has no contents.

C. Users who were using the old default tablespace will have their default tablespaces changed to the MRKT tablespace.

D. No more data files can be added to the tablespace.

E. The relative file number of the tablespace is not stored in rowids for the table rows that are stored in the MRKT tablespace.

Correct Answer:CDE

Question 6

Examine the command:
SQL> CREATE TABLESPACE test1
DATAFILE '/u01/app/oracle/oradata/orc1/test01.dbf' SIZE 5M AUTOEXTEND ON UNIFORM;
Which statement is true?

A. The data file, TEST01.DBF, can be auto extended to a maximum size M.

B. The tablespace, TEST1, can contain a maximum of one data file.

C. Allocated and free extents are tracked using bitmaps.

D. Segment free space is tracked in the data dictionar

Correct Answer:C

START 1Z0-062 EXAM