Oracle 2 Flashcards
Examine the parameters for a database instance:
Your database has three undo tablespaces and the default undo tablespace is not autoextensible.
Resumable space allocation is not enabled for any sessions in the database instance.
What is the effect on new transactions when all undo space in the default undo tablespace is in use by active transactions?
A. Transactions write their undo in the SYSTEM undo segment.
B. Transactions fail.
C. Transactions wait until space becomes available in UNDOTBS1.
D. Transactions write their undo in a temporary tablespace.
B. Transactions fail.
The DEFERRED_SEGMENT_CREATION parameter is set to TRUE in your database instance.
You execute the following command to create a table:
Which two statements are true? (Choose two.)
A. The table is created without a segment because the storage clause is missing.
B. A segment is allocated when the first row is inserted in the table.
C. A segment is allocated when an index is created for any column in the table.
D. The table is created and extents are immediately allocated as per the default storage defined for its tablespace.
E. A segment is allocated for the table if the ALTER TABLE… ALLOCATE EXTENT command is issued.
B. A segment is allocated when the first row is inserted in the table.
E. A segment is allocated for the table if the ALTER TABLE… ALLOCATE EXTENT command is issued.
Which three statements are true about automated maintenance tasks? (Choose three.)
A. They run at predefined time intervals that are intended to occur during a period of low system load.
B. An Oracle Scheduler job is created for each maintenance task that is scheduled to run in a maintenance window.
C. A maintenance window is automatically extended until all the maintenance tasks defined are completed.
D. A repository is maintained in the SYSTEM tablespace to store the history of execution of all tasks.
E. Predefined maintenance tasks consist of automatic optimizer statistics collection, running Automatic Segment Advisor, and running Automatic SQL Tuning.
A. They run at predefined time intervals that are intended to occur during a period of low system load.
B. An Oracle Scheduler job is created for each maintenance task that is scheduled to run in a maintenance window.
E. Predefined maintenance tasks consist of automatic optimizer statistics collection, running Automatic Segment Advisor, and running Automatic SQL Tuning.
Which three statements are true about the purpose of checkpoints? (Choose three.)
A. They ensure that uncommitted transactions are rolled back in case of an instance failure.
B. They ensure that all the dirty buffers are written to disk during a normal shutdown.
C. They ensure that instance recovery starts in the event of an instance failure.
D. They ensure that dirty buffers in the buffer cache are written to disk regularly.
E. They reduce the time required for recovery in case of an instance failure.
B. They ensure that all the dirty buffers are written to disk during a normal shutdown.
D. They ensure that dirty buffers in the buffer cache are written to disk regularly.
E. They reduce the time required for recovery in case of an instance failure.
The HR user executes the following query on the EMPLOYEES table but does not issue COMMIT, ROLLBACK, or any data definition language (DDL) command after that:
HR then opens a second session.
Which two operations wait when executed in HR’s second session? (Choose two.)
A. LOCK TABLE employees IN EXCLUSIVE MODE;
B. INSERT INTO employees(empno,ename) VALUES (1289, `Dick’);
C. SELECT job FROM employees WHERE job=’CLERK’ FOR UPDATE OF empno;
D. SELECT empno,ename FROM employees WHERE job=’CLERK’;
E. INSERT INTO employees(empno,ename,job) VALUES 2001,’Harry’,’CLERK);
A. LOCK TABLE employees IN EXCLUSIVE MODE;
C. SELECT job FROM employees WHERE job=’CLERK’ FOR UPDATE OF empno;
In your database, USERS is the default permanent tablespace.
Examine the commands and their outcome:
You plan to execute the commands:
Which two statements are true? (Choose two.)
A. The MYTAB table is created in the SYSTEM tablespace but no rows can be inserted into the table by USER02.
B. The MYTAB table is created in the SYSTEM tablespace and rows can be inserted into the table by USER02.
C. The MYTAB table is created in the USERS tablespace but no rows can be inserted into the table by USER02.
D. The CREATE TABLE statement generates an error because the SYSDBA privilege does not provide any space quota on the SYSTEM tablespace by default.
E. The MYTAB table is owned by the SYS user.
B. The MYTAB table is created in the SYSTEM tablespace and rows can be inserted into the table by USER02.
E. The MYTAB table is owned by the SYS user.
You use multiple temporary tables frequently in your database. Which two are benefits of configuring temporary undo? (Choose two.)
A. Performance improves because less redo is written to the redo log.
B. Temporary undo reduces the amount of undo stored in undo tablespaces.
C. Performance improves because data manipulation language (DML) operations performed on temporary tables do not use the buffer cache.
D. Performance improves because no redo and undo are generated for the temporary tables.
A. Performance improves because less redo is written to the redo log.
B. Temporary undo reduces the amount of undo stored in undo tablespaces.
Which three statements are true about the Pre-Upgrade Information Tool? (Choose three.)
A. It generates a script to recompile invalid objects post-upgrade.
B. The preupgrade_fixups.sql script is created to list and describe issues in the source database.
C. A log file, preupgrade.log, is created that contains the output of the Pre-Upgrade Information tool.
D. It checks for required tablespaces and if they are not available, creates them automatically.
E. The preupgrade_fixups.sql script is executed automatically to fix issues in the source database.
F. The postupgrade_fixups.sql script is created to address issues that can be fixed after a database has been upgraded.
B. The preupgrade_fixups.sql script is created to list and describe issues in the source database.
C. A log file, preupgrade.log, is created that contains the output of the Pre-Upgrade Information tool.
F. The postupgrade_fixups.sql script is created to address issues that can be fixed after a database has been upgraded.
Which activity is audited by default and recorded in the operating system audit trail irrespective of whether or not database auditing is enabled?
A. execution of SQL statements by users connected with the SYSDBA privilege
B. creation of a fine-grained audit policy
C. configuration of unified auditing mode
D. usage of the AUDIT statement
A. execution of SQL statements by users connected with the SYSDBA privilege
You want to create a role that:
- is protected from unauthorized usage
- does not use a password embedded in the application source code or stored in a table
- is enabled for a user based on security policies defined in a PL/SQL package
How would you create this role?
A. as a secure application role
B. with definer’s rights
C. with global authentication
D. with external authentication
A. as a secure application role
Your database instance is started by using a server parameter file (SPFILE).
You execute the following command to change the value of the LOG_BUFFER initialization parameter:
ALTER SYSTEM SET LOG_BUFFER=32 M;
What is the outcome of this command?
A. The parameter value is changed and it comes into effect as soon as space becomes available in the SGA.
B. It returns an error because the value of this parameter cannot be changed dynamically.
C. The parameter value is changed and it comes into effect at the next instance startup.
D. It returns an error because SCOPE should be set to MEMORY
B. It returns an error because the value of this parameter cannot be changed dynamically.
You want to create a database and you have the following:
- Oracle Grid Infrastructure is installed and configured.
- Oracle Database Vault is installed in ORACLE_HOME to be used for this database.
- Oracle Enterprise Manager Cloud Control is available and an agent is deployed on the database server.
Examine the requirements:
- configuring the database instance to support shared server mode
- using Automatic Storage Management (ASM) for storing database files.
- configuring a naming method to help a remote user connect to a database instance
- configuring the Fast Recovery Area
- configuring Database Vault
- configuring Enterprise Manager (EM) Database Express
- registering with EM Cloud Control
- configuring remote log archive destinations
- enabling daily incremental backups
- configuring a nondefault block size for nondefault block size tablespaces
Which of these requirements can be met while creating a database by using the Database Configuration Assistant (DBCA)?
A. 1, 2, 4, 5, 7, 8, 9 and 10
B. 1, 2, 4, 5, 6 and 7
C. 1, 2, 3, 8, 9 and 10
D. 1, 2, 3, 4, 6, 8, 9 and 10
E. 1, 2, 4, 5, 6, 7 and 8
D. 1, 2, 3, 4, 6, 8, 9 and 10
You want execution of large database operations to suspend, and then resume, in the event of space allocation failures.
You set the value of the initialization parameter RESUMABLE_TIMEOUT to 3600.
Which two statements are true? (Choose two.)
A. Before a statement executes in resumable mode, the ALTER SESSION ENABLE RESUMABLE statement must be issued in its session.
B. Data Manipulation Language (DML) operations are resumable, provided that they are not embedded in a PL/SQL block.
C. A resumable statement can be suspended and resumed only once during execution.
D. A suspended statement will report an error if no corrective action has taken place during a timeout period.
E. Suspending a statement automatically results in suspending a transaction and releasing all the resources held by the transaction.
A. Before a statement executes in resumable mode, the ALTER SESSION ENABLE RESUMABLE statement must be issued in its session.
D. A suspended statement will report an error if no corrective action has taken place during a timeout period.
Which two statements are true about Automatic Database Diagnostic Monitor (ADDM)? (Choose two.)
A. It calls SQL advisors automatically if required.
B. It provides recommendations only for poorly performing SQL statements.
C. Its results are stored in AWR.
D. It runs automatically after each AWR snapshot is created and requires at least two snapshots for analysis.
E. It requires at least one Automatic Workload Repository (AWR) snapshot for analysis.
C. Its results are stored in AWR.
D. It runs automatically after each AWR snapshot is created and requires at least two snapshots for analysis.
Which statement is true about using the Database Upgrade Assistant (DBUA) to upgrade your database from Oracle Database 11g to Oracle Database 12c?
A. It terminates if the SYSTEM tablespace in the source database is not autoextensible.
B. It automatically makes necessary changes to Oracle environment variables.
C. It automatically enables unified auditing in the upgraded database.
D. It automatically adds new data files if there is not enough disk space to grow.
B. It automatically makes necessary changes to Oracle environment variables.
Identify two prerequisites for configuring Enterprise Manager Database Express (EM Express).
A. Grant the APEX_PUBLIC_USER role to the SYSMAN user.
B. Use the DBMS_XDB_CONFIG.SETHTTPPORT procedure to configure a port number for Oracle HTTP Server.
C. Install Oracle HTTP Server.
D. Configure at least one dispatcher for the TCP/IP protocol.
E. Create a SYSMAN user with the SYSDBA privilege as an administrator for EM Express.
B. Use the DBMS_XDB_CONFIG.SETHTTPPORT procedure to configure a port number for Oracle HTTP Server.
D. Configure at least one dispatcher for the TCP/IP protocol.
Your database supports a Decision Support System (DSS) workload that involves the execution of complex queries. Currently, the database is running with peak workload.
You want to analyze some of the most resource-intensive statements cached in the library cache.
What must you run to receive recommendations on the efficient use of indexes and materialized views to improve query performance?
A. Automatic Database Diagnostic Monitor (ADDM)
B. SQL Tuning Advisor
C. SQL Access Advisor
D. SQL Performance Analyzer
E. Automatic Workload Repository (AWR) report
C. SQL Access Advisor
In which situations does the Database Writer process (DBWn) write to data files? (choose two).
A. when the RMAN recovery process starts
B. when a user process commits a transaction
C. when a tablespace is made read-only or taken offline
D. when PMON cleans up dirty buffers in the database buffer cache
E. when clean buffers for reading new blocks into the database buffer cache are not found easily
C. when a tablespace is made read-only or taken offline
E. when clean buffers for reading new blocks into the database buffer cache are not found easily
Which two statements are true about availability audit features after migration to unified auditing? (Choose two.)
A. The ability of users to audit their own schema objects is not available in the post-migrated database.
B. Operating system audit trail is available in the post-migrated database.
C. Network auditing is available in the post-migrated database.
D. Mandatory auditing of audit administrative actions is available in the post-migrated database.
A. The ability of users to audit their own schema objects is not available in the post-migrated database.
D. Mandatory auditing of audit administrative actions is available in the post-migrated database.
Which three statements are true about Database Resource Manager? (Choose three.)
A. A resource plan change can be automated by using the Oracle Scheduler.
B. It can be used to control the consumption of only physical I/Os where excessive physical I/Os can trigger an automatic session termination but excessive logical I/Os cannot.
C. It can be used to control the usage of the undo tablespace by consumer groups.
D. A resource plan can have multiple resource plan directives, each of which controls resource allocation for a different consumer group.
E. It can be used to enable resumable timeout for user sessions.
F. It can be used to control the usage of the temp tablespace by consumer groups.
A. A resource plan change can be automated by using the Oracle Scheduler.
C. It can be used to control the usage of the undo tablespace by consumer groups.
D. A resource plan can have multiple resource plan directives, each of which controls resource allocation for a different consumer group.
What is the effect of setting the STATISTICS_LEVEL initialization parameter to BASIC?
A. Optimizer statistics are collected automatically.
B. Only timed operating system (OS) statistics and plan execution statistics are collected.
C. Automatic Workload Repository (AWR) snapshots are not generated automatically.
D. The Oracle server dynamically generates the necessary object-level statistics on tables as part of query optimization.
C. Automatic Workload Repository (AWR) snapshots are not generated automatically.
You are administering a database that supports an OLTP workload.
The default UNDO tablespace is a fixed size tablespace with the RETENTION NOGUARATNEE clause and undo retention set to 12 minutes.
The user SCOTT queries a large table during peak activity.
The query runs for more than 15 minutes and then SCOTT receives the following error:
ORA-01555: snapshot too old
Which is possible reason for this?
A. The Oracle server is unable to generate a read-consistent image for a block containing updates.committed after the query began.
B. The query is unable to place data blocks in the UNDO tablespace.
C. The flashback data archive is not enabled for the table on which the query is issued.
D. There is not enough space in Fast Recovery Area.
E. The Oracle server is unable to generate a read-consistent image for a block containing uncommitted updates.
A. The Oracle server is unable to generate a read-consistent image for a block containing updates.committed after the query began.
Which two categories of segments are analyzed by the Automatic Segment Advisor? (Choose two.)
A. segments in tablespaces that have exceeded a critical or warning space threshold
B. segments that have the highest growth rate in a database
C. segments that are sparsely populated and have more than 10% of free space below the high water mark.
D. segments that have unusable indexes
E. segments for tables created using ADVANCED ROW COMPRESSION
A. segments in tablespaces that have exceeded a critical or warning space threshold
B. segments that have the highest growth rate in a database
Automatic Shared Memory Management (ASMM) is enabled for your database instance.
You execute the following command:
SQL> ALTER SYSTEM SET DB_CACHE_SIZE = 100M;
Which statement is true?
A. It succeeds and the minimum size for the DEFAULT buffer pool is set to 100M.
B. It fails because DB_CACHE_SIZE is a static initialization parameter.
C. It fails because ASMM is enabled and individual SGA components cannot be sized.
D. It succeeds and the value is changed in the SPFILE immediately, but the change takes effect only at the next instance startup.
A. It succeeds and the minimum size for the DEFAULT buffer pool is set to 100M.
You want to create a database with a block size other than the default 8 kilobytes (KB) by using the Database Configuration Assistant (DBCA).
Which option should you use?
A. Automatic Storage Management (ASM) for storage of data files
B. a file system for storage of data files
C. a Data Warehouse database template
D. a custom database template
D. a custom database template
Which two statements are true about using SQL*Loader? (Choose two.)
A. It can load data from external files by using the direct path only.
B. It can load data into multiple tables using the same load statement.
C. It can load data into only one table at a time.
D. It can generate unique sequential key values in specified columns.
E. It can load data from external files by using the conventional path only.
B. It can load data into multiple tables using the same load statement.
D. It can generate unique sequential key values in specified columns.
The HR user owns the BONUSES table. HR grants privileges to the user TOM by using the command:
SQL> GRANT SELECT ON bonuses TO tom WITH GRANT OPTION;
Tom then executes this command to grant privileges to the user JIM:
SQL> GRANT SELET ON hr.bonuses TO jim;
Which statement is true?
A. TOM cannot revoke the SELECT ON HR.BONUSES privilege from JIM.
B. HR can revoke the SELECT ON HR.BONUSES privilege from JIM.
C. JIM can grant the SELECT ON HR.BONUSES privilege to other users, but cannot revoke the privilege from them.
D. HR can revoke the SELECT ON HR.BONUSES privilege from TOM, which will automatically revoke the SELECT ON HR.BONUSES privilege from JIM.
D. HR can revoke the SELECT ON HR.BONUSES privilege from TOM, which will automatically revoke the SELECT ON HR.BONUSES privilege from JIM.
Your database is running in NOARCHIVLOG mode.
Examine the following parameters:
You execute the following command after performing a STARTUP MOUNT:
SQL> ALTER DATABASE ARCHIVELOG;
Which statement is true about the execution of the command?
A. It executes successfully and sets the Fast Recovery Area as the local archive destination.
B. It executes successfully and issues a warning to set LOG_ARCHIVE_DEST while opening the database.
C. It fails and returns an error about LOG_ARCHIVE_DEST not being set.
D. It executes successfully and sets $ORACLE_HOME/dbs as the default archive destination.
A. It executes successfully and sets the Fast Recovery Area as the local archive destination.
What is the benefit of running the catctl.pl script during an upgrade of a pre-12c database to an Oracle 12c database?
A. It provides a summary of the upgrade results.
B. It recompiles all invalid PL/SQL and Java code.
C. It generates a log file containing the fixes that can be made to the source database.
D. It provides parallel upgrade options to finish the upgrade process with a reduced down time.
E. It generates fix-up scripts to be run on the source database before upgrade.
D. It provides parallel upgrade options to finish the upgrade process with a reduced down time.
Which statement is true about redo log files during instance recovery?
A. All current, online, and archived redo logs are required to complete instance recovery.
B. All redo log entries in the current and active logs are applied to data files to reconstruct changes made after the most recent checkpoint.
C. All redo log entries in the current log are applied to data files until the checkpoint position is reached.
D. All current, active, and inactive redo logs are required to complete instance recovery.
B. All redo log entries in the current and active logs are applied to data files to reconstruct changes made after the most recent checkpoint.
Your database is running in ARCHIVELOG mode.
You want to take a consistent whole database backup.
Which two statements are true in this scenario? (Choose two.)
A. The user-managed backup consists of only formatted data blocks.
B. The database must be shut down to take a user-managed backup.
C. The RMAN backup contains only data files.
D. The RMAN backup can be performed while the database is open.
E. The database must be in MOUNT state to take RMAN backup.
B. The database must be shut down to take a user-managed backup.
E. The database must be in MOUNT state to take RMAN backup.
Your database is configured for ARCHIVELOG mode, and a daily full database backup is taken.
RMAN is configured to perform control file autobackup.
In which three scenarios do you need media recovery? (Choose three.)
A. loss of all the copies of the control file
B. loss of all the inactive online redo log group members
C. loss of a data file that belongs to the active undo tablespace
D. loss of data files that belong to the SYSTEM tablespace
E. logical corruption of data that is caused by a wrong transaction
F. abnormal termination of the database instance
A. loss of all the copies of the control file
C. loss of a data file that belongs to the active undo tablespace
D. loss of data files that belong to the SYSTEM tablespace
Which two statements are true about Oracle Data Pump export and import operations? (Choose two.)
A. You cannot specify how partitioned tables should be handled during an import operation.
B. Only data can be compressed during an export operation.
C. Existing dump files can be overwritten during an export operation.
D. Tables cannot be renamed during an import operation.
E. Metadata that is exported and imported can be filtered based on objects and object types.
C. Existing dump files can be overwritten during an export operation.
E. Metadata that is exported and imported can be filtered based on objects and object types.
Your database instance has the following parameter setting:
OS_AUTHENT_PREFIX = OPS$
You execute the following command:
And then grant OPS$GUEST_USER the CREATE SESSION privilege.
Which two statements are true? (Choose two.)
A. GUEST_USER can query the tables created in the USERS tablespace by default.
B. The authentication details for GUEST_USER are stored in the database password file.
C. A local GUEST_USER OS account should exist before GUEST_USER can log on to the database.
D. GUEST_USER can log on to the database without specifying a username and password.
E. GUEST_USER is forced to change the password at the first login.
C. A local GUEST_USER OS account should exist before GUEST_USER can log on to the database.
D. GUEST_USER can log on to the database without specifying a username and password.
Your database has been running with a peak load for the past hour.
You want to preserve the performance statistics collected during this period for comparison when you analyze the performance of the database later.
What must you do to achieve this?
A. Increase the window size of the moving window baseline so that it equals the Automatic Workload Repository (AWR) snapshot retention period.
B. Create a baseline on a pair of snapshots that span the peak load period.
C. Generate Active Session History reports for the peak load period.
D. Set the snapshot retention period in AWR to 60 to avoid automatic purging of snapshots for the past hour.
B. Create a baseline on a pair of snapshots that span the peak load period.
Which four operations performed after the Oracle Restart installation are automatically added to the Oracle Restart configuration? (Choose four.)
A. listener configured by using NETCA
B. database service created by using SRVCTL
C. database created by using a SQL statement
D. database created by using DBCA
E. ASM instance created by using ASMCA
F. database service created by using DBMS_SERVICE.CREATE_SERVICE
G. database service created by modifying the SERVICE_NAMES initialization parameter
A. listener configured by using NETCA
B. database service created by using SRVCTL
D. database created by using DBCA
E. ASM instance created by using ASMCA
Your single-instance Oracle 12c database home currently supports conventional auditing and uses Automatic Storage Management (ASM).
You want to enable unified auditing by executing the command:
$ make fins_rdbms.mk uniaud_on ioracle ORACLE_HOME=$ORACLE_HOME
Which two steps should you perform before executing this command? (Choose two.)
A. Ensure that the initialization parameter AUDIT_TRAIL is set to DB.
B. Drop any existing fine-grained audit (FGA) policies.
C. Stop the listener.
D. Shut down the database instance.
E. Disable auditing by setting the initialization parameter AUDIT_TRAIL to NONE.
C. Stop the listener.
D. Shut down the database instance.
You create an Oracle 12c database and then import schemas that are required by an application which has not yet been developed.
You want to get advice on creation of or modifications to indexes, materialized views and partitioning in these schemas.
What must you run to achieve this?
A. SQL Access Advisor with a SQL tuning set
B. Automatic Database Diagnostic Monitor (ADDM) report
C. SQL Tuning Advisor
D. SQL Access Advisor with a hypothetical workload
E. SQL Performance Analyzer
D. SQL Access Advisor with a hypothetical workload
The HR user updates the salary of one of the employees in the non-partitioned EMPLOYEES table, but does not commit the transaction.
Which two types of lock exist in this situation? (Choose two.)
A. exclusive lock on the EMPLOYEES table
B. null lock on the row being updated
C. null lock on the EMPLOYEES table
D. row level lock on the row being updated
E. shared lock on the EMPLOYEES table
D. row level lock on the row being updated
E. shared lock on the EMPLOYEES table
For which three requirements would you use the Database Resource Manager? (Choose three.)
A. specifying an idle time limit that applies to sessions that are idle and blocking other sessions
B. limiting the degree of parallelism of operations performed by user sessions in a consumer group
C. specifying the maximum number of concurrent sessions allowed for a user
D. limiting the CPU used per database call
E. specifying the amount of private space a session can allocate in the shared pool of the SGA.
A. specifying an idle time limit that applies to sessions that are idle and blocking other sessions
B. limiting the degree of parallelism of operations performed by user sessions in a consumer group
C. specifying the maximum number of concurrent sessions allowed for a user
In your database instance, the UNDO_RETENTION parameter is set to 1000 and undo retention is not guaranteed for the fixed size undo tablespace.
Which statement is true about undo retention?
A. Undo is retained in the UNDO tablespace for 1000 seconds, and then moved to the SYSTEM tablespace to provide read consistency.
B. Inactive undo is retained for at least 1000 seconds if free undo space is available.
C. Inactive undo is retained for 1000 seconds even if new transactions fall due to lack of space in the undo tablespace.
D. Undo becomes expired obsolete after 1000 seconds.
B. Inactive undo is retained for at least 1000 seconds if free undo space is available.
Which two files must you copy from the Oracle home of the database that is being upgraded to the new Oracle home for Oracle Database 12c? (Choose three.)
A. the tnsnames.ora file
B. the sqlnet.ora file
C. the initialization parameter file
D. the password file
E. the listener.ora file
C. the initialization parameter file
D. the password file
In your Oracle 12c database, you invoke SQL *Loader Express Mode command to load data:
$> sqlldr hr/hr table=employees
Which two statements are true about this command? (Choose two.)
A. It succeeds and creates the EMPLOYEES table in the HR schema if the table does not exist.
B. It fails because the SQL *Loader control file location is not specified.
C. It fails because the SQL *Loader data file location is not specified.
D. It succeeds with default settings if the EMPLOYEES table belonging to the HR schema is already defined in the database.
E. It succeeds even if the HR user does not have the CREATE DIRECTORY privilege.
D. It succeeds with default settings if the EMPLOYEES table belonging to the HR schema is already defined in the database.
E. It succeeds even if the HR user does not have the CREATE DIRECTORY privilege.
Backup requirements for a database:
- * Level 0 backup on Sunday
- * Cumulative incremental level 1 backup on Monday, Wednesday, and Saturday
- * Differential incremental level 1 backup on Tuesday, Thursday, and Friday
Which three statements are true about the strategy? (Choose three.)
A. Level 0 backup on Sunday contains all the blocks that have been formatted.
B. Level 0 backup on Sunday contains all the blocks that have been changed since the last level 1 backup.
C. Level 1 backup on Tuesday, Thursday, and Friday contains all the blocks that have been changed since the last level 1 backup.
D. Level 1 backup on Monday, Wednesday, and Saturday contains all the blocks that have been changed since the last level 0 backup.
E. Level 1 backup on Tuesday, Thursday, and Friday contains all the blocks that have been changed since the last level 0 backup.
A. Level 0 backup on Sunday contains all the blocks that have been formatted.
C. Level 1 backup on Tuesday, Thursday, and Friday contains all the blocks that have been changed since the last level 1 backup.
D. Level 1 backup on Monday, Wednesday, and Saturday contains all the blocks that have been changed since the last level 0 backup.
You want to import the schema objects of the HR user from the development database DEVDB to the production database PRODDB by using Oracle Data Pump.
A database link devdb.us.oracle.com is created between PRODDB and DEVDB.
You execute the following command on the PRODDB database server:
What should you do to resolve the error?
A. Add network_link = devdb.us.oracle.com.
B. Add the SYSTEM user to the schemas option.
C. Change the dumpfile option value to schema.dat@devdb.us.oracle.com.
D. Replace the schemas option with network_1ink = devdb.us.oracle.com.
E. Replace the dumpfile option with network_1ink = devdb.us.oracle.com.
E. Replace the dumpfile option with network_1ink = devdb.us.oracle.com.
Examine the parameters:
Users complain that their sessions for certain transactions hang.
You investigate and discover that some users fail to complete their transactions, causing other transactions to wait on row-level locks.
Which two actions would you take to prevent this problem? (Choose two.)
A. Increase the maximum number of ITL slots for segments on which a blocking user performs a transaction.
B. Decrease the SESSIONS_PER_USER limit in the profiles assigned to blocking users.
C. Set a limit in the profiles of blocking users to control the number of data blocks that can be accessed in a session.
D. Use Database Resource Manager to automatically kill the sessions that are idle and are blocking other sessions.
E. Decrease the IDLE_TIME resource limit in the profiles assigned to blocking users.
D. Use Database Resource Manager to automatically kill the sessions that are idle and are blocking other sessions.
E. Decrease the IDLE_TIME resource limit in the profiles assigned to blocking users.
In your database, the RESOURCE_LIMIT parameter is set to TRUE.
You create the profile:
Which two statements are true about users and their sessions that are subject to this profile? (Choose two.)
A. The CPU_PER_CALL is ignored in the user sessions because of the unlimited value of CPU_PER_CALL
B. These users can never reuse a password
C. The PASSWORD_LIFE_TIME value is ignored because of the unlimited value of PASSWORD_REUSE_MAX.
D. In each user session, the limit for LOGICAL_READS_PER_SESSION in the same as defined in the DEFAULT profile.
B. These users can never reuse a password
D. In each user session, the limit for LOGICAL_READS_PER_SESSION in the same as defined in the DEFAULT profile.
You executed the following query:
Considering that all the redo logs are available, what information can you derive from the output of the preceding query?
A. The time when the last flashback operation in your database was performed
B. The time when the first flashback operation in our database was performed
C. The approximate time and the lowest system change number (SCN) to which you can flash back your database
D. The system change number (SCN) and the time when the Flashback Database was enabled in the database instance
C. The approximate time and the lowest system change number (SCN) to which you can flash back your database
