Your database is in NOARCHIVELOG mode. You want to enable archiving for database. Examine the steps：

-1.Execute the ALTER DATABASE ARCHIVELOG command 

-2.Execute SHUTDOWN IMMEDIATE 

-3.Execute STARTUP MOUNT 

-4.Set the DA_RECOUVERY_FILE_DEST parameter to $ORACLE_HOME/dbs/ 

-5.Execute STARTUP NOMOUNT 

-6.Open the database 

Identify the require steps in the correct sequence.

Examine the details of the uncompressed, non-partitioned heap table CITIES.

Name Null Type

CITYIDNOT NULL NUMBER(4)

CITYNAME VARCHAR2(50)

Examine the command：

SQL>ALTER TABLE cities SHRINK SPACE COMPACT; What must you do nefore executing it?

Which statement is ture about profile?

What is the outcome of the SHUTDOWN ABORT command?

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.

Eaxmine these command： conn SALES/SALES123 CREATE DATABASE LINK orcl2 USING ‘orcl12’;

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

Which statement is true about a database in ARCHIVELOG mode?

Identify the access that is initially availabel to connect to your Database as a Service (DBaaS) environment

Which statement is true about the Database as a Service (DBaaS) instances and Database instances in Oracle Public Cloud?

Your database instance is started with a PFILE. Examine the parameters：

NAME TYPE VALUE

Memory_max_target big integer 0

Memory_target big integer 0

Sga_max_size big integer 2G

Sga_target big integer 2G

You want to increase the size of the buffer cache. Free memory is available to increase the size of the buffer cache. you execute the command：

SQL> ALTER SYSTEM SET DB_CACHE_SIZE=1024M;

Which is the outcome?

You want to create a locally managed tablespace called NEWTBS to store segments with different extent sizes.

Which set of tablespace attributes can be specified for a tablespace the satifies the requirements?

Which user are created and can be used for database and host management of your DBaaS database servers?

What action must you take to ensure complete database recovery till the point of failure?

You want to distribute a set of structured data to your customers who can integrate this data into their existing databases irrespective of the platform.

Which method provides the fastest way of achieving this?