1z0-082

Question 1 of 120

1

You execute this command:
CREATE BIGFILE TABLESPACE big_tbs
DATAFILE '/u01/oracle/data/big_f1.dbf'
SIZE 20G;

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

(Choose two).

Select one or more of the following:

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

Explanation

Question 52 of 120 Question 2 of 120

1

Which statement is true about the INTERSECT operator used in compound queries?

Select one or more of the following:

It processes NULLs in the selected columns
It ignores NULLs
INTERSECT is of lower precedence than UNION or UNION ALL
Multiple INTERSECT operators are not possible in the same SQL statement

Explanation

Question 65 of 120 Question 3 of 120

1

Which three statements are true about advanced connection options supported by Oracle Net for connection to Oracle Database instances?

(Choose three).

Select one or more of the following:

Source Routing enables the use of Connection Manager (CMAN) which enables network traffic to be routed through a firewall
Load Balancing requires the use of a name server
Source Routing requires the use of a name server
Connect Time Failover requires the connect string to have two or more listener addresses configured
Connect Time Failover requires the use of Transparent Application Failover (TAF)
Load Balancing can balance the number of connections to dispatchers when using a Shared Server configuration

Explanation

Question 4 of 120

1

Which two statements are true about date/time functions in a session where NLS_DATE_FORMAT is set to DD-MON-YYYY HH24:MI:SS?

(Choose two).

Select one or more of the following:

CURRENT_TIMESTAMP returns the same date and time as SYSDATE with additional details of fractional seconds
SYSDATE can be queried only from the DUAL table
CURRENT_DATE returns the current date and time as per the session time zone
SYSDATE can be used in expressions only if the default date format is DD-MON-RR
SYSDATE and CURRENT_DATE return the current date and time set for the operating system of the database server
CURRENT_TIMESTAMP returns the same date as CURRENT_DATE

Explanation

Question 17 of 120 Question 5 of 120

1

A database is configured to use automatic undo management with temporary undo enabled. An UPDATE is executed on a temporary table.

Where is the UNDO stored?

Select one of the following:

In the undo tablespace
In the PGA
In the SYSAUX tablespace
In the SGA
In the temporary tablespace

Explanation

Question 5 of 120 Question 6 of 120

1

You have been tasked to create a table for a banking application.
One of the columns must meet three requirements:
1. Be stored in a format supporting date arithmetic without using conversion functions
2. Store a loan period of up to 10 years
3. Be used for calculating interest for the number of days the loan remains unpaid

Which data type should you use?

Select one of the following:

TIMESTAMP
INTERVAL DAY TO SECOND
INTERVAL YEAR TO MONTH
TIMESTAMP WITH TIMEZONE
TIMESTAMP WITH LOCAL TIMEZONE

Explanation

Question 26 of 120 Question 7 of 120

1

In the spfile of a single instance database, LOCAL_LISTENER is set to LISTENER_1.
The TNSNAMES.ORA file in $ORACLE_HOME/network/admin in the database home contains:
LISTENER_1 =
(ADDRESS =
(PROTOCOL = TCP)
(HOST = host1.abc.com)
(PORT = 5121)
)

Which statement is true?

Select one of the following:

Dynamic service registration cannot be used for this database instance
The definition for LISTENER_1 requires a CONNECT_DATA section to enable dynamic service registration
The LREG process registers services dynamically with the LISTENER_1 listener
LISTENER_1 must also be defined in the LISTENER.ORA file to enable dynamic service registration
There are two listeners named LISTENER and LISTENER_1 running simultaneously using port 1521 on the same host as the database instances

Explanation

Question 18 of 120 Question 8 of 120

1

Which three statements are true concerning logical and physical database structures?

(Choose three).

Select one or more of the following:

A segment can span multiple data files in some tablespaces
All tablespaces may have one or more data files
Segments can span multiple tablespaces
A segment's blocks can be of different sizes
A segment might have only one extent
A smallfile tablespace might be bigger than a bigfile tablespace
The extents of a segment must always reside in the same datafile

Explanation

Question 88 of 120 Question 9 of 120

1

Which two statements are true regarding a SAVEPOINT?

(Choose two).

Select one or more of the following:

Only one SAVEPOINT may be issued in a transaction
Rolling back to a SAVEPOINT can undo a TRUNCATE statement
Rolling back to a SAVEPOINT can undo a DELETE statement
A SAVEPOINT does not issue a COMMIT
Rolling back to a SAVEPOINT can undo a CREATE INDEX statement

Explanation

Question 25 of 120 Question 10 of 120

1

Which three functions are performed by dispatchers in a shared server configuration?

(Choose three).

Select one or more of the following:

Sending each connection input request to the appropriate shared server input queue
Receiving inbound requests from processes using shared server connections
Broadcasting shared server session responses back to requesters on all connections
Writing inbound request to the common request queue from all shared server connections
Sending shared server session responses back to requesters on the appropriate connection
Checking for outbound shared server responses on the common outbound response queue

Explanation

Question 2 of 120 Question 11 of 120

1

Which two statements are true about the SET VERIFY ON command?

(Choose two).

Select one or more of the following:

It displays values for variables used only in the WHERE clause of a query
It displays values for variables created by the DEFINE command
It can be used in SQL Developer and SQL*Plus
It displays values for variables prefixed with &&
It can be used only in SQL*Plus

Explanation

Question 19 of 120 Question 12 of 120

1

Which three statements are true about a self join?

(Choose three).

Select one or more of the following:

It must be an inner join
It can be an outer join
The ON clause can be used
The query must use two different aliases for the table
It must be an equijoin
The ON clause must be used

Explanation

Question 3 of 120 Question 13 of 120

1

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?

Select one of the following:

SELECT &col1, &col2 FROM &&table WHERE &condition;
SELECT &&col1, &&col2 FROM &table WHERE &&condition = &&cond;
SELECT &col1, &col2 FROM ג€&tableג€ WHERE &condition;
SELECT '&&col1', '&&col2' FROM &table WHERE '&&condition' = '&cond';
SELECT &&col1, &&col2 FROM &table WHERE &&condition;

Explanation

Question 34 of 120 Question 14 of 120

1

Examine the description of the CUSTOMERS table:
Name Null? Type
--------------------------- -------------- ------------
CUST_ID NOT NULL VARCHAR2(6)
FIRST_NAME VARCHAR2(50)
LAST_NAME NOT NULL VARCHAR2(50)
ADDRESS VARCHAR2(50)
CITY VARCHAR2(25)

You want to display details of all customers who reside in cities starting with the letter D followed by at least two characters.

Which query can be used?

Select one of the following:

SELECT * FROM customers WHERE city LIKE 'D_%';
SELECT * FROM customers WHERE city LIKE 'D_';
SELECT * FROM customers WHERE city = 'D_%';
SELECT * FROM customers WHERE city = '%D_';

Explanation

Question 9 of 120 Question 15 of 120

1

Examine this command:
ALTER DATABASE
MOVE DATAFILE '/u01/sales1.dbf'
TO '/u01/sales01.dbf'
REUSE;

Which two statements are true?

(Choose two).

Select one or more of the following:

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

Explanation

Question 16 of 120

1

Which three statements are true about dropping and unused columns in an Oracle database?

(Choose three).

Select one or more of the following:

A primary key column referenced by another column as a foreign key can be dropped if using the CASCADE option.
An UNUSED column's space is reclaimed automatically when the block containing that column is next queried.
An UNUSED column's space is reclaimed automatically when the row containing that column is next queried.
Partition key columns cannot be dropped.
A DROP COLUMN command can be rolled back.
A column that is set to UNUSED still counts towards the limit of 1000 columns per table.

Explanation

Question 55 of 120 Question 17 of 120

1

Which two statements are true regarding Oracle database space management within blocks managed by Automatic Segment Space Management (ASSM)?

(Choose two).

Select one or more of the following:

Update operations always attempt to find blocks with free space appropriate to the length of the row being updated.
PCTFREE defaults to 10% for all blocks in all segments for all compression methods.
Insert operations always attempt to find blocks with free space appropriate to the length of the row being inserted.
ASSM assigns blocks to one of four fullness categories based on what percentage of the block is allocated for rows.
A block will always be eligible for inserts if the row is short enough to fit into the block

Explanation

Question 97 of 120 Question 18 of 120

1

Evaluate these commands which execute successfully:
CREATE SEQUENCE ord_seq
INCREMENT BY 1
START WITH 1
MAXVALUE 100000
CYCLE
CACHE 5000;

CREATE TABLE ord _items(
ord_no NUMBER(4) DEFAULT ord_seq NEXTVAL NOT NULL,
item_no NUMBER(3),
qty NUMBER(3),
expiry_date DATE,
CONSTRAINT it _pk PRIMARY KEY (ord_no, item_no),
CONSTRAINT ord_fk FOREIGN KEY (ord_no) REFERENCES orders (ord _no));

Which two statements are true about the ORD_ITEMS table and the ORD_SEQ sequence?

(Choose two).

Select one or more of the following:

Any user inserting rows into table ORD_ITEMS must have been granted access to sequence ORD_SEQ.
Sequence ORD_SEQ is guaranteed not to generate duplicate numbers
If sequence ORD_SEQ is dropped then the default value for column ORD_NO will be NULL for rows inserted into ORD_ITEMS.
Sequence ORD_SEQ cycles back to 1 after every 5000 numbers and can cycle 20 times.
Column ORD_NO gets the next number from sequence ORD_SEQ whenever a row is inserted into ORD_ITEMS and no explicit value is given for ORD_NO.

Explanation

Question 19 of 120

1

Which three instance situations are possible with the Oracle Database server without multi-tenant?

(Choose three).

Select one or more of the following:

Two or more instances on separate servers all associated with one database.
One instance on one server associated with one database.
One instance on one server associated with two or more databases on the same server.
One instance on one server not associated with any database
One instance on one server associated with two or more databases on separate servers.

Explanation

Question 62 of 120 Question 20 of 120

1

Which two statements are true about the ORDER BY clause when used with a SQL statement containing a SET operator such as UNION?

(Choose two).

Select one or more of the following:

Each SELECT statement in the compound query must have its own ORDER BY clause.
Column positions must be used in the ORDER BY clause.
The first column in the first SELECT of the compound query with the UNION operator is used by default to sort output in the absence of an ORDER BY clause.
Each SELECT statement in the compound query can have its own ORDER BY clause.
Only column names from the first SELECT statement in the compound query are recognized.

Explanation

Question 41 of 120 Question 21 of 120

1

Which four account management capabilities can be configured using Oracle profiles?

(Choose four).

Select one or more of the following:

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

Explanation

Question 21 of 120 Question 22 of 120

1

Which three statements are true about single-row functions?

(Choose three).

Select one or more of the following:

They can accept only one argument.
They can be nested to any level.
The data type returned can be different from the data type of the argument.
They can be used only in the WHERE clause of a SELECT statement.
They return a single result row per table.
The argument can be a column name, variable, literal or an expression.

Explanation

Question 82 of 120 Question 23 of 120

1

You want to use table compression suitable for OLTP that will:
1. Compress rows for all DML statements on that table
2. Minimize the overheads associated with compression

Which compression option is best suited for this?

Select one of the following:

COLUMN STORE COMPRESS FOR ARCHIVE HIGH
COLUMN STORE COMPRESS FOR ARCHIVE LOW
ROW STORE COMPRESS ADVANCED
COLUMN STORE COMPRESS FOR QUERY LOW
ROW STORE COMPRESS BASIC

Explanation

Question 109 of 120 Question 24 of 120

1

Which two statements are true about space-saving features in an Oracle Database?

