I85PREP
⌘ K
1Z0-908 study materials
1Z0-908 study resources

1Z0-908 practice questions

One question at a time. Build your 1Z0-908 understanding.

First 50 of 200 questions. Each one lists the choices, the correct answer, and an explanation. The checker at the top of this page saves progress in this browser when it is available.

Continue in the practice tool above to load more questions, 50 at a time.

Question 1Architecture and Configuration

Which MySQL 8.0 storage engine is the default transactional engine that supports row-level locking, foreign keys, and crash recovery?

  1. MEMORY
  2. InnoDB Correct answer.
  3. MyISAM
  4. CSV

Explanation

InnoDB is the default storage engine in MySQL 8.0 and provides ACID transactions, row-level locking, foreign key constraints, and crash-safe recovery through redo logs. MyISAM and CSV are non-transactional, and MEMORY keeps data in RAM without durability.

Question 2Architecture and Configuration

Which file in a MySQL 8.0 data directory contains the InnoDB system tablespace and the data dictionary?

  1. mysql.ibd Correct answer.
  2. ibdata1
  3. auto.cnf
  4. ib_logfile0

Explanation

In MySQL 8.0 the data dictionary is stored in the mysql.ibd tablespace inside the data directory, replacing the .frm files used by earlier releases. ibdata1 holds the InnoDB system tablespace, and ib_logfile0 is a redo log file.

Question 3Architecture and Configuration

A DBA wants MySQL to resolve unqualified object names using the database named in the connection rather than requiring fully qualified names. Which behavior must be in effect?

  1. The server must be started with lower_case_table_names=1.
  2. The client must connect with a default database selected. Correct answer.
  3. The user must hold the SELECT privilege on mysql.*.
  4. The SQL_MODE must include ANSI_QUOTES.

Explanation

When a connection has a default database (for example via USE db or the database argument of a client), unqualified table names resolve against that schema. Without a default database, every reference must be schema-qualified.

Question 4Architecture and Configuration

Which statement about MySQL 8.0 redo log configuration is correct?

  1. innodb_log_files_in_group must be set to at least 4.
  2. Redo log files are stored in the innodb_undo_directory.
  3. innodb_redo_log_capacity replaces innodb_log_file_size and innodb_log_files_in_group. Correct answer.
  4. innodb_log_file_size can be changed at runtime without a restart.

Explanation

MySQL 8.0.30 introduced innodb_redo_log_capacity, which controls total redo log space and supersedes the older innodb_log_file_size and innodb_log_files_in_group variables. The server manages a pool of redo log files automatically.

Question 5Architecture and Configuration

A DBA needs to isolate InnoDB undo logs on a dedicated fast disk. Which variable controls where undo tablespaces are created?

  1. innodb_temp_data_file_path
  2. innodb_log_group_home_dir
  3. innodb_undo_directory Correct answer.
  4. innodb_data_home_dir

Explanation

innodb_undo_directory specifies the path where InnoDB creates undo tablespace files. In MySQL 8.0 undo tablespaces can also be relocated with ALTER INSTANCE, but the directory variable defines their default location.

Question 6Architecture and Configuration

Which MySQL 8.0 privilege is required by a user to create a new role and grant it to other users?

  1. ROLE_ADMIN Correct answer.
  2. GRANT OPTION
  3. CREATE ROLE
  4. SUPER

Explanation

ROLE_ADMIN is a dynamic privilege introduced in MySQL 8.0 that allows a user to create roles, drop roles, and grant or revoke roles. It is distinct from the ability to grant object privileges, which requires GRANT OPTION.

Question 7Architecture and Configuration

Which statement best describes the purpose of the MySQL 8.0 binary log?

  1. It stores the data dictionary and table metadata for the server.
  2. It contains the InnoDB buffer pool contents for fast restart.
  3. It holds the list of currently connected sessions and their state.
  4. It records committed row changes used for replication and point-in-time recovery. Correct answer.

Explanation

The binary log records events describing data changes (and optionally statement text) and is the basis for replication and point-in-time recovery. It is enabled with log_bin and is separate from the data dictionary and session state.

