1.
Which three components are always part of System Global Area?
2.
Which two statements about Database Express are true?
3.
Which three operations can the PUBLIC user with the SYSOPER privilege perform?
4.
To revoke unnecessary and unused privileges, you can use Privilege Analysis. Which sequence should you follow?
1 -Start the analysis.
2 - Set up the analysis policy type (database, role, context).
3 - Generate the results.
4 -View the results in DBA_USED_PRIVSand DBA_UNUSED_PRJVS.
5 - Stop the analysis.
5.
Which command do you use to create a local role while you are connected as the local user?
6.
YOU want to move all objects of the CONSULTANT user from the test database to theDB-USER schema of the production database. Which option of IMPDP would you use to accomplish this task?
7.

For which database operation do you need the database to be in MOUNT state?
8.
Examine the table: Table name: PRODUCTS Schema: SCOTT Tablespace: USERS Organization: Standard (Heap Organized) This table contains 20 rows. In the data that has been entered, the PROD_ID column contains only single-digit values, PROD_NAME has a maximum of five characters, and PROD_RATE has four-digit values for all rows. Which two statements are true regarding the modifications that can be performed to the structure of the PRODUCTS table?
9.
A DBA informs you that an Oracle instance has started. What does this imply?
10.
Real-Time ADDM detects a high-load performance issue within the database. Which condition triggered it?