Oracle Interview Questions – Part 45

Q.what is the physical database structure? A.Physical database structure The physical database structure comprises of datafiles, redo log files and control files 1.Datafiles Datafiles contain database’s data. The data of logical data structures such as tables and indexes is stored in datafiles of the database. One or more datafiles form a logical unit of database […]

Oracle Interview Questions – Part 44

Q.What is a shared pool?  A.It is the area in SGA that allows sharing of parsed SQL statements among concurrent users. Q.What is snapshot in oracle?  A.It is a read only copy of a table or a subset of a table.A recent copy of a table or a subset of rows or cols of a […]

Oracle Interview Questions – Part 43

Q.Explain different types of segment. Data segment, Index segment, Rollback segment and temporary segment. A.There are four types of segments used in Oracle databases: -data segments -index segments -rollback segments -temporary segments Data Segments: There is a single data segment to hold all the data of every non clustered table in an oracle database. This […]

Oracle Interview Questions – Part 41

Q.What Is a Dynamic Performance View in Oracle? A.Oracle contains a set of underlying views that are maintained by the database server and accessible to the database administrator user SYS. These views are called dynamic performance views because they are continuously updated while a database is open and in use, and their contents relate primarily […]

Oracle Interview Questions – Part 42

Q.What is correlated sub-query?      A.In a simple SubQuery, the result retrieved by the inner query is fed to the outer query. The outer query takes the result as its input and processes it to produce its output.However, in a corelated sub query, a correlated sub-query is dependent upon the outer query.The outer query and the […]

Oracle Interview Questions – Part 39

Q.What is a synonym ? Synonym, as the name suggests, is an alternative name for an object. It can be used for simplifying names that are lenghy or complex, for e.g you can use a simple synonym for accessing objects of other users, for which you had to prefix username to the object. Q.What is […]

Oracle Interview Questions – Part 38

Q.How would you go about generating an EXPLAIN plan? Create a plan table with utlxplan.sql. Use the explain plan set statement_id = ‘tst1’ into plan_table for a SQL statement Look at the explain plan with utlxplp.sql or utlxpls.sql Q.How would you go about increasing the buffer cache hit ratio? Use the buffer cache advisory over […]

Oracle Interview Questions – Part 36

Q.Can you assign Priority to users? YES. This is achievable with Oracle Resource Manager. DBMS_RESOURCE_MANAGER is the packcage to administer the Database Resource Manager. The DBMS_RESOURCE_MANAGER package maintains plans, consumer groups, and plan directives. It also provides semantics so that you may group together changes to the plan schema. Q.You want users to change their […]

Oracle Interview Questions – Part 34

Q.Where in the Oracle directory tree structure are audit traces placed? In unix $ORACLE_HOME/rdbms/audit, in Windows the event viewer Q.Explain materialized views and how they are used. Materialized views are objects that are reduced sets of information that have been summarized, grouped, or aggregated from base tables. They are typically used in data warehouse or […]

Oracle Interview Questions – Part 33

Q.Explain the use of setting GLOBAL_NAMES equal to TRUE. Setting GLOBAL_NAMES dictates how you might connect to a database. This variable is either TRUE or FALSE and if it is set to TRUE it enforces database links to have the same name as the remote database to which they are linking. Q.What command would you […]