Question 8Architecture and Configuration

A DBA wants to limit the amount of memory used by the InnoDB buffer pool to roughly 4 GB on a dedicated database host. Which configuration change is appropriate?

  1. Set key_buffer_size=4G.
  2. Set sort_buffer_size=4G.
  3. Set innodb_log_buffer_size=4G.
  4. Set innodb_buffer_pool_size=4G. Correct answer.

Explanation

innodb_buffer_pool_size controls the size of the InnoDB buffer pool, which caches data and index pages in memory. On a dedicated server it is typically the largest memory consumer and should be sized to a large fraction of available RAM.

Question 9Architecture and Configuration

Which MySQL 8.0 feature allows a DBA to configure the server to accept connections on a Unix socket only and disable TCP/IP listening?

  1. Set socket=mysql.sock.
  2. Set bind_address=127.0.0.1.
  3. Set skip_networking=ON. Correct answer.
  4. Set skip_name_resolve=ON.

Explanation

skip_networking disables TCP/IP connections entirely, forcing clients to use the Unix socket (or named pipe on Windows) or shared memory. bind_address=127.0.0.1 still listens on TCP loopback.

Question 10Architecture and Configuration

Which statement about MySQL 8.0 temporary tables is correct?

  1. Temporary tables are always persisted in the binary log.
  2. Temporary tables can be shared across sessions by name.
  3. Temporary tables use session temporary tablespaces in the ibtmp1 file pool. Correct answer.
  4. Temporary tables are stored in the InnoDB system tablespace.

Explanation

In MySQL 8.0, session temporary tables are stored in session temporary tablespaces backed by the ibtmp1 file pool, and they are private to the session that created them. They are not written to the binary log in row-based mode.

Question 11Architecture and Configuration

A DBA sees the error 'Too many connections' during peak load. Which server variable should be raised to allow more concurrent client sessions?

  1. table_open_cache
  2. max_connections Correct answer.
  3. thread_cache_size
  4. open_files_limit

Explanation

max_connections caps the number of simultaneous client connections the server permits. Raising it allows more sessions, though open_files_limit and OS limits may also need adjustment.

Question 12Architecture and Configuration

Which MySQL 8.0 option enables the server to validate that each client connection uses TLS and to reject plaintext connections?

  1. ssl_cipher=AES256-SHA
  2. ssl_mode=REQUIRED
  3. require_secure_transport=ON Correct answer.
  4. tls_version=TLSv1.2

Explanation

require_secure_transport=ON forces all client connections to use TLS or another secure transport and rejects unencrypted sessions. ssl_mode is a client-side option, while tls_version and ssl_cipher configure protocol details rather than mandating encryption.

Question 13Architecture and Configuration

Which InnoDB file-per-table behavior is controlled by the innodb_file_per_table variable?

  1. Whether each InnoDB table has its own .ibd tablespace file. Correct answer.
  2. Whether undo logs are stored per table.
  3. Whether InnoDB uses compressed pages in the buffer pool.
  4. Whether redo logs are written per table.

Explanation

With innodb_file_per_table=ON (the default in MySQL 8.0), each InnoDB table is stored in its own .ibd tablespace file rather than the shared system tablespace. This simplifies space reclamation and supports features like table compression and encryption.

Question 14Architecture and Configuration

A DBA wants to ensure that a specific user can read a table but cannot modify it, even if the user is later granted a broader role. Which approach is most appropriate in MySQL 8.0?

  1. Grant SELECT on *.* to the user to simplify administration.
  2. Grant the user the SUPER privilege and rely on application-level checks.
  3. Grant SELECT on the table to the user directly and avoid granting write privileges. Correct answer.
  4. Grant SELECT on the table to a role and grant the role to the user.

Explanation

Directly granting only SELECT on the specific table follows least privilege and limits the user to read access. Roles are useful for grouping privileges, but a role with only SELECT still needs careful management to avoid later expansion.

Question 15Architecture and Configuration

