Examine this command:

Which two statements are true? (Choose two.)

• A.The tablespace containing SALES1.DBF must be altered READ ONLY before executing the command.
• B.DML may be performed on tables with one or more extents in this data file during the execution of this command.
• C.The file is renamed and stored in the same location
• D.The tablespace containing SALES1.DBF must be altered OFFLINE before executing the command.
• E.If Oracle Managed Files (OMF) is used, then the file is renamed but moved to DB_CREATE_FILE_DEST.

Comment: *

Name: *

Email: *

Verification: *

The SCOTT/TIGER user exists in two databases, BOSTON_DB and DALLAS_DB, in two different locations.
Each database has a tnsnames.ora file defining DALLAS_DB as a service name.
Examine this command:
CREATE DATABASE LINK dblink1 CONNECT TO scott IDENTIFIED BY tiger USING
`dallas_db';
How do you execute the command so that only SCOTT in BOSTON_DB can access the SCOTT schema in DALLAS_DB?

• A.as SCOTT in both the databases
• B.as SYS in both the databases
• C.as SCOTT in BOSTON_DB and SYS in DALLAS_DB
• D.as SCOTT in DALLAS_DB
• E.as SCOTT in BOSTON_DB

Comment: *

Name: *

Email: *

Verification: *

The ORCL database has RESUMABLE__TIMEOUT = 7200 and DEFERRED_SEGMENT_CREATION = FALSE User U1 has a 1 MB quota in tablespace DATA.
U1 executes this command:
SQL> CREATE TABLE t1 AS
(SELECT object_name, sharing, created
FROM dba_objects);
U1 complains that the command is taking too long to execute.
In the alert log, the database administrator (DBA) finds this:
2017/3/6 14:45:17
statement in resumable session 'User U1(136), Session 1, Instance 1' was suspended due to ORA-01536: space quota exceeded for tablespace 'DATA' Which are three actions any one of which the DBA could take to resume the session? (Choose three.)

• A.Add a data file to DATA
• B.Set AUTOEXTEND ON for data files in DATA
• C.Set DEFERRED_SEGMENT_CREATION to TRUE
• D.Grant UNLIMITED TABLESPACE to U1
• E.Drop other U1 objects in DATA
• F.Increase U1's quota sufficiently in DATA

Comment: *

Name: *

Email: *

Verification: *

Which two tasks can you perform using DBCA for databases? (Choose two.)

• A.Configure a nonstandard block size for a new database
• B.Enable flashback database for an existing database
• C.Register a new database with an available Enterprise Manager Management server
• D.Configure incremental backups for a new database
• E.Change the standard block size of an existing database

Comment: *

Name: *

Email: *

Verification: *

Which two statements are true about the DUAL table? (Choose two.)

• A.It can be accessed only by the SYS user
• B.It consists of a single row and single column of VARCHAR2 data type
• C.It can display multiple rows but only a single column
• D.It can be used to display only constants or pseudo columns
• E.It can be accessed by any user who has the SELECT privilege in any schema
• F.It can display multiple rows and columns

Comment: *

Name: *

Email: *

Verification: *