Online Access Free 1z1-072 Exam Questions

Examine this command:
CREATE TEMPORARY TABLESPACE temp_tbs
TEMPFILE 'temp01.dbf' SIZE 10M AUTOEXTEND ON
ONLINE
SEGMENT MANAGEMENT AUTO;
Which two changes must you make so that TEMP_TBS is created? (Choose two.)

• A.Add the NOLOGGING clause.
• B.Add MAXSIZE for the AUTOEXTEND ON clause.
• C.Remove the AUTOEXTEND ON clause.
• D.Remove the SEGMENT MANAGEMENT AUTO clause.
• E.Add the EXTENT MANAGEMENT LOCAL UNIFORM clause.
• F.Remove the ONLINE clause.

Which three statements are true about an spfile? (Choose three)

• A.It contains initialization parameters whose values can be changed using the ALTER SYSTEM command.
• B.It can be used to create a pfile.
• C.It contains only static initialization parameters.
• D.It must exist for a database instance to start.
• E.It is the first file processed at instance startup.
• F.It can be edited by SYS when the database instance is shut down.

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 DALLAS_DB
• B.as SCOTT in BOSTON_DB and SYS in DALLAS_DB
• C.as SYS in both the databases
• D.as SCOTT in both the databases
• E.as SCOTT in BOSTON_DB

Which two statements are true about the tablespace SEGMENT SPACE MANAGEMENT clause? (Choose two.)

• A.It specifies whether users have direct control over space allocation for the objects in a tablespace.
• B.It overrides the DEFAULT STORAGE clause specified for a tablespace.
• C.It applies only to permanent tablespaces.
• D.It applies only to tablespaces with uniform extent size.
• E.It specifies whether used and free extents are tracked using free lists or bitmaps.
• F.It applies only to smallfile tablespaces.

Which two backup configurations are set by default when you choose Cloud Storage Only as the backup destination? (Choose two.)

• A.encryption for all backups
• B.encryption of backups only for Enterprise Edition databases
• C.on-demand backups that need to be scheduled
• D.encryption of backups only for High Performance and Extreme Performance database versions
• E.automatic daily full database backups
• F.RMAN incremental backups in a seven-day cycle