CoolInterview.com - World's Largest Collection of Interview Questions & Answers, FAQs, queries, sample papers, exam papers, dumps, what, why, how, where, when questions
Our Services
Get 9,000 Interview Questions & Answers in an eBook.




Get it now !!
Send your Resume to 6000 Companies
Oracle Interview Questions & Answers - Learning Mode
COOLINTERVIEW.COM ORACLE INTERVIEW QUESTIONS QUESTIONS & ANSWERS - LEARNING MODE

Oracle Interview Questions & Answers - Learning Mode

Oracle Corporation (Oracle) is an enterprise software company. The Company develops, manufactures, markets, distributes and services database and middleware software, as well as applications software that help organizations to manage their businesses.

Try Oracle Interview Questions & Answers - Exam Mode
Subcategories for Oracle Interview Questions & Answers - Learning Mode

Following are sub categories for which Interview Questions & Answers are available under Oracle Interview Questions & Answers - Learning Mode. Please select the appropriate sub-category:-

Backup and Recovery Interview Questions & Answers (60) Learning Mode | Exam Mode

Concepts and Architecture Interview Questions & Answers (62) Learning Mode | Exam Mode

Data Access Interview Questions & Answers (35) Learning Mode | Exam Mode

Database Administration Interview Questions & Answers (88) Learning Mode | Exam Mode

Database Security Interview Questions & Answers (33) Learning Mode | Exam Mode

Distributed Processing Interview Questions & Answers (17) Learning Mode | Exam Mode

General Oracle Interview Questions & Answers (198) Learning Mode | Exam Mode

Memory Management Interview Questions & Answers (123) Learning Mode | Exam Mode

ONT Interview Questions & Answers (12) Learning Mode | Exam Mode

Oracle Architecture Interview Questions & Answers (29) Learning Mode | Exam Mode

Oracle Backup and Recovery Interview Questions & Answers (14) Learning Mode | Exam Mode

Oracle Forms 3.0 Interview Questions & Answers (65) Learning Mode | Exam Mode

Oracle Forms 4.0 Interview Questions & Answers (64) Learning Mode | Exam Mode

PL-SQL Interview Questions & Answers (105) Learning Mode | Exam Mode

Programmatic Constructs Interview Questions & Answers (11) Learning Mode | Exam Mode

Scenario Interview Questions & Answers (20) Learning Mode | Exam Mode

SQL In Oracle Interview Questions & Answers (61) Learning Mode | Exam Mode

SQL Plus Interview Questions & Answers (101) Learning Mode | Exam Mode

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 Next

Sort By : Latest First | Oldest First | By Rating

Oracle Interview Questions & Answers - Learning Mode
Try Oracle Interview Questions & Answers - Exam Mode
Question: What are Drawback of cursor?

Answer: Cursor fetch the record in a row by row process.It takes some more time.so in oracle 8i there is a concept that is bulk into and bulk bind. Source: CoolInterview.com
Question: How many codds rule should oracle satisfies



Answer: Oracle can support codd's 11.5 rules.

view updated rules fully not supported in oracle.
Source: CoolInterview.com
Question: what is place holder column?
where we can use other than formula column?



Answer: Place Holder column is created in reports<br><br>A placeholder is a column for which you set the datatype and value in PL/SQL that you define. Placeholder columns are useful when you want to selectively set the value of a column (e.g., each time the nth record is fetched, or each time a record containing a specific value is fetched, etc.). You can set the value of a placeholder column in the following places: the Before Report Trigger, if the placeholder is a report-level column a re Source: CoolInterview.com
Question: What is a dirty buffer?

Answer:
A dirty buffer refers to blocks in the database buffer cache that are changed, but are not yet written to the disk.
Source: CoolInterview.com
Question: The initialization parameter file has LOG_CHECKPOINT_INTERVAL = 60; What does this mean?

Answer: LOG_CHECKPOINT_INTERVAL ensures that no more than a specified number of redo log blocks(OS blocks) need to be read during instance recovery. LOG_CHECKPOINT_TIMEOUT ensures that no more than a specified number of seconds worth of redo log blocks need to be read during instance recovery. Source: CoolInterview.com
Question: What is function overloading?an example of function overloading in oracle?

Answer: Function overloading--The function is said to be overloaded when same name is given to different function. Source: CoolInterview.com
Question: what are phantom rows?

Answer: If you have already read a range of data based upon a key value, another transaction inserts a new row which happens to have a value between this range. The original range which was referred to would now become invalid. This is because a ?Phantom row? was added. Source: CoolInterview.com
Question: Explaint the nvl2 function



Answer: Sybtax:- - nvl2(expr1,expr2,expr3)In nvl2 if expr1 evaluates to NULL then expr3 is returned and if it evaluates to some value it returns expr2.for e.g select nvl2(commission_pct,'SAL+COMM','SAL') from employees;if commission_pct is having null value then SAL will be displayed else SAL+COMM. Source: CoolInterview.com
Question: How many control files are required to create a database?

Answer: You do not need any control files to create a database; the control files are created when you create a database, based on the filenames specified in the CONTROL_FILES parameter of the parameter file Source: CoolInterview.com
Question: What is the difference between object library and pl/sql library



Answer: When object library is attached to a form, complete object library are compile/used in compilation, assume that object library has some objects like 1, 2,3. But my form don't use 1,2 & 3 all, it uses only 1,2. But still ur form contain 1,2,3 all because the object library is attached.

when pl/sql is attached to a form, it picks up only those source from pl/sql library which is used in the form. other sources are not loaded onto the memory.

Object libary can be used to define t Source: CoolInterview.com
Question: What is the difference between groupby and orderby?



Answer: Group by is used to group set of values based on one or more values.
Order by is to sort values either in ascending or descending order Source: CoolInterview.com
Question: A table is created with an INITRANS value of 2. Which value would you choose for INITRANS of an index created on this table?

Answer: Since index blocks hold more entries per block than table data blocks hold, you should provide a higher value of INITRANS to the index than the table. Source: CoolInterview.com
Question: What is a basic difference between having and where clause?

Answer: WHERE clause will restrict the no of rows to be retrieved while where
HAVING clause will restrict groups. Source: CoolInterview.com
Question: What is the prefix for dynamic performance views?

Answer: The dynamic performance views have a prefix of V$. The actual views have the prefix of V_$, and the synonyms have a V$ prefix. The views are called dynamic performance views because they are continuously updated while the database is open and in use, and their contents related primarily to performance. Source: CoolInterview.com
Question:
When you issue the command ALTER SYSTEM ENABLE RESTRICTED SESSION, what happens to the users who are connected to the database?


Answer: If you enable the RESTRICTED SESSION when users are connected, nothing happens to the already connected sessions. Future sessions are started only if the user has the RESTRICTED SESSION privilege.

Source: CoolInterview.com
Question: Which parameter specified in the DEFAULT STORAGE clause of CREATE TABLESPACE cannot be altered after creating the tablespace?



Answer: All the default storage parameters defined for the tablespace can be changed using the ALTER TABLESPACE command. When objects are created their INITIAL and MINEXTENS values cannot be changed. Source: CoolInterview.com
Question: What packages are associated with the LogMiner utility?

Answer: DBMS_LOGMNR is used to add and drop files (including redo log files) and to start the LogMiner utility. DBMS_LOGMNR_D is used to create the data dictionary. The script dbmslogmnrd.sql creates the DBMS_LOGMNR_D package. Source: CoolInterview.com
Question: If you have two redo log groups with four members each, how many disks does Oracle recommend to keep the redo log files?

Answer: You should keep a minimum of two redo log groups, with a recommended two members in each group. Oracle recommends that you keep each member of a redo log group on a different disk. The maximum number of redo log groups is determined by the MAXLOGFILES database parameter. The MAXLOGMEMBERS database parameter specifies the maximum number of members per group. Source: CoolInterview.com
Question: What is the maximum number of database writer processes allowed in an Oracle instance?

Answer: The maximum is ten. Every Oracle instance begins with only one database writer process, DBW0. Additional writer processes may be started by setting the initialization parameter DB_WRITER_PROCESSES (DBW1 through DBW9). Source: CoolInterview.com
Question: What are the valid status codes in the V$LOGFILE view?

Answer: Valid status codes V$LOGFILE views include STALE, INVALID, DELETED, or the status can be blank. STALE means the file contents are incomplete; INVALID means the file is not accessible; DELETED means the file is no longer used; and blank status means the file is in use. Source: CoolInterview.com

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 Next



India News Network
Latest 20 Questions
Payment of time- barred debt is: (a) Valid (b) Void (c) Illegal (d) Voidable
Consideration is defined in the Indian Contract Act,1872 in: (a) Section 2(f) (b) Section 2(e) (c) Section 2(g) (d) Section 2(d)
Which of the following is not an exception to the rule, "No consideration, No contract": (a) Natural love and affection (b) Compensation for involuntary services (c) Completed gift (d) Agency
Consideration must move at the desire of: (a) The promisor (b) The promisee (c) The promisor or any other party (d) Both the promisor and the promisee
An offer which is open for acceptance over a period of time is: (a) Cross Offer (b) Counter Offer (c) Standing Offer (d) Implied Offer
Specific offer can be communicated to__________ (a) All the parties of contract (b) General public in universe (c) Specific person (d) None of the above
_________ amounts to rejection of the original offer. (a) Cross offer (b) Special offer (c) Standing offer (d) Counter offer
A advertises to sell his old car by advertising in a newspaper. This offer is caleed: (a) General Offer (b) Special Offer (c) Continuing Offer (d) None of the above
In case a counter offer is made, the original offer stands: (a) Rejected (b) Accepted automatically (c) Accepted subject to certain modifications and variations (d) None of the above
In case of unenforceable contract having some technical defect, parties (a) Can sue upon it (b) Cannot sue upon it (c) Should consider it to be illegal (d) None of the above
If entire specified goods is perished before entering into contract of sale, the contract is (a) Valid (b) Void (c) Voidable (d) Cancelled
______________ contracts are also caled contracts with executed consideration. (a) Unilateral (b) Completed (c) Bilateral (d) Executory
A offers B to supply books @ Rs 100 each but B accepts the same with condition of 10% discount. This is a case of (a) Counter Offer (b) Cross Offer (c) Specific Offer (d) General Offer
_____________ is a game of chance. (a) Conditional Contract (b) Contingent Contract (c) Wagering Contract (d) Quasi Contract
There is no binding contract in case of _______ as one's offer cannot be constructed as acceptance (a) Cross Offer (b) Standing Offer (c) Counter Offer (d) Special Offer
An offer is made with an intention to have negotiation from other party. This type of offer is: (a) Invitation to offer (b) Valid offer (c) Voidable (d) None of the above
When an offer is made to the world at large, it is ____________ offer. (a) Counter (b) Special (c) General (d) None of the above
Implied contract even if not in writing or express words is perfectly _______________ if all the conditions are satisfied:- (a) Void (b) Voidable (c) Valid (d) Illegal
A specific offer can be accepted by ___________. (a) Any person (b) Any friend to offeror (c) The person to whom it is made (d) Any friend of offeree
An agreement toput a fire on a person's car is a ______: (a) Legal (b) Voidable (c) Valid (d) Illegal
Cache = 0.03125 Seconds