NEW QUESTION 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?

• A. T1, an index segment for the primary key, a LOB segment, and a lobindex segment
• B. no segments are created
• C. T1 only
• D. T1 and an index segment created for the primary key only
• E. T1, an index segment for the primary key, and a LOB segment only

Answer: C

NEW QUESTION 2
Which two statements are true about single row functions? (Choose two.)

• A. MOD : returns the quotient of a division operation
• B. FLOOR : returns the smallest integer greater than or equal to a specified number
• C. TRUNC : can be used to combine any number of values
• D. CONCAT : can be used to combine any number of values
• E. CEIL : can be used for positive and negative numbers

Answer: AC

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

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

Answer: D

NEW QUESTION 4
Which three statements are true about the tools used to configure Oracle Net Services? (Choose three.)

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

Answer: BDE

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

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

Answer: ABF

NEW QUESTION 6
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.)

• A. CONCAT (qty_sold, invoice_date) : requires explicit conversion
• B. invoice_date = ’15-march-2021’ : uses implicit conversion
• C. invoie_date > ’01-02-2021’ : uses implicit conversion
• D. qty_sold BETWEEN ‘101’ AND ’110’ : uses implicit conversion
• E. qty_sold = ‘0554982’ uses implicit conversion

Answer: BD

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

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

Answer: ACF

NEW QUESTION 8
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:

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

• A. The sales user must have a quota on the TEMP tablespace
• B. 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
• C. The sales user must have been granted the CREATE SESSION privilege
• D. The sales user must have their quota on the users tablespace removed
• E. 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
• F. The sales user must have been granted the CREATE TABLE privilege

Answer: BDF

NEW QUESTION 9
Which two statements are true about the PMON background process? (Choose two.)

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

Answer: AB

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

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

Answer: CDF

NEW QUESTION 11
Which three statements are true about the Oracle join and ANSI join syntax? (Choose three.)

• A. The Oracle join syntax supports creation of a Cartesian product of two tables
• B. The Oracle join syntax performs better than the SQL:1999 compliant ANSI join syntax
• C. The SQL:1999 compliant ANSI join syntax supports natural joins
• D. The SQL:1999 compliant ANSI join syntax supports creation of a Cartesian product of two tables
• E. The Oracle join syntax only supports right outer joins
• F. The Oracle join syntax supports natural joins
• G. The Oracle join syntax performs less well than the SQL:1999 compliant ANSI join syntax

Answer: CDF

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

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

Answer: AE

NEW QUESTION 13
Examine this command and some partial output:

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

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

Answer: B

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

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

Answer: B

NEW QUESTION 15
You execute this command:

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

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

Answer: AE

NEW QUESTION 16
You execute this command:

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

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

Answer: AB

NEW QUESTION 17
Examine the description of the EMPLOYEES table:

Which query is valid?

• A. SELECT dept_id, AVG(MAX(salary)) FROM employees GROUP BY dept_id;
• B. SELECT dept_id, join_date, SUM(salary) FROM employees GROUP BY dept_id;
• C. SELECT dept_id, join_date, SUM(salary) FROM employees GROUP BY dept_id, join_date;
• D. SELECT dept_id, MAX(AVG(salary)) FROM employees GROUP BY dept_id;

Answer: B

NEW QUESTION 18
Which three statements are true regarding indexes? (Choose three.)

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

Answer: ADE

NEW QUESTION 19
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.)

• A. Column positions must be used in the ORDER BY clause
• B. Only column names from the first SELECT statement in the compound query are recognized
• C. 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
• D. Each SELECT statement in the compound query must have its own ORDER BY clause
• E. Each SELECT statement in the compound query can have its own ORDER BY clause

Answer: BE

NEW QUESTION 20
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 wee.
Which query can be used?

• A. SELECT emp_id, ADD_MONTHS(hire_date, 6), NEXT_DAY(‘MONDAY’) FROM employees;
• B. SELECT emp_id, NEXT_DAY(ADD_MONTHS(hire_date, 6), ‘MONDAY’) FROM employees;
• C. SELECT emp_id, NEXT_DAY(MONTHS_BETWEEN(hire_date, SYSDATE), 6) FROM employees;
• D. SELECT emp_id, NEXT_DAY(ADD_MONTHS(hire_date, 6), 1) FROM employees;

Answer: B

NEW QUESTION 21
Examine these commands:

Which two statements are true about the sqlldr execution? (Choose two.)

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

Answer: BD

NEW QUESTION 22
......