(Choose two).

Select one or more of the following:

An index created with the UNUSABLE attribute has no segment
Private Temporary Tables (PTTS) store metadata in memory only
An index that is altered to be UNUSABLE will retain its segment
If they exist for a session, Private Temporary Tables (PTTs) are always dropped at the next COMMIT OR ROLLBACK statement
A table that is truncated will always have its segment removed

Explanation

Question 25 of 120

1

Which two statements are true about the PMON background process?

(Choose two).

Select one or more of the following:

It registers database services with all local and remote listeners known to the database instance.
It frees resources held by abnormally terminated processes.
It records checkpoint information in the control file.
It frees unused temporary segments.
It kills sessions that exceed idle time.

Explanation

Question 100 of 120 Question 26 of 120

1

In which three situations does a new transaction always start?

(Choose three).

Select one or more of the following:

When issuing a CREATE INDEX statement after a CREATE TABLE statement completed successfully in the same session.
When issuing a CREATE TABLE statement after a SELECT statement was issued in the same session.
When issuing a DML statement after a DML statement failed in the same session.
When issuing a TRUNCATE statement after a SELECT statement was issued in the same session.
When issuing the first Data Manipulation Language (DML) statement after a COMMIT OR ROLLBACK statement was issued in the same session.
When issuing a SELECT FOR UPDATE statement after a CREATE TABLE AS SELECT statement was issued in the same session.

Explanation

Question 27 of 120

1

Examine the description of the SALES1 table:
Name Null Type
------------------------ ------------- ------------
SALES_ID NOT NULL NUMBER
STORE_ID NOT NULL NUMBER
ITEMS_ID NUMBER
QUANTITY NUMBER
SALES_DATE DATE

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?

Select one of the following:

INTERSECT
UNION ALL
UNION
SUBTRACT
MINUS

Explanation

Question 28 of 120

1

Your database instance is started with a PFILE. Examine these 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;

What is the outcome?

Select one of the following:

The value is changed only in the PFILE and takes effect at the next instance startup.
The value is changed for the current instance and in the PFILE.
It fails because the SCOPE clause is missing.
Change is applied to the current instance, but does not persist after instance restart

Explanation

Question 29 of 120

1

Which three Oracle database space management features will work with both Dictionary and Locally managed tablespaces?

(Choose three).

Select one or more of the following:

Oracle Managed Files (OMF)
Online table segment shrink
Online index segment shrink
Automatic data file extension (AUTOEXTEND)
Capacity planning growth reports based on historical data in the Automatic Workload Repository (AWR)

Explanation

Question 74 of 120 Question 30 of 120

1

You execute this command:
[oracle@host01 ~]$ expdp system/oracle \
> FULL=Y \
> DUMPFILE=exp_db_full.dmp \
> PARALLEL=4 \
> LOGFILE=exp_dp_full.log \
> JOB_NAME=exp_db_full \

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).

Select one or more of the following:

It terminates.
You can no longer monitor it.
It continues to run in the background.
You can reattach to it and monitor it.
It is paused and can be resumed.

Explanation

Question 31 of 120

1

In one of your databases, you create a user, HR, and then execute this command:
GRANT CREATE SESSION TO hr WITH ADMIN OPTION;

Which four actions can HR perform?

(Choose four).

Select one or more of the following:

Revoke the CREATE SESSION privilege from other users.
Revoke the CREATE SESSION privilege from user HR.
Log in to the database instance.
Grant the CREATE SESSION privilege with ADMIN OPTION to other users.
Execute DDL statements in the HR schema.
Execute DML statements in the HR schema.

Explanation

Question 32 of 120

1

Which two statements are true about the WHERE and HAVING clauses in a SELECT statement?

(Choose two).

Select one or more of the following:

Aggregating functions and columns used in HAVING clauses must be specified in the SELECT list of a query.
WHERE and HAVING clauses can be used in the same statement only if applied to different table columns.
The HAVING clause can be used with aggregating functions in subqueries.
The WHERE clause can be used to exclude rows before dividing them into groups.
The WHERE clause can be used to exclude rows after dividing them into groups.

Explanation

Question 44 of 120 Question 33 of 120

1

Which two statements are true about UNDO and REDO?

(Choose two).

Select one or more of the following:

The generation of UNDO generates REDO.
DML modifies Oracle database objects and generates UNDO and REDO.
DML modifies Oracle database objects and only generates REDO.
The generation of REDO generates UNDO.
DML modifies Oracle database objects and only generates UNDO.

Explanation

Question 34 of 120

1

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?

Select one of the following:

as SCOTT in DALLAS_DB
as SCOTT in BOSTON_DB
as SCOTT in BOSTON_DB and SYS in DALLAS_DB
as SYS in both the databases
as SCOTT in both the databases

Explanation

Question 103 of 120 Question 35 of 120

1

Which three statements are true about the DESCRIBE command?

(Choose three).

Select one or more of the following:

It can be used to display the structure of an existing view.
It displays the NOT NULL constraint for any columns that have that constraint.
It displays all constraints that are defined for each column.
It displays the PRIMARY KEY constraint for any column or columns that have that constraint.
It can be used from SQL Developer.
It can be used only from SQL*Plus.

Explanation

Question 95 of 120 Question 36 of 120

1

Examine the description of the CUSTOMERS table:
Name Null? Type
-------------------------------------- ------------------- ------------
CUST_ID NOT NULL NUMBER
CUST_FIRST_NAME NOT NULL VARCHAR2(20)
CUST_LAST_NAME NOT NULL VARCHAR2(30)
CUST_INCOME_LEVEL VARCHAR2(30)
CUST_CREDIT_LIMIT NUMBER

For customers whose income level has a value, you want to display the first name and due amount as 5% of their credit limit. Customers whose due amount is null should not be displayed.

Which query should be used?

Select one of the following:

SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNT FROM customers WHERE cust_income_level != NULL AND due_amount != NULL;
SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNT FROM customers WHERE cust_income_level != NULL AND cust_credit_level !=NULL;
SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNT FROM customers WHERE cust_income_level <> NULL AND due_amount <> NULL;
SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNT FROM customers WHERE cust_income_level IS NOT NULL AND cust_credit_limit IS NOT NULL;
SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNT FROM customers WHERE cust_income_level IS NOT NULL AND due_amount IS NOT NULL;

Explanation

Question 96 of 120 Question 37 of 120

1

The INVOICE table has a QTY_SOLD column of data type NUMBER and an INVOICE_DATE column of data type DATE.
NLS_DATE_FORMAT is set to DD-MON-RR.

Which two are true about data type conversions involving these columns in query expressions?

(Choose two). ==> 3

Select one or more of the following:

CONCAT (qty_sold, invoice_date) : requires explicit conversion
invoice_date = '15-march-2019' : uses implicit conversion
qty_sold BETWEEN '101' AND '110' : uses implicit conversion
qty_sold = '0554982' uses implicit conversion
invoie_date > '01-02-2019' : uses implicit conversion

Explanation

Question 94 of 120 Question 38 of 120

1

Which three are types of segments in an Oracle Database?

(Choose three).

Select one or more of the following:

stored procedures
undo
tables
sequences
clusters
index

Explanation

Question 61 of 120 Question 39 of 120

1

Which two statements are true about the results of using the INTERSECT operator in compound queries?

(Choose two).

Select one or more of the following:

INTERSECT returns rows common to both sides of the compound query.
Reversing the order of the intersected tables can sometimes affect the output.
Column names in each SELECT in the compound query can be different.
INTERSECT ignores NULLs.
The number of columns in each SELECT in the compound query can be different.

Explanation

Question 101 of 120 Question 40 of 120

1

Which two statements are true about single row functions?

(Choose two).

Select one or more of the following:

CEIL : can be used for positive and negative numbers
CONCAT : can be used to combine any number of values
FLOOR : returns the smallest integer greater than or equal to a specified number
MOD : returns the quotient of a division operation
TRUNC : can be used with NUMBER and DATE values

Explanation

Question 13 of 120 Question 41 of 120

1

The EMPLOYEES table contains columns EMP_ID of data type NUMBER and HIRE_DATE of data type DATE.
You want to display the date of the first Monday after the completion of six months since hiring.
The NLS_TERRITORY parameter is set to AMERICA in the session and, therefore, Sunday is the first day on the week.

Which query can be used?

Select one of the following:

SELECT emp_id, NEXT_DAY(MONTHS_BETWEEN(hire_date, SYSDATE), 6) FROM employees;
SELECT emp_id, NEXT_DAY(ADD_MONTHS(hire_date, 6), 'MONDAY') FROM employees;
SELECT emp_id, NEXT_DAY(ADD_MONTHS(hire_date, 6), 1) FROM employees;
SELECT emp_id, ADD_MONTHS(hire_date, 6), NEXT_DAY('MONDAY') FROM employees;

Explanation

Question 42 of 120

1

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-03-06T12:15:17.183438+05:30 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).

Select one or more of the following:

Add a data file to DATA.
Drop other U1 objects in DATA.
Increase U1's quota sufficiently in DATA.
Set DEFERRED_SEGMENT_CREATION to TRUE.
Grant UNLIMITED TABLESPACE to U1.
Set AUTOEXTEND ON for data files in DATA.

Explanation

Question 43 of 120

1

Which three statements are true about the Oracle Data Dictionary?

(Choose three).

Select one or more of the following:

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

Explanation

Question 44 of 120

1

In one of your databases, the user HR has the password HRMGR.
You want to connect to a database instance whose listener listens on port 1531 by using this statement:

CONNECT HR/HRMGR@orcl -

No name server is used.

Which statement is true about ORCL?

Select one of the following:

It must be the value of the SERVICE_NAMES parameter on the client side.
It must resolve to a valid connect descriptor in the server's tnsnames.ora file
It must resolve to a valid connect descriptor in the client's tnsnames.ora file
It must be the name of the database to whose instance HR wishes to connect
It must be the name of the server running the database to whose instance HR wishes to connect

Explanation

Question 48 of 120 Question 45 of 120

1

Which two statements are true about views used for viewing tablespace and datafile information?

(Choose two).

Select one or more of the following:

V$TABLESPACE displays information about tablespaces contained in the data dictionary.
V$TABLESPACE displays information that is contained in the controlfile about tablespaces.
Tablespace free space can be viewed in DBA_TABLESPACES.
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.
Tablespace free space can be viewed in V$TABLESPACE.

Explanation

Question 10 of 120 Question 46 of 120

1

Examine the description of the PROMOTIONS table:
Name Null? Type
-----------------------------------------------------------------------
PROMO_ID NOT NULL NUMBER(6)
PROMO_NAME NOT NULL VARCHAR2(30)
PROMO_CATEGORY NOT NULL VARCHAR2(30)
PROMO_COST NOT NULL NUMBER(10,2)

You want to display the unique promotion costs in each promotion category.
Which two queries can be used?

(Choose two).

Select one or more of the following:

SELECT promo_cost, promo_category FROM promotions ORDER BY by 1;
SELECT promo_category, DISTINCT promo_cost FROM promotions ORDER BY 2;
SELECT DISTINCT promo_category || ' has ' || promo_cost AS COSTS FROM promotions ORDER BY 1;
SELECT DISTINCT promo_cost || ' in ' || DISTINCT promo_category FROM promotions ORDER BY 1;
SELECT DISTINCT promo_category, promo_cost FROM promotions ORDER BY 1;

Explanation

Question 87 of 120 Question 47 of 120

1

In the ORCL database, UNDOTBS1 is the active undo tablespace with these properties:
1. A size of 100 MB
2. AUTOEXTEND is off
3. UNDO_RETENTION is set to 15 minutes
4. It has RETENTION GUARANTEE

