A .False. External tables are read-only; no DELETE. B .False. Require OPEN state, unlike V$ views. C .False. No UPDATE support; read-only. D .True. Queryable like regular tables without loading. E .True. Data Pump can unload query results to files.
Question 2
You want to apply the principle of Least Privilege in all your live databases. One of your requirements is to revoke unnecessary privileges from all users who have them using Privilege Analysis. Which three types of analyses can be done using the DBMS_PRIVILEGE_CAPTURE package?
Correct Answer: A,E,F
A .True. Captures unused self-owned object privileges. B .False. SYS is excluded from capture. C .False. No exclusion option for admin users. D .False. Direct role grants aren't separately analyzed. E .True. Tracks indirect role privileges used. F .True. Identifies used self-owned privileges.
Question 3
At which two container database levels can COMMON Unified Audit Policies be used?
Correct Answer: B,E
A .False. Not limited to CDB; PDBs can use common policies. B .True. Common policies apply at CDB level. C .False. Application Root uses app-specific policies. D .False. "COMMON option" isn't a feature; policies are common by creation context. E .True. A common user can create policies for PDBs.
Question 4
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.
Question 5
Which three statements are true about the tools used to configure Oracle Net Services?
Correct Answer: C,D,F
A .False. Net Manager is local, not centralized. B .False. NetCA can run standalone. C .True. EMCC manages service names centrally. D .True. EMCC configures listeners on managed targets. E .False. lsnrctl starts a default listener if no listener.ora exists. F .True. Net Manager configures local tnsnames.ora.
