You execute this command：

SQL> CREATE TABLE acct1 (ac_no NUMBER,ac_desc VARCHAR2(25),amount NUMBER(10, 2));

which three statements are true?

SQL> CREATE TABLE acct1 (ac_no NUMBER,ac_desc VARCHAR2(25),amount NUMBER(10, 2));

which two statements are true?

SQL>CREATE USER sidney IDENTIFIED BY out_standing1 DEFAULT TABLESPACE users QUOTA 10M ON users TEMPORARY TABLESPACE temp ACCOUNT UNLOCK;

SQL>GRANT CREATE SESSION To sidney;

Which two statements are true?

$> impdp <user_name> full=Y network_link=hrdb_test transportable=always transport_datafiles=

'/u01/app/oracle/oradata/hrdb/salea01.dbf' ,

'/u01/app/oracle/oradata/hrdb/cust01.dbf' ,

'/u01/app/oracle/oradata/hrdb/emp01.dbf’

version=l2 logfile=import.log

Which three are prerequisites for successful execution of the command?

You plan to use the ALTER SYSTEM command. Which two methods can be used?

Which two types of lock are held by the transaction?

Hostname：HOST01

Port：1521

Service_name：SALES_SRV

You issue this command：

$tnsping SALES

Which two are true?

A newly created database has no RMAN backups.

Examine these commands ：

CONfIGURE RETENTION POLICY To REDUNDANCY 2 ;

RMAN>BACKUP TABLESPACE SYSTEM;

backup set complete,elapsed time ：

RMAN>BACKUP TABLESPACE SYSTEM,SYSAUX ；

backup set complete, elapsed time： 00： 00： 04

RMAN>BACKUP DATABASE ;

backup set complete, elapsed time： 00：00：07

Which two are true about the execution of the third backup command?

NAME               TYPE     VALUE

db_create_file_deststring   /u01/app/oracle/oradata/prod/

Now examine this statement which executes successfully in an Oracle Database version 12c or later.

CREATE TABLESPACE data_olap;

Which two are true about this tablespace and its attributes?

SQL>STARTUP PFILE= 'D：\0racle12c\0racle\admin\orcl\pfile\pfileinitorcl.ora ' ORACLE instance started .

Total system Global Area 5117049968 bytes

Fixed Size  9038960 bytes

Variable size  922746880 bytes

Database Buffers  4177526784 bytes

Redo Buffers  7737344 bytes

Database mounted .

Database opened .

Now examine these statements：

SQL>SHOW PARAMETER cursor_ sharing;

NAME           TYPE  VALUE

cursor_sharing    string  EXACT

SQL>ALTER SYSTEM SET cursor_sharing= FORCE; （游标，force是在任何情况下，无条件重用SQL）

Which three are true about the result of processing the last statement?

SQL>SHOW PARAMETER undo retention;

NAME            TYPEVALUE

undo_retontion  integer  900

Now examine     these statements：

SQL>SELECT TABLESPACE_NAME, RETENTION FROM dba_table_spaces WHERE TABLESPACE_NAME="UNDOTHSl" ; 

TABLESPACE_NAMERETENTION

UNDOTBS1       GUARANTEE

SQL>conn hr/hr@PROD

Connocted .

SQL>INSERT INTO emp (id, name, salary, Depno) VALUES (101, ‘John', 12000, 30);

1 row created -

COMMIT;

Commi tcomplete .

Which three are true about the processing of these statements?

NAME             TYPE VALUE

undo_management  string  AUTO

undo_retention   integer  900

Now examine this statement：

AITER TABLESPACE undotbsl RETENTION GUARANTEE; Tablespace altered .

Which two are true about undo retention in this configuration?