1. The database instance crashed because of power failure. The database files are not affected by the crash.
Which files will be used for the instance recovery at the next database instance startup? (Choose all that apply)

A. Data files
B. Control file
C. Redo log files
D. Flash recovery logs
E. Archive redo log files

___________________________________________________________________________

2. The database instance is started using SPFILE and the database is in MOUNT state.
Which two operations can you perform in the MOUNT state of the database? (Choose two)

A. Renaming the data files
B. Creating new tablespace
C. Adding the database user
D. Configuring the database in the ARCHIVELOG mode

___________________________________________________________________________

3. Examine the following specifications for the USERS tablespace: -
The tablespace is locally managed - The segment space management is automatic
- The tablespace will extend automatically whenever it needs space.
Which two statements are true about the space management in the USERS tablespace? (Choose two)

A. You must coalesce the free space to avoid fragmentation
B. The used and free extents are managed by the freelists
C. The extent size is determined automatically by the system
D. The free space in the segment is managed by the bitmaps
E. The PCTUSED and PCTFREE storage attributes are used to track free space in segments

___________________________________________________________________________

4. You execute the following set of commands to create a database user and to grant
the system privileges in your production database:

SQL> CREATE USER user01
IDENTIFIED BY oracle
DEFAULT TABLESPACE tbs1
TEMPORARY TABLESPACE temp
PROFILE default;
SQL> GRANT create session, create table TO user01;

Identify the tasks that the USER01 user can perform.

A. Connecting to the database instance and creating tables only
B. Connecting to the database instance, creating tables and dropping tables
C. Only connecting to the database instance
D. Connecting to the database instance, creating tables and granting access for tables in other schemas

___________________________________________________________________________

5. Which three resource restrictions can be imposed for the users by assigning profiles? (Choose three)

A. Redo generated by a user
B. Undo generated by a user
C. The CPU usage for a user
D. The input/output (I/O) for a user
E. The number of concurrent sessions for a user

___________________________________________________________________________

6. UNDO_RETENTION is set to 900 in your database, but undo retention guarantee is not enabled.
Which statement is true in this scenario?

A. Undo data is overwritten if no space is available for the new undo data
B. All undo data is purged if no space is available to accommodate new undo generated
C. Undo data is retained even if no space is available and new undo generated is stored in the temporary tablespace
D. Undo data becomes obsolete if a long-running transaction takes more time than that specified by UNDO_RETENTION

___________________________________________________________________________

7. The database is running and users are connected to the database instance using the LSNR1 listener.
You observe that LSNR1 has stopped. Which two statements are true in this situation? (Choose all that apply)

A. New connections are not allowed
B. The connected sessions are not affected
C. The connected sessions are hung until the LSNR1 listener is started
D. All the sessions are terminated and active transactions are rolled back

___________________________________________________________________________

8. The abnormal termination of the database background process causes
the database instance to shut down without synchronizing the database files.
The steps that will be performed at the next instance startup in random order are as follows:

1) Perform recovery manually
2) SMON applies redo to the database
3) The database opens
4) Uncommitted transactions are rolled back by SMON
5) SMON reads the archived redo log files and online redo log files.

Arrange the steps required for instance recovery in the correct order

A. 2, 3, and 4 (1 and 5 not required)
B. 2, 4, and 3 (1 and 5 not required)
C. 5, 3, and 4 (1 and 2 not required)
D. 2, 3, and 1 (4 and 5 not required)

___________________________________________________________________________

9. Which statement is true for the database configured in the ARCHIVELOG mode?
A. Archiving information is written to the data files and redo log files.
B. Flash recovery area must be used to store the archived redo log files
C. You can take backup of the database without shutting down the database.
D. The online redo log files must be multiplexed before putting the database in the ARCHIVELOG mode.

___________________________________________________________________________


10. Which two statements are true about the Flashback technology? (Choose two)
A. The accidental loss of schema can be recovered.
B. The accidental loss of tablespace can be recovered.
C. The restoration of files is not required for accomplishing the recovery.
D. The unsolicited or wrongly committed transactions can be recovered.

أنا مش عبقرى و لا حاجة.. بس حبيت انشط الذاكره على الصبح كده

1. A B C
2. A D
3. C D
4. C
5. C D E
6. A
7. A B
8. A
9. C
10. C D

related also to OCP ; can provide more questions perfect questions but all related OCA