Examine the parameters for your database instance:You execute the following command:SQL> ALTER TABLESPACE undotbs1 RETENTION NOGUARANTEE;Which statement is true in this scenario?
One of your databases supports an OLTP workload.The default UNDO tablespace is fixed size with:1. RETENTION NOGUARANTEE2. UNDO_RETENTION is 12 minutesUser SCOTT gets this error after a query on the SALES table has run for more than 15 minutes:ORA-01555: snapshot too old -Which three factors taken separately or in some combination might be the cause? (Choose three.)
A user establishes a connection to a database instance by using an Oracle Net connection. You want to ensure the following:1. The user account must be locked after five 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 of 10 minutes session idle time before being logged off automatically.How would you accomplish this?
As a user of the ORCL database, you establish a database link to the remote HQ database such that all users in the ORCL database may access tables only from the SCOTT schema in the HQ database. SCOTT’s password is TIGER. The service mane "HQ" is used to connect to the remote HQ database.Which command would you execute to create the database link?
One of your databases has archive logging enabled and RMAN backups are taken at regular intervals.The data file for the USERS tablespace is corrupt.Which command must you execute before starting the recovery of this tablespace?
Examine this command executed on a client that is remote from the database server.SQL> CONNECT hr/hr@orcl -Which two are required for this command to connect the SQLPLUS client to a database instance? (Choose two.)