UNDOTBS1 fills with uncommitted undo 10 minutes after the database opens.

What will happen when the next update is attempted by any transaction?

Select one of the following:

It succeeds and the least recently written undo block of UNDOTBS1 is overwritten by the generated undo.
It succeeds and the least recently read undo block of UNDOTBS1 is overwritten by the generated undo.
It succeeds and the generated undo is stored in SYSTEM.
It succeeds and the generated undo is stored in SYSAUX.
It fails and returns the error message ג€ORA-30036: unable to extend segment by 8 in undo tablespace 'UNDOTBS1'ג€.

Explanation

Question 106 of 120 Question 48 of 120

1

Which two statements are true about the rules of precedence for operators?

(Choose two).

Select one or more of the following:

Arithmetic operators with equal precedence are evaluated from left to right within an expression.
The + binary operator has the highest precedence in an expression in a SQL statement.
NULLS influence the precedence of operators in an expression.
The concatenation operator | | is always evaluated before addition and subtraction in an expression.
Multiple parentheses can be used to override the default precedence of operators in an expression.

Explanation

Question 49 of 120

1

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:
SHOW PARAMETER OS_AUTHENT_PREFIX

NAME TYPE VALUE
--------------------------------------------------------
os_authent_prefix string

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

Select one of the following:

Set OS_AUTHENT_PREFIX to OPS$
Have the OS administrator add KING to the OSDBA group
Grant DBA to KING
Unset REMOTE_LOGIN_PASSWORDFILE
Alter user KING to be IDENTIFIED EXTERNALLY

Explanation

Question 85 of 120 Question 50 of 120

1

View the Exhibits and examine the structure of the COSTS and PROMOTIONS tables.

You want to display PROD_IDS whose promotion cost is less than the highest cost PROD_ID in a promotion time interval.

Examine this SQL statement:

SELECT prod_id
FROM costs
WHERE promo_id IN
(SELECT promo_id
FROM promotions
WHERE promo_cost < ALL
(SELECT MAX(promo_cost)
FROM promotions
GROUP BY (promo_end_date - promo_begin_date)));

What will be the result?

Select one of the following:

It gives an error because the ALL keyword is not valid.
It executes successfully but does not give the required result.
It gives an error because the GROUP BY clause is not valid.
It executes successfully and gives the required result.

Explanation

Question 8 of 120 Question 51 of 120

1

Which three statements are true about GLOBAL TEMPORARY TABLES?

(Choose three).

Select one or more of the following:

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

Explanation

Question 24 of 120 Question 52 of 120

1

Which two statements are true about trace files produced by the Oracle Database server?

(Choose two).

Select one or more of the following:

Trace files are written to the Fast Recovery Area (FRA).
All trace files contain error information that require contacting Oracle Support.
They can be written by server processes.
Trace file names are based on the database name concatenated with a sequential number.
They can be written by background processes.

Explanation

Question 46 of 120 Question 53 of 120

1

You need to calculate the number of days from 1 January 2019 until today.
Dates are stored in the default format of DD-MON-RR.

Which two queries give the required output?

(Choose two).

Select one or more of the following:

SELECT ROUND(SYSDATE - '01-JAN-2019') FROM DUAL;
SELECT TO_CHAR(SYSDATE, 'DD-MON-YYYY') - '01-JAN-2019' FROM DUAL;
SELECT ROUND(SYSDATE - TO_DATE('01/JANUARY/2019')) FROM DUAL;
SELECT SYSDATE - TO_DATE('01-JANUARY-2019') FROM DUAL;
SELECT TO_DATE(SYSDATE, 'DD/MONTH/YYYY') - '01/JANUARY/2019' FROM DUAL;

Explanation

Question 56 of 120 Question 54 of 120

1

Which two statements are true about the DUAL table?

(Choose two).

Select one or more of the following:

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

Explanation

Question 91 of 120 Question 55 of 120

1

Which four statements are true regarding primary and foreign key constraints and the effect they can have on table data?

(Choose four).

Select one or more of the following:

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.
The foreign key columns and parent table primary key columns must have the same names.
Only the primary key can be defined at the column and table level.
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.
A table can have only one primary key but multiple foreign keys.
A table can have only one primary key and one foreign key.
Primary key and foreign key constraints can be defined at both the column and table level.

Explanation

Question 58 of 120 Question 56 of 120

1

Examine the description of the EMPLOYEES table:
Name Null? Type
----------------------------------------------------
EMP_ID NOT NULL NUMBER
EMP_NAME VARCHAR2(40)
DEP_ID NUMBER(2)
SALARY NUMBER(8,2)
JOIN_DATE DATE

Which query is valid?

Select one of the following:

SELECT dept_id, join_date, SUM(salary) FROM employees GROUP BY dept_id, join_date;
SELECT dept_id, AVG(MAX(salary)) FROM employees GROUP BY dept_id;
SELECT dept_id, MAX(AVG(salary)) FROM employees GROUP BY dept_id;
SELECT dept_id, join_date, SUM(salary) FROM employees GROUP BY dept_id;

Explanation

Question 15 of 120 Question 57 of 120

1

What is true about non-equijoin statement performance?

(Choose two).

Select one or more of the following:

The join syntax used makes no difference to performance.
The Oracle join syntax performs better than the SQL:1999 compliant ANSI join syntax.
Table aliases can improve performance.
The BETWEEN condition always performs better than using the >= and <= conditions.
The BETWEEN condition always performs less well than using the >= and <= conditions.

Explanation

Question 38 of 120 Question 58 of 120

1

In your data center, Oracle Managed Files (OMF) is used for all databases. All tablespaces are smallfile tablespaces.
SALES_Q1 is a permanent user-defined tablespace in the SALES database.

Examine this command which is about to be issued by a DBA logged in to the SALES database:
ALTER TABLESPACE sales_q1 ADD DATAFILE;

Which are two actions, either one of which you could take to ensure that the command executes successfully?

(Choose two).

Select one or more of the following:

Add the AUTOEXTEND ON clause with NEXT set to 100M.
Ensure that DB_RECOVERY_FILE_DEST and DB_CREATE_FILE_DEST each specify locations with at least 50 Mb of available space.
Ensure that DB_CREATE_FILE_DEST specifies a location with at least 100 Mb of available space.
Specify a path in the DATAFILE clause of the command specifying a location with at least 100M of available space.
Ensure that DB_RECOVERY_FILE_DEST and DB_CREATE_FILE_DEST each specify with at least 50 Mb of available space.

Explanation

Question 117 of 120 Question 59 of 120

1

Examine this command and some partial output:
LSNRCTL> start LISTENER_1

Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=PROTOCOL=tcp) (HOST=host01.abc.com) (PORT=1562))
Services Summary...
Service "DB01.abc.com" has 1 instance(s).
Instance "DB01" status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully

Why does the DB01.abc.com service show unknown status?

Select one of the following:

The SID_LIST_LISTENER section is not contained in the LISTENER.ORA file
The LOCAL_LISTENER database parameter is not set to a service name that refers to LISTENER_1.
The service DB01.abc.com is statically registered.
The service DB01.abc.com is dynamically registered.
The listener is not listening on the default port 1521.

Explanation

Question 42 of 120 Question 60 of 120

1

Which three statements are true about the tools used to configure Oracle Net Services?

(Choose three).

Select one or more of the following:

Enterprise Manager Cloud Control can be used to centrally configure listeners on any managed database server.
The lsnrctl utility requires a listener.ora file to exist before it is started.
Enterprise Manager Cloud Control can be used to centrally configure net service names for any database server target
Oracle Net Manager can be used to locally configure naming methods on a database server.
Oracle Net Manager can be used to centrally configure listeners on any database server target.
The Oracle Net Configuration Assistant is only used when running the Oracle installer.

Explanation

Question 61 of 120

1

Which two statements are true regarding the UNION and UNION ALL operators?

(Choose two).

Select one or more of the following:

Duplicates are eliminated automatically by the UNION ALL operator.
The number of columns selected in each SELECT statement must be identical.
The names of columns selected in each SELECT statement must be identical.
The output is sorted by the UNION ALL operator.
NULLS are not ignored during duplicate checking

Explanation

Question 63 of 120 Question 62 of 120

1

Which two statements are true about the Automatic Diagnostic Repository (ADR)?

(Choose two).

Select one or more of the following:

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

Explanation

Question 69 of 120 Question 63 of 120

1

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).

Select one or more of the following:

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

Explanation

Question 54 of 120 Question 64 of 120

1

Which three statements are true about undo segments and the use of undo by transactions in an Oracle database instance?

(Choose three).

Select one or more of the following:

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

Explanation

Question 31 of 120 Question 65 of 120

1

Which two statements are true about Enterprise Manager Database Express?

(Choose two).

Select one or more of the following:

It is available only when the database is open.
The same port number can be used for Database Express configurations for databases on different hosts.
The same port number can be used for multiple Database Express configurations for multiple databases on the same host
It can be used to perform database recovery.
It can be used to switch a database into ARCHIVELOGMODE.

Explanation

Question 115 of 120 Question 66 of 120

1

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:
UPDATE employees
SET (job_id, salary) =
(SELECT job_id, salary
FROM employees
WHERE employee_id = 200)
WHERE employee_id = 100;

Which two statements are true?

(Choose two).

Select one or more of the following:

Employees 100 and 200 will have the same SALARY as before the update command.
Employee 200 will have JOB_ID set to the same value as the JOB_ID of employee 100.
Employee 100 will have SALARY set to the same value as the SALARY of employee 200.
Employee 200 will have SALARY set to the same value as the SALARY of employee 100.
Employee 100 will have JOB_ID set to the same value as the JOB_ID of employee 200.
Employees 100 and 200 will have the same JOB_ID as before the update command.

Explanation

Question 67 of 120

1

Which two are true about a SQL statement using SET operators such as UNION?

(Choose two).

Select one or more of the following:

The data type group of each column returned by the second query must match the data type of the corresponding column returned by the first query.
The number, but not names, of columns must be identical for all SELECT statements in the query.
The data type of each column returned by the second query must exactly match the data type of the corresponding column returned by the first query.
The names and number of columns must be identical for all SELECT statements in the query.
The data type of each column returned by the second query must be implicitly convertible to the data type of the corresponding column returned by the first query.

Explanation

Question 6 of 120 Question 68 of 120

1

Which three statements are true about time zones, date data types, and timestamp data types in an Oracle database?

(Choose three).

Select one or more of the following:

The CURRENT_TIMESTAMP function returns data without time zone information.
A TIMESTAMP WITH LOCAL TIMEZONE data type column is stored in the database using the time zone of the session that inserted the row.
A TIMESTAMP data type column contains information about year, month, and day.
The SESSIONTIMEZONE function can return an offset from Universal Coordinated Time (UTC)
The DBTIMEZONE function can return an offset from Universal Coordinated Time (UTC).

Explanation

Question 50 of 120 Question 69 of 120

1

Which three statements are true about inner and outer joins?

(Choose three).

Select one or more of the following:

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

Explanation

Question 72 of 120 Question 70 of 120

1

Examine this description of the TRANSACTIONS table:
Name Null? Type
-------------------------------------------------------------------------------
TRANSACTION_ID NOT NULL VARCHAR2(6)
TRANSACTION_DATE DATE
AMOUNT NUMBER(10,2)
CUSTOMER_ID VARCHAR2(6)

Which two SQL statements execute successfully?

(Choose two).

Select one or more of the following:

