Sreejobs Logo
   For Latest Job Updates Online Exams
Home Govt Jobs IT Fresher Jobs IT Exp Jobs IT Walk-Ins MBA Jobs BPO Jobs Register FAQ’s Post Job Contact Us
SreeJob Fees   Feeds
Hot Jobs
Welcome Guest
Login | Register
Total No Of Questions: 100.
1) 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.)

2) 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?

3) Which two statements are true about alerts? (Choose two.)

4) Which statements listed below describe the data dictionary views? 1) These are stored in the SYSTEM tablespace. 2) These are the based on the virtual tables. 3) These are owned by the SYS user. 4) These can be queried by a normal user only if O7_DICTIONARY_ACCESSIBILTY parameter is set to TRUE. 5) The V$FIXED_TABLE view can be queried to list the names of these views.

5) User A executes the following command to drop a large table in your database: SQL> DROP TABLE trans; While the drop table operation is in progress, user B executes the following command on the same table: SQL> DELETE FROM trans WHERE tr_type='SL'; Which statement is true regarding the DELETE command?

6) You are installing Oracle Database 11g on a machine. When you run the installer, the Oracle Universal Installer (OUI) shows the message that says one of the product-specific prerequisite checks has failed: Checking available swap space requirements ... Expected result: 1512MB Actual Result: 1018MB Check complete. The overall result of this check is: Failed <<<

7) Which two kinds of failures make the Data Recovery Advisor (DRA) generate a manual checklist?(Choose two.)

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

9) View the Exhibit and examine the attributes of an undo tablespace. In an OLTP system, the user SCOTT has started a query on a large table in the peak transactional hour that performs bulk inserts. The query runs for more than 15 minutes and then SCOTT receives the following error: ORA-01555: snapshot too old What could be the reason for this error?

10) The job to gather optimizer statistics for objects runs as part of the automatic maintenance window in your database instance. At a certain point of time, the maintenance window closes before the statistics are gathered for all objects. Which statement is true in this scenario?
Page 1 of 10
Home | Register for Job Updates | Contact Us