Which two statements are true about the logical storage structure of an Oracle database? (Choose two.)
Which two statements are true about the logical storage structure of an Oracle database? (Choose two.)
It is possible to have tablespaces of different block sizes in an Oracle database, as specific tablespaces can be created with a different block size from the standard block size of the database. Additionally, a data block is indeed the smallest unit of I/O in data files, representing the smallest unit of storage that can be read from or written to in an Oracle database.
Which two statements correctly describe the relationship between data files and logical database structures? (Choose two.)
A data file can belong to only one tablespace, ensuring that each data file is uniquely associated with a single logical database structure. Additionally, an extent cannot span data files, meaning that a single extent is constrained within the boundaries of a single data file, maintaining logical consistency.
Which statement is true about the Log Writer process?
The Log Writer (LGWR) process in Oracle Database writes redo log entries to the online redo log files. One of the primary situations that trigger this write is when a user commits a transaction. When a commit is issued, LGWR ensures that the corresponding redo entries are written to disk immediately to guarantee transactional integrity. This mechanism helps to ensure the durability of committed transactions, making option D the correct statement.
The ORCL database is configured to support shared server mode. You want to ensure that a user connecting remotely to the database instance has a one-to-one ratio between client and server processes.
Which connection method guarantees that this requirement is met?
To ensure a one-to-one ratio between client and server processes in an Oracle database configured for shared server mode, users need to connect using a net service name that specifies a dedicated server. The setting SERVER=DEDICATED in the tnsnames.ora file guarantees that the connection will use a dedicated server, thereby meeting the requirement. Therefore, connecting by using the local naming method with the server = dedicated parameter set in the tnsnames.ora file for the net service is the correct method.
Which two tasks can be performed on an external table? (Choose two.)
External tables in Oracle allow you to access data stored outside the database as if it were in a table within the database. However, certain limitations apply to what you can do with external tables. Specifically, you cannot perform DML operations like UPDATE, INSERT, or DELETE on external tables, and you cannot create indexes, including invisible indexes, on them. However, you can create views and public synonyms for external tables, which makes options D and E correct. Partitioning the table (option A) might be possible in certain Oracle Database versions, but it is not universally applicable across all versions. Therefore, the safest and most widely correct options are creating a public synonym and creating a view.