SELECT customer_id CUSTID, transaction_date TRANS_DATE, amount + 100 DUES FROM transactions;
SELECT customer_id AS "CUSTOMER-ID", transaction_date AS DATE, amount + 100 "DUES" FROM transactions;
SELECT customer_id AS 'CUSTOMER-ID', transaction_date AS DATE, amount + 100 'DUES AMOUNT' FROM transactions;
SELECT customer_id AS "CUSTOMER-ID", transaction_date AS "DATE", amount + 100 DUES FROM transactions;
SELECT customer_id AS CUSTOMER-ID, transaction_date AS TRANS_DATE, amount + 100 "DUES AMOUNT" FROM transactions;

Explanation

Question 30 of 120 Question 71 of 120

1

The CUSTOMERS table has a CUST_CREDIT_LIMIT column of data type NUMBER.
Which two queries execute successfully?

(Choose two).

Select one or more of the following:

SELECT NVL(cust_credit_limit * .15, 'Not Available') FROM customers;
SELECT NVL(TO_CHAR(cust_credit_limit * .15), 'Not Available') FROM customers;
SELECT NVL2(cust_credit_limit, TO_CHAR(cust_credit_limit * .15), 'Not Available') FROM customers;
SELECT TO_CHAR(NVL(cust_credit_limit * .15, 'Not Available')) FROM customers;
SELECT NVL2(cust_credit_limit * .15, 'Not Available') FROM customers;

Explanation

Question 45 of 120 Question 72 of 120

1

Which statement is true about aggregate functions?

Select one of the following:

Aggregate functions can be nested to any number of levels.
The MAX and MIN functions can be used on columns with character data types.
Aggregate functions can be used in any clause of a SELECT statement.
The AVG function implicitly converts NULLS to zero.

Explanation

Question 39 of 120 Question 73 of 120

1

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).

Select one or more of the following:

The alert log records the execution details.
The Oracle background processes are started.
The online redo logs are opened.
The online data files are opened.
The initialization parameter file is read.
The control file is read.

Explanation

Question 12 of 120 Question 74 of 120

1

Which two are true about shrinking a segment online?

(Choose two).

Select one or more of the following:

It is not possible to shrink either indexes or Index Organized Tables (IOTs).
To shrink a table it must have a UNIQUE KEY constraint.
It must be in a tablespace that uses Automatic Segment Space Management (ASSM)
To shrink a table it must have a PRIMARY KEY constraint.
To shrink a table it must have row movement enabled
It always eliminates all migrated rows if any exist in the table.

Explanation

Question 75 of 120

1

Examine these commands:
[oracle@host01 ~]$ sqlplus u1/oracle
SQL> SELECT * FROM emp;
ENO ENAME DN
--------------------------------
1 Alan 2
2 Ben 2

SQL> exit

[oracle@host01 ~] cat emp.dat
3,Culr,4
4,Bob,4

[oracle@host01 ~] sqlldr u01/oracle TABLE=emp

Which two statements are true about the sqlldr execution?

(Choose two).

Select one or more of the following:

It overwrites data in EMP with data in EMP.DAT
It uses the database buffer cache to load data.
It generates a log that contains control file entries, which can be used with normal SQL*Loader operations.
It generates a sql script that it uses to load data from EMP.DAT to EMP
It appends data from EMP.DAT to EMP

Explanation

Question 76 of 120

1

A script abc.sql must be executed to perform a job.

A database user HR, who is defined in this database, executes this command:
$ sqlplus hr/hr@orcl @abc.sql

What will happen upon execution?

Select one of the following:

The command succeeds and HR will be connected to the orcl and abc.sql databases.
The command succeeds and HR will be connected to the orcl database instance, and the abc.sql script will be executed.
The command fails because the script must refer to the full path name.
The command fails and reports an error because @ is used twice.

Explanation

Question 76 of 120 Question 77 of 120

1

Which three statements are true regarding indexes?

(Choose three).

Select one or more of the following:

A table belonging to one user can have an index that belongs to a different user.
An update to a table can result in no updates to any of the table's indexes.
An update to a table can result in updates to any or all of the table's indexes.
A SELECT statement can access one or more indices without accessing any tables.
A UNIQUE index can be altered to be non-unique.
When a table is dropped and is moved to the RECYCLE BIN, all indexes built on that table are permanently dropped.

Explanation

Question 104 of 120 Question 78 of 120

1

Which three statements are true about Oracle synonyms?

(Choose three).

Select one or more of the following:

A synonym cannot be created for a PL/SQL package.
A synonym can be available to all users.
Any user can drop a PUBLIC synonym
A synonym created by one user can refer to an object belonging to another user.
A SEQUENCE can have a synonym.

Explanation

Question 99 of 120 Question 79 of 120

1

View the Exhibit and examine the structure of the PRODUCTS table.
Which two tasks require subqueries?

(Choose two).

Select one or more of the following:

Display products whose PROD_MIN_PRICE is more than the average PROD_LIST_PRICE of all products, and whose status is orderable.
Display the number of products whose PROD_LIST_PRICE is more than the average PROD_LIST_PRICE.
Display suppliers whose PROD_LIST_PRICE is less than 1000.
Display the total number of products supplied by supplier 102 which have a product status of obsolete.
Display the minimum PROD_LIST_PRICE for each product status.

Explanation

Question 80 of 120

1

The SALES_Q1 and USERS tablespaces exist in one of your databases and TEMP is a temporary tablespace.
Segment creation is not deferred.

You execute this command:
CREATE USER sales
IDENTIFIED BY sales_123
DEFAULT TABLESPACE sales_q1
TEMPORARY TABLESPACE temp
QUOTA 5M ON users;

Which three statements must be true so that the SALES user can create tables in SALES_Q1?

(Choose three).

Select one or more of the following:

The sales user must have a quota on the TEMP tablespace.
The sales user must have a quota on the SALES_Q1 tablespace to hold the initial extends of all tables they plan to create in their schema.
The sales user must have been granted the CREATE SESSION privilege.
The sales user must have their quota on the users tablespace removed.
The sales user must have a quota on the SALES_Q1 tablespace to hold all the rows to be inserted into any table in their schema.
The sales user must have been granted the CREATE TABLE privilege.

Explanation

Question 81 of 120

1

Which three statements are true about table data storage in an Oracle Database?

(Choose three).

Select one or more of the following:

Data block headers contain their own Data Block Address (DBA).
A table row piece can be chained across several database blocks.
Multiple row pieces from the same row may be stored in different database blocks.
Multiple row pieces from the same row may be stored in the same block.
Data block free space is always contiguous in the middle of the block.
Index block free space is always contiguous in the middle of the block

Explanation

Question 82 of 120

1

Examine the description of the BOOKS table:
Name Null? Type
----------------------------------------------------------------------
TRANSACTION_ID NOT NULL VARCHAR2(6)
TRANSACTION_DATE DATE
AMOUNT NUMBER(10,2)
CUSTOMER_ID VARCHAR2(6)

The table has 100 rows.

Examine this sequence of statements issued in a new session:
INSERT INTO books VALUES ('ADV112', 'Adventures of Tom Sawyer', NULL, NULL);
SAVEPOINT a;
DELETE FROM books;
ROLLBACK TO SAVEPOINT a;
ROLLBACK;

Which two statements are true?

(Choose two).

Select one or more of the following:

The second ROLLBACK command does nothing.
The second ROLLBACK command replays the delete.
The first ROLLBACK command restores the 101 rows that were deleted, leaving the inserted row still to be committed.
The second ROLLBACK command undoes the insert.
The first ROLLBACK command restores the 101 rows that were deleted and commits the inserted row

Explanation

Question 83 of 120

1

Which three statements are true about external tables in Oracle 18c and later releases?

(Choose three).

Select one or more of the following:

External table files can be used for other external tables in a different database.
The ORACLE_LOADER access driver can be used to unload data from a database into an external table.
The ORACLE_DATAPUMP access driver can be used to unload data from a database into an external table.
They cannot be partitioned.
The ORACLE_DATAPUMP access driver can be used to load data into a database from an external table.
They support UPDATEs but not INSERTs and DELETEs

Explanation

Question 84 of 120

1

Which three statements are true about the Oracle join and ANSI join syntax?

(Choose three).

Select one or more of the following:

The Oracle join syntax supports creation of a Cartesian product of two tables.
The Oracle join syntax performs better than the SQL:1999 compliant ANSI join syntax.
The SQL:1999 compliant ANSI join syntax supports natural joins.
The SQL:1999 compliant ANSI join syntax supports creation of a Cartesian product of two tables.
The Oracle join syntax only supports right outer joins.
The Oracle join syntax supports natural joins.
The Oracle join syntax performs less well than the SQL:1999 compliant ANSI join syntax

Explanation

Question 47 of 120 Question 85 of 120

1

Which two tasks can you perform using DBCA for databases?

(Choose two).

Select one or more of the following:

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

Explanation

Question 79 of 120 Question 86 of 120

1

You execute this query:
SELECT TO_CHAR(NEXT_DAY(LAST_DAY(SYSDATE), 'MON'), 'dd "Monday for" fmMonth rrrr') FROM DUAL;

What is the result?

Select one of the following:

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

Explanation

Question 7 of 120 Question 87 of 120

1

Examine this command:
CREATE UNDO TABLESPACE undotbs01 DATAFILE 'undotbs_01.dbf'
SIZE 100M AUTOEXTEND ON;

Which two actions must you take to ensure UNDOTBS01 is used as the default UNDO tablespace?

(Choose two).

Select one or more of the following:

Make certain that the database operates in automatic undo management mode.
Set UNDO_TABLESPACE to UNDOTBS01.
Add the NOLOGGING clause.
Add the ONLINE clause
Add the SEGMENT SPACE MANAGEMENT AUTO clause.

Explanation

Question 28 of 120 Question 88 of 120

1

Which three statements are true about views in an Oracle database?

(Choose three).

Select one or more of the following:

Data Manipulation Language (DML) can always be used on views.
The WITH CHECK clause prevents certain rows from being displayed when querying the view.
Tables in the defining query of a view must always exist in order to create the view.
Views can be updated without the need to re-grant privileges on the view.
The WITH CHECK clause prevents certain rows from being updated or inserted
Deleting one or more rows using a view whose defining query contains a GROUP BY clause will cause an error.
Inserting one or more rows using a view whose defining query contains a GROUP BY clause will cause an error.

Explanation

Question 89 of 120

1

You execute this command:
CREATE SMALLFILE TABLESPACE sales DATAFILE '/u01/app/oracle/sales01.dbf
SIZE 5G SEGMENT SPACE MANAGEMENT AUTO;

Which two statements are true about the SALES tablespace?

(Choose two).

Select one or more of the following:

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

Explanation

Question 90 of 120

1

In the SALES database, DEFERRED_SEGMENT_CREATION is TRUE.
Examine this command:
SQL> CREATE TABLE T1(c1 INT PRIMARY KEY, c2 CLOB);

Which segment or segments, if any, are created as a result of executing the command?

Select one of the following:

T1, an index segment for the primary key, a LOB segment, and a lobindex segment.
No segments are created
T1 only
T1 and an index segment created for the primary key only
T1, an index segment for the primary key, and a LOB segment only

Explanation

Question 73 of 120 Question 91 of 120

1

Which three activities are recorded in the database alert log?

(Choose three).

Select one or more of the following:

Data Definition Language (DDL) statements
Block corruption errors
Non-default database parameters
Deadlock errors
Session logins and logouts

Explanation

Question 93 of 120 Question 92 of 120

1

Which two statements are true about Enterprise Manager (EM) Express?

Select one or more of the following:

