NEW QUESTION 1
Which three statements are true about GLOBAL TEMPORARY TABLES? (Choose three.)

• A. A TRUNCATE command issued in a session causes all rows in a GLOBAL TEMPORARY TABLE for the issuing session to be deleted.
• B. GLOBAL TEMPORARY TABLE rows inserted by a session are available to any other session whose user has been granted select on the table.
• C. GLOBAL TEMPORARY TABLE space allocation occurs at session start.
• D. Any GLOBAL TEMPORARY TABLE rows existing at session termination will be deleted.
• E. A GLOBAL TEMPORARY TABLE’S definition is available to multiple sessions.
• F. A DELETE command on a GLOBAL TEMPORARY TABLE cannot be rolled back.

Answer: BCF

NEW QUESTION 2
Which three statements are true about undo segments and the use of undo by transactions in an Oracle database instance? (Choose three.)

• A. An undo segment may be used by multiple transactions simultaneously
• B. Undo segments can wrap around to the first extent when a transaction fills the last extend of the undo segment
• C. Undo segments have a minimum of three extents
• D. Undo segments can extend when a transaction fills the last extent of the undo segment
• E. A single transaction may use multiple undo segments simultaneously
• F. Undo segments must be stored in a BIGFILE tablespace
• G. Undo segments must be stored in a SMALLFILE tablespace

Answer: ADG

NEW QUESTION 3
In which three situations does a new transaction always start? (Choose three.)

• A. when issuing a SELECT FOR UPDATE statement after a CREATE TABLE AS SELECT statement was issued in the same session
• B. when issuing a TRUNCATE statement after a SELECT statement was issued in the same session
• C. when issuing a CREATE TABLE statement after a SELECT statement was issued in the same session
• D. when issuing the first Data Manipulation Language (DML) statement after a COMMIT OR ROLLBACK statement was issued in the same session
• E. when issuing a CREATE INDEX statement after a CREATE TABLE statement completed successfullyin the same session
• F. when issuing a DML statement after a DML statement failed in the same session

Answer: ADF

NEW QUESTION 4
You want to write a query that prompts for two column names and the WHERE condition each time it is executed in a session but only prompts for the table name the first time it is executed.
The variables used in your query are never undefined in your session. Which query can be used?

• A. SELECT &&col1, &&col2FROM &tableWHERE &&condition = &&cond;
• B. SELECT &col1, &col2FROM &&tableWHERE &condition;
• C. SELECT &col1, &col2FROM “&table”WHERE &condition;
• D. SELECT ‘&&col1’, ‘&&col2’FROM &tableWHERE ‘&&condition’ = ‘&cond’;
• E. SELECT &&col1, &&col2FROM &tableWHERE &&condition;

Answer: B

NEW QUESTION 5
In one of your databases, user KING is:
1. Not a DBA user
2. An operating system (OS) user Examine this command and its output:

What must you do so that KING is authenticated by the OS when connecting to the database instance?

• A. Set OS_AUTHEN_PREFIX to OPS$
• B. Have the OS administrator add KING to the OSDBA group
• C. Grant DBA to KING
• D. Unset REMOTE_LOGIN_PASSWORDFILE
• E. Alter user KING to be IDENTIFIED EXTERNALLY

Answer: D

NEW QUESTION 6
Which three statements are true concerning logical and physical database structures? (Choose three.)

• A. All tablespaces may have one or more data files
• B. The extents of a segment must always reside in the same datafile
• C. A smallfile tablespace might be bigger than a bigfile tablespace
• D. A segment can span multiple data files in some tablespaces
• E. A segment’s blocks can be of different sizes
• F. A segment might have only one extent
• G. Segments can span multiple tablespsaces

Answer: CFG

NEW QUESTION 7
Which three are types of segments in an Oracle Database? (Choose three.)

• A. undo
• B. index
• C. stored procedures
• D. sequences
• E. tables
• F. clusters

Answer: BEF

NEW QUESTION 8
You want to apply the principle of Least Privilege in all your live databases.
One of your requirements is to revoke unnecessary privileges from all users who have them using Privilege Analysis.
Which three types of analyses can be done using the DBMS_PRIVILEGE_CAPTURE package? (Choose three.)

• A. analysis of all privileges used by all users including administrative users in the database
• B. analysis of all privileges used by all users but excluding administrative users in the database
• C. analysis of privileges that a user has on their own schema objects that they did not use
• D. analysis of privileges that a user has on their own schema objects that they did use
• E. analysis of privileges granted directly to a role that are then used by a user who has been granted that role
• F. analysis of privileges granted indirectly to a role that are then used by a user who has been granted that role

Answer: ACF

NEW QUESTION 9
Examine the description of the SALES1 table:

SALES2 is a table with the same description as SALES1. Some sales data is duplicated in both tables.
You want to display the rows from the SALES1 table which are not present in the SALES2 table. Which set operator generates the required output?

• A. INTERSECT
• B. UNION ALL
• C. UNION
• D. SUBTRACT
• E. MINUS

Answer: E

NEW QUESTION 10
Which four account management capabilities can be configured using Oracle profiles? (Choose four.)

• A. the number of hours for which an account is locked after the configured number of login attempts has been reached
• B. the number of days for which an account may be inactive before it is locked
• C. the maximum amount of CPU time allowed for a user’s sessions before their account is locked
• D. the ability to prevent a password from ever being reused
• E. the number of password changes required within a period of time before a password can be reused
• F. the number of days for which an account is locked after the configured number of login attempts has been reached
• G. the maximum number of sessions permitted for a user before the account is locked

Answer: DEFG

NEW QUESTION 11
Which two statements are true about views used for viewing tablespace and datafile information? (Choose two.)

• A. Tablespace free space can be viewed in VSTABLESPACE
• B. VSTABLESPACE displays information that is contained in the controlfile about tablespaces
• C. VSTABLESPACE displays information about tablespaces contained in the data dictionary
• D. Tablespace free space can be viewed in DBA_TABLESPACES
• E. A datafile can be renamed when the database is in MOUNT state and the new file name is displayed when querying DBA_DATA_FILES after the database is opened

Answer: BE

NEW QUESTION 12
You execute this query:
SELECT TO_CHAR(NEXT_DAY(LAST_DAY(SYSDATE), ‘MON’), ‘dd “Monday for” fmMonth rrrr’) What is the result?

• A. It executes successfully but does not return any result
• B. It returns the date for the first Monday of the next month
• C. It generates an error
• D. It returns the date for the last Monday of the current month

Answer: B

NEW QUESTION 13
Which three statements are true about the Oracle Data Dictionary? (Choose three.)

• A. Data dictionary views are created by joins of dictionary base tables and DBA-defined tables
• B. The data dictionary is created and maintained by the database administrator
• C. Views with the same name but different prefixes, such as CDB, DBA, ALL and USER, reference the same base tables from the data dictionary
• D. Base tables can be queried directly
• E. It is owned by the SYSTEM user
• F. Usernames of all users including database administrators are stored in the data dictionary

Answer: CDF

NEW QUESTION 14
Table EMPLOYEES contains columns including EMPLOYEE_ID, JOB_ID and SALARY. Only the EMPLOYEE_ID column is indexed.
Rows exist for employees 100 and 200. Examine this statement:

Which two statements are true? (Choose two.)

• A. Employee 100 will have SALARY set to the same value as the SALARY of employee 200
• B. Employee 200 will have JOB_ID set to the same value as the JOB_ID of employee 100
• C. Employee 200 will have SALARY set to the same value as the SALARY of employee 100
• D. Employee 100 will have JOB_ID set to the same value as the JOB_ID of employee 200
• E. Employees 100 and 200 will have the same JOB_ID as before the update command
• F. Employees 100 and 200 will have the same SALARY as before the update command

Answer: AB

NEW QUESTION 15
You execute this command:
CREATE SMALLFILE TABLESPACE sales
DATAFILE ‘/u01/app/oracle/sales01.dbf SIZE 5G
SEGMENT SPACE MANAGEMENT AUTO;
Which two actions must you take to ensure UNDOTBS01 is used as the default UNDO tablespace? (Choose two.)

• A. It must be smaller than the smallest BIGFILE tablespace
• B. Free space is managed using freelists
• C. Any data files added to the tablespace must have a size of 5 gigabytes
• D. It uses the database default blocksize
• E. It is a locally managed tablespace

Answer: DE

NEW QUESTION 16
Which two statements are true about the Automatic Diagnostic Repository (ADR)? (Choose two.)

• A. The ADR base defaults to $ORACLE_HOME/rdbms/admin ifneither DIAGNOSTIC_DEST nor ORACLE_BASE is set
• B. The ADR base defaults to $ORACLE_HOME/dbs if the DIAGNOSTIC_DEST parameter and the ORACLE_BASE environment variable are not set
• C. It supports diagnostics for Automatic Storage Management (ASM)
• D. It supports diagnostics for Oracle Clusterware
• E. It is held inside an Oracle database schema

Answer: AE

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

Answer: D

NEW QUESTION 18
Which four statements are true regarding primary and foreign key constraints and the effect they can have on table data? (Choose four.)

• A. A table can have only one primary key but multiple foreign keys
• B. A table can have only one primary key and foreign key
• C. The foreign key columns and parent table primary key columns must have the same names
• D. It is possible for child rows that have a foreign key to remain in the child table at the time the parent row is deleted
• E. It is possible for child rows that have a foreign key to be deleted automatically from the child table at the time the parent row is deleted
• F. Only the primary key can be defined at the column and table level
• G. Primary key and foreign key constraints can be defined at both the column and table level

Answer: ACEG

NEW QUESTION 19
Your database instance was shut down normally and then started in NOMOUNT state. You then execute this command:
ALTER DATABASE MOUNT;
Which two actions are performed? (Choose two.)

• A. The online redo logs are opened
• B. The online data files are opened
• C. The alert log records the execution details
• D. The Oracle background processes are started
• E. The initialization parameter file is read
• F. The control file is read

Answer: DF

NEW QUESTION 20
Which three statements are true about inner and outer joins? (Choose three.)

• A. A full outer join returns matched and unmatched rows
• B. An inner join returns matched rows
• C. Outer joins can only be used between two tables per query
• D. A full outer join must use Oracle syntax
• E. Outer joins can be used when there are multiple join conditions on two tables
• F. A left or right outer join returns only unmatched rows

Answer: ABF

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

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

Answer: BC

NEW QUESTION 22
You execute this command:

Sufficient storage is available in filesystem /u01.
Which two statements are true about the BIG_TBS tablespace? (Choose two.)

• A. AUTOEXTEND is possible for the datafile
• B. It must be bigger than the largest SMALLFILE tablespace
• C. Additional data files may not be added
• D. It will be a dictionary-managed tablespace by default
• E. It will always have a 32K blocksize

Answer: AB

NEW QUESTION 23
You execute this command:

During the export operation, you detach from the job by using CTRL+C and then execute this command: Export> STOP_JOB=immediate
Are you sure you wish to stop the job ([yes]/no): yes
Which two statements are true about the job? (Choose two.)

• A. You can no longer monitor it
• B. You can reattach to it and monitor it
• C. It is paused and can be resumed
• D. It continues to run in the background
• E. It terminates

Answer: AE

NEW QUESTION 24
......