Free Oracle 1z1-072 Exam Dumps Questions & Answers


Exam Code/Number:	1z1-072Join the discussion
Exam Name:	Oracle Database 12cR2 Administration
Certification:	Oracle
Free Question Number:	88
Publish Date:	Oct 04, 2026
# of views:	2686
Rating 100%

Page: 1 / 18
Total 88 questions

Question 1

Your client application and Oracle database are located on different hosts.
Which statement is true about establishing a connection between them?

A.Only Oracle Net can be used.
B.Net service names must be configured on both the client and database servers.
C.Oracle Connection Manager must be installed on the client.
D.The Listener Control utility must be installed on the client if you are using the default listener on the server.
E.Oracle Net Listener is required.

Question 2

Which two operations can be performed on external tables? (Choose two.)

A.executing UPDATE statements
B.creating views
C.creating partitions
D.creating invisible indexes
E.creating public synonyms

Question 3

Your database is configured for shared server and the SGA_TARGET parameter is set to a non-zero value.
Which three actions could help in handling a large number of concurrent users?

A.using Automatic SGA Memory Management (ASMM)
B.setting the SHARED_POOL_SIZE parameter to a non-zero value
C.increasing the size of the PGA
D.setting the LARGE_POOL_SIZE parameter to a non-zero value
E.increasing the number of dispatchers

Question 4

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

A.It uses the default blocksize used at database creation.
B.The FREELISTS and FREELIST GROUPS parameters are used to manage extent allocation.
C.It is read-only by default.
D.It is a locally managed tablespace.
E.DML operations performed on objects in this tablespace are not logged by default.
F.It is offline by default.

Question 5

Which two statements are true about VSTABLESPACE and DBA_ TABLESPACE?

A.VSTABLESPACE metadata is lost at shutdown, but DBA_ TABLESPACE metadata persists across shutdowns.
B.VSTABLESPACE is a dynamic view that is populated with data from th DBA_ TABLESPACE dictionary view.
C.VSTABLESPACE and DBA_ TABLESPACES are view based on base tables in the data dictionary.
D.VSTABLESPACE is a dynamic view that is populated with data from the DBA_ TABLESPACES data queried only when a database is open.
E.VSTABLESPACE cab be queries by all users, but DBA_ TABLESPACEs cab be queries only by SYSDBA users.