You can shut down a database instance using EM Express.
You cannot start up a database instance using EM Express.
You can use a single instance of EM Express to manage multiple database running on the same server.
EM Express uses a separate repository database to store target database metadata.
By default, EM express is available for a database after database creation using DBCA.

Explanation

Question 71 of 120 Question 93 of 120

1

Examine this SQL statement:
SELECT cust_id, cust_last_name "Last Name"
FROM customers
WHERE country_id = 10
UNION
SELECT cust_id CUST_NO, cust_last_name
FROM customers
WHERE country_id = 30

Identify three ORDER BY clauses, any one of which can complete the query successfully.

(Choose three).

Select one or more of the following:

ORDER BY CUST_NO
ORDER BY 2, 1
ORDER BY "CUST_NO"
ORDER BY 2, cust_id
ORDER BY "Last Name"

Explanation

Question 94 of 120

1

Which two statements are true about the configuration and use of UNDO_RETENTION with GURANTEED RETENTION?

(Choose two).

Select one or more of the following:

UNDO_RETENTION specifies for how long Oracle attempts to keep expired and unexpired UNDO.
UNDO_RETENTION specifies how long all types of UNDO are retained.
Unexpired UNDO is always retained.
Active UNDO is always retained.
UNDO_RETENTION specifies for how long Oracle attempts to keep unexpired UNDO.

Explanation

Question 75 of 120 Question 95 of 120

1

Table ORDER_ITEMS contains columns ORDER_ID, UNIT_PRICE and QUANTITY, of data type NUMBER.
Examine these SQL statements:

Statement 1:
SELECT MAX(unit_price * quantity) 'Maximum Order' FROM order_items;

Statement 2:
SELECT MAX(unit_price * quantity) 'Maximum Order' FROM order_items GROUP BY order_id;

Which two statements are true?

Select one or more of the following:

Statement 1 returns only one row of output.
Both statements will return NULL if either UNIT_PRICE or QUANTITY contains NULL.
Statement 2 may return multiple rows of output.
Both the statements give the same output.
Statement 2 returns only one row of output.

Explanation

Question 96 of 120

1

Which three files are used by conventional path SQL*Loader when the TABLE option is not specified?

(Choose three).

Select one or more of the following:

Dump files
Control files
Password files
Bad files
Input files

Explanation

Question 59 of 120 Question 97 of 120

1

Which three statements are true about the naming methods and their features supported by Oracle database used to resolve connection information?

(Choose three).

Select one or more of the following:

Directory Naming requires setting the TNS_ADMIN environment variable on the client side.
A client can connect to an Oracle database instance even if no client side network admin has been configured.
Local naming can be used if Connect-Time Failover is required.
Local Naming requires setting the TNS_ADMIN environment variable on the client side.
Easy Connect supports TCP/IP and SSL.
Directory Naming can be used if Connect-Time Failover is required.

Explanation

Question 98 of 120

1

Which two statements are true about User Authentication in an Oracle Database?

(Choose two).

Select one or more of the following:

Password authentication must be used for system-privileged administrative users.
Password File authentication must be used for system-privileged administrative users.
Operating System authentication may be used for system-privileged administrative users.
Password File authentication is supported for any type of database user.
REMOTE_LOGIN_PASSWORDFILE must be set to exclusive to permit password changes for system-privileged administrative users.

Explanation

Question 92 of 120 Question 99 of 120

1

Which is the default column or columns for sorting output from compound queries using SET operators such as INTERSECT in a SQL statement?

Select one of the following:

The first VARCHAR2 column in the first SELECT of the compound query.
The first NUMBER or VARCHAR2 column in the last SELECT of the compound query.
The first column in the last SELECT of the compound query.
The first NUMBER column in the first SELECT of the compound query.
The first column in the first SELECT of the compound query.

Explanation

Question 11 of 120 Question 100 of 120

1

Examine the description of the PRODUCT_STATUS table:
Name Null? Type
-----------------------------------------------------------
PROD_ID NOT NULL VARCHAR2(6)
STATUS NOT NULL DATE

The STATUS column contains the values 'IN STOCK' or 'OUT OF STOCK' for each row.

Which two queries will execute successfully?

(Choose two).

Select one or more of the following:

SELECT prod_id || q'('s not available)' 'CURRENT AVAILABILITY'
FROM product_status WHERE status = 'OUT OF STOCK';
SELECT prod_id || q'('s not available)' "CURRENT AVAILABILITY"
FROM product_status WHERE status = 'OUT OF STOCK';
SELECT prod_id q's not available"
FROM product_status WHERE status = 'OUT OF STOCK';
SELECT prod_id || q"'s not available"
FROM product_status WHERE status = 'OUT OF STOCK';
SELECT prod_id "CURRENT AVAILABILITY" || q'('s not available)'
FROM product_status WHERE status = 'OUT OF STOCK';
SELECT prod_id || q'('s not available)'
FROM product_status WHERE status = 'OUT OF STOCK';

Explanation

Question 77 of 120 Question 101 of 120

1

Which two statements are true about UNDO and UNDO tablespaces?

(Choose two).

Select one or more of the following:

An UNDO tablespace may be owned by only one instance.
There can be only one UNDO tablespace created in a database.
An instance will crash if the active undo tablespace is lost.
UNDO segments are owned by SYSBACKUP.
UNDO segments are owned by SYSTEM.

Explanation

Question 51 of 120 Question 102 of 120

1

You must create a tablespace of non-standard block size in a new file system and plan to use this command:
CREATE TABLESPACE ns_tbs
DATAFILE '/u02/oracle/data/nstbs_f01.dbf'
SIZE 100G
BLOCKSIZE 32K;

The standard block size is 8k but other non-standard block sizes will also be used.

Which two are requirements for this command to succeed?
(Choose two).

Select one or more of the following:

The /u02 file system must have at least 100g space for the datafile.
DB_32K_CACHE_SIZE must be set to a value that can be accommodated in the SGA.
DB_32K_CACHE_SIZE must be less than DB_CACHE_SIZE.
DB_32K_CACHE_SIZE should be set to a value greater than DB_CACHE_SIZE.
The operating system must use a 32k block size.
DB_CACHE_SIZE must be set to a size that is smaller than DB_32K_CACHE_SIZE.

Explanation

Question 29 of 120 Question 103 of 120

1

Examine the description of the PRODUCTS table:
Name Null? Type
------------------------------------------------------------------------
PROD_ID NOT NULL NUMBER
PROD_NAME VARCHAR2(40)
COST NUMBER(8,2)
RELEASE_DATE DATE

Which query is valid?

Select one of the following:

SELECT prod_id, release_date, SUM(cost) FROM products GROUP BY prod_id;
SELECT prod_id, AVG(MAX(cost)) FROM products GROUP BY prod_id;
SELECT prod_id, release_date, SUM(cost) FROM products GROUP BY prod_id, release_date;
SELECT prod_id, MAX(AVG(cost)) FROM products GROUP BY prod_id;

Explanation

Question 43 of 120 Question 104 of 120

1

Which two statements are true about the Oracle Data Dictionary?

(Choose two).

Select one or more of the following:

All data dictionary view join base tables to dynamic performance views.
Data dictionary base tables can be queried directly.
Data dictionary views are always created with queries that join two or more base tables.
It is owned by the SYSTEM user.
It is owned by the SYS user.

Explanation

Question 111 of 120 Question 105 of 120

1

Which two Oracle database space management features require the use of locally managed tablespaces?

(Choose two).

Select one or more of the following:

Oracle Managed Files (OMF)
Server-generated tablespace space alerts.
Free space management with bitmaps.
Automatic data file extension (AUTOEXTEND).
Online segment shrink.

Explanation

Question 84 of 120 Question 106 of 120

1

Which three statements are true about connection strings and service names used to connect to an Oracle database instance?

(Choose three).

Select one or more of the following:

Different connection strings in the same tnsnames.ora file can contain the same service name, host and port parameters.
A connection string including a service name must be defined in the tnsnames.ora file.
A single connection string can refer to multiple database instances.
A single database instance can support connections for multiple service names.
A connection string must include the SID of a database instance.
A service name is created by a listener.

Explanation

Question 112 of 120 Question 107 of 120

1

Which three statements are true about using SQL*Plus?

(Choose three).

Select one or more of the following:

It can run scripts entered at the SQL prompt.
It can run scripts passed to it by a shell script.
It has its own commands that are separate from any SQL statements.
It must be downloaded from the Oracle Technology Network (OTN).
It has both command-line and graphical user interfaces (GUI).
It can run Recovery Manager (RMAN) commands.

Explanation

Question 64 of 120 Question 108 of 120

1

The orders table has a column ORDER_DATE of data type DATE.
The default display format for a date is DD-MON-RR.

Which two WHERE conditions demonstrate the correct usage of conversion functions?

(Choose two).

Select one or more of the following:

WHERE order_date > TO_DATE(ADD_MONTHS(SYSDATE, 6), 'MON DD YYYY')
WHERE order_date IN (TO_DATE('Oct 21 2018', 'Mon DD YYYY'), TO_CHAR('Nov 21 2018', 'Mon DD YYYY'))
WHERE TO_CHAR(order date, 'MON DD YYYY') = 'JAN 20 2019'
WHERE order_date > TO DATE('JUL 10 2018', 'MON DD YYYY')
WHERE order_date > TO_CHAR(ADD_MONTHS(SYSDATE, 6), 'MON DD YYYY')

Explanation

Question 23 of 120 Question 109 of 120

1

Which three statements are true about the Automatic Diagnostic Repository (ADR)?

(Choose three).

Select one or more of the following:

It is held inside an Oracle database schema.
It is a file-based repository held outside any database.
The ADR base is specified in the DIAGNIOSTIC_DEST database parameter.
It can be used for problem diagnosis of a database when that database's instance is down.
It is only used for Oracle Database diagnostic information.

Explanation

Question 37 of 120 Question 110 of 120

1

Which two statements are true about a self join?

(Choose two).

Select one or more of the following:

It can be an inner join.
The join key column must have an index.
It must be a full outer join.
It must be an equijoin.
It can be a left outer join.

Explanation

Question 22 of 120 Question 111 of 120

1

Which statement is true about database links?

Select one of the following:

A public database link can be used by a user connected to the local database instance to connect to any schema in the remote database instance.
A database link created in a database allows a connection from that database's instance to the target database's instance, but not vice versa.
Private database link creation requires the same user to exist in both the local and the remote databases.
A database link can be created only between two Oracle databases.
A public database link can be created only by SYS.

Explanation

Question 36 of 120 Question 112 of 120

1

Which two queries execute successfully?

(Choose two).

Select one or more of the following:

SELECT NULLIF(100, 100) FROM DUAL;
SELECT NULLIF(NULL, 100) FROM DUAL;
SELECT COALESCE(100, 'A') FROM DUAL;
SELECT NULLIF(100, 'A') FROM DUAL;
SELECT COALESCE(100, NULL, 200) FROM DUAL;

Explanation

Question 60 of 120 Question 113 of 120

1

Which three statements are true about data block storage in an Oracle Database?

(Choose three).

Select one or more of the following:

An index block can contain row data.
Row data is stored starting at the end of the block.
A table block must always contain row data.
A data block header is of a fixed length.
A block header contains a row directory pointing to all rows in the block.

Explanation

Question 107 of 120 Question 114 of 120

1

Which two are benefits of external tables?

(Choose two).

Select one or more of the following:

They can be queried, transformed, and joined with other tables without having to load the data first.
The results of a complex join or aggregating function or both can be unloaded to a file for transportation to another database.
They support DELETES which transparently deletes records in the file system as if they were table rows.
They support UPDATES which transparently updates records in the file system as if they were table rows.
They can be queried while the database is in the MOUNT state like dynamic performance views.

