Ractice Ump: Free Practice Dumps - Unlimited Free Access of Practice Exam

PracticeDump
http://www.practicedump.com
Free Practice Dumps - Unlimited Free Access of practice exam
1Z0-082 practice exam dumps, 1Z0-082 practice exam online
IT Certification Guaranteed, The Easy Way!
Exam : 1z0-082
Title : Oracle Database

Administration I
Vendor : Oracle
Version : DEMO
1
Oracle practice exam 1Z0-082 dumps pdf, 1Z0-082 practice exam online, 1Z0-082 practice test free，1Z0-082 practice que
https://www.practicedump.com/1Z0-082_actualtests.html
NO.1 Which two statements are true?

A. SALES1 is created with 1 row.
B. SALES1 has primary key and unique constraints on any selected columns which had those
constraints in the sales table.
C. SALES1 has not NULL constraints on any selected columns which had those constraints in the sales
table.
D. SALES1 is created with no rows.
E. SALES1 is created with 55,000 rows.
Answer: C,E
NO.2 Which three statements are true about single-row functions? (Choose three.)
A. They can be nested to any level
B. They return a single result row per table
C. The argument can be a column name, variable, literal or an expression
D. They can be used only in the WHERE clause of a SELECT statement
E. The data type returned can be different from the data type of the argument
F. They can accept only one argument
Answer: A,C,E
Explanation:
https://www.tutorialspoint.com/sql_certificate/using_single_row_functions_questions.htm
NO.3 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.)
A. Add the SEGMENT SPACE MANAGEMENT AUTO clause
B. Add the ONLINE clause
C. Add the NOLOGGING clause
D. Make certain that the database operates in automatic undo management mode
E. Set UNDO_TABLESPACE to UNDOTBS01
Answer: D,E
NO.4 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. no segments are created
B. T1, an index segment for the primary key, a LOB segment, and a lobindex segment
C. T1 only
D. T1, an index segment for the primary key, and a LOB segment only
2
E. T1 and an index segment created for the primary key only

Answer: A
NO.5 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?
A. WHERE TO_XUMBER(start_date - SYSDATE) <= 25
B. WHERE MON'THS_BETWEEN (start_date, SYSDATE) <= 25
C. WHERE MON'THS_BETWEEN (SYSDATE, start_date) <= 25
D. WHERE ADD_MONTHS<start_date, 25) <= SYSDATE
Answer: B
NO.6 Examine the description of the product_details table:
Which two statements are true?

A. PRODUCT _price contains the value zero by default if no value is assigned to it.
B. PRODUCT _price can be used in an arithmetic expression even if it has no value stored in it.
C. EXPIRY_ DATE contains the sysdate by default if no date is assigned to it.
D. PRODUCT _ic can be assigned the PRIMARY KEY constraint.
E. EXPIRY_ DATE cannot be used in arithmetic expressions.
F. PRODUCT_NAKE cannot contain duplicate values.
Answer: B,D
NO.7 Which two actions can you perform using DBCA for an existing database?
A. Create a template that can be used to clone the database.
B. Change the character set.
C. Create nonstandard block size tablespaces.
D. Create an additional listener.
E. Change the server mode from dedicated to shared, and vice versa.
Answer: B,E
NO.8 Which three statements are true about advanced connection options supported by Oracle Net
for connection to Oracle Database instances? (Choose three.)
A. Load Balancing requires the use of a name server
B. Source Routing enables the use of Connection Manager (CMAN) which enables network traffic to
be routed through a firewall
C. Connect Time Failover requires the use of Transparent Application Failover (TAF)
D. Connect Time Failover requires the connect string to have two or more listener addresses
3
configured
E. Source Routing requires the use of a name server
F. Load Balancing can balance the number of connections to dispatchers when using a Shared Server
configuration
Answer: B,D,F
Explanation:
https://docs.oracle.com/en/database/oracle/oracle-database/12.2/rilin/shared-server-configuration-
for-an-oracle-rac-database.html#GUID-2EFBA08D-FEEE-407F-BC42-E548DA946DF9
NO.9 Which two statements are true about the Oracle Data Dictionary?
A. Data dictionary base tables can be queried directly.
B. Data dictionary views are always created with queries that join two or more base tables.
C. All data dictionary view joins base tables to dynamic performance views.
D. It is owned by the sys user.
E. It is owned by the system user.
Answer: A,D
NO.10 Examine the description of the CUSTOMERS table:
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?
A. SELECT * FROM customers WHERE city = 'D_%';
B. SELECT * FROM customers WHERE city LIKE 'D_';
C. SELECT * FROM customers WHERE city = '%D_';
D. SELECT * FROM customers WHERE city LIKE 'D_%';
Answer: D
NO.11 In the promotions table, the PROMO_BEGIN_DATE column is of data type date and the
default date format Is DD-MON-RR.
h two statements are true about expressions using PROMO_BEGIN_DATE contained In a query?
A. PROMO_ BEGIN_DATE - 5 will return a date.
B. PROMO_ BEGIN_DATE - sysdate will return a number.
C. PROMO_ BEGIN_DATE - sysdate will return an error.
D. to_numberipromo_begin_date) - s will return a number.
4
E. TO_date(PROMO_ BEGIN_DATE * 5| will return a date.

Answer: A,C
NO.12 Which three files are used by conventional path SQL*Loader when the TABLE option is not
specified? (Choose three.)
A. dump files
B. input files
C. password files
D. bad files
E. control files
Answer: B,D,E
5

Ractice Ump: Free Practice Dumps - Unlimited Free Access of Practice Exam

Uploaded by

Copyright:

Available Formats

Ractice Ump: Free Practice Dumps - Unlimited Free Access of Practice Exam

Uploaded by

Document Information

Original Title

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

Ractice Ump: Free Practice Dumps - Unlimited Free Access of Practice Exam

Uploaded by

Copyright:

Available Formats

PracticeDump

Title : Oracle Database

NO.1 Which two statements are true?

NO.3 Examine this command:

NO.4 In the SALES database, DEFERRED_SEGMENT_CREATION is TRUE.

E. T1 and an index segment created for the primary key only

NO.6 Examine the description of the product_details table:

Which two statements are true?

NO.10 Examine the description of the CUSTOMERS table:

E. TO_date(PROMO_ BEGIN_DATE * 5| will return a date.

You might also like