Which MySQL 8.0 component stores optimizer statistics and can be configured to persist statistics across server restarts?

  1. The InnoDB persistent statistics tables. Correct answer.
  2. The mysql.plugin table.
  3. The performance_schema tables.
  4. The general query log.

Explanation

InnoDB persistent optimizer statistics are stored in internal tables and remain available after a restart when innodb_stats_persistent is enabled. This provides stable execution plans compared with transient statistics.

Question 16Architecture and Configuration

Which statement about the MySQL 8.0 data dictionary is correct?

  1. It stores metadata in .frm files alongside each table.
  2. It stores metadata in transactional InnoDB tables. Correct answer.
  3. It is maintained only in memory and rebuilt at startup.
  4. It is stored in MyISAM tables in the mysql schema.

Explanation

The MySQL 8.0 data dictionary stores object metadata in hidden InnoDB tables within the mysql.ibd tablespace, making metadata operations transactional and crash-safe. The older .frm file approach was removed in 8.0.

Question 17Architecture and Configuration

A DBA wants to change the default storage engine for new tables created without an explicit ENGINE clause. Which action accomplishes this?

  1. Set innodb_default_row_format=DYNAMIC.
  2. Run ALTER TABLE on every existing table.
  3. Set default_storage_engine=InnoDB at startup or session level. Correct answer.
  4. Set storage_engine=MyISAM in my.cnf.

Explanation

default_storage_engine determines the engine used when a CREATE TABLE statement omits ENGINE. It can be set globally or per session, and InnoDB is the built-in default in MySQL 8.0.

Question 18Architecture and Configuration

Which MySQL 8.0 mechanism allows an administrator to limit the number of statements or connections a single account can make per hour?

  1. Password expiration policies
  2. Resource groups
  3. Account resource limits Correct answer.
  4. The max_user_connections variable only

Explanation

Account resource limits, configured with CREATE USER or ALTER USER ... WITH MAX_QUERIES_PER_HOUR, MAX_UPDATES_PER_HOUR, MAX_CONNECTIONS_PER_HOUR, and MAX_USER_CONNECTIONS, throttle activity per account. Resource groups instead bind threads to CPU resources.

Question 19Architecture and Configuration

A DBA wants to enable the slow query log and capture statements that take longer than two seconds. Which two settings are required?

  1. slow_query_log=ON and log_queries_not_using_indexes=ON
  2. general_log=ON and long_query_time=2
  3. log_error=ON and long_query_time=2
  4. slow_query_log=ON and long_query_time=2 Correct answer.

Explanation

slow_query_log enables the slow query log, and long_query_time sets the threshold in seconds above which statements are logged. Both must be configured for the intended behavior.

Question 20Architecture and Configuration

Which MySQL 8.0 statement correctly creates a user that authenticates with the caching_sha2_password plugin and requires TLS?

  1. CREATE USER 'app'@'%' IDENTIFIED BY 'S3cret!' ACCOUNT LOCK;
  2. CREATE USER 'app'@'%' IDENTIFIED BY 'S3cret!' PASSWORD EXPIRE;
  3. CREATE USER 'app'@'%' IDENTIFIED WITH caching_sha2_password BY 'S3cret!' REQUIRE SSL; Correct answer.
  4. CREATE USER 'app'@'%' IDENTIFIED WITH mysql_native_password BY 'S3cret!';

Explanation

The CREATE USER syntax supports IDENTIFIED WITH plugin BY password to select an authentication plugin and REQUIRE SSL to mandate encrypted connections. caching_sha2_password is the default plugin in MySQL 8.0.

Question 21Architecture and Configuration

Which statement about MySQL 8.0 resource groups is correct?

  1. They define password complexity rules for accounts.
  2. They assign threads to CPU sets and thread priorities on supported platforms. Correct answer.
  3. They control the size of the InnoDB buffer pool per schema.
  4. They restrict which users may connect from a given host.

Explanation

Resource groups let administrators map threads to CPU affinity and set thread priority, helping isolate workloads on supported operating systems. They are managed with CREATE RESOURCE GROUP and the RESOURCE_GROUP thread attribute.

Question 22Architecture and Configuration

