Oracle Interview Questions And Answers

Computer Tutorials Earn Money From Internet Cheap Freelancers Ask An Expert Register Cheap Domain Data Recovery Best Mutual Funds Trading Forex Online Cheap Web Hosting Ajax Tutorials Cheap Cell Phone Plans Free Mobile Learning Job Portal Photoshop Tutorials Cheap Jewelry Cheapest Air Travel

Oracle Interview Questions And Answers Page 75 of 95 78. How can values be passed bet. precompiler exits & Oracle call interface? By using the statement EXECIAFGET & EXECIAFPUT. 79. How can I message to passed to the user from reports? By using SRW.MESSAGE function. Oracle DBA 1. SNAPSHOT is used for [DBA] a] Synonym, b] Table space, c] System server, d] Dynamic data replication Ans : D 2. We can create SNAPSHOTLOG for [DBA] a] Simple snapshots, b] Complex snapshots, c] Both A & B, d] Neither A nor B Ans : A 3. Transactions per rollback segment is derived from [DBA] a] Db_Block_Buffers, b] Processes, c] Shared_Pool_Size, d] None of the above Ans : B 4. ENQUEUE resources parameter information is derived from [DBA] a] Processes or DDL_LOCKS and DML_LOCKS, b] LOG_BUFFER, c] DB__BLOCK_SIZE.. Ans : A 5. LGWR process writes information into a] Database files, b] Control files, c] Redolog files, d] All the above. Ans : C 6. SET TRANSACTION USE ROLLBACK SEGMENT is used to create user objects in a particular Tablespace a] True, b] False Ans : False 7. Databases overall structure is maintained in a file called a] Redolog file, b] Data file, c] Control file, d] All of the above. Ans : C