niteshaggarwal

 Profile Answers by niteshaggarwal Questions by niteshaggarwal

• Oct 20th, 2008

The ROWID of that row and the Data value on which that index is created will be inserted in index file. ROWID have row address, which will locate the row at the physical level and thus accessing of that value will be fast.

Answer Question  Select Best Answer

Gayathri Panchangam

 Profile Answers by Gayathri Panchangam Questions by Gayathri Panchangam

• Sep 4th, 2008

Yes.Becoz sysdate contains date and time.For example: if u create a table like thiscreate table ex(id number,date1 date defualt sysdate unique);u get table created. After that if u insert rows in that...

lovely sethii

 Profile Answers by lovely sethii Questions by lovely sethii

• Jun 17th, 2008

Yes it will

Answer Question  Select Best Answer

vishakha_jain81

 Profile Answers by vishakha_jain81 Questions by vishakha_jain81

• Aug 12th, 2008

For DDL commands, We cannot do autocommit off. It is modify structure?of database object such as table, view and these commands have automatically commit.Set autocommit on/off is used for DML.

lovely sethii

 Profile Answers by lovely sethii Questions by lovely sethii

• Jun 17th, 2008

By using set autocommit on we can do it

Answer Question  Select Best Answer

In which section of a PL/SQL block is a user defined exception waste?

vishakha_jain81

 Profile Answers by vishakha_jain81 Questions by vishakha_jain81

• Aug 7th, 2008

In exception block

Answer Question  Select Best Answer

sweetytrivedi

 Profile Answers by sweetytrivedi Questions by sweetytrivedi

• Jun 24th, 2008

If a view is based upon a single table then DML operations can be performed on it, while if a view is based upon more than two tables then it is a complex view and DML operations can be performed using instead of triggers.

Srikanth

• Nov 7th, 2006

A view can be manpulated by using instead of triggers

Answer Question  Select Best Answer

TRUNCATE commits after deleting entire table i.e., can not be rolled back. Database triggers do not fire on TRUNCATEDELETE allows the filtered deletion. Deleted records can be rolled back or committed.Database triggers fire on DELETE.

nandk.sharma

 Profile Answers by nandk.sharma Questions by nandk.sharma

• Jun 27th, 2008

Truncate is faster than delete as it does not generate rollback segment.

nandk.sharma

 Profile Answers by nandk.sharma Questions by nandk.sharma

• Jun 27th, 2008

TRUNCATE -  Truncate is a ddl command.DELETE-     Delete is a dml command.TRUNCATE - We can not use 'where' clause with truncate.DELETE-      We can use 'where '  clause  with delete .

Answer Question  Select Best Answer

G.D.S.Prasad

 Profile Answers by G.D.S.Prasad Questions by G.D.S.Prasad

• Jun 21st, 2008

It is a subquery which is evaluated once for each row processed by parent statement.

globalanil18

 Profile Answers by globalanil18 Questions by globalanil18

• Mar 31st, 2007

Hi Guys,The Oracle Server performs a correlated subquery when the subquery references a column from a table reffered to in the parent statement. A correlated subquery is evaluated once for each row pr...

Answer Question  Select Best Answer

G.D.S.Prasad

 Profile Answers by G.D.S.Prasad Questions by G.D.S.Prasad

• Jun 21st, 2008

VARCHAR2: Max Size=4000 bytesCHAR: Max Size=2000 bytesNUMBER(p,s): The precision p can range from 1 to 38.               &nbs...

Rama Krishna,Yerra

• Aug 2nd, 2006

The Max Size is upto 32.Thanks&RegdsRamki,TCS,Hyd

Answer Question  Select Best Answer

sravee123

 Profile Answers by sravee123 Questions by sravee123

• Jun 17th, 2008

Select ROWNUM, col1, col2 from tablename;

Dr. Codd

 Profile Answers by Dr. Codd Questions by Dr. Codd

• Jun 16th, 2008

SELECT ROWNUM,table_name.* FROM table_name;

Answer Question  Select Best Answer

shanthi_9881

 Profile Answers by shanthi_9881 Questions by shanthi_9881

• May 8th, 2008

In sqlserver 2005 we can use as follows to retreive the date part of the given date or sys dateselect datepart(dd,getdate())

Dharmendra Gohil

• Sep 26th, 2006

  Date Functions:  =============Oracle stores dates in an internal numeric format:century,year,month,day,hours,minutes and secondsDefault display format is DD-MON-YYYYOracle stores...

Answer Question  Select Best Answer

CHAR pads blank spaces to the maximum length. VARCHAR2 does not pad blank spaces. For CHAR it is 255 and 2000 for VARCHAR2.

Shambhu Kumar

 Profile Answers by Shambhu Kumar Questions by Shambhu Kumar

• May 7th, 2008

The break keyword halts the execution of the current loop and forces control out of the loop. The continue is similar to break, except that instead of halting the execution of the loop, it starts the next iteration.

Shambhu Kumar

 Profile Answers by Shambhu Kumar Questions by Shambhu Kumar

• May 7th, 2008

The break keyword halts the execution of the current loop and forces control out of the loop. The continue is similar to break, except that instead of halting the execution of the loop, it starts the next iteration.

Answer Question  Select Best Answer

List all customer (user id, name, and e-mail), number of charging, total charging,number of transaction and total number of transaction value?If u have these tables:1- 'Credit_card'columns: credit_number,type,value,Customer_ID.2-'Coupon'columns: Coupon_number,value,password,Customer_ID3-'Customer'columns: Customer_ID,Fname,Mname,lname,E_mail,password,bdate,tot_trans,mobil_no,hom_no,ex_id_date,current_Balance.

friends_mukesh

 Profile Answers by friends_mukesh Questions by friends_mukesh

• Feb 19th, 2008

Hi, One of the solution is as follow: select cust.customer_id,fname,mname,lname,e_mail,credit.tot_credit+coupan.tot_coup no_of_recharge,credit.tot_credit_val+coupan.tot_coup_val tot_recharging,to...

Answer Question  Select Best Answer

aditi

• Oct 16th, 2007

UNION : It is a set operator which retrives all the matching records from two different tables and eliminates the duplicate rows.OUTER JOIN: It is used to retrive lacking records from one table agains...

suresh

• Oct 21st, 2005

UNION is a set operator which combines the result set of one query with that of the otherOUTER JOIN is a type of join which gives both the matching and unmatching in the table specified in the left si...

Answer Question  Select Best Answer

thirupathi

• Sep 24th, 2007

Explicit & Implicit crusors have same attributes.

kashan

• May 28th, 2006

hai,          plz help me about coursor in sql quries 

Answer Question  Select Best Answer

YESTHA BAPNA

• Jul 31st, 2007

With scrollable cursors, you can move directly to the rows you want without having to FETCH every other row returned by the cursor. the rows of a table can be fetched many timesSequence is repeated each time FETCH statement is issued

Shreenivas

• Sep 22nd, 2005

A scrollable cursor, however, can move forward and backward, and can seek any desired record in the cursor.  Such operations are common in applications that present results sets in scrolling wind...

Answer Question  Select Best Answer

When ON DELETE CASCADE is specified ORACLE maintains referential integrity by automatically removing dependent foreign key values if a referenced primary or unique key value is removed.

bhawesh

• Jul 17th, 2007

Does not consider parent-child relationship.On deletion of parent record child records are deleated automatically but vise versa is'nt true

rampratap409

 Profile Answers by rampratap409 Questions by rampratap409

• Dec 8th, 2006

for deleteing master record with out deleteing the child records on delete cascade is used.  in this case when ever master record is deleted all the child record will be deleted automatically.

Answer Question  Select Best Answer

Rajeev Ranjan

• Jul 11th, 2007

We can be selective in joins query. e.g.select e.name,d.cityfrom employee einner join detail don e.employee_id = d.employee_id and d.city in('aaa',bbbb','cccc')

ravi wadalkar

• Jan 2nd, 2006

subquery retrive the data depending on certain condition or manupulation in inner query.where as joins will join the enitire data depending on the conditions given it cannot manupulate the data or we cannot be selective while using joins

Answer Question  Select Best Answer

Mukul

• Jun 19th, 2007

We can update the datatype of?column?with ALTER function?but the constraints cant be added with the ALTER function if there is data in the table.

rampratap409

 Profile Answers by rampratap409 Questions by rampratap409

• Dec 7th, 2006

to modify the datatype of a column that should be empty, but if increasing the width then it can be done even it holds the value.to add then not null column the table must be empty if not then add the column as nullable then modify that that column as not null.

Answer Question  Select Best Answer

Kaliappan

• Mar 7th, 2007

SQL plus doesn't have engine with that. So the SQL commands will be executed at the database only.

Answer Question  Select Best Answer

Lavanya Chowdary

• May 6th, 2007

Months_between(date1,date2) returns the number valueno other date functions return number value

sudhaker

• Dec 28th, 2006

to_char will also give number valueselect to_char(hiredate,'d') from emp

Answer Question  Select Best Answer