Which MySQL 8.0 variable controls the maximum size of a single packet or generated or intermediate row sent between client and server?

  1. max_connect_errors
  2. max_allowed_packet Correct answer.
  3. thread_stack
  4. net_buffer_length

Explanation

max_allowed_packet sets the upper bound on the size of a single communication packet and on certain generated or intermediate rows. It must be large enough for the biggest statements or row values clients send.

Question 23Architecture and Configuration

An administrator needs to inspect which InnoDB tables currently hold locks and which transactions are waiting. Which source provides this information in MySQL 8.0?

  1. The binary log index file.
  2. The slow query log.
  3. The performance_schema data_locks and data_lock_waits tables. Correct answer.
  4. The mysql.user table.

Explanation

performance_schema.data_locks and data_lock_waits expose current InnoDB lock information and blocking relationships. These tables replace the older INFORMATION_SCHEMA.INNODB_LOCKS views removed in MySQL 8.0.

Question 24Architecture and Configuration

Which statement about MySQL 8.0 atomic DDL is correct?

  1. DDL cannot be executed while binary logging is enabled.
  2. Data definition statements are transactional and either fully succeed or fully roll back. Correct answer.
  3. DDL requires the SUPER privilege for all users.
  4. DDL statements are always written to the binary log as row events.

Explanation

MySQL 8.0 supports atomic DDL for InnoDB tables, so a data definition statement either completes entirely or is rolled back, avoiding partial metadata changes. This improves crash safety compared with earlier releases.

Question 25Architecture and Configuration

A DBA wants MySQL to use the operating system's native asynchronous I/O for InnoDB data files on Linux. Which variable should be configured?

  1. innodb_flush_method
  2. innodb_io_capacity
  3. innodb_doublewrite
  4. innodb_use_native_aio Correct answer.

Explanation

innodb_use_native_aio enables or disables the use of native asynchronous I/O for InnoDB data file reads and writes on platforms that support it. It is enabled by default on Linux.

Question 26Architecture and Configuration

Which MySQL 8.0 server variable determines the maximum number of simultaneous client connections the server will accept?

  1. thread_cache_size
  2. open_files_limit
  3. max_user_connections
  4. max_connections Correct answer.

Explanation

max_connections sets the ceiling on how many client sessions the server will admit at once; once it is reached, new connections are refused with 'Too many connections'. It is a global dynamic variable, so it can be raised at runtime without a restart.

Question 27Architecture and Configuration

A DBA wants new InnoDB tables to be created in a general tablespace named ts1 by default, without specifying TABLESPACE in each CREATE TABLE. Which setting accomplishes this?

  1. innodb_default_row_format=DYNAMIC
  2. innodb_undo_tablespaces=2
  3. default_tablespace='ts1' Correct answer.
  4. innodb_file_per_table=ON

Explanation

The default_tablespace system variable names the tablespace used when a CREATE TABLE statement omits an explicit TABLESPACE clause. Setting it to a general tablespace such as ts1 makes that the implicit location for new InnoDB tables.

Question 28Architecture and Configuration

Which MySQL 8.0 construct lets a DBA define a named set of privileges that can be granted to multiple accounts and later revoked in one operation?

  1. A role Correct answer.
  2. A stored procedure
  3. A user-defined function
  4. A resource group

Explanation

A role is a named collection of privileges created with CREATE ROLE; granting the role to accounts confers all its privileges, and REVOKE of the role removes them together. Roles can also be nested and set as default, simplifying privilege administration at scale.

Question 29Architecture and Configuration

A DBA wants to record every statement that modifies data, including the actual values written, so the log can be replayed to reproduce changes. Which binary logging format should be chosen?

  1. OFF
  2. STATEMENT
  3. ROW Correct answer.
  4. MIXED

Explanation

ROW format logs the before-and-after images of each affected row, so replaying the log reproduces the exact data changes regardless of nondeterministic functions. It is the default in MySQL 8.0 and is required for the safest point-in-time recovery of data modifications.

Question 30Architecture and Configuration

