What is the outcome of executing these commands in the ORCL1 database?

The schema SALES exists in two databases, ORCL1 and ORCL2, and has the same password, SALES123.User SALES has CREATE DATABASE LINK and CREATE SESSION privileges on both databases.Examine these commands:Conn SALES/SALES123CREATE DATABASE LINK orcl2 USING ‘orcl2’;What is the outcome of executing these commands in the ORCL1 database? A. ORCL2 is created as a public database […]

Read More

Which statement is true about a database in ARCHIVELOG mode?

Which statement is true about a database in ARCHIVELOG mode? A. All backups taken prior to switching to ARCHIVELOG mode can be used to perform complete recovery. B. Online redo log files have to be multiplexed before putting the database in ARCHIVELOG mode. C. A Fast Recovery Area (FRA) must be configured for the database. […]

Read More

The default location for the archived redo log files is the FRA.

You configured the Fast Recovery Area (FRA) for your database. The database instance is in ARCHIVELOGmode. The default location for the archived redo log files is the FRA.Which two files are removed automatically if space is required in the FRA as per the retention policy? (Choosetwo.) A. Archived redo log files that have multiple copies […]

Read More

Which three statements are true about user account administration?

Which three statements are true about user account administration? (Choose three.) A. A user’s current session is not affected when the user’s profile is changed. B. Only users with the SYSDBA privilege can change the tablespace quota for other users. C. A new user account can be created only by SYS or SYSTEM users. D. […]

Read More