1Z0-052, Instructor, rwhiteside
What point describe the Oracle Data Pump utility?
1 - It enables the transfer of data from one database to another
The database instance is currently using SPFILE. View the Exhibit and examine the error that you received while running the DB Structure Integrity check. Given below are the steps to recover from the error in random order: 1. Shut down the instance, if not already done. 2. Copy one of the remaining control files to a new location. 3. Change the value of the CONTROL_FILES initialization parameter to correspond to the new location of the control files. 4. Start up the database instance to the NOMOUNT stage. 5. Recover the database to the point of failure of the control file. 6. Open the database. Identify the correct sequence of steps?
1, 2, 4, 3, 5, 6
You are working on a new Oracle Database 11g server, where only the software is installed and no database is created. You plan to create a database on this server using the Database Configuration Assistant (DBCA). Some of the requirements set for your database creation task are: 1. Configure the database to operate in shared server mode. 2. Disable automatic maintenance tasks such as optimizer statistics collection. 3. Configure a naming method to help the remote user connect to the database instance. 4. Use Automatic Storage Management (ASM) for storing the database files. 5. Configure daily database backup to flash recovery area. 6. Configure Enterprise Manager Database Control to manage the database. Which of these requirements can be met while creating the database?
1, 2, 4, 5, and 6
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 database. 4. Set the DB_RECOVERY_FILE_DEST initialization parameter to $ORACLE_HOME/dest_1. 5. Open the database. Which is the correct sequence of steps for accomplishing the task?
1, 3, 2, 5; 4 not required
Observe the information in the columns: 1. The SGA a. Text and parsed forms of all SQL statements 2. The cursor state b. Run-time memory values for the SQL statement, such as rows retrieved 3. User-session data c. Security and resource usage information 4. The stack space d. Local variables for the process Which option has the correct match between the memory areas and their contents?
1-a, 2-b, 3-c, 4-d
You are working on an instance started using the SPFILE. You want to move the Flash Recovery Area of your database to a new location. You want the Flashback log files to be stored in the new location. Given below are the steps to accomplish the task in random order: 1) Shut down the instance. 2) Change the value of the DB_RECOVERY_FILE_DEST initialization parameter to a new value. 3) Execute the ALTER DATABASE FLASHBACK OFF command. 4) Start up the instance and mount the database. 5) Execute the ALTER DATABASE FLASHBACK ON command. 6) Open the database. Select the correct order in which these tasks need to be performed.
2, 1, 4, 3, 5, 6
You have issued a SHUTDOWN ABORT command to bring down your database instance. Consider the steps that will be performed later when you open the database: 1. SGA is allocated. 2. Control file is read. 3. Redo log files are read. 4. Instance recovery is started. 5. Background processes are started. 6. Data files are checked for consistency. 7. Server parameter file or the initialization parameter file is read. Which option has the correct order in which these steps occur?
7, 1, 5, 2, 3, 6, 4
Examine the command that is used to create a table: SQL> CREATE TABLE orders ( oid NUMBER(6) PRIMARY KEY, odate DATE, ccode NUMBER (6), oamt NUMBER(10,2) ) TABLESPACE users; Which two statements are true about the effect of the above command? (Choose two.)
A NOT NULL constraint is created on the OID column. AND The ORDERS table and a unique index are created in the USERS tablespace.
Which statements are true regarding the USERS tablespace? (Choose all that apply.)
A bitmap is used to record free extents AND Free extents information is managed within the tablespace
You execute the following command to change the status of the SALES tablespace: SQL> ALTER TABLESPACE sales OFFLINE; Which statements describe the effect of the command? (Choose all that apply.)
A checkpoint is taken on all data files that are associated with the SALES tablespace. AND The sessions that subsequently try to access the objects in the SALES tablespace receivean error.
In which of the scenario will the DBA perform recovery? (Choose all that apply.)
A tablespace is accidentally dropped AND The hard disk on which the data files is stored is corrupted
User SCOTT wants to perform a bulk insert operation in the EMP_DEP table. SCOTT receives the following error after the INSERT statement is issued and few rows are inserted: INSERT INTO EMP_DEP (emp_id,name,salary,dep_name,mgr_id) * ERROR at line 1: ORA-01653: unable to extend table SCOTT.EMP_DEP by 128 in tablespace USERS Identify two actions either of which will help you resolve this problem. (Choose two.)
Add data files to the USERS tablespace. AND Increase the size of the data file associated with the USERS tablespace.
The instance abnormally terminates because of a power outage. Which statement is true about redo log files during instance recovery?
All redo log entries after the last checkpoint are applied from redo log files to data files
The instance abnormally terminates because of a power outage. Which statement is true about redo log files during instance recovery?
All redo log entries after the last checkpoint are applied from redo log files to data files A checkpoint performs the following three operations: Every dirty block in the buffer cache is written to the data files. That is, it synchronizes the datablocks in the buffer cache with the datafiles on disk. It's the DBWR that writes all modified databaseblocks back to the datafiles. The latest SCN is written (updated) into the datafile header. The latest SCN is also written to the controlfiles. The update of the datafile headers and the control files is done by the LGWR(CKPT if CKPT is enabled). As of version 8.0, CKPT is enabled by default.
Which two statements correctly describe the relation between a data file and the logical database structures? (Choose two)
An extent cannot spread across data files.; A data file can belong to only one tablespace.
You configured the Flash Recovery Area for your database. The database instance has been started in ARCHIVELOG mode and the LOG_ARCHIVE_DEST_1 parameter is not set. What will be the implications on the archiving and the location of archive redo log files?
Archiving will be enabled and the destination for the archived redo log file will be set to the Flash Recovery Area implicitly
You want to access employee details contained in flat files as part of the EMPLOYEE table. You plan to add a new column to the EMPLOYEE table to achieve this. Which data types would you use for the new column?
BFILE
You have executed this command to change the size of the database buffer cache: SQL> ALTER SYSTEM SET DB_CACHE_SIZE=2516582; System altered. To verify the change in size, you executed this command: SQL> SHOW PARAMETER DB_CACHE_SIZE NAME TYPE VALUE ---------------------- ---------------- ------------------ db_cache_size big integer 4194304 Why is the value set to 4194304 and not to 2516582?
Because 4194304 is the granule size
In your database instance, the user sessions are connected to the database server from the remote machines. You want to achieve the following for these users: 1. The user account must be locked after four unsuccessful login attempts. 2. The user must be prompted to change the password at regular intervals. 3. The user may not have more than three simultaneous sessions. 4. The user session must automatically be logged off if more than 10 minutes elapsed time used. How would you accomplish the above?
By assigning profiles for the users
You notice that the perfomrance of the database has degraded beacuse of frequent checkpoints. Which tow actions resolve the issue?
Check the size of the redo log file size and increase the size if it is small AND Set the FAST_START_MTTR_TARGET parameter as per the advice given by the MTTR Advisor
You are managing an Oracle Database 11g database. You want to ensure the recovery of the database to the point of failure. Which configuration will you do to accomplish the task?
Configure the database instance ARCHIVELOG mode
You are managing an Oracle Database 11g database. You want to ensure the recovery of the database to the point of failure. Which configuration will you do to accomplish the task?
Configure the database instance for ARCHIVELOG mode.
Which two files in the database can be configured for automatic backups by using the autobackup feature in Recovery Manager (RMAN)? (Choose two.)
Control Files AND Server Parameter File
Your database is functional with a peak load for the last one hour. You want to preserve the performance statistics collected during this period to be used for comparison when you analyze the performance of the database in the future. What action would you take to achieve this task?
Create a baseline on a pair of snapshots spanning the peak-load period.
You have a large amount of historical data in a flat file. Some analysts in your organization need to query this data in the file. The file is too large to load the data in it into your current database. Which is the most effective method to access this data in your database?
Create an external table and leave the data in the flat file.
Which task would you perform before you run Oracle Universal Installer (OUI) in silent or suppressed mode for an installation?
Create the oraInst.loc file.
The HR user creates a stand-alone procedure as follows and grants the EXECUTE privilege on the procedure to many database users: CREATE OR REPLACE PROCEDURE create_dept ( v_deptno NUMBER, v_dname VARCHAR2, v_mgr NUMBER, v_loc NUMBER) BEGIN INSERT INTO hr.departments VALUES (v_deptno, v_dname, v_mgr, v_loc); END; The users having permission to execute the procedure are able to insert records into the DEPARTMENTS table even though they do not have the INSERT privilege on the table. You want only those users who have privileges on the DEPARTMENTS table to be able to execute the procedure successfully. What would you suggest to the PL/SQL developers to achieve this?
Create the procedure with invoker's right.
Which two statements are true regarding Oracle Data Pump? (Choose two.)
EXPDP and IMPDP are the client components of Oracle Data Pump; EXPDP and IMPDP are the client components of Oracle Data Pump
You want to configure and schedule offline database backups to run automatically. Which tool or utility would you use to achieve this?
Enterprise Manager to schedule the backup
You configured the Flash Recovery Area (FRA) for your database. The database instance is running in ARCHIVELOG mode. The default location for the archived redo log files is the Flash Recovery Area. Which two files are removed automatically if the space is required in the FRA as per the retention policy? (Choose two.)
Flashback log files AND Backups that have become obsolete
Which three operations require undo data? (Choose three.)
Flashing back a transaction AND Recovering a failed transaction AND Running a read-consistent query
In your production database, data manipulation language (DML) operations are executed on the SALES table. You have noticed some dubious values in the SALES table during the last few days. You are able to track users, actions taken, and the time of the action for this particular period but the changes in data are not tracked. You decide to keep track of both the old data and new data in the table long with the user information. What action would you take to achieve this task?
Implement value-based auditing. P.244-245 Value based auditingwill include the actual values of the row that was inserted. FGA can be configured to generate udit records only when certain rows are acessed or columns of certain rows are accessed.
Which three statements are correct about temporary tables? (Choose three.)
Indexes and views can be created on temporary tables. AND Temporary tables are always created in a user's temporary tablespace. AND Data manipulation language (DML) locks are never acquired on the data of temporary tables.
Which three statements are correct about temporary tables? (Choose three.)
Indexes and views can be created on temporary tables; Temporary tables are always created in a user's temporary tablespace; Data Manipulation Language (DML) locks are never acquired on the data of temporary tables
Which two statements are true regarding the SGA_TARGET initialization parameter? (Choose two.)
It can be increased up to the value of the SGA_MAX_SIZE parameter. AND Increasing the value of the SGA_TARGET parameter distributes the increased memory among all the autotuned components.
Which two statements are true regarding a tablespace? (Choose two.)
It can consist of multiple data files; It can contains segments of different sizes
Which two statements are true regarding a PL/SQL package body? (Choose two.)
It cannot be created without a package specification. AND It can be changed and recompiled without making the package specification invalid.
To make audit information more productive, the DBA executes the following command before starting an audit operations: SQL>ALTER SYSTEM SET AUDIT_TRAIL=DB,EXTENDED SCOPE=SPFILE; Which statement is true regarding the audit record generated when auditing starts after restarting the database?
It contains the SQL text executed by the user and the bind variables used with it
A constraint in a table is defined with the INITIALLY IMMEDIATE clause. You executed the ALTER TABLE command with the ENABLE VALIDATE option to enable the constraint that was disabled. What are the two effects of this command? (Choose two.)
It fails if any existing row violates the constraint. AND It prevents insert, update, and delete operations on the table while the constraint is in the process of being enabled.
Examine the following output: SQL> SELECT index_name,status FROM dba_indexes WHERE status='UNUSABLE'; INDEX_NAME STATUS -------------------------- --------------- EIND UNUSABLE Which two statements about the above index are true? (Choose two.)
It is ignored by the query optimizer. AND It is not used while the index is being rebuilt.
You executed the following command to create a password file in the database server: $ orapwd file = orapworcl entries = 5 ignorecase=N Which statement describes the purpose of the above password file?
It is used by Oracle to authenticate users for remote database administrator
You plan to implement the distributed database system in your company. You invoke Database Configuration Assistant (DBCA) to create a database on the server. During the installation, DBCA prompts you to specify the Global Database Name. What must this name be made up of?
It must be made up of a database name and a domain name.
Which statement is true about the Manageability Monitor (MMON) background process?
It transfers statistics from memory to disk at regular intervals.
User SCOTT executes the following command on the EMP table but has not issued COMMIT, ROLLBACK, or any data definition language (DDL) command: SQL> SELECT ename FROM emp 2 WHERE job='CLERK' FOR UPDATE OF empno; SCOTT has opened another session to work with the database instance. Which three operations would wait when issued in SCOTT's second session? (Choose three.)
LOCK TABLE emp IN SHARE MODE; LOCK TABLE emp IN EXCLUSIVE MODE; SELECT ename FROM emp WHERE job='CLERK' FOR UPDATE OF empno;
Identify the memory component from which memory may be allocated for: Session memory for the shared serverBuffers for I/O slavesOracle Database Recovery Manager (RMAN) backup and restore operations
Large Pool
Which naming method uses the tnsnames.ora file to store the connect descriptor used by the client while connecting to the database instance from a remote machine?
Local naming method
You have statistics collected for some selected tables. Your requirement is that the statistics for the tables and all dependent indexes must not be overwritten by further statistics collection until a certain point of time. How would you achieve this?
Lock statistics for the tables.
You have set Tablespace Full Metrics Threshold values for the USERS tablespace as follows: Warning (%): 90 Critical (%): 95 Which background process is responsible for issuing alerts when the threshold is crossed?
Manageability Monitor process (MMON)
Which two statements are true regarding transactions in an Oracle database? (Choose two.)
Multiple transactions can use the same undo segment. AND A transaction is assigned an undo segment when it is started.
Which statement is true about loading data using the conventional path of SQL*Loader?
No exclusive locks are acquired when the conventional path loads are performed
You execute this command to drop the ITEM table, which has the primary key referred in the ORDERS table: SQL> DROP TABLE scott.item CASCADE CONSTRAINTS PURGE; Which two statements are true about the effect of the command?(Choose two.)
No flashback is possible to bring back the ITEM table AND The dependent referential integrity constraints in the ORDERS table are removed. WRONG?: The table definition of the ITEM table and associated indexes are placed in the recycle bin
SQL> CREATE BIGFILE TABLESPACE MRKT 2 DATAFILE '/u01/app/oracle/oradata/orcl/mrkt.dbf' size 10M LOGGING 3 EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO; Tablespace created. SQL> ALTER DATABASE DEFAULT TABLESPACE MRKT; Database altered. Which two statements are true regarding the MRKT tablespace? (Choose two.)
No more data files can be added to the tablespace. AND A user created without being assigned a default tablespace uses this tablespace.
You want to check the details of few errors that users have reported. You search for the alert log file and execute few commands to find the location of the alert log file. View the Exhibit and check the commands executed. What is the location of the alert_orcl.log file?
ORACLE_BASE/diag/rdbms/orcl/orcl/trace
SQL> AUDIT DROP ANY TABLE BY scott BY SESSION WHENEVER SUCCESSFUL; What is the effect of this command?
One audit record is created for the whole session if user SCOTT successfully drops one or more tables in his session
In a new installation of Oracle Database 11g, you perform these activities: 1. Organize software and data on different subdirectories to avoid poor performance. 2. Use consistent naming conventions for database files. 3. Separate administrative information pertaining to the database in different directories. Which option corresponds to the type of activities you performed?
Optimal Flexible Architecture
Note the following functionalities of various background processes: 1. Record the checkpoint information in data file headers. 2. Perform recovery at instance startup. 3. Cleanup unused temporary segments. 4. Free the resources used by a user process when it fails. 5. Dynamically register database services with listeners. 6. Monitor sessions for idle session timeout. Which option has the correct functionalities listed for a background process?
Process Monitor Process (PMON): 4, 5, 6
Which two activities are NOT supported by the Data Recovery Advisor (DRA)? (Choose two.)
Recover from failures in the RAC environment. AND Diagnose and repair failures on a standby database.
database, DEVDB, to the production database, PRODDB. A database link devdb.us.oracle.com is created between PRODDB and DEVDB. You execute the following command on the PRODDB database server: $ impdp system/manager directory = DB_DATA dumpfile = schemas.dat schemas = hr flashback_time = "TO_TIMESTAMP('25-08-2007 14:35:00', 'DD-MM-YYYY HH24:MI:SS')" The command fails displaying the following error: ORA-39001: invalid argument value ORA-39000: bad dump file specification ORA-31640: unable to open dump file "/home/oracle/schema/schemas.dat" for read ORA-27037: unable to obtain file status What would you do to overcome the error?
Replace the dumpfile option with the network_link = devdb.us.oracle.com
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 help to use the previous set of statistics on the objects?
Restore statistics from statistics history.
Automatic Shared Memory Management is disabled for your database instance. You realize that there are cases of SQL statements performing poorly because of repeated parsing activity, resulting in degradation of performance. What would be your next step to improve performance?
Run the memory advisor for the shared pool
The session of user SCOTT receives the following error after executing an UPDATE command on the EMP table: ERROR at line 1: ORA-00060: deadlock detected while waiting for resource On investigation, you find that a session opened by user JIM has a transaction that caused the deadlock. Which two statements are true regarding the session of SCOTT in this scenario? (Choose two.)
SCOTT should perform a COMMIT or ROLLBACK to allow JIM to continue with his transaction. AND SCOTT has to reexecute the last command in the transaction after he commits the transaction.
In a system, large online transaction processing (OLTP) jobs run during the daytime that require a large database buffer cache. In the night, the system supports batch jobs that require a higher value to be set for the large pool. You must simultaneously configure the memory components to accommodate the peak requirement. What would you do to automate this configuration for the memory components with change in mode of working?
Set the SGA_TARGET initialization parameter to a nonzero value.
You have two tables with referential integrity enforced between them. You need to insert data to the child table first because it is going to be a long transaction and data for the parent table will be available in a later stage, which can be inserted as part of the same transaction. View the Exhibit to examine the commands used to create tables. Which action would you take to delay the referential integrity checking until the end of the transaction?
Set the constraint to deferred before starting the transaction
Some non-DBA users in your database have been granted ANY TABLE system privileges and they are able to access data dictionary base tables. You decide to restrict their access to data dictionary objects. Which method would you adopt to achieve this objective?
Set the value of the O7_DICTIONARY_ACCESSIBILITY parameter to FALSE.
View the Exhibit. You want to create a tablespace to contain objects with block size 16 KB. But while configuring the storage you find that the block size that you can provide is only 8 KB. Which configuration could have enabled the block selection of 16 KB?
Setting the DB_16K_CACHE_SIZE parameter for the database instance to a nonzero value
Which two statements are true about Shared SQL Area and Private SQL Area? (Choose two.)
Shared SQL Area will be allocated in the shared pool AND The number of Private SQL Area allocations is dependent on the OPEN_CURSORS parameter
Your test database is configured to run in NOARCHIVELOG mode. One of the data files in the USERS tablespace is lost due to a media failure. You notice that all the online redo logs have been overwritten since the last backup. What would you do to recover the data file?
Shutdown the instance, restores all the database files from the last consistent backup and restart the database instance
Examine the command: SQL>DBMS_STATS.SET_TABLE_PREFS('SH','CUSTOMERS','PUBLISH','false'); Which statement describes the effect of the above command?
Subsequently, statistics gathered on the CUSTOMERS table are stored as pending statistics
Which two statements are true about the Automatic Database Diagnostic Monitor (ADDM)? (Choose two.)
The ADDM runs after each AWR snapshot is collected automatically by MMON AND The results of the ADDM analysis are stored in the Automatic Workload Repository (AWR)
Which two statements are true about the Automatic Database Diagnostic Monitor(ADDM)? (Choose two.
The ADDM runs after each AWR snapshot is collected automatically by MMON AND The results of the ADDM analysis are stored in the Automatic Workload Repository (AWR)
View the Exhibit and examine the undo tablespace attributes. Your database instance is experiencing a large volume of transactions from non-DBA users in the last one hour. The undo tablespace NDOTBS1 is full with transactions and no transaction was committed more than one hour ago. The database has two more undo tablespaces. What happens to the new DML operations in this scenario?
The DML commands will fail
You set the following parameters in the parameter file and restarted the database: MEMORY_MAX_TARGET=0 MEMORY_TARGET=500M PGA_AGGREGATE_TARGET=90M SGA_TARGET=270M Which two statements are true about these parameters after the database instance is restarted? (Choose two.
The MEMORY_MAX_TARGET parameter is automatically set to 500 MB. AND The lower bounds of PGA_AGGREGATE_TARGET and SGA_TARGET parameters are set to 90 MB and 270 MB, respectively.
Examine the values for the following initialization parameters: FAST_START_MTTR_TARGET=0 LOG_CHECKPOINT_INTERVAL=0 Which two will be the implications of these values in your database? (Choose two.)
The MTTR advisor will be disabled AND Automatic checkpoint tuning will be disabled
You are managing an Oracle Database 11g database. The database is open, and you plan to perform Recovery Manager (RMAN) backups. Which three statements are true about these backups? (Choose three.)
The backups would be inconsistent. AND The backups would be possible only if the database is running in ARCHIVELOG mode. AND The backups need to be restored and the database has to be recovered in case of a media failure. Backups are inconsitent because database is open, meaning archive logs would have to be used.
Which is the correct description of a pinned buffer in the database buffer cache?
The buffer is currently being accessed
View the Exhibit and examine the user information. The user has been granted CONNECT and RESOURCE roles and no individual system privileges. The SL_REP user executes this command to create a table : SQL> CREATE TABLE orders ( oid number(6), odate date, ccode number(4), oamt number(10,2) ) TABLESPACE purchase_space; The PURCHASE_SPACE tablespace already exists in the database. Which statement describes the effect of the command?
The command executes successfully and creates the table in the PURCHASE_SPACE tablespace.
View the Exhibit to examine the error that occurred during the database startup. You opened an RMAN session for the database. To repair the failure, you executed the following command as the first RMAN command: RMAN> REPAIR FAILURE; Which statement describes the consequence of this command?
The command produces an error because the ADVISE FAILURE command was not executed before the REPAIR FAILURE command
Your database instance is started using the server parameter file (SPFILE). You executed a command to change the value of the LOG_BUFFER initialization parameter: ALTER SYSTEM SET LOG_BUFFER=32M SCOPE=BOTH; What would be the outcome of this command?
The command returns an error because the size of the redo log buffer cannot be changed dynamically.
Examine the following statement that is used to modify the primary key constraint on the SALES table: SQL> ALTER TABLE SALES MODIFY CONSTRAINT pk DISABLE VALIDATE; Which three statements are true regarding the above command? (Choose three.)
The constraint remains valid. AND The index on the constraint is dropped. AND It allows the loading of data into the table using SQL *Loader.
Which two statements are true regarding undo tablespaces? (Choose two.)
The database can have more than one undo tablespace AND Undo segments automatically grow and shrink as needed, acting as circular storage buffer for their assigned transactions
Identify two situations in which you can use Data Recovery Advisor for recovery. (Choose two.)
The database files are corrupted when the database is open AND The database is not opening because the required database files are missing
Which statement is true about a whole consistent database backup on a database running in ARCHIVELOG mode?
The database must be shut down to accomplish the backup.
Which two statements are true regarding B-tree index? (Choose two.)
The leaf blocks in the index are doubly linked. AND The deletion of a row from the table causes a logical deletion in index leaf block and the space becomes available for the new leaf entry.
The database instance has the following parameter setting: OS_AUTHENT_PREFIX = OPS$ OS_ROLES = FALSE REMOTE_OS_AUTHENT = FALSE REMOTE_OS_ROLES = FALSE TIMED_OS_STATISTICS = 0 You have a local operating system user SKD. You create a database user OPS$SKD, and then assign external authentication. The user OPS$SKD has the CREATE SESSION privilege. What would you achieve by the above process?
The local operating system user SKD will be able to access the database instance without specifying the username and password. "To do this, we create an Oracle user in the normal way, but the username must be the prefix value concatenated to the OS username. So for the OS user "tim_hall", we would expect an Oracle username of "ops$tim_hall" on a UNIX or Linux platform."
Automatic Shared Memory Management (ASMM) has been enabled for your database instance. The initialization parameters for the components that are managed by ASMM are not set. After observing the effects of ASMM, you executed the following command: SQL> ALTER SYSTEM SET DB_CACHE_SIZE = 100M; Which statement is true in this scenario?
The minimum memory size for the database buffer cache is set to 100 MB.
View the Exhibit1, which shows the options that are selected to create the user SL_REP. View the Exhibit2 and examine the contents of DATABASE_PROPERTIES. Which two statements are true regarding this user? (Choose two.)
The objects created by the user are placed in the USERS tablespace. AND The user does not require quota on the TEMP tablespace to perform sort operations.
After performing a clean shut down of the database instance for maintenance, you mount the database and then execute a command to open the database: SQL> ALTER DATABASE OPEN; Which two statements are true? (Choose two.)
The online redo log files and online data files are opened AND All the online data files headers are checked for consistency
You are installing Oracle Database 11g on your server. During the installation Oracle Universal Installer (OUI) prompts you to enter the path of the inventory directory and also prompts you to specify an operating system group name. Which statement is true in this case?
The operating system group that will be specified must have permission to write to the inventory directory.
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 the rows inserted into the REPORT_WORK_AREA table during a transaction?
The rows stay in the table only until session termination
View the Exhibit and examine the output of the query. What do you infer from this?
The server parameter file (SPFILE) was used to start the instance.
Why does performance degrade when many UPDATE, INSERT or DELETE statements are issued on a table that has an associated bitmap index?
The smallest amount of a bitmap that can be locked is a bitmap segment
In your database instance, the STATISTICS_LEVEL initialization parameter is set to BASIC. What is the impact of this setting?
The snapshots for the Automatic Workload Repository (AWR) are not generated automatically.
Your database is configured in shared server mode. However, your senior DBA asks you to modify the value of the PRIVATE_SGA limit in the profile of the users. What could be the reason for this?
To limit the User Global Area (UGA) memory allocated to a session from the SGA
The TRANS_SUMMARY table contains product-wise transaction details that get updated with every transaction in the system. Each row has cumulative transaction details of a single product and every product is identified by a product code, which is the primary key. As part of the archival process, the company wants to transfer the rows in the TRANS_SUMMARY table to the TRANS_SUMMARY_DUP table at the end of every quarter of the year. Along with existing products, the company deals with many new products during every quarter. Which method is best suited for this quarterly data transfer?
Using the MERGE command
Identify two situations in which the block header grows in a data block. (Choose two.)
When row directories need more row entries AND When more transaction slots are required than are initially configured
In which situation may the UNDO_RETENTION parameter be ignored, even if it is set to a value?
When the undo tablespace is of a fixed size and retention guarantee is not enabled
View the Exhibit. You are creating an additional database by using the Database Configuration Assistant (DBCA). You opted to create a General Purpose database and during the database creation realize that the Block Size field is not enabled. What could be the reason for this?
You are using General Purpose template and not the Custom Database template to create the database.
Which statements are true regarding the creation of an incident package file by using the EM Workbench Support? (Choose all that apply.)
You can add SQL test cases to the incident package. AND You can add or remove the trace files to the package.AND You can create the incremental incident package ZIP file for new or modified diagnostic information for the incident package already created.
Which two statements are true regarding the usage of the SQL*LOADER utility? (Choose two.)
You can load data into multiple tables during the same load session AND You can load data from multiple files to a table during the same load session
You are managing an Oracle Database 11g database. You configured the database to run in ARCHIVELOG mode. Which two statements are true in this scenario? (Choose two.)
You can perform complete database backups without closing the database. AND All the previous closed database backups including control files become invalid afteryou configure the database to ARCHIVELOG mode.
