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

2) Which statement is true about the Manageability Monitor (MMON) background process?

3) 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.)

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

5) For which database operation would you need the database to be in the MOUNT state?

6) You are using Enterprise Manager to schedule backups for your database. Which type of script would be generated by the backup scheduler?

7) To make audit information more productive, the DBA executes the following command before starting an audit operation: 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?

8) You executed the following command to create a tablespace called ALES_DATA: SQL> CREATE TABLESPACE sales_data DATAFILE SIZE 100M SEGMENT SPACE MANAGEMENT AUTO; Which two statements are true about the SALES_DATA tablespace? (Choose two.)

9) Which three operations require undo data? (Choose three.)

10) 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?
Page 1 of 10
Home | Register for Job Updates | Contact Us