Oracle Database 23ai Administration Associate

Here you have the best Oracle 1z0-182 practice exam questions

Question 1 of 4

Which of the following ALTER SYSTEM statements can be run from within a pluggable database (PDB) and affect the entire container database (CDB)?

ALTER SYSTEM ENABLE / DISABLE RESTRICTED SESSION

ALTER SYSTEM FLUSH BUFFER_CACHE

ALTER SYSTEM CHECKPOINT

ALTER SYSTEM SWITCH LOGFILE

Correct Answer: B, C

Question 2 of 4

Which three statements are true about dynamic performance views? (Choose three.)

They are owned by the SYSTEM user.

V$FIXED_TABLE can be queried to display the name of all dynamic performance views.

Data displayed by querying dynamic performance views is derived from metadata in the data dictionary.

They can be queried only when the database is open.

Read consistency is not guaranteed.

Data displayed by querying dynamic performance views is derived from memory structures.

Correct Answer: B, D, F

Question 3 of 4

Which two actions can you perform using DBCA for an existing database? (Choose two.)

Create a template that can be used to clone the database.

Change the character set.

Change the server mode from dedicated to shared, and vice versa.

Create an additional listener.

Create nonstandard block size tablespaces.

Correct Answer: A, E

Question 4 of 4

Which three statements are true about UNDO and REDO? (Choose three.)

Both REDO and UNDO can be multiplexed.

UNDO is used for read consistency.

REDO is used for ROLLBACK.

REDO is used for instance recovery.

REDO is used for read consistency.

UNDO is used for some flashback operations.

Correct Answer: A, B, D