An administrator needs to know which storage engine a table currently uses without reading the .frm metadata. Which MySQL 8.0 source reports the engine for each table in a schema?

  1. INFORMATION_SCHEMA.TABLES Correct answer.
  2. SHOW BINARY LOGS
  3. SHOW ENGINE INNODB STATUS
  4. performance_schema.threads

Explanation

INFORMATION_SCHEMA.TABLES exposes an ENGINE column for every base table, drawn from the data dictionary, so it answers the question for all engines in one query. In MySQL 8.0 the .frm files no longer exist, making the data dictionary views the authoritative source.

Question 31Architecture and Configuration

A DBA wants the server to reject any CREATE TABLE statement that omits an explicit primary key, enforcing a schema standard across the team. Which MySQL 8.0 capability supports this?

  1. Enabling innodb_strict_mode
  2. Setting sql_require_primary_key=ON Correct answer.
  3. Setting sql_mode=STRICT_TRANS_TABLES
  4. Setting require_secure_transport=ON

Explanation

sql_require_primary_key, when enabled, causes CREATE TABLE and ALTER TABLE to fail if the resulting table would have no primary key. It applies to all storage engines and can be set globally or per session, making it a direct enforcement of the schema standard.

Question 32Architecture and Configuration

Which MySQL 8.0 variable specifies the directory where InnoDB writes its redo log files?

  1. datadir
  2. innodb_temp_data_file_path
  3. innodb_data_home_dir
  4. innodb_log_group_home_dir Correct answer.

Explanation

innodb_log_group_home_dir points to the directory holding the InnoDB redo log files, allowing them to be placed on separate storage from the data files. By default it follows the data directory, but it can be set independently to tune I/O.

Question 33Installation and Patching

Which utility is the supported way to install Oracle Database 19c software on a Linux server without creating or configuring a database during installation?

  1. The Database Configuration Assistant run in interactive mode
  2. The Oracle Restart configuration script roothas.pl
  3. The OPatch utility applied to the Oracle home
  4. Oracle Universal Installer run with the -silent and -ignorePrereq flags Correct answer.

Explanation

Oracle Universal Installer (OUI) performs software-only installations when you choose the install-software-only option, and the -silent flag allows it to run without a graphical interface. DBCA is used afterward to create and configure databases, so it is not the software installer.

Question 34Installation and Patching

You must determine the exact patch level of an Oracle Database 19c home before opening a service request. Which command reports the installed patches for that home?

  1. $ORACLE_HOME/bin/dbca -version
  2. $ORACLE_HOME/OPatch/opatch util cleanup
  3. $ORACLE_HOME/OPatch/opatch lspatches Correct answer.
  4. $ORACLE_HOME/bin/srvctl status database

Explanation

opatch lspatches lists each applied patch identifier and description for the Oracle home, which is the authoritative record of the patch level. It must be run from the OPatch directory of the home being investigated.

Question 35Installation and Patching

Which file should you read first to learn the required kernel parameter values for installing Oracle Database 19c on Oracle Linux?

  1. The Oracle Database Installation Guide for Linux Correct answer.
  2. The listener.ora of the target host
  3. The oratab file in /etc
  4. The alert log of an existing database

Explanation

The platform-specific installation guide documents required kernel parameters, packages, and operating system prerequisites for the release. Those values change between releases, so the guide for the exact version is the authoritative source.

Question 36Installation and Patching

What is the purpose of running root.sh at the end of a new Oracle Database 19c software installation on Linux?

  1. It downloads and applies the latest release update automatically
  2. It starts the listener and registers services with the database
  3. It creates the starter database and data dictionary
  4. It performs root-owned configuration steps such as setting permissions on certain binaries and creating central inventory entries Correct answer.

Explanation

root.sh completes privileged setup tasks that the oracle user cannot perform, including ownership and permission changes on server binaries and inventory updates. Database creation is a separate DBCA step and is not part of root.sh.

Question 37Installation and Patching

A patching run failed and you want to return an Oracle home to its state before the failed patch was applied. Which OPatch action is intended for rolling back an applied patch?

  1. opatch version
  2. opatch query -all <patch_id>
  3. opatch apply -id <patch_id>
  4. opatch rollback -id <patch_id> Correct answer.

