Get Special Discount Offer on 1Z0-182 Dumps PDF [UPDATED Dec-2025]
PDF Download Oracle Test To Gain Brilliante Result!
Oracle 1Z0-182 Exam Syllabus Topics:
| Topic | Details |
|---|---|
| Topic 1 |
|
| Topic 2 |
|
| Topic 3 |
|
| Topic 4 |
|
| Topic 5 |
|
| Topic 6 |
|
| Topic 7 |
|
| Topic 8 |
|
| Topic 9 |
|
NEW QUESTION # 53
Which two statements are true about views used for viewing tablespace and datafile information?
- A. A datafile can be renamed when the database is in MOUNT state and the new file name is displayed when querying DBA_DATA_FILES after the database is opened.
- B. V$TABLESPACE displays information about tablespaces contained in the data dictionary.
- C. Tablespace free space can be viewed in DBA_TABLESPACES.
- D. V$TABLESPACE displays information that is contained in the control file about tablespaces.
- E. Tablespace free space can be viewed in V$TABLESPACE.
Answer: A,D
Explanation:
A .False. V$TABLESPACE doesn't show free space directly.
B .False. It's from the control file, not the data dictionary.
C .True. Renaming in MOUNT state updates DBA_DATA_FILES post-open.
D .False. DBA_TABLESPACES shows attributes, not free space directly (use DBA_FREE_SPACE).
E .True. V$TABLESPACE reflects control file data.
NEW QUESTION # 54
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?
- A. Analysis of privileges that a user has on their own schema objects that they did use.
- B. Analysis of all privileges used by all users but excluding administrative users in the database.
- C. Analysis of privileges that a user has on their own schema objects that they did not use.
- D. Analysis of privileges granted indirectly to a role that are then used by a user who has beengranted that role.
- E. Analysis of privileges granted directly to a role that are then used by a user who has been granted that role.
- F. Analysis of all privileges used by all users including administrative users in the database.
Answer: A,C,D
Explanation:
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.
NEW QUESTION # 55
Which three statements are true about row chaining and row migration done by Oracle database block space management?
- A. Update statements can result in one or more chained rows.
- B. Insert statements can result in a migrated row.
- C. A migrated row results in an update to any index on the table to point the row ID in the index to the row's new location.
- D. Update statements can result in one or more migrated rows.
- E. Row pieces of a chained row must always reside in different blocks.
Answer: A,C,D
Explanation:
A .True. Migration updates index ROWIDs.
B .True. Updates can migrate rows if space is insufficient.
C .True. Large updates can chain rows across blocks.
D .False. Chained rows may span blocks but aren't required to.
E .False. Inserts don't migrate; they chain if too large initially.
NEW QUESTION # 56
Examine this command: SQL> ALTER TABLE ORDERS SHRINK SPACE COMPACT; Which two statements are true?
- A. The SHRINK operation causes rows to be moved to empty space starting from the beginning of the ORDERS segment.
- B. The high-water mark (HWM) of ORDERS is adjusted.
- C. The SHRINK operation causes rows to be moved to empty space starting toward the end of the ORDERS segment.
- D. Queries and DML statements are allowed on ORDERS while the SHRINK is executing.
- E. Only queries are allowed on ORDERS while SHRINK is executing.
- F. Dependent indexes become UNUSABLE.
Answer: A,D
Explanation:
A . Dependent indexes become UNUSABLE.False. SHRINK SPACE COMPACT does not affect index usability; only SHRINK SPACE without COMPACT may require index maintenance if CASCADE is omitted.
B . ... starting toward the end of the ORDERS segment.False. Rows are compacted toward the beginning of the segment, not the end.
C . Only queries are allowed ...False. Both queries and DML are allowed during SHRINK SPACE COMPACT as it's an online operation.
D . The high-water mark (HWM) of ORDERS is adjusted.False. COMPACT moves rows but doesn't adjust the HWM; the full SHRINK SPACE command is needed for HWM adjustment.
E . Queries and DML statements are allowed ...True. This is an online operation in 23ai, allowing concurrent access.
F . ... starting from the beginning of the ORDERS segment.True. Rows are moved to fill free space from the segment's start.
NEW QUESTION # 57
Which data dictionary view describes the data sources of external tables?
- A. DBA_ALL_USER_TAB_COLUMNS
- B. DBA_ALL_USER_EXTERNAL_LOCATIONS
- C. DBA_ALL_USER_EXTERNAL_TABLES
- D. DBA_ALL_USER_TABLES
Answer: B
Explanation:
A .True. DBA_EXTERNAL_LOCATIONS (or prefixed variants) shows external table data sources (e.g., file paths).
B-D .False. These views cover columns or tables but not external sources specifically.
NEW QUESTION # 58
In the SPFILE of a single instance database, LOCAL_LISTENER is set to LISTENER_1. The TNSNAMES.ORA file in $ORACLE_HOME/network/admin in the database home contains: LISTENER_1 = (ADDRESS = (PROTOCOL = TCP)(HOST = host1.abc.com)(PORT = 1521)). Which statement is true?
- A. There are two listeners named LISTENER and LISTENER_1 running simultaneously using port 1521 on the same host as the database in LISTENERS.
- B. The LREG process registers services dynamically with the LISTENER_1 listener.
- C. The definition for LISTENER_1 requires a CONNECT_DATA section to enable dynamic service registration.
- D. Dynamic service registration cannot be used for this database instance.
- E. LISTENER_1 must also be defined in the LISTENER.ORA file to enable dynamic service registration.
Answer: B
Explanation:
Dynamic service registration allows a database to automatically register its services with a listener without manual configuration in LISTENER.ORA. Let's analyze each option:
A . The definition for LISTENER_1 requires a CONNECT_DATA section to enable dynamic service registration.
False. The CONNECT_DATA section is part of a client-side TNSNAMES.ORA entry for connecting to a service, not for listener registration. Dynamic registration is handled by the database's LREG (Listener Registration) process, which uses the LOCAL_LISTENER parameter to locate the listener's address (e.g., host1.abc.com:1521). No CONNECT_DATA is needed in the listener address definition itself. This option confuses client connection syntax with listener configuration.
Mechanics:The listener address in TNSNAMES.ORA (LISTENER_1) is sufficient for LREG to find and register with it, as long as the listener is running at that address.
B . LISTENER_1 must also be defined in the LISTENER.ORA file to enable dynamic service registration.
False. Dynamic registration doesn't require the listener to be explicitly defined in LISTENER.ORA. The LOCAL_LISTENER parameter pointing to LISTENER_1 (resolved via TNSNAMES.ORA) tells LREG where to register services. If the listener is running on host1.abc.com:1521, LREG will find it without a LISTENER.ORA entry. However, LISTENER.ORA is needed tostartthe listener process, but that's separate from dynamic registration.
Practical Note:If LISTENER.ORA isn't configured, a default listener might run on port 1521, but the question implies LISTENER_1 is operational.
C . The LREG process registers services dynamically with the LISTENER_1 listener.
True. In Oracle 23ai, the LREG background process (replacing PMON's registration role in earlier versions) dynamically registers database services with listeners specified by LOCAL_LISTENER. Here, LOCAL_LISTENER=LISTENER_1 resolves to host1.abc.com:1521 via TNSNAMES.ORA. LREG periodically sends service information (e.g., service names, instance details) to the listener, enabling clients to connect without static configuration.
Mechanics:LREG uses the TNS alias (LISTENER_1) to locate the listener's IP and port, registers services like orcl or orclpdb, and updates the listener's service table. This happens automatically every 60 seconds or on significant events (e.g., instance startup).
D . Dynamic service registration cannot be used for this database instance.
False. The setup (LOCAL_LISTENER set and a valid TNSNAMES.ORA entry) explicitly supports dynamic registration. No blockers (e.g., REGISTRATION_EXCLUDED_LISTENERS) are mentioned, so LREG can function normally.
E . There are two listeners named LISTENER and LISTENER_1 running simultaneously using port 1521 on the same host as the database in LISTENERS.
False. The question mentions only LISTENER_1 in the SPFILE and TNSNAMES.ORA. There's no evidence of a second listener (LISTENER) or a LISTENERS configuration (possibly a typo). Two listeners can't share the same port (1521) on the same host due to port conflicts unless explicitly configured with different IPs, which isn't indicated here.
NEW QUESTION # 59
Which three statements are true about a dedicated server configuration?
- A. A dedicated server process communicates directly with a client or middle-tier process once the session is established.
- B. A dedicated server process can be spawned without a listener when using local clients.
- C. The DBA configures the maximum number of dedicated server processes that can share the samedispatcher process.
- D. A dedicated server process can be spawned by the listener when using local clients.
- E. A dedicated server process may be reused by a new session after the session using that process terminates.
- F. Each dedicated server process has its own dispatcher process.
Answer: A,B,D
Explanation:
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.
NEW QUESTION # 60
How do you validate that the database was migrated to Unified Auditing?
- A. By querying V$OPTION for parameter Unified Auditing.
- B. By using the LSINVENTORY Command to query the Oracle Database Software Library.
- C. By executing DBMS_AUDIT_MGMT PL/SQL package in Verify mode.
- D. By querying the DBA_UNIFIED_AUDIT_OPTION view.
Answer: A
Explanation:
Unified Auditing is enabled at database creation or migration in 23ai. Let's analyze:
A . By querying V$OPTION for parameter Unified Auditing.
True. SELECT VALUE FROM V$OPTION WHERE PARAMETER = 'Unified Auditing'; returns TRUE if enabled. It's the definitive way to confirm Unified Auditing is active at the database level.
Mechanics:V$OPTION reflects compiled-in features; TRUE indicates the binary was linked with Unified Auditing (uniauflt=on during relink).
Practical Use:Quick, reliable check post-migration or upgrade.
B . By using the LSINVENTORY Command to query the Oracle Database Software Library.
False. LSINVENTORY (from OPatch) lists installed software components, not runtime features like auditing mode.
C . By querying the DBA_UNIFIED_AUDIT_OPTION view.
False. This view doesn't exist; DBA_AUDIT_POLICIES or UNIFIED_AUDIT_TRAIL show policies and records but not migration status.
D . By executing DBMS_AUDIT_MGMT PL/SQL package in Verify mode.
False. No "Verify mode" exists in DBMS_AUDIT_MGMT; it manages audit trails, not migration validation.
NEW QUESTION # 61
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 two types of analyses can be done using the DBMS_PRIVILEGE_CAPTURE package?
- A. Analysis of all privileges used by the SYS user.
- B. Analysis of privileges granted directly to a role that are then used by a user who has been granted that role.
- C. Analysis of privileges granted indirectly to a role that are then used by a user who has been granted that role.
- D. Analysis of privileges that a user has on their own schema objects.
- E. Analysis of privileges that a user has on other schemas' objects.
Answer: B,C
Explanation:
A .False. Limited to captured privileges, not all schema objects.
B .False. SYS is excluded from capture.
C .True. Captures indirect role privileges used.
D .True. Captures direct role privileges used.
E .False. Focus is on roles, not self-owned objects broadly.
NEW QUESTION # 62
Which two statements describe why Database Auditing is a security requirement?
- A. To monitor suspicious activity.
- B. To protect against data corruption.
- C. To monitor proper usage of the system and data by privileged users.
- D. To protect against data theft by a non-authorized user.
- E. To alert DBAs about system issues.
Answer: A,C
Explanation:
A .True. Auditing tracks suspicious actions.
B .False. That's monitoring, not auditing.
C .False. Auditing detects, doesn't prevent.
D .False. Corruption is a reliability issue.
E .True. Ensures privileged user compliance.
NEW QUESTION # 63
Which two AWR-based tools listed below are part of Oracle Database self-tuning components?
- A. Automatic capture of statistical information from the SGA and storing it in the AWR using Automatic Database Diagnostic.
- B. Automatic Application Tracing used to collect High-Load SQL statements and statistics.
- C. Automatic Application Tracing used to collect High-Load SQL statements and statistics.
- D. Automatic population of performance views (V$ views) from statistical data stored in AWR repository and using Automatic Database Diagnostic.
- E. ADDM, a server-based expert that reviews database performance statistics captured by Snapshots to identify potential problems before system performance degrades noticeably.
- F. Automatic Diagnostic Collector used to capture and store database errors and hung analysis.
Answer: A,E
Explanation:
False. No "Automatic Application Tracing" exists as an AWR tool. SQL tracing (e.g., DBMS_MONITOR) is manual, and high-load SQL is captured by AWR indirectly via V$SQL snapshots, not a distinct tracing tool.
Why Incorrect:Conflates manual tracing with AWR's passive collection.
Explanation:
The Automatic Workload Repository (AWR) is a cornerstone of Oracle's self-tuning capabilities, collecting and storing performance statistics for analysis. Let's dissect each option:
A : Automatic capture of statistical information from the SGA and storing it in the AWR using Automatic Database Diagnostic.
True. AWR automatically captures statistics (e.g., wait events, SQL stats) from the System Global Area (SGA) via the MMON (Manageability Monitor) process, storing them in the AWR repository (in SYSAUX). This is part of the Automatic Database Diagnostic Monitor (ADDM) framework, though "Automatic Database Diagnostic" likely refers to this broader mechanism.
Mechanics:Snapshots are taken hourly by default (configurable via DBMS_WORKLOAD_REPOSITORY.MODIFY_SNAPSHOT_SETTINGS), persisting data like DBA_HIST_SYSSTAT for self-tuning analysis.
Practical Use:Enables historical performance tracking, feeding tools like ADDM and SQL Tuning Advisor.
Edge Case:If STATISTICS_LEVEL=BASIC, AWR collection is disabled, haltingself-tuning.
Historical Note:Introduced in 10g, enhanced in 23ai for finer granularity.
B : ADDM, a server-based expert that reviews database performance statistics captured by Snapshots to identify potential problems before system performance degrades noticeably.
True. The Automatic Database Diagnostic Monitor (ADDM) analyzes AWR snapshots to proactively detect issues (e.g., high CPU usage, I/O bottlenecks) and recommend fixes. It runs automatically after each snapshot in maintenance windows.
Mechanics:ADDM uses DBA_ADVISOR_FINDINGS to log issues, leveraging AWR data like DBA_HIST_SQLSTAT. Example: It might suggest adding an index for a slow query.
Practical Use:Prevents performance degradation in production systems by catching trends early.
Edge Case:Limited by snapshot frequency; real-time issues may need manual intervention.
C : Automatic Diagnostic Collector used to capture and store database errors and hung analysis.
False. No such tool exists as an "Automatic Diagnostic Collector" in AWR context. This likely confuses the Incident Packaging Service (IPS) or ADR (Automatic Diagnostic Repository), which handles errors but isn't AWR-based or self-tuning.
Why Incorrect:ADR collects trace files and logs, not AWR statistics, and isn't part of self-tuning.
D : Automatic population of performance views (V$ views) from statistical data stored in AWR repository and using Automatic Database Diagnostic.
False. V$ views (e.g., V$SESSION) are real-time memory structures in the SGA, not populated from AWR, which is historical (e.g., DBA_HIST_*). AWR doesn't back-feed V$ views; the reverse occurs via snapshots.
Why Incorrect:Misunderstands the data flow; AWR is a sink, not a source for V$ views.
NEW QUESTION # 64
Which statement regarding PDBs (Pluggable Databases) is correct?
- A. You can drop a PDB as long as it is not the PDB seed.
- B. You cannot drop a source PDB of a refreshable PDB.
- C. When the relocation of a PDB is finished, the source PDB must be dropped.
- D. You can drop an application root along with the associated PDBs.
Answer: A
Explanation:
A .True. Any PDB except PDB$SEED can be dropped.
B .False. Source PDBs of refreshable clones can be dropped after cloning.
C .False. Dropping an application root requires explicit handling of PDBs.
D .False. Relocation doesn't mandate dropping the source PDB.
NEW QUESTION # 65
Which three statements are true about dynamic performance views?
- A. They are owned by the SYSTEM user.
- B. They can be queried only when the database is open.
- C. Read consistency is not guaranteed.
- D. V$FIXED_TABLE can be queried to display the names of all dynamic performance views.
- E. Data displayed by querying dynamic performance views is derived from metadata in the data dictionary.
Answer: C,D,E
Explanation:
A .True. V$ views reflect real-time memory data, not consistent snapshots.
B .True. V$FIXED_TABLE lists all V$ views.
C .True. Data comes from memory structures and data dictionary metadata.
D .False. Owned by SYS, not SYSTEM.
E .False. Some V$ views are accessible in MOUNT state.
NEW QUESTION # 66
Examine this command: ALTER DATABASE MOVE DATAFILE '\u01/sales1.dbf' TO '\u01/sales01.dbf' REUSE; Which two statements are true?
- A. DML may be performed on tables with one or more extents in this data file during the execution of this command.
- B. The file is renamed and stored in the same location.
- C. If Oracle Managed Files (OMF) is used, then the file is renamed but moved to DB_CREATE_FILE_DEST.
- D. The tablespace containing SALES1.DBF must be altered READ ONLY before executing the command.
- E. The tablespace containing SALES1.DBF must be altered OFFLINE before executing the command.
Answer: A,B
Explanation:
This command moves/renames a data file online. Let's evaluate:
A . DML may be performed on tables with one or more extents in this data file during the execution of this command.
True. Introduced in 12c and refined in 23ai, MOVE DATAFILE is an online operation, allowing DML (e.g., INSERT, UPDATE) on tables within the file. Oracle ensures consistency via redo and undo.
Mechanics:The file is copied to the new location/name while tracking changes, then switched atomically.
Practical Use:Minimizes downtime in production systems.
B . If Oracle Managed Files (OMF) is used, then the file is renamed but moved to DB_CREATE_FILE_DEST.
False. With OMF, omitting the TO clause would place the file in DB_CREATE_FILE_DEST, but here, TO '\u01/sales01.dbf' explicitly specifies the target, overriding OMF defaults.
Mechanics:OMF only applies if the destination is unspecified (e.g., MOVE DATAFILE ... without TO).
Why Incorrect:Explicit path trumps OMF behavior.
C . The tablespace containing SALES1.DBF must be altered READ ONLY before executing the command.
False. READ ONLY isn't required; the operation is online and supports active use.
Why Incorrect:Conflicts with Oracle's online move feature.
D . The file is renamed and stored in the same location.
True. The command renames /u01/sales1.dbf to /u01/sales01.dbf (correcting \u01 to /u01 as a Windows/Unix typo), keeping it in /u01/. REUSE allows overwriting if sales01.dbf exists.
Mechanics:File is copied and renamed in-place within the same filesystem directory.
E . The tablespace containing SALES1.DBF must be altered OFFLINE before executing the command.
False. Offline mode isn't needed; the online move handles activetablespaces.
NEW QUESTION # 67
Which two statements are true about database instances and Real Application Clusters (RAC)?
- A. A RAC database can have one instance.
- B. A RAC database can have instances on separate servers.
- C. Two RAC databases can share their instances.
- D. A RAC database must have three or more instances.
- E. A RAC database must have two or more instances.
Answer: A,B
Explanation:
A .False. RAC can run with one instance (degraded mode).
B .True. Possible, though not typical for RAC.
C .False. No minimum of three.
D .True. RAC instances run on separate nodes.
E .False. Instances are DB-specific in RAC.
NEW QUESTION # 68
You must create a tablespace of nonstandard block size in a new file system and plan to use this command: CREATE TABLESPACE ns_tbs DATAFILE '/u02/oracle/data/nstbs_f01.dbf' SIZE 100G BLOCKSIZE 32K; The standard block size is 8K, but other nonstandard block sizes will also be used. Which two are requirements for this command to succeed?
- A. DB_32K_CACHE_SIZE must be set to a value that can be accommodated in the SGA.
- B. DB_32K_CACHE_SIZE should be set to a value greater than DB_CACHE_SIZE.
- C. The operating system must use a 32K block size.
- D. DB_32K_CACHE_SIZE must be less than DB_CACHE_SIZE.
- E. The /u02 file system must have at least 100G space for the datafile.
Answer: A,E
Explanation:
A .False. No such restriction exists; DB_32K_CACHE_SIZE is independent of DB_CACHE_SIZE.
B .True. A nonstandard block size (32K) requires a corresponding cache (DB_32K_CACHE_SIZE) set to a non-zero value within SGA limits.
C .False. OS block size is irrelevant; Oracle manages its own block sizes.
D .False. No requirement for it to exceed DB_CACHE_SIZE.
E .True. The file system must have 100G available for the datafile.
NEW QUESTION # 69
Examine these commands:
[oracle@host01 ~]$ sqlplus u1/oracle
SQL> SELECT * FROM emp;
ENO ENAME DN
-------------------------
1 Alan 2
2 Ben 2
SQL> exit
[oracle@host01 ~]$ cat emp.dat
1, Alan, 2
3, Curl, 4
4, Bob, 4
[oracle@host01 ~]$ sqlldr u1/oracle TABLE=emp
Which two statements are true?
- A. It appends data from EMP.DAT to EMP.
- B. It overwrites all data in EMP with data from EMP.DAT.
- C. It generates a SQL script that it uses to load data from EMP.DAT to EMP.
- D. It generates a log that contains control file entries, which can be used with normal SQL*Loader operations.
- E. It overwrites the data for Alan and adds data for Curl and Bob.
Answer: A,D
Explanation:
SQL*Loader (sqlldr) loads data from external files into Oracle tables. The command sqlldr u1/oracle TABLE=emp uses defaults since no control file is specified. Let's evaluate:
A . It overwrites the data for Alan and adds data for Curl and Bob.
False. SQLLoader's default mode is APPEND, not REPLACE. It doesn't "overwrite" existing rows unless REPLACE or TRUNCATE is specified in a control file. Here, row 1, Alan, 2 exists, and SQLLoader will either skip it (if a primary key rejects duplicates) or raise an error, but it won't overwrite. 3, Curl, 4 and 4, Bob, 4 are appended.
Mechanics:Without a control file, SQL*Loader assumes APPEND and matches columns positionally (ENO, ENAME, DN).
B . It generates a log that contains control file entries, which can be used with normal SQL*Loader operations.
True. SQL*Loader always generates a log file (e.g., emp.log) when invoked. With no control file specified, it auto-generates one internally and logs it, including entries like LOAD DATA INFILE 'emp.dat' APPEND INTO TABLE emp FIELDS TERMINATED BY ',' (ENO, ENAME, DN). This can be reused.
Practical Use:The log's control section is editable for future runs (e.g., changing to REPLACE).
C . It appends data from EMP.DAT to EMP.
True. Default behavior without a control file is APPEND, adding new rows (3, Curl, 4 and 4, Bob, 4) to EMP. Existing rows (1, Alan, 2, 2, Ben, 2) remain unless constrained (e.g., unique key violations).
Mechanics:SQL*Loader processes each line of emp.dat, skipping duplicates if constrained, appending otherwise.
D . It generates a SQL script that it uses to load data from EMP.DAT to EMP.
False. SQL*Loader doesn't generate SQL scripts; it uses direct path or conventional path loading, not SQL scripts. The log contains control file syntax, not a script.
E . It overwrites all data in EMP with data from EMP.DAT.
False. REPLACE or TRUNCATE would overwrite, but these require a control file with those options. Default APPEND preserves existing data.
NEW QUESTION # 70
You want to view the initialization parameter settings for only a specific PDB. Which of the following statements is true?
- A. From the CDB root, execute SELECT NAME, VALUE, ISPDB_MODIFIABLE FROM v$parameter;
- B. From the PDB, execute SELECT NAME, VALUE, ISPDB_MODIFIABLE FROM v$parameter;
- C. From the CDB root, execute SELECT db_uniq_name, pdb_uid, name, value$ FROM pdb_spfiles;
- D. From the PDB, execute SELECT db_uniq_name, pdb_uid, name, value$ FROM pdb_spfile$;
Answer: B
Explanation:
A .Incorrect syntax and view (pdb_spfile$ is not a valid view; PDB_SPFILE$ exists but lacks value$).
B .From CDB root, V$PARAMETER shows all parameters, not PDB-specific ones.
C .pdb_spfiles is not a valid view; PDB_SPFILE$ exists but requires scoping to a PDB.
D .True. From the PDB, V$PARAMETER shows parameters specific to that PDB, including inherited and PDB-modified values, with ISPDB_MODIFIABLE indicating alterability.
NEW QUESTION # 71
Which advisor is used to detect missing or stale object statistics?
- A. SQL Access Advisor
- B. SQL Statistics Advisor
- C. SQL Tuning Advisor
- D. SQL Performance Analyzer
Answer: B
Explanation:
B .True. The SQL Statistics Advisor (new in 23ai) identifies stale or missing statistics. Others focus on tuning, performance analysis, or access paths.
NEW QUESTION # 72
Examine this command: ALTER DATABASE MOVE DATAFILE '/u01/sales01.dbf' TO '/u02/sales02.dbf'; Which two statements are true?
- A. DML may be performed on tables with one or more extents in this data file during the execution of this command.
- B. The "TO" clause containing the new file name must be specified even if Oracle Managed Files (OMF) is used.
- C. Tables with one or more extents in this data file may be queried during the execution of this command.
- D. Compressed objects in sales01.dbf will be uncompressed in sales02.dbf after the move.
- E. It overwrites any existing file with the name sales02.dbf in /u02 by default.
Answer: A,C
Explanation:
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.
NEW QUESTION # 73
You unplugged a PDB to plug it into another CDB with the following command: SQL> ALTER PLUGGABLE DATABASE pdb1 UNPLUG INTO '/tmp/pdb1.pdb'; Which statement is true prior to plugging the PDB into the other CDB?
- A. PDB archive file and only the user-defined tablespaces must be copied to the target CDB.
- B. The PDB manifest and all the datafiles must be copied to the target CDB.
- C. The PDB manifest, the data files, and the PDB archive file must be copied to the target CDB.
- D. The PDB archive file must be copied to the target CDB.
Answer: C
Explanation:
D .True. The .pdb file (archive) contains the manifest and data files; all must be copied to the target CDB for plugging.
A-C .False. The archive alone isn't enough; all components are needed.
NEW QUESTION # 74
As the DBA, you execute this command: GRANT CREATE VIEW TO usr1 WITH ADMIN OPTION; USR1 then executes: GRANT CREATE VIEW TO usr2 WITH ADMIN OPTION; USR2 then executes: GRANT CREATE VIEW TO usr3; Which statement is true?
- A. When the DBA revokes the CREATE VIEW privilege from USR1, it is neither revoked from USR2 nor USR3.
- B. USR1 can revoke the CREATE VIEW privilege from USR3.
- C. When the DBA revokes the CREATE VIEW privilege from USR2, it is revoked from USR3.
- D. The DBA can revoke only ADMIN OPTION from USR1.
- E. When the DBA revokes the CREATE VIEW privilege from USR1, it is revoked from USR2 but not USR3.
Answer: A,C
Explanation:
A .False. Revoking from USR1 doesn't cascade due to WITH ADMIN OPTION.
B .True. Revoking from USR2 cascades to USR3 because USR2 granted it.
C .False. DBA can revoke the full privilege, not just ADMIN OPTION.
D .False. USR1 can't revoke from USR3 directly; only the grantor (USR2) can.
E .True. WITH ADMIN OPTION breaks the revoke chain from USR1 onward.
NEW QUESTION # 75
Which three statements are true about roles?
- A. All roles granted to a user are set on default when the user logs in.
- B. Roles must be password protected.
- C. Roles may be granted to other roles.
- D. Object privileges may not be granted to roles.
- E. The SET ROLE statement can enable one or more roles for a session.
- F. The SET ROLE statement can disable one or more roles for a session.
Answer: C,E,F
Explanation:
Roles in Oracle manage privileges efficiently. Let's dive into each option:
A . Roles must be password protected.
False. Roles can be password-protected (e.g., CREATE ROLE mgr IDENTIFIED BY secret), but it's optional. Non-protected roles (default) are enabled automatically if granted, requiring no password.
Mechanics:Password-protected roles need SET ROLE mgr IDENTIFIED BY secret, enhancing security for sensitive privileges.
B . Roles may be granted to other roles.
True. Roles can form hierarchies (e.g., GRANT clerk TO mgr), allowing nested privilege management.
Mechanics:A user with mgr inherits clerk privileges indirectly. Revoking clerk from mgr cascades appropriately.
Practical Use:Simplifies complex privilege structures in large organizations.
C . The SET ROLE statement can enable one or more roles for a session.
True. SET ROLE role1, role2; activates specified roles for the session, assuming they're granted and not password-protected (or password is provided).
Mechanics:Enabled roles grant their privileges immediately within the session scope.
D . Object privileges may not be granted to roles.
False. Object privileges (e.g., GRANT SELECT ON emp TO clerk) are a primary use of roles, making this statement incorrect.
Why Incorrect:Roles are designed for this purpose, contradicting the option.
E . All roles granted to a user are set on default when the user logs in.
False. Only roles marked as DEFAULT ROLE (via ALTER USER ... DEFAULT ROLE role1) are enabled at login. Non-default roles require SET ROLE.
Mechanics:Check via SELECT * FROM DBA_ROLE_PRIVS WHERE DEFAULT_ROLE='YES'.
F . The SET ROLE statement can disable one or more roles for a session.
True. SET ROLE NONE disables all roles, or SET ROLE role1 implicitly disables others not listed, providing granular control.
Practical Use:Useful for testing or restricting privileges temporarily.
NEW QUESTION # 76
Script abc.sql must be executed to perform a certain task. User HR with password HR exists in the target database and the account is unlocked. The TNSNAMES.ORA file is up to date. Examine this command attempted by the user: $ sqlplus hr/hr@orcl @abc. What will happen and why?
- A. The command succeeds and HR will be connected to the orcl database instance, and the abc script will be executed.
- B. The command succeeds and HR will be connected to the orcl database instance, and the abc script will be executed.
- C. The command fails and reports an error because @ is used twice.
- D. The command succeeds and HR will be connected to the orcl database and after logging out to the abc database.
- E. The command fails because the script must refer to the full path name.
Answer: A
Explanation:
A .False. "Logging out to the abc database" is nonsensical; abc is a script, not a database.
B .False. SQL*Plus finds abc.sql in the current directory by default; a full path isn't required unless it's elsewhere.
C .False. The first @ specifies the TNS alias (orcl), the second runs the script (@abc); this is valid syntax.
D & E.True (identical options). The command connects to orcl via TNSNAMES.ORA, authenticates HR, and executes abc.sql.
Mechanics:sqlplus hr/hr@orcl resolves orcl to a listener address, connects, and@abc runs the script post-login.
NEW QUESTION # 77
You have connected to a PDB to perform the administration operations of changing and verifying a system parameter that is PDB_MODIFIABLE. What is the appropriate mode to open the PDB to achieve this?
- A. RESTRICTED READ ONLY
- B. RESTRICTED WRITE ONLY
- C. READ WRITE
- D. READ ONLY
Answer: C
Explanation:
To change a PDB_MODIFIABLE parameter, the PDB must be in READ WRITE mode, allowing ALTER SYSTEM commands to modify parameters stored in the PDB's SPFILE or memory. READONLY modes prevent modifications, and no RESTRICTED WRITE ONLY mode exists.
NEW QUESTION # 78
......
1Z0-182 Dumps are Available for Instant Access: https://torrentpdf.validvce.com/1Z0-182-exam-collection.html