Explanation

Question 35 of 120 Question 115 of 120

1

Examine the description of the MEMBERS table:
Name Null? Type
----------------------------------------------------
MEMBER_ID NOT NULL VARCHAR2(6)
FIRST_NAME VARCHAR2(50)
LAST_NAME NOT NULL VARCHAR2(50)
ADDRESS VARCHAR2(50)
CITY VARCHAR2(25)

Examine the partial query:
SELECT city, last_name LNAME FROM members ...;

You want to display all cities that contain the string an. The cities must be returned in ascending order, with the last names further sorted in descending order.

Which two clauses must you add to the query?

(Choose two).

Select one or more of the following:

WHERE city IN ('%AN%')
WHERE city = '%AN%'
ORDER BY 1, LNAME DESC
ORDER BY last_name DESC, city ASC
ORDER BY 1, 2
WHERE city LIKE '%AN%'

Explanation

Question 4 of 120 Question 116 of 120

1

Which three statements are true about sequences in a single instance Oracle database?

(Choose three).

Select one or more of the following:

A sequence can issue duplicate values.
A sequence can only be dropped by a DBA.
Sequences can always have gaps.
Two or more tables cannot have keys generated from the same sequence.
A sequence number that was allocated can be rolled back if a transaction fails.
A sequence's unallocated cached values are lost if the instance shuts down.

Explanation

Question 117 of 120

1

Your database instance is started with an SPFILE.
A PFILE is also available.

You execute this command:
ALTER SYSTEM SET DB_CACHE_SIZE=100K;

Where is the value changed?

Select one of the following:

In the SPFILE, PFILE, and memory
In the SPFILE and in memory
Only in the SPFILE
Only in memory
In the SPFILE and PFILE

Explanation

Question 40 of 120 Question 118 of 120

1

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 two are types of analyses can be done using the DBMS_PRIVILEGE_CAPTURE package?

(Choose two).

Select one or more of the following:

Analysis of privileges granted directly to a role that are then used by a user who has been granted that role.
Analysis of privileges that a user has on their own schema objects.
Analysis of privileges that a user has on other schema’s objects.
Analysis of privileges granted indirectly to a role that are then used by a user who has been granted that role.
Analysis of all privileges used by the sys user.

Explanation

Question 98 of 120 Question 119 of 120

1

Examine the description of the SALES table:
Name Null? Type
--------------------------------------------------------------
PRODUCT_ID NOT NULL NUMBER(10)
CUSTOMER_ID NOT NULL NUMBER(10)
TIME_ID NOT NULL DATE
CHANNEL_ID NOT NULL NUMBER(5)
PROMO_ID NOT NULL NUMBER(5)
QUANTITY_SOLD NOT NULL NUMBER(10,2)
PRICE NUMBER(10,2)
AMOUNT_SOLD NOT NULL NUMBER(10,2)

The SALES table has 55,000 rows.

Examine this statement:
CREATE TABLE sales1 (prod_id, cust_id, quantity_sold, price)
AS
SELECT product_id, customer_id, quantity_sold, price
FROM sales
WHERE 1 = 1;

Which two statements are true?

(Choose two).

Select one or more of the following:

SALES1 is created with no rows.
SALES1 is created with 55,000 rows.
SALES1 is created with l row.
SALES1 has primary KEY and UNIQUE constraints on any selected columns which had those constraints in the SALES table.
SALES1 has NOT NULL constraints on any selected columns which had those constraints in the SALES table.

Explanation

Question 120 of 120 Question 120 of 120

1

Which three statements are true about performing Data Manipulation Language (DML) operations on a view with no INSTEAD OF triggers defined?

(Choose three).

Select one or more of the following:

Views cannot be used to add rows to an underlying table if the table has columns with NOT NULL constraints lacking default values which are not referenced in the defining query of the view.
Insert statements can always be done on a table through a view.
Views cannot be used to query rows from an underlying table if the table has a PRIMARY KEY and the PRIMARY KEY columns are not referenced in the defining query of the view.
The WITH CHECK clause has no effect when deleting rows from the underlying table through the view.
Delete statements can always be done on a table through a view.
Views cannot be used to add or modify rows in an underlying table if the defining query of the view contains the DISTINCT keyword.

Explanation

Question 114 of 120 Question 121 of 120

1

Which three statements are true about indexes and their administration in an Oracle database?

(Choose three).

Select one or more of the following:

An index can be created as part of a CREATE TABLE statement.
If a query filters on an indexed column, then it will always be used during execution of the query.
An INVINSIBLE INDEX is not maintained when Data Manipulation Language (DML) is performed on its underlying table.
A DROP INDEX statement always prevents updates to the table during the drop operation.
A descending index is a type of function-based index.
A UNIQUE and non-unique index can be created on the same table column.

Explanation

Question 16 of 120 Question 122 of 120

1

Which three actions are ways to apply the principle of least privilege?

(Choose three).

Select one or more of the following:

Revoking execute privilege on UTL_SMTP, UTL_TCP, UTL_HTTP, and UTL_FILE from the public user
Setting the O7_DICTIONARY_ACCESSIBILITY parameter to true.
Setting the REMOTE_OS_AUTHENT parameter to true.
Using Access Control Lists (ACLs).
Enabling Unified Auditing.
Revoking execute privilege on UTL_SMTP, UTL_TCP, UTL_HTTP, and UTL_FILE from the SYSTEM user,

Explanation

Question 27 of 120 Question 123 of 120

1

The STORES table has a column START_DATE of data type DATE, containing the date the row was inserted.
You only want to display details of rows where START_DATE is within the last 25 months.

Which WHERE clause can be used?

Select one of the following:

WHERE MONTHS_BETWEEN(SYSDATE, start_date) <=25
WHERE ADD_MONTHS(start_date, 25) <= SYSDATE
WHERE TO_NUMBER(start date - SYSDATE) <= 25
WHERE MONTHS_BETWEEN(start_date, SYSDATE) <= 25

Explanation

Question 102 of 120 Question 124 of 120

1

Examine the description of the BOOKS_TRANSACTIONS table:
Name Null? Type
-------------------------------------------------------------------------
TRANSACTION_ID NOT NULL VARCHAR2(6)
TRANSACTION_TYPE VARCHAR2(3)
BORROWED_DATE DATE
BOOK_ID VARCHAR2(6)
MEMBER_ID VARCHAR2(6)

Examine this partial SQL statement:
SELECT * FROM books_transactions

Which two WHERE conditions give the same result?

(Choose two).

Select one or more of the following:

