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: With SQL, how can you return the number of records in the ?Persons? table?
a) SELECT COLUMNS (*) FROM Persons
b) SELECT COLUMNS () FROM Persons
c) SELECT COUNTS () FROM Persons
d) SELECT COUNTS (*) FROM Persons


Answer: d. SELECT COUNTS (*) FROM Persons Source: CoolInterview.com
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: 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: 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: 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: 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: 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 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: 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: 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:
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: 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: 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: 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: Name the parts of the database buffer pool.

Answer: The database buffer pool consists of the keep buffer pool, recycle buffer pool, and the default buffer pool.

The keep buffer pool retains the data block in memory.

The recycle buffer pool removes the buffers from memory when it?s not needed.

The default buffer pool contains the blocks that are not assigned to the other pools.
Source: CoolInterview.com
Question: List components of an Oracle instance?

Answer: An Oracle instance is comprised of memory structures and background processes.
The Systems Global Area (SGA) and shared pool are memory structures. The process monitor is a background process (DBWn, LGWR, ARCn, PMON, any others??). The Oracle database consists of the physical components such as data files, redo log files, and the control file.
Source: CoolInterview.com
Question: What is the use of INCTYPE option in EXP command ?

Answer: Type export should be performed COMPLETE,CUMULATIVE,INCREMENTAL. List the sequence of events when a large transaction that exceeds beyond its optimal value when an entry wraps and causes the rollback segment toexpand into anotion Completes. e. will be written. 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: How to get a calender in date field in oracle forms?



Answer: 1)Set the LOV of the item for which calendar to be attached as ENABLE_LIST_LAMP LOV, which is included in the TEMPLATE form.

2)Set ?Validate from List? to 'No' in the property palette of that item .

3)Then in KEY?LISTVAL trigger of that item write

calendar.show;
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.0625 Seconds