This Is A Custom Widget

This Sliding Bar can be switched on or off in theme options, and can take any widget you throw at it or even fill it with your custom HTML Code. Its perfect for grabbing the attention of your viewers. Choose between 1, 2, 3 or 4 columns, set the background color, widget divider color, activate transparency, a top border or fully disable it on desktop and mobile.

This Is A Custom Widget

This Sliding Bar can be switched on or off in theme options, and can take any widget you throw at it or even fill it with your custom HTML Code. Its perfect for grabbing the attention of your viewers. Choose between 1, 2, 3 or 4 columns, set the background color, widget divider color, activate transparency, a top border or fully disable it on desktop and mobile.

Oracle DBA Ques

/Tag:Oracle DBA Ques

Oracle DBA Interview Questions and Answers – Part 6

By | May 19th, 2013|Uncategorized|

51). What is COMPRESS and CONSISTENT setting in EXPORT utility ? COMPRESS Simply: COMPRESS=n - Allocated space in database for imported table will be exactly as the space required to hold the data. COMPRESS=y - The INITIAL extent of the table would be as large as the sum of all the extents allocated to the [...]

Oracle DBA Interview Questions and Answers – Part 5

By | May 19th, 2013|Uncategorized|

41). A table has been created with below settings. What will be size of 4th extent ? storage (initial 200k next 200k minextents 2 maxextents 100 pctincrease 40) What will be size of 4th extent ? "NEXT" Specify in bytes the size of the next extent to be allocated to the object. Percent Increase allows [...]

Oracle DBA Interview Questions and Answers – Part 4

By | May 19th, 2013|Uncategorized|

31). How do you collect statistics for a table, schema and Database ? Using DBMS_STATS package to gather Oracle dictionary statistics. HOW-TO: http://emarcel.com/database/157-dbmsstats10g 32). Can you make collection of Statistics for tables automatically ? YES. Oracle database has default, scheduled job "gather_stats_job" that analyses stats on a daily basis during the maintenance window time. There are two [...]

Oracle DBA Interview Questions and Answers – Part 3

By | May 19th, 2013|Uncategorized|

21). Large Pool is used for what ? The large pool is an optional memory area and provides large memory allocations for: Session memory for the shared server and the Oracle XA interface (used where transactions interact with more than one database) I/O server processes, buffer area Oracle backup and restore operations (RMAN) User Global [...]

Oracle DBA Interview Questions and Answers – Part 2

By | May 19th, 2013|Uncategorized|

11). Which default Database roles are created when you create a Database ? CONNECT , RESOURCE and DBA are three default roles. The DBA_ROLES data dictionary view can be used to list all roles of a database and the authentication used for each role. The following query lists all the roles in the database: SELECT [...]

Oracle DBA Interview Questions and Answers – Part 1

By | May 18th, 2013|Uncategorized|

1). What is an Oracle Instance?  An Oracle database server consists of an Oracle database and an Oracle instance. Every time a database is started, a system global area (SGA) is allocated and Oracle background processes are started. The combination of the background processes and memory buffers is called an Oracle instance. We can run multiple instances on [...]

Basic Oracle RMAN Questions

By | November 29th, 2011|Interview Questions, Oracle DBA Ques|

Q.What is RMAN and How to configure it ? A.RMAN is an Oracle Database client that performs backup and recovery tasks on your databases and automates administration of your backup strategies. It greatly simplifies the dba jobs by managing the production database's backing up, restoring, and recovering database files. This tool integrates with sessions running on [...]