WHERE borrowed_date = SYSDATE AND (transaction_type = 'RM' OR member_id IN ('A101', 'A102'));
WHERE borrowed_date = SYSDATE AND (transaction_type = 'RM' AND (member_id = 'A101' OR member_id = 'A102'));
WHERE borrowed_date = SYSDATE AND (transaction_type = 'RM' AND member_id = 'A101' OR member_id = 'A102');
WHERE (borrowed_date = SYSDATE AND transaction_type - 'RM') OR member_id IN ('A101', VA102');
WHERE borrowed_date = SYSDATE AND transaction_type = 'RM' OR member_id IN ('A101', 'A102');

Explanation

Question 118 of 120 Question 125 of 120

1

Which two statements are true about views?

(Choose two).

Select one or more of the following:

Views can be indexed.
Views can be updated without the need to re-grant privileges on the view.
The WITH CHECK clause prevents certain rows from being updated or inserted in the underlying table through the view.
The WITH CHECK clause prevents certain rows from being displayed when querying the view.
A view must only refer to tables in its defining query.

Explanation

Question 126 of 120

1

Which compression method is recommended for Direct-Path Insert operations?

Select one of the following:

ROW STORE COMPRESS BASIC
ROW STORE COMPRESS ADVANCED
COLUMN STORE COMPRESS ADVANCED
COLUMN STORE COMPRESS BASIC

Explanation

Question 113 of 120 Question 127 of 120

1

Which three statements are true about Deferred Segment Creation in Oracle databases?

(Choose three).

Select one or more of the following:

Indexes inherit the DEFERRED to IMMEDIATE segment creation attribute from their parent table
It is the default behavior for tables and indexes.
It is supported for Index Organized Tables (IOTs) contained in locally managed tablespaces.
Sessions may dynamically switch back and forth from DEFERRED to IMMEDIATE segment creation.
It is supported for SYS-owned tables contained in locally managed tablespaces.

Explanation

Question 53 of 120 Question 128 of 120

1

Examine these statements executed in a single Oracle session:
CREATE TABLE product (pcode NUMBER(2), pname VARCHAR2(20));

INSERT INTO product VALUES(1,'pen');
INSERT INTO product VALUES(2,'pencil');
INSERT INTO product VALUES(3,'fountain pen');

SAVEPOINT a;

UPDATE product SET pcode = 10 WHERE pcode = 1;

COMMIT;

DELETE FROM product WHERE pcode = 2;

SAVEPOINT b;

UPDATE product SET pcode = 30 WHERE pcode = 3;

SAVEPOINT c;

DELETE FROM product WHERE pcode = 10;

ROLLBACK TO SAVEPOINT b;

COMMIT;

Which three statements are true?

(Choose three).

Select one or more of the following:

There is no row containing pen.
There is no row containing fountain pen.
The code for pen is 1.
The code for fountain pen is 3.
The code for pen is 10.
There is no row containing pencil.

Explanation

Question 105 of 120 Question 129 of 120

1

Examine the description of the SALES1 table:
Name Null? Type
----------------------------------------------------
SALES_ID NOT NULL NUMBER
STORE_ID NOT NULL NUMBER
ITEMS_ID NUMBER
QUANTITY NUMBER
SALES_DATE DATE

SALES2 is a table with the same description as SALES1.

Some sales data is contained erroneously in both tables.

You must display rows from SALES1 and SALES2 and wish to see the duplicates too.

Which set operator generates the required output?

Select one of the following:

SUBTRACT
UNION
MINUS
UNION ALL
INTERSECT

Explanation

Question 86 of 120 Question 130 of 120

1

In the promotions table, the PROMO_BEGIN_DATE column is of data type DATE and the default date format is DD-MON-RR.

Which two statements are true about expressions using PROMO_BEGIN_DATE contained in a query?

(Choose two).

Select one or more of the following:

TO_NUMBER(PROMO_BEGIN_DATE) - 5 will return a number.
PROMO_BEGIN_DATE - 5 will return a date.
PROMO_BEGIN_DATE - SYSDATE will return a number.
TO_DATE(PROMO_BEGIN_DATE * 5) will return a date.
PROMO_BEGIN_DATE - SYSDATE will return an error.

Explanation

Question 131 of 120

1

Which two statements are true regarding indexes?

(Choose two).

Select one or more of the following:

A non-unique index can be altered to be unique.
An update to a table can result in no updates to any of the table's indexes.
The RECYCLE BIN never contains indexes.
An update to a table can result in updates to any or all of the table's indexes.
A table belonging to one user cannot have an index that belongs to a different user.

Explanation

Question 119 of 120 Question 132 of 120

1

Which three statements are true regarding single row subqueries?

(Choose three).

Select one or more of the following:

They must be placed on the right side of the comparison operator or condition.
A SQL statement may have multiple single row subquery blocks.
They must return a row to prevent errors in the SQL statement.
They must be placed on the left side of the comparison operator or condition.
They can be used in the HAVING clause.
They can be used in the WHERE clause.

Explanation

Question 81 of 120 Question 133 of 120

1

Which two statements are true about Oracle synonyms?

(Choose two).

Select one or more of the following:

A synonym can be created on an object in a package.
Any user can create a public synonym.
A synonym has an object number.
All private synonym names must be unique in the database.
A synonym can have a synonym.

Explanation

Question 78 of 120 Question 134 of 120

1

Examine this command:
SQL> ALTER TABLE ORDERS SHRINK SPACE COMPACT

Which two statements are true?

(Choose two).

Select one or more of the following:

Only queries are allowed on ORDERS while the shrink is executing.
The high-water mark (HWM) of ORDERS is adjusted.
The SHRINK operation causes rows to be moved to empty space starting toward the end of the ORDERS segment.
The SHRINK operation causes rows to be moved to empty space starting from the beginning of the ORDERS segment.
Queries and DML statements are allowed on ORDERS while the SHRINK is executing.
Dependent indexes become UNUSABLE.

Explanation

Question 135 of 120

1

The sales table has columns PROD_ID and QUANTITY_SOLD of data type number.

Which two queries execute successfully?

(Choose two).

Select one or more of the following:

SELECT COUNT(prod_id) FROM sales WHERE quantity_sold > 55000 GROUP BY prod_id;
SELECT COUNT(prod_id) FROM sales GROUP BY prod_id WHERE quantity_sold > 55000;
SELECT prod_id FROM sales WHERE quantity_sold > 55000 AND COUNT(*) > 10 GROUP BY COUNT(*) > 10;
SELECT prod_id FROM sales WHERE quantity_sold > 55000 GROUP BY proa_id HAVING COUNT(*) > 10;
SELECT prcd_id FROM sales WHERE quantity_sold > 55000 AND COUNT (*) > 10 GROUP BY prod_id HAVING COUNT(*) > 10;

Explanation

Question 89 of 120 Question 136 of 120

1

Examine the description of the PRODUCT_DETAILS table:
Name Null? Type
-------------------------------------------------------------------------
PRODUCT_ID NOT NULL NUMBER(2)
PRODUCT_NAME NOT NULL VARCHAR2(25)
PRODUCT_PRICE NUMBER(8,2)
EXPIRY_DATE DATE

Which two statements are true?

(Choose two).

Select one or more of the following:

PRODUCT_ID can be assigned the PRIMARY KEY constraint.
EXPIRY_DATE contains the SYSDATE by default if no date is assigned to it.
PRODUCT_PRICE contains the value zero by default if no value is assigned to it.
PRODUCT_PRICE can be used in an arithmetic expression even if it has no value stored in it.
PRODUCT_NAME cannot contain duplicate values.
EXPIRY_DATE cannot be used in arithmetic expressions.

Explanation

Question 83 of 120 Question 137 of 120

1

Which two statements are true about INTERVAL data types?

(Choose two).

Select one or more of the following:

INTERVAL DAY TO SECOND columns support fractions of seconds.
INTERVAL YEAR TO MONTH columns only support monthly intervals within a range of years.
INTERVAL YEAR TO MONTH columns only support monthly intervals within a single year.
INTERVAL YEAR TO MONTH support yearly intervals.
The value in an INTERVAL DAY TO SECOND column can be copied into an INTERVAL YEAR TO MONTH column.
The YEAR field in an INTERVAL YEAR TO MONTH column must be a positive value.

Explanation

Question 33 of 120 Question 138 of 120

1

Examine the description of the EMPLOYEES table:
Name Null? Type
----------------------------------------------------
EMP_ID NOT NULL NUMBER
EMP_NAME VARCHAR2(10)
DEPT_ID NUMBER(2)
SALARY NUMBER(8,2)
JOIN_DATE DATE

NLS_DATE_FORMAT is set to DD-MON-YY.

Which query requires explicit data type conversion?

Select one of the following:

SELECT join_date FROM employees WHERE join_date > '10-02-2018';
SELECT join_date + '20' FROM employees;
SELECT SUBSTR(join_date, 1, 2) - 10 FROM employees;
SELECT salary + '120.50' FROM employees;
SELECT join_date || ' ' || salary FROM employees;

Explanation

Question 32 of 120 Question 139 of 120

1

You start your database instance in NOMOUNT state.

Which two actions are performed?
(Choose two).

Select one or more of the following:

SYS can access the database.
The control files are opened.
All required background processes are started.
Memory is allocated for the SGA.
The consistency of the database is checked.

Explanation

Question 80 of 120 Question 140 of 120

1

Which two statements are true about the PMON background process?

(Choose two).

Select one or more of the following:

It registers database services with all local and remote listeners known to the database instance.
It rolls back transactions when a process fails.
It frees resources held by abnormally terminated processes.
It frees unused temporary segments.
It records checkpoint information in the control file.

Explanation

Question 20 of 120 Question 141 of 120

1

Which two statements are true about the Oracle join and ANSI join syntax?

(Choose two).

Select one or more of the following:

The Oracle join syntax supports creation of a Cartesian product of two tables.
The SQL:1999 compliant ANSI join syntax supports creation of a Cartesian product of two tables.
The Oracle join syntax performs better than the SQL:1999 compliant ANSI join syntax.
The Oracle join syntax performs less well than the SQL:1999 compliant ANSI join syntax.
The Oracle join syntax lacks the ability to do outer joins.

Explanation

Question 142 of 120

1

Which two statements are true about single row functions?

(Choose two).

Select one or more of the following:

CEIL : can be used for positive and negative numbers.
MOD : returns the remainder of a division operation.
CONCAT : can be used to combine any number of values.
FLOOR : returns the smallest integer greater than or equal to a specified number.
TRUNC : can be used only with NUMBER data types.

Explanation

Question 68 of 120 Question 143 of 120

1

What is true about non-equijoin statement performance?

Select one of the following:

The Oracle join syntax performs less well than the SQL:1999 compliant ANSI join syntax.
The join syntax used makes no difference to performance.
The BETWEEN condition used with a non-equijoin sometimes performs better than using the >= and <= conditions.
The BETWEEN condition used with a non-equijoin always performs better than when using the >= and <= conditions.
The Oracle join syntax performs better than the SQL:1999 compliant ANSI join syntax.

Explanation

Question 144 of 120

1

Examine the description of the CUSTOMERS table:
Name Null? Type
----------------------------------------------------
CUST_ID NOT NULL VARCHAR2(2)
CUST_LAST_NAME VARCHAR2(30)
CITY VARCHAR2(10)
CUST_CREDIT_LIMIT NUMBER(6,2)

You need to display last names and credit limits of all customers whose last name starts with A or B in lower or upper case, and whose credit limit is below 1000.

Examine this partial query:
SELECT cust_last_name, cust_credit_limit FROM customers

Which two WHERE conditions give the required result?

(Choose two).

Select one or more of the following:

WHERE (UPPER(cust_last_name) LIKE 'A%' OR UPPER(cust_last_name) LIKE 'B%')
AND ROUND(cust_credit_limit) < 1000;
WHERE (INITCAP(cust_last_name) LIKE 'A%' OR INITCAP(cust_last_name) LIKE 'B%')
AND cust_credit_limit < 1000;
WHERE UPPER(cust_last_name) IN ('A%', 'B%')
AND cust_credit_limit < 1000;
WHERE (UPPER(cust_last_name) LIKE INITCAP('A') OR UPPER(cust_last_name) LIKE INITCAP('B'))
AND ROUND(cust_credit_limit) < ROUND(1000);
WHERE UPPER(cust_last_name) BETWEEN UPPER('A%' AND 'B%')
AND ROUND(cust_credit_limit) < 1000;

Explanation

Question 145 of 120

1

Which two statements are true about substitution variables?

(Choose two).

Select one or more of the following:

A substitution variable can be used with any clause in a SELECT statement.
A substitution variable used to prompt for a column name must be enclosed in double quotation marks.
A substitution variable used to prompt for a column name must be enclosed in single quotation marks.
A substitution variable prefixed with & always prompts only once for a value in a session.
A substitution variable can be used only in a SELECT statement.
A substitution variable prefixed with && prompts only once for a value in a session unless it is set to undefined in the session.

Explanation

Question 108 of 120 Question 146 of 120

1

The CUSTOMERS table has a CUST_LAST_NAME column of data type VARCHAR2.
The table has two rows whose CUST_LAST_NAME values are Anderson and Ausson.

Which query produces output for CUST_LAST_NAME containing Oder for the first row and Aus for the second?

Select one of the following:

SELECT INITCAP(REPLACE(TRIM('son' FROM cust_last_name), 'An', 'O')) FROM customers;
SELECT REPLACE(SUBSTR(cust_last_name, -3), 'An', 'O') FROM customers;
SELECT REPLACE(REPLACE(cust_last_name, 'son', ''), 'An', 'O') FROM customers;
SELECT REPLACE(TRIM(TRAILING 'son' FROM cust_last_name), 'An', 'O') FROM customers;

Explanation

Question 1 of 120 Question 147 of 120

1

Which two statements are true about GLOBAL TEMPORARY TABLES?

(Choose two).

Select one or more of the following:

GLOBAL TEMPORARY TABLE rows inserted by a session are available to any other session whose user has been granted select on the table.
GLOBAL TEMPORARY TABLE space allocation occurs at session start.
A GLOBAL TEMPORARY TABLE 's definition is available to multiple sessions.
A DELETE command on a GLOBAL TEMPORARY TABLE cannot be rolled back.
A TRUNCATE command issued in a session causes all news in a GLOBAL TEMPORARY TABLE for the issuing session to be deleted.

Explanation

Question 110 of 120 Question 148 of 120

1

Which three statements are true about Resumable Space Allocation in Oracle databases?

(Choose three).

Select one or more of the following:

The AFTER SUSPEND event trigger can itself be suspended due to space conditions.
Resumable space allocation may be enabled for some sessions and not others.
Resumable space allocation is only possible with locally managed tablespaces.
All sessions must have the same timeout value when waiting for resumable space allocations.
A user's session may be suspended and resumed multiple times.
A user's session may be suspended even if the user has the UNLTMTTED TABLESPACE system privilege.

Explanation

Question 66 of 120 Question 149 of 120

1

Examine the description of the PRODUCT_INFORMATION table:
Name Null? Type
--------------------------------------------------------------------
PROD_ID NOT NULL NUMBER(2)
PROD_NAME VARCHAR2(10)
LIST_PRICE NUMBER(6,2)

Which query retrieves the number of products with a null list price?

Select one of the following:

SELECT COUNT(DISTINCT list price) FROM product_information WHERE list_price IS NULL;
SELECT COUNT(list_price) FROM product_information WHERE list_price IS NULL;
SELECT COUNT(list_price) FROM product_information WHERE list_price = NULL;
SELECT COUNT(NVL(list_price, 0)) FROM product_information WHERE list_price IS NULL;

Explanation

Question 150 of 120

1

Examine the description of the CUSTOMERS table:
Name Null? Type
--------------------------------------------------------------------------------
CUSTINO NOT NULL NUMBER(3)
CUSTNAME NOT NULL VARCHAR2(25)
CUSTADDRESS VARCHAR2(35)
CUST_CREDIT_LIMIT NUMBER(5)

CUSTINO is the PRIMARY KEY

You must determine if any customers' details have been entered more than once using a different CUSTINO, by listing all duplicate names.

Which two methods can you use to get the required result?

(Choose two).

Select one or more of the following:

Subquery
Self join
LEFT OUTER JOIN with self join
RIGHT OUTER JOIN with self join
FULL OUTER JOIN with self join

Explanation

Question 90 of 120 Question 151 of 120

1

Which two statements are true about undo segments and the use of undo by transactions in an Oracle database instance?

(Choose two).

Select one or more of the following:

Undo segments can wrap around to the first extent when a transaction fills the last extend of the undo segment.
Undo segments can be stored in the SYSAUX tablespace.
Undo segments can be stored in the SYSTEM tablespace.
A single transaction may use multiple undo segments simultaneously.
Undo segments can extend when a transaction fills the last extent of the undo segment.

Explanation

Question 57 of 120 Question 152 of 120

1

DATADIR1 and DATATDIR2 are database directory objects.

Examine this command:
[oracle@host01 ~] expdp system/oracle \
> FULL=y \
> DUMPFILE=datadir1:full$U.dmp,datadir2:full2$U.dmp
> FILESIZE=2G \
> PARALLEL=4 \
> LOGFILE=datadir1:/expfull.log \
> JOB_NAME=expfull

Which two statements are true about the expdp operation?

(Choose two).

Select one or more of the following:

It fails if the total size of the dump file is more than 2GB.
It creates dump files only for objects in the SYSTEM schema.
It creates a master table to store details of the export operation.
It creates dump files for the entire database.
It starts only when four worker processes are available.

Explanation

Question 14 of 120 Question 153 of 120

1

Which two statements are true about Enterprise Manager Database Express?

(Choose two).

Select one or more of the following:

It can be used to switch a database into ARCHIVELOGMODE.
It can be used to perform database recovery when the database is opened.
The same port number can be used for multiple Database Express configurations for multiple databases on the same host.
It can be used to perform database recovery when the database is mounted
The same port number can be used for Database Express configurations for databases on different hosts.
It is available only when the database is open.

Explanation

Question 70 of 120 Question 154 of 120

1

Examine these SQL statements which execute successfully:
CREATE TABLE emp
(emg_no NUMBER (2) CONSTRAINT emp_emp_no_pk PRIMARY KEY,
ename VARCHAR2 (15),
salary NUMBER (8,2),
mgr_no NUMBER (2));

ALTER TABLE emp ADD CONSTRAINT emp_mgr_fk
FOREIGN KEY (mgr_no)
REFERENCES emp (emp_no)
ON DELETE SET NULL;

ALTER TABLE emp
DISABLE CONSTRAINT emp_emp_no_pk
CASCADE;

ALTER TABLE emp
ENABLE CONSTRAINT emp_emp_no_prk;

Which two statements are true after execution?

(Choose two).

Select one or more of the following:

The primary key constraint will be enabled and IMMEDIATE.
The foreign key constraint will be enabled and DEFERRED.
The foreign key constraint will be disabled.
The foreign key constraint will be enabled and IMMEDIATE.
The primary key constraint will be enabled and DEFERRED.

Explanation

Question 67 of 120 Question 155 of 120

1

Which two statements are true about the ORDER BY clause?

(Choose two).

Select one or more of the following:

Numeric values are displayed in descending order if they have decimal positions.
NULLS are not included in the sort operation.
In a character sort, the values are case-sensitive.
Column aliases can be used in the ORDER BY clause.
Only columns that are specified in the SELECT list can be used in the ORDER BY clause.

Explanation

Question 49 of 120 Question 156 of 120

1

Examine this query:
SELECT employee_id, first_name, salary
FROM employees
WHERE hire_date > '&1';

Which two methods should you use to prevent prompting for a hire date value when this query is executed?

(Choose two).

Select one or more of the following:

Execute the SET verify off command before executing the query.
Store the query in a script and pass the substitution value to the script when executing it.
Replace '&1' with '&&1' in the query.
Execute the SET VERIFY ON command before executing the query.
Use the define command before executing the query.
Use the undefine command before executing the query.

Explanation

Question 116 of 120 Question 157 of 120

1

You issued this command:
DROP TABLE hr.employees;

Which three statements are true?

(Choose three).

Select one or more of the following:

Views referencing HR.EMPLOYEES are dropped.
Synonyms for HR.EMPLOYEES are dropped.
All indexes defined on HR.EMPLOYEES are dropped.
The HR.EMPLOYEES table may be moved to the recycle bin.
All constraints defined on HR.EMPLOYEES are dropped.
Sequences used to populate columns in the HR.EMPLOYEES table are dropped.

Explanation

Question 158 of 120

1

Examine the data in the CUST_NAME column of the CUSTOMERS table:
CUST_NAME
==========
Renske Ladwing
Jason Mallin
Samuel McCain
Allan McEwen
Irene Mikkilineni
Julia Nayer

You want to display the CUST_NAME values where the last name starts with Mc or MC.

Which two WHERE clauses give the required result?

(Choose two).

Select one or more of the following:

WHERE UPPER (SUBSTR (cust_name, INSTR (cust_name, ' ') + 1)) LIKE UPPER ('MC%')
WHERE SUBSTR(cust_name, INSTR(cust_name, ' ') + 1 ) LIKE 'Mc%' OR 'MC%'
WHERE SUBSTR(cust_name, INSTR(cust_name, ' ') +1) LIKE 'Mc%'
WHERE INITCAP(SUBSTR(cust_name, INSTR(cust_name, ' ') +1)) LIKE 'Mc%'
WHERE INITCAP(SUBSTR(cust_name, INSTR(cust_name, ' ') +1)) IN (MC%', 'Mc%)

	Created by Henderson Viscarra 8 months ago

Database Administration

0 comments

Question 1 of 120

You execute this command: CREATE BIGFILE TABLESPACE big_tbs DATAFILE '/u01/oracle/data/big_f1.dbf' SIZE 20G; Sufficient storage is available in filesystem /u01. Which two statements are true about the BIG_TBS tablespace? (Choose two).

Select one or more of the following:

Explanation

Question 52 of 120 Question 2 of 120

Which statement is true about the INTERSECT operator used in compound queries?

Select one or more of the following:

Explanation

Question 65 of 120 Question 3 of 120

Which three statements are true about advanced connection options supported by Oracle Net for connection to Oracle Database instances? (Choose three).

Select one or more of the following:

Explanation

Question 4 of 120

Which two statements are true about date/time functions in a session where NLS_DATE_FORMAT is set to DD-MON-YYYY HH24:MI:SS? (Choose two).

Select one or more of the following:

Explanation

Question 17 of 120 Question 5 of 120

A database is configured to use automatic undo management with temporary undo enabled. An UPDATE is executed on a temporary table. Where is the UNDO stored?

Select one of the following:

Explanation

Question 5 of 120 Question 6 of 120

Select one of the following:

Explanation

Question 26 of 120 Question 7 of 120

In the spfile of a single instance database, LOCAL_LISTENER is set to LISTENER_1. The TNSNAMES.ORA file in $ORACLE_HOME/network/admin in the database home contains: LISTENER_1 = (ADDRESS = (PROTOCOL = TCP) (HOST = host1.abc.com) (PORT = 5121) ) Which statement is true?

Select one of the following:

Explanation

Question 18 of 120 Question 8 of 120

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

Select one or more of the following:

Explanation

Question 88 of 120 Question 9 of 120

Which two statements are true regarding a SAVEPOINT? (Choose two).

Select one or more of the following:

Explanation

Question 25 of 120 Question 10 of 120

Which three functions are performed by dispatchers in a shared server configuration? (Choose three).

Select one or more of the following:

Explanation

Question 2 of 120 Question 11 of 120

Which two statements are true about the SET VERIFY ON command? (Choose two).

Select one or more of the following:

Explanation

Question 19 of 120 Question 12 of 120

Which three statements are true about a self join? (Choose three).

Select one or more of the following:

Explanation

Question 3 of 120 Question 13 of 120

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?

Select one of the following:

Explanation

Question 34 of 120 Question 14 of 120

Select one of the following:

Explanation

Question 9 of 120 Question 15 of 120

Examine this command: ALTER DATABASE MOVE DATAFILE '/u01/sales1.dbf' TO '/u01/sales01.dbf' REUSE; Which two statements are true? (Choose two).

Select one or more of the following:

Explanation

Question 16 of 120

Which three statements are true about dropping and unused columns in an Oracle database? (Choose three).

Select one or more of the following:

Explanation

Question 55 of 120 Question 17 of 120

Which two statements are true regarding Oracle database space management within blocks managed by Automatic Segment Space Management (ASSM)? (Choose two).

Select one or more of the following:

Explanation

Question 97 of 120 Question 18 of 120

Select one or more of the following:

Explanation

Question 19 of 120

Which three instance situations are possible with the Oracle Database server without multi-tenant? (Choose three).

Select one or more of the following:

Explanation

Question 62 of 120 Question 20 of 120

Which two statements are true about the ORDER BY clause when used with a SQL statement containing a SET operator such as UNION? (Choose two).

Select one or more of the following:

Explanation

You execute this command:
CREATE BIGFILE TABLESPACE big_tbs
DATAFILE '/u01/oracle/data/big_f1.dbf'
SIZE 20G;

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

(Choose two).

Which three statements are true about advanced connection options supported by Oracle Net for connection to Oracle Database instances?

(Choose three).

Which two statements are true about date/time functions in a session where NLS_DATE_FORMAT is set to DD-MON-YYYY HH24:MI:SS?

(Choose two).

A database is configured to use automatic undo management with temporary undo enabled. An UPDATE is executed on a temporary table.

Where is the UNDO stored?

In the spfile of a single instance database, LOCAL_LISTENER is set to LISTENER_1.
The TNSNAMES.ORA file in $ORACLE_HOME/network/admin in the database home contains:
LISTENER_1 =
(ADDRESS =
(PROTOCOL = TCP)
(HOST = host1.abc.com)
(PORT = 5121)
)

Which statement is true?

Which three statements are true concerning logical and physical database structures?

(Choose three).

Which two statements are true regarding a SAVEPOINT?

(Choose two).

Which three functions are performed by dispatchers in a shared server configuration?

(Choose three).

Which two statements are true about the SET VERIFY ON command?

(Choose two).

Which three statements are true about a self join?

(Choose three).

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?

Examine this command:
ALTER DATABASE
MOVE DATAFILE '/u01/sales1.dbf'
TO '/u01/sales01.dbf'
REUSE;

Which two statements are true?

(Choose two).

Which three statements are true about dropping and unused columns in an Oracle database?

(Choose three).

Which two statements are true regarding Oracle database space management within blocks managed by Automatic Segment Space Management (ASSM)?

(Choose two).

Which three instance situations are possible with the Oracle Database server without multi-tenant?

(Choose three).

Which two statements are true about the ORDER BY clause when used with a SQL statement containing a SET operator such as UNION?

(Choose two).

Which four account management capabilities can be configured using Oracle profiles?

(Choose four).

Which three statements are true about single-row functions?

(Choose three).

You want to use table compression suitable for OLTP that will:
1. Compress rows for all DML statements on that table
2. Minimize the overheads associated with compression

Which compression option is best suited for this?

Which two statements are true about space-saving features in an Oracle Database?

(Choose two).

Which two statements are true about the PMON background process?

(Choose two).

In which three situations does a new transaction always start?

(Choose three).

Which three Oracle database space management features will work with both Dictionary and Locally managed tablespaces?

(Choose three).

In one of your databases, you create a user, HR, and then execute this command:
GRANT CREATE SESSION TO hr WITH ADMIN OPTION;

Which four actions can HR perform?

(Choose four).

Which two statements are true about the WHERE and HAVING clauses in a SELECT statement?

(Choose two).

Which two statements are true about UNDO and REDO?

(Choose two).

Which three statements are true about the DESCRIBE command?

(Choose three).

The INVOICE table has a QTY_SOLD column of data type NUMBER and an INVOICE_DATE column of data type DATE.
NLS_DATE_FORMAT is set to DD-MON-RR.

Which two are true about data type conversions involving these columns in query expressions?

(Choose two). ==> 3