What are the various restrictions imposed on view in terms of dml?
How can get second highest salary in sql?
What is difference between inner join and cross join?
Explain commit, rollback and savepoint.
What are the differences between in and exists clause?
Does oracle roll back the transaction on an error?
Let us suppose we have a table with structure in order empno empname empdesig empcountry and now i want to re-organize the columns of this table to empno empdesig empname empcountry how can i do this with queries ? assume that table contains the data.
What is the difference between DELETE and TRUNCATE?
15 Answers Johns Hopkins University, Tech Mahindra,
what is primary key? : Sql dba
hi..........i m Accenture employee...Accenture is an IT company having itz branches in India at Mumbai, Pune,Delhi, Hyderabad, Chennai and Bangalore....Presently there are openings here for SAP, Testing, Oracle,Java,.NET,MAinframe and Peoplesoft...... I am a software engineer working with Accenture,Mumbai....u can mail me in your resume..i`ll forward it to our HR team...my mail id: pankit.lodaya@accenture.com
Explain sql data types?
how do you control the max size of a heap table? : Sql dba
What has stored procedures in sql?