Which two tasks can you perform using DBCA for databases?
Correct Answer: B,C
A .False. Backups are configured via RMAN, not DBCA. B .True. DBCA allows nonstandard block sizes during DB creation. C .True. DBCA can register new DBs with EM. D .False. Block size is fixed post-creation. E .False. Flashback is enabled via SQL, not DBCA for existing DBs.
1Z0-182 Exam Question 42
Which three statements are true about a dedicated server configuration?
Correct Answer: C,E,F
A .False. Dispatchers are for shared servers, not dedicated. B .False. Dedicated processes die with the session. C .True. Direct client-server communication occurs. D .False. No dispatchers in dedicated mode. E .True. Listener spawns for local/remote clients. F .True. Local logins (e.g., sqlplus /) bypass the listener.
1Z0-182 Exam Question 43
Examine this command: ALTER DATABASE MOVE DATAFILE '/u01/sales01.dbf' TO '/u02/sales02.dbf'; Which two statements are true?
Correct Answer: A,E
The ALTER DATABASE MOVE DATAFILE command relocates a data file to a new location while the database remains online, introduced in Oracle 12c and enhanced in subsequent releases like 23ai. Let's evaluate each option: A . DML may be performed on tables with one or more extents in this data file during the execution of this command.True. The move operation is online by default in Oracle 23ai, allowing DML (INSERT, UPDATE, DELETE) operations on tables within the data file being moved. The database ensures consistency using redo and undo mechanisms. B . It overwrites any existing file with the name sales02.dbf in /u02 by default.False. By default, the command does not overwrite an existing file unless the REUSE clause is specified (e.g., ALTER DATABASE MOVE DATAFILE ... REUSE). Without it, the command fails if the target file exists. C . The "TO" clause containing the new file name must be specified even if Oracle Managed Files (OMF) is used.False. When OMF is enabled (via DB_CREATE_FILE_DEST), the TO clause is optional. If omitted, Oracle automatically generates a file name and places it in the OMF destination. D . Compressed objects in sales01.dbf will be uncompressed in sales02.dbf after the move.False. The move operation is a physical relocation of the data file; it does not alter the logical structure or compression state of objects within it. Compressed data remains compressed. E . Tables with one or more extents in this data file may be queried during the execution of this command.True. The online nature of the move allows queries (SELECT statements) to proceed without interruption, leveraging Oracle's multi-version consistency model.
1Z0-182 Exam Question 44
What services does the Automatic Workload Repository (AWR) provide for the database self-tuning functionality?
Correct Answer: B
A .False. AWR doesn't create PDBs. B .True. AWR stats aid migration planning (e.g., performance baselines). C .False. AWR doesn't convert CDB to Non-CDB. D .False. SID management isn't AWR's role.
1Z0-182 Exam Question 45
Which two statements are true about the UNLIMITED TABLESPACE system privilege and space quota?
Correct Answer: A,B
A .True. Grants unlimited space across all tablespaces. B .True. Explicit quotas override the privilege. C .False. Not limited to default tablespace. D .False. Roles can't have this privilege directly. E .False. Default is zero quota unless specified.
