The tnsnames.ora file has an entry for the service alias ORCL as follows:The TNSPING command executes successfully when tested with ORCL; however, from the same OS user session, you are not able to connect to the database instance with the following command:SQL > CONNECT scott/tiger@orcl -What could be the reason for this?
Examine the following steps of privilege analysis for checking and revoking excessive, unused privileges granted to users:1. Create a policy to capture the privilege used by a user for privilege analysis.2. Generate a report with the data captured for a specified privilege capture.3. Start analyzing the data captured by the policy.4. Revoke the unused privileges.5. Compare the used and unused privileges lists.6. Stop analyzing the data.Identify the correct sequence of steps.
Your database is running an ARCHIVELOG mode.The following parameters are set in your database instance:Which statement is true about the archived redo log files?
Your multitenant container database (CDB) is running in ARCHIVELOG mode. You connect to the CDB RMAN.Examine the following command and its output:You execute the following command:RMAN > BACKUP DATABASE PLUS ARCHIVELOG;Which data files will be backed up?
Your database uses Automatic Memory Management, and has the large pool configured.You issue the following command:SQL> ALTER SYSTEM SET SHARED_SERVERS = 5;Which statement is true about the shared server configuration?
Which two statements are true about Oracle Managed Files (OMF)? (Choose two.)
