Sreejobs Logo
   For Latest Job Updates  
sreenutech.com 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
Search:
SreeJob Fees   Feeds
Hot Jobs
Welcome Guest
Login | Register
Total No Of Questions: 100.
1) 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?


2) Which two statements are true regarding listeners? (Choose two.)


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


4) All the database users are presently connected to the database instance and working. The HR user has opened three database sessions and executed the following command in one of his sessions: SQL> UPDATE persons SET ccode='U031' WHERE ccode='U029'; 123 rows updated. SQL> DELETE FROM persons WHERE exp='Y'; 3 rows deleted. The SYS user opens a new session after HR executed the above commands.Which sessions can see the effect of the UPDATE and DELETE commands?


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


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


7) Note the following structures in your database server: 1. Extents 2. OS Blocks 3. Tablespace 4. Segments 5. Oracle Data Block Which option has the correct arrangement of these structures from the smallest to the largest?


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


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


10) Which two kinds of failures make the Data Recovery Advisor (DRA) generate a manual checklist?(Choose two.)
Page 1 of 10
Home | Register for Job Updates | Contact Us