Hi I want to know what are thw common oracle production support issues that we face when we deal with banking domain and as general too.

If it reduce the traffic then please give an example for that one

ranganath

• Dec 5th, 2014

Materialized view to used improve the performance of the query for example joins and aggregate function.it is stores the data but view doesn't store any data

Pradeep

• Sep 23rd, 2014

Materialized view is mainly used to improve the performance. When you call the normal view, It will run the select query and then fetch the results returned by select query. This is time consuming and...

Answer Question  Select Best Answer

Where will the transactions be stored during Hot Backup?
During hot backup we specify the tablespace during beginning backup mode and now if a user perform some transactions then where such transactions are stored?

Divakar

• Oct 31st, 2014

During hot backup, once we issue the Begin Backup command respective datafile header will be freezed, if users performs transaction it will be stored in the datafiles but the SCN # will not updated as...

pavanintouch

 Profile Answers by pavanintouch Questions by pavanintouch

• May 20th, 2014

Http://orcl11gdba.blogspot.in/2014/03/taking-hot-bakcup-database-in-begin.html

check this

Answer Question  Select Best Answer

SQL Guy

• Aug 21st, 2014

This is crazy .. the original question was posted in 2005 and people are still answering through 2014 with the same answers, come on guys whats wrong with you.

By the way all the ones saying that you cant roll back a truncate you are wrong. It can be rolled back without a problem.

SQL guy

Bharath

• Feb 18th, 2014

Truncate will be faster than delete. Because truncate wont make any backup of deleted rows where in delete it will take backup of deleted records for purpose of rollback. In other words Truncate will...

Answer Question  Select Best Answer

A employee getting variable salary like Jan 3000,Feb 5000,Mar 1000 ,Apr 7000,May 500 write query to display his next salary "increse" or "decrese" as compare to previous month ,three column in the employee table empname ,salarydate,salary ?

bharahi

• Aug 5th, 2014

It can be done by analytical function using the lead function.

tinku981

 Profile Answers by tinku981 Questions by tinku981

• Jun 14th, 2013

This can be done by analytical function using the LEAD function.

Answer Question  Select Best Answer

Annaiah

• Jun 27th, 2014

Ref cursor is typically used to return a record set or cursor from a stored procedure.ref cursor is basically data type ref cursor can be changed dynamically at run time normal cursor is static cursor...

rammohan

• Apr 8th, 2013

REF cursor is a dynamic cursor where as normal cursor is static cursor,In dynamic cursor single segment are process multiple SELECT statements dynamically at run time, where as in normal cursor we process only one select statement

Answer Question  Select Best Answer

Read Best Answer

Editorial / Best Answer

Answered by: Renu

• Jan 26th, 2007

---

Materialized View stores both - definition of the view and rows resulted from execution of the viewMain disadvantage of materialized view is that, its contents get outdated when underlying base table is modified .U can refresh Materialized View using DBMS_MVIEW.REFRESH

thiru

• Jun 25th, 2014

Its a one of the oracle object,its physical storage on the disk then (dbms_refresh)

shanitha

• Sep 11th, 2012

Materialized view is a database object that contains the results of a query..

Improve Answer

Read Best Answer

Editorial / Best Answer

Answered by: thiru

• Jun 25th, 2014

---

Using for low cardinality purpose

thiru

• Jun 25th, 2014

Using for low cardinality purpose

Improve Answer

JP

• May 25th, 2014

When create primary constraints oracle automatically creates Unique Index .
Using "Create index" by default oracle will create B tree index .
To create other indexes like Bit map,IOT index you need mention the Index name while creating index
ex "create Bitmap index "

Sant_parkash

 Profile Answers by Sant_parkash Questions by Sant_parkash

• Jan 31st, 2008

Index will only help you in searching the data but unique index will provide uniqueness to the indexed column. But in both the cases NULL values are allowed to insert.

Answer Question  Select Best Answer

Jp

• May 25th, 2014

Lister is Network Service to establish connection between client machine and server .

Lister are stored at server side .Each lister listen to client request and establish connection.

Innila

 Profile Answers by Innila Questions by Innila

• Dec 4th, 2006

Oracle uses all three files (tnsnames.ora, sqlnet.ora, listener.ora) for network configuration.tnsnames.ora A tnsnames.ora file maps net service names to connect descriptors. In simple words, tnsnames...

Answer Question  Select Best Answer

AMRUT SWAGAT DWIVEDY

• Apr 18th, 2014

TRUNCATE Query

Code
TRUNCATE table table_name;

Rakesh Anand

 Profile Answers by Rakesh Anand Questions by Rakesh Anand

• Aug 24th, 2013

Code
SELECT * FROM (SELECT COLUMN_NAME, ROWNUM RN FROM TABLE)
WHERE MOD (RN, 2) <> 0;

Answer Question  Select Best Answer

Amrut Swagat Dwivedy

• Apr 18th, 2014

These are different types of upgraded tools

Answer Question  Select Best Answer

Deepika S Verma

• Mar 14th, 2014

TRUNC applies to numeric and Dates values Syntax- ------- TRUNC( number, [ decimal_places ] ) TRUNC ( date, [ format ] ) Example - --------- TRUNC(125.815) would retur...

shiiva

 Profile Answers by shiiva Questions by shiiva

• Aug 6th, 2013

We cannot compare Truncate & Trim. Truncate is a DDL command which deletes the content of a table completely, without effecting the table structure.

Trim is a function which alters the output of one of the column output of a select query.

Answer Question  Select Best Answer

What is the difference between Varray And Nested Table?

Vishnu Bharath

• Jan 8th, 2014

Varrays are generally dense , that mean you cannot delete elements of the varray.But the elements of the Nested Table are generally sparse in nature and hence the elements can be deleted in between us...

Sheraz Baig

• Dec 3rd, 2013

Both are type of collections in Oracle. In Varray because its not stored in database columns so no DML operation can be implemented but on other hand as Nested tables we can perform DML operations

Answer Question  Select Best Answer

How its helps? Why we go for Conceptual Model?

vivekanand

• Dec 9th, 2013

Conceptual modeling is the very first level of data modeling once gathering the Business requirements. It tells about only the Entity and attributes , not the relations(constraints) or physical tables...

Sheraz Baig

• Dec 3rd, 2013

When we talk about Conceptual Model , so we definitely mean the High Level of information. Unlike Physical Model, Conceptual model doesn't discuss the data, but it discuss the process. as we told its ...

Answer Question  Select Best Answer

In PL/SQL if we write select statement with INTO clause it may return two exceptions NO_DATA_FOUND or TOO_MANY_ROW .To avoid these execeptions. How do you write SQL statement in alternative way?

Ananda Kumar Behera

• Nov 12th, 2013

To avoid use:

Code
DECLARE a variable
SELECT COUNT(*) INTO num WHERE <Condition OF your data retreival FOR SELECT INTO statement>;
IF num==1 THEN
EXECUTE your SELECT INTO statement
END IF

tinku981

 Profile Answers by tinku981 Questions by tinku981

• Jun 16th, 2013

We can use explicit cursor to avoid Oracle exception - NO_DATA_FOUND and TOO_MANY_ROWS.

Answer Question  Select Best Answer

1. Queries for Nth maximum Nth row?2. In One table there are 5 fields. empno, ename, deptcd, managr_id, salary.Select the departments whose sum of the salary greater than the sum of salaries of any department?3. When index will be usd in the Query?

mahesh

• Aug 12th, 2013

Code
SELECT* FROM (SELECT RANK() 
over(ORDER BY price DESC) 
odrd,products.* FROM products) 
WHERE odrd =5;

priyank

• May 10th, 2012

Use Case in update statement

Answer Question  Select Best Answer

Rahul

• Jul 11th, 2013

It retrieve or fetch all data from Emp table,and show all data of table like Emp as result.

vaasukk@yahoo.com

• Dec 13th, 2012

First it will check the syntax and semantics in library cache, after that it will create execution plan. Already data in the buffer cache it will directly return to the client. If not it write the fetched to the dB buffer cache after that it will send server. Server sends to the client.

Answer Question  Select Best Answer

In order to 'Compute Sum' clause in the SQL reports which of the following is mandatory1) Break on 2) Order by 3) Set page size 4) Set feedback

tinku981

 Profile Answers by tinku981 Questions by tinku981

• Jun 13th, 2013

Break and compute are required, but for spooling output you should be using all the another 3 functions.

Gaurav Saxena

• Apr 24th, 2013

Break on is compulsory for compute function.

Answer Question  Select Best Answer

If you have an open cursor on a table, modify the same table and commit, what would happen?

tinku981

 Profile Answers by tinku981 Questions by tinku981

• Jun 14th, 2013

There will not be any impact on the output even if we will insert (and commit) the data after cursor is opened. The output will be same as of the record set when cursor was opened and new row will not be selected in that operations.

tinku981

 Profile Answers by tinku981 Questions by tinku981

• Jun 14th, 2013

There will not be any impact on the output even if we will insert (and commit) the data after cursor is opened. The output will be same as of the record set when cursor was opened and new row will not...

Answer Question  Select Best Answer