Explanation

opatch rollback -id reverses a previously applied patch using the rollback information stored in the home. The Oracle home must be shut down for the components being rolled back, and the patch must have been applied with rollback support retained.

Question 38Installation and Patching

You are preparing an Oracle Database 19c installation and need to confirm that the operating system user running OUI belongs to the correct groups. Which group membership is required so that the user can perform ASM administration on the planned Grid Infrastructure home?

  1. The OSDBA group plus the oper group
  2. Only the OSDBA group such as dba
  3. Only the oinstall group
  4. The OSDBA group such as dba plus the OSASM group such as asmadmin Correct answer.

Explanation

ASM administration requires membership in the OSASM group (typically asmadmin) in addition to the OSDBA group used for database administration. The oinstall group controls inventory ownership and is separate from ASM privileges.

Question 39Installation and Patching

Your site must apply a release update to a 19c Oracle home while keeping a tested rollback path. Which preparation step best preserves that option?

  1. Delete the OPatch backup directory to save space before patching
  2. Disable archivelog mode on all databases in the home
  3. Record the current opatch lspatches output and confirm the patch ships rollback information before applying Correct answer.
  4. Drop the database so that patching completes faster

Explanation

Capturing the pre-patch inventory lets you verify the rollback result, and rollback is only possible when the patch includes rollback data. Removing backups or database configuration destroys the ability to restore the prior state.

Question 40Installation and Patching

After installing new 19c binaries into a fresh Oracle home, you want existing databases to use the new home with minimal downtime. Which approach matches Oracle's recommended upgrade path?

  1. Create the new home, run the appropriate upgrade scripts or DBUA against each database, then switch the environment to the new home Correct answer.
  2. Point the old home's oratab entry at the new home without running any scripts
  3. Run OPatch rollback on the old home to promote the new one
  4. Copy the old Oracle home over the new one to reuse configuration

Explanation

Installing into a separate home and then upgrading each database with DBUA or the manual upgrade scripts is the supported method and keeps the old home available for fallback. Simply repointing environment variables leaves the data dictionary at the old version.

Question 41Installation and Patching

You plan to run a silent installation of Oracle Database 19c software. Which artifact does OUI require to supply installation choices without prompts?

  1. A tnsnames.ora file describing the target database
  2. A response file containing the installation parameters Correct answer.
  3. A sqlnet.ora file with authentication settings
  4. A spfile for the database being created

Explanation

Silent installations read their answers from a response file, which you can generate with the record mode of the installer and then edit. Network and server parameter files are irrelevant to the software installation itself.

Question 42Installation and Patching

A patch requires that no database instance in the Oracle home be running. Which sequence correctly prepares the home for applying the patch?

  1. Shut down all instances and the listener in the home, then run opatch apply Correct answer.
  2. Set the environment to the Grid Infrastructure home and patch the database home
  3. Stop only the listener, then run opatch apply while instances stay open
  4. Run opatch apply first, then bounce the instances afterward

Explanation

OPatch requires the Oracle home to be inactive for the components being patched, so all instances and the listener in that home must be stopped first. Leaving instances running can produce inconsistent binaries or a failed patch operation.

Question 43Installation and Patching

You need to confirm that a downloaded patch is compatible with the exact Oracle home version before applying it. Which OPatch command checks patch conflicts and prerequisites without applying the patch?

  1. opatch lsinventory -detail
  2. opatch util delete
  3. opatch apply -silent
  4. opatch prereq CheckConflictAgainstOHWithDetail -ph ./ Correct answer.

Explanation

The prereq CheckConflictAgainstOHWithDetail check reports conflicts between the candidate patch and patches already present in the home. Running it before apply avoids failed or partially applied patches.

Question 44Installation and Patching

During a Grid Infrastructure installation for standalone Oracle Restart, which script must be run as root to configure the automatic restart framework on Linux?

  1. roothas.pl from the Grid Infrastructure home Correct answer.
  2. netca from the database home
  3. root.sh from the database home
  4. dbca from the Grid Infrastructure home

Explanation

For Oracle Restart, roothas.pl configures the high availability framework that restarts resources after failures. It is run once as root after the Grid Infrastructure home is installed.

Question 45Installation and Patching

An installation fails the prerequisite check because the shared memory kernel parameters are too low. What is the most appropriate corrective action before rerunning OUI?

  1. Set the -ignorePrereq flag and continue with the installation
  2. Increase the SGA_TARGET value in the database spfile
  3. Set the documented kernel parameter values in the operating system configuration and reload them Correct answer.
  4. Reinstall the operating system with a different distribution

Explanation

Kernel parameters such as shared memory limits must meet the documented minimums and be applied at the operating system level, typically through sysctl configuration. Ignoring prerequisites leaves the home in an unsupported state.

Question 46Installation and Patching

You must install Oracle Database 19c software on a server where the oracle user has no write access to the central inventory location. What is the recommended resolution?

  1. Ensure the inventory directory exists and is writable by the oinstall group, or specify a valid inventory location during installation Correct answer.
  2. Install into the Grid Infrastructure home instead
  3. Run the installer as root for the entire installation
  4. Disable the inventory by removing oraInst.loc

Explanation

The central inventory must be writable by the installing user through the oinstall group, and oraInst.loc points to it. Correcting ownership or choosing a valid inventory location resolves the failure without compromising security.

Question 47Installation and Patching

After applying a release update, a database in the patched home fails to start because the data dictionary must be updated. What is the correct next step?

  1. Run the datapatch utility to apply the SQL changes required by the patched binaries Correct answer.
  2. Recreate the database with DBCA
  3. Run the catcon.pl script against an unrelated home
  4. Run OPatch rollback to remove the release update

Explanation

datapatch examines the patched binaries and applies the corresponding SQL patch actions to each database in the home. Until datapatch runs, the data dictionary can be out of sync with the binaries.

Question 48Installation and Patching

You are comparing an in-place patch with an out-of-place patch for a production 19c database. Which statement correctly describes a key advantage of the out-of-place approach?

  1. It eliminates the need to run datapatch on the new home
  2. It removes the requirement to run root.sh in the new home
  3. The original home remains untouched, allowing a fast fallback by switching back to it if the new home fails validation Correct answer.
  4. It allows patching without stopping the database instances in the source home

Explanation

Out-of-place patching builds a separate patched home, so the source home stays intact and can be reused if the new home does not pass testing. The patched home still requires datapatch and normal post-install configuration.

Question 49Storage Structures and Space Management

A tablespace is created with a single data file and AUTOEXTEND enabled with MAXSIZE 2G. Users report that inserts fail with ORA-01653 even though the file is only 1.5 GB on disk. Which condition most directly explains this behavior?

  1. The tablespace is locally managed and therefore cannot grow beyond its initial extent allocation
  2. The data file has reached its MAXSIZE limit and cannot extend further Correct answer.
  3. The database is running in ARCHIVELOG mode, which caps data file growth
  4. The segment's PCTFREE setting prevents allocation of new blocks

Explanation

When a data file has AUTOEXTEND enabled, growth stops at the MAXSIZE value, and further allocation requests raise ORA-01653 (unable to extend table). Locally managed tablespaces and ARCHIVELOG mode do not impose a growth ceiling. PCTFREE controls space reserved within a block for row updates, not whether new extents can be allocated.

Question 50Storage Structures and Space Management

Which statement correctly describes a locally managed tablespace with AUTOALLOCATE extent management?

  1. Every extent in the tablespace is exactly 64 KB regardless of segment size
  2. The DBA must specify an extent size for every new segment created in the tablespace
  3. Extent sizes are inherited from the dictionary-managed SYSTEM tablespace
  4. Oracle chooses extent sizes in a fixed progression, growing larger as the segment grows Correct answer.

Explanation

AUTOALLOCATE lets Oracle select extent sizes automatically, typically starting small and increasing as the segment grows, which reduces fragmentation and overhead. The DBA does not supply extent sizes, and extents are not uniformly 64 KB. Dictionary-managed behavior belongs to older, non-locally managed tablespaces.