|
| Home | Tech FAQ | Interview Questions | Placement Papers | Tech Articles | Learn | Freelance Projects | Online Testing | Geeks Talk | Job Postings | Knowledge Base | Site Search | Add/Ask Question |
 Related Questions Answer posted by Scott on 2005-05-25 18:30:04: TRUNCATE is a DDL command and cannot be rolled back. All of the memory space is released back to the server. DELETE is a DML command and can be rolled Latest Answer : DELETE is a logged operation on a per row basis. This means that the deletion of each row gets logged and physically deleted. You can DELETE any row that will not violate a constraint, while leaving the foreign key or any other contraint in place. ... tnsnames.ora is used to connect to the remote db. To get the connection listener.ora should be configured at the server and it should be up and running. Latest Answer : listener is used to get the client server communication. U can access ur server only if the listerner is ON ... Latest Answer : 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. ... Latest Answer : SQL plus doesn't have engine with that. So the SQL commands will be executed at the database only. ... How do you get back into SQLPlus to disable restricted session if you enabled. Latest Answer : "When database is in restricted mode only users who have restricted permissions can log on to database" To disable itALTER SYSTEM DISABLE RESTRICTED SESSION ...
Sponsored Links
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
