The good php File Manager allows you to manage your site through HTTP rather than an FTP tool or other third-party application. You can upload, create or delete files, organize files in folders and change file permissions. Folders and files may be displayed in a hierarchical tree based on their directory structure. Some php file …
Awesome 10 good php file manager Read More »
ORA-27154 is a quite a common error which many DBA face in day to day activites.I am trying to share what i have learned to resolve it .We are starting the Oracle database and We receive below error while starting up the database SQL> startup ORA-24323: value not allowed ORA-24323: value not allowed SQL> startup; …
What is Nested Loop Join in Oracle -For each row in the first row source access all the rows from the second row source.-The NESTED LOOPS Join is a join operation that selects a row from the selected beginning row source and uses the values of this row source to drive into or select from the …
What is hash Join in Oracle? Hash joins are used when the joining large tables or when the joins requires most of the joined tables rows. This is used for equality joins only Algorithm for Oracle Hash Join 1) The optimizer uses smaller of the 2 tables to build a hash table in memory.Small table …
What is request set in Concurrent Manager? Request set provides the user to submit the same set of requests regularly using a single transaction. User can use the Request Set window to create and edit request sets. Request sets are divided into one or more “stages” which are linked to determine the sequence in which …
Question 1. Which two are valid modes for a process requesting latches? A. Scheduled B. Deferred C. Immediate D. Pre- Emptive E. Willing- to- Wait Solution C, E. Question 2. Which three SQL statements can use the NOLOGGING mode to reduce redo operations? A. UPDATE B. CREATE INDEX C. ALTER INDEX …REBUILD D. Conventional Path …
Oracle examination questions Read More »
