1z0-062 無料問題集「Oracle Database 12c: Installation and Administration」

（A）Increase the size of the temporary tablespace.

（B）Enable undo retention guarantee.

（C）Enable Automatic Memory Management (AMM).

（D）Increase the size of the redo log buffer.

（E）Enable temporary undo for the database.

（A）Existing dump files can be overwritten during an export operation.

（B）Metadata that is exported and imported can be filtered based on objects and object types.

（C）Tables cannot be renamed during an import operation.

（D）Only data can be compressed during an export operation.

（E）You cannot specify how partitioned tables should be handled during an import operation.

（A）It fails because no SQL *Loader control file location is specified.

（B）It succeeds with default settings if the EMPLOYEES table belonging to HR is already defined in the database.

（C）It fails because no SQL *Loader data file location is specified.

（D）It fails if the HR user does not have the CREATE ANY DIRECTORY privilege.

（A）1, 2, 3, 4, 5

（B）3, 4

（C）1, 6, 3, 4

（D）1, 2, 3, 5

（E）1, 6, 3

（A）when a tablespace is made read-only or taken offline

（B）when a user process commits a transaction

（C）when PMON cleans up dirty buffers in the database buffer cache

（D）when the RMAN recovery process starts

（E）when clean buffers for reading new blocks into the database buffer cache are not found easily

（A）10, 1, 2, 5, 4, 9, 8

（B）10, 1, 2, 5, 8

（C）6, 5, 4, 7

（D）10, 1, 5, 8, 10

（A）A connection request from a client is always first received by a listener running on the port that is used for the connection request for the database server.

（B）The listener continuously monitors a connection after the user process connects to a service handler.

（C）A server process checks a user's authentication credentials and creates a session if the credentials are valid.

（D）A listener may listen on behalf of only one database instance at a time.

（E）The listener always spawns a new server process to deal with each new connection.

（A）Use transparent parallel processing without having to split the external data first.

（B）Load data into multiple tables during the same load statement.

（C）Transform the data while it is being loaded into the database.

（D）Generate unique sequential key values in specified columns.

（A）The flashback data archive is not enabled for the table on which the query is issued.

（B）The Oracle server is unable to generate a read-consistent image for a block containing updates.committed after the query began.

（C）The query is unable to place data blocks in the UNDO tablespace.

（D）The Oracle server is unable to generate a read-consistent image for a block containing uncommitted updates.

（E）There is not enough space in Fast Recovery Area.

（A）Backup retention policy

（B）Default backup device type

（C）Multiple backup device types for single backup

（D）Default section size for backups

（E）Default destinations for backups

（A）You cannot start up or shut down a database Instance by using EM express.

（B）You can perform basic administrative tasks for pluggable databases by using the EM express interface.

（C）You can create and configure pluggable databases by using EM express.

（D）By default, EM express is available for a database after database creation.

（E）You can use EM express to manage multiple databases running on the same server.

（A）Create a file watcher for the bulk inserts and then create a job to rebuild indexes.

（B）Create an event-based job for the file arrival event, then create a job for bulk insert, and then create a job to rebuild indexes.

（C）Create a job array and add a job for bulk insert and a job to rebuild indexes to the job array.

（D）Create a file watcher and an event-based job for bulk insert and then create another job to rebuild indexes on the table.

（A）The transaction in Scott's session is rolled back and the tablespace becomes readonly.

（B）The command waits and the user SCOTT can execute data manipulation language (DML) statements only as part of the current transaction.

（C）The command fails as a transaction is still pending.

（D）The command hangs until all transactions on the objects in the tablespace commit or rollback, and then the tablespace is placed in readonly mode.

（A）Only 2

（B）Only 1

（C）3 and 1

（D）Only 3

（E）1 and 2

（A）An Automatic Database Diagnostic Monitor (ADOM) report was generated before the execution of the second query.

（B）The database instance was restarted before the execution of the second query.

（C）An Automatic Workload Repository (AWR) snapshot was taken before the execution of the second query.

（D）The threshold alerts were cleared and transferred to DBA_ALERT_HISTORY.

（A）It provides recommendations only for poorly performing SQL statements.

（B）It calls SQL advisors automatically if required.

（C）It runs automatically after each AWR snapshot is created and requires at least two snapshots for analysis.

（D）It requires at least one Automatic Workload Repository (AWR) snapshot for analysis.

（E）Its results are stored in AWR.

（A）It is used by Oracle to authenticate users for remote database administrator

（B）It records usernames and passwords of all users when they are added to OSDBA or OSOPER operating groups

（C）It records usernames and passwords of users when granted the DBA role

（D）It contains usernames and passwords of users for whom auditing is enabled