Free Access Oracle.1Z0-082.v2022-02-11.q110 Practice Test (Page 12)

Question 51

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 only

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

C.T1, an index segment for the primary key, a LOB segment, and a lobindex segment

D.T1, an index segment for the primary key, and a LOB segment only

E.no segments are created

Question 52

Examine the description of the BOOKS table:

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

A.The second ROLLBACK command does nothing

B.The second ROLLBACK command replays the delete

C.The first ROLLBACK command restores the 101 rows that were deleted, leaving the inserted row still to be committed

D.The second ROLLBACK command undoes the insert

E.The first ROLLBACK command restores the 101 rows that were deleted and commits the inserted row

Question 53

Examine these commands:

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

A.It generates a sql script that it uses to load data from EMP.DAT to EMP

B.It uses the database buffer cache to load data

C.It overwrites data in EMP with data in EMP.DAT

D.It generates a log that contains control file entries, which can be used with normal SQL*Loader operations

E.It appends data from EMP.DAT to EMP

Question 54

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 with NUMBERand DATEvalues

D.CONCAT : can be used to combine any number of values

E.CEIL : can be used for positive and negative numbers

Question 55

Which is true about security rules on a compute node?

A.A compute node port can be enabled only if it is associated with an existing security rule.

B.The port used for HTTPS connections is enabled by default based on a predefined security rule.

C.A security rule can restrict IP addresses that can connect to a database instance on a compute node.

D.New security rules can be defined to use only the TCP protocol but multiple port numbers.

E.A new database deployment on a compute node automatically enables a set of predefined security rules.

Other Version: 2263Oracle.1Z0-082.v2023-08-24.q111; 1402Oracle.1Z0-082.v2023-03-31.q49; 3871Oracle.1Z0-082.v2022-07-18.q111; 4915Oracle.1Z0-082.v2022-03-27.q110; 97Oracle.Prepawaytest.1Z0-082.v2021-09-10.by.ives.98q.pdf

Latest Upload: 101OCEG.GRCP.v2025-09-11.q211; 101HP.HPE0-V27.v2025-09-11.q78; 117Oracle.1Z0-1057-23.v2025-09-10.q47; 150Google.Professional-Cloud-Network-Engineer.v2025-09-09.q179; 131SAP.C-S4EWM-2023.v2025-09-08.q83; 164TheSecOpsGroup.CNSP.v2025-09-08.q20; 222CFAInstitute.ESG-Investing.v2025-09-08.q173; 157PECB.ISO-IEC-27001-Lead-Implementer.v2025-09-06.q132; 146Salesforce.Data-Architect.v2025-09-05.q216; 140Adobe.AD0-E605.v2025-09-05.q50

Question 51

Question 52

Question 53

Question 54

Question 55

Download PDF File