Exam information

Exam 1Z0-050: Oracle Database 11g, New Features for Administrators

Other

Which statement is true about loading data using the conventional path of SQL*Loader?


Which statement is true about loading data using the conventional path of SQL*Loader?

Which task would you perform before you run Oracle Universal Installer (OUI) in silent or suppressed mode for an installation?

Which task would you perform before you run Oracle Universal Installer (OUI) in silent or suppressed mode for an installation?

Which method would serve the purpose?

You have an ORDERS table with the following structure: Name Null? Type ————————- ——– ————————- OID NUMBER(6) ODATE DATE CCODE […]

Which two files in the database can be configured for automatic backups by using the autobackup feature in Recovery Manager (RMAN)?

Which two files in the database can be configured for automatic backups by using the autobackup feature in Recovery Manager (RMAN)? (Choose two.)

What could be the reason for this error?

You executed the following command to perform a backup of the USERS tablespace: SQL> ALTER TABLESPACE users BEGIN BACKUP; ALTER TABLESPACE users BEGIN BACKUP * ERROR at line 1: ORA-01123: cannot start online backup; media recovery not enabled What could be the reason for this error?


Which action would help to use the previous set of statistics on the objects?

You have recently collected statistics on certain objects of a schema in your database. But you observe suboptimal execution plans for the queries on these objects after two days of statistics collection. The optimizer statistics retention period is set to its default value. Which action would […]

Which statement is true about the rows inserted into the REPORT_WORK_AREA table during a transaction?

You executed this command to create a temporary table: SQL> CREATE GLOBAL TEMPORARY TABLE report_work_area ( startdate DATE, enddate DATE, class CHAR(20) ) ON COMMIT PRESERVE ROWS;Which statement is true about […]

which memory may be allocated for:

Identify the memory component from which memory may be allocated for: Session memory for the shared server Buffers for I/O slaves Oracle Database Recovery Manager (RMAN) backup and restore operations

What affect would this command have on the database?

Your database instance is configured with automatic undo management and the UNDO_RETENTION parameter is set to 900 seconds. You executed the following command to enable retention guarantee: SQL> ALTER TABLESPACE undotbs1 RETENTION GUARANTEE;What affect would this command have on the database?

Which is the correct sequence of steps for accomplishing the task?

You want to enable archiving on your database. Presently, the database is running in NOARCHIVELOG mode. Given below are the steps to accomplish the task in random order: 1. Shut down the instance. 2. Execute the ALTER DATABASE ARCHIVELOG command. 3. Start up the instance and mount the […]



Page 1 of 2612345...1020...Last »