Which three statements are true when the listener handles connection requests to an Oracle 12c database instance with multithreaded architecture enabled In UNIX?
Correct Answer: A,B,E
1Z1-060 Exam Question 107
Which three are true about the large pool for an Oracle database instance that supports shared server connections? (Choose three.)
Correct Answer: A,B,C
Explanation The large pool can provide large memory allocations for the following: / (B)UGA (User Global Area) for the shared server and the Oracle XA interface (used where transactions interact with multiple databases) /Message buffers used in the parallel execution of statements / (A) Buffers for Recovery Manager (RMAN) I/O slaves Note: * large pool Optional area in the SGA that provides large memory allocations for backup and restore operations, I/O server processes, and session memory for the shared server and Oracle XA. * Oracle XA An external interface that allows global transactions to be coordinated by a transaction manager other than Oracle Database. * UGA User global area. Session memory that stores session variables, such as logon information, and can also contain the OLAP pool. * Configuring the Large Pool Unlike the shared pool, the large pool does not have an LRU list (not D). Oracle Database does not attempt to age objects out of the large pool. Consider configuring a large pool if the database instance uses any of the following Oracle Database features: * Shared server In a shared server architecture, the session memory for each client process is included in the shared pool. * Parallel query Parallel query uses shared pool memory to cache parallel execution message buffers. * Recovery Manager Recovery Manager (RMAN) uses the shared pool to cache I/O buffers during backup and restore operations. For I/O server processes, backup, and restore operations, Oracle Database allocates buffers that are a few hundred kilobytes in size.
1Z1-060 Exam Question 108
Which statement is true regarding the default behavior of the order by clause?
Correct Answer: A
Character Strings and Dates Character strings and date values are enclosed with single quotation marks. Character values are case-sensitive and date values are format-sensitive. The default date display format is DD-MON-RR.
1Z1-060 Exam Question 109
Which four actions are possible during an Online Data file Move operation?
Correct Answer: A,B,C,D
1Z1-060 Exam Question 110
Which three statements are true concerning unplugging a pluggable database (PDB)?
Correct Answer: B,D,E
Explanation/Reference: Explanation: D: An unplugged PDB contains data dictionary tables, and some of the columns in these encode information in an endianness-sensitive way. There is no supported way to handle the conversion of such columns automatically. This means, quite simply, that an unplugged PDB cannot be moved across an endianness difference. E (not F): To exploit the new unplug/plug paradigm for patching the Oracle version most effectively, the source and destination CDBs should share a filesystem so that the PDB's datafiles can remain in place. The PDB must be closed before it can be unplugged. When you unplug a PDB from a CDB, the unplugged PDB is in mounted mode. The unplug operation makes some changes in the PDB's data files to record, for example, that the PDB was successfully unplugged. Because it is still part of the CDB, the unplugged PDB is included in an RMAN backup of the entire CDB. Such a backup provides a convenient way to archive the unplugged PDB in case it is needed in the future.
