-
What are triggers in database? ">
What are triggers in database?
The programmer may like the database o take some action when a database event occurs. In order to achieve the above purpose triggers are defined. The trigger body refers to the code written within the trigger which gets fired and executed when the related database event associated with the trigger occurs. On this situation one may have the question what is the event on the happening of which triggers...
-
What is the use of truncate command?
Truncate command will delete all records and the most important thing to make note of truncate command is since truncate command cannot be rolled back one must make sure to take proper backup of table data before performing the truncate command. Truncate command is thus used to remove all rows from either a table or a cluster. If one wants to use the truncate command in a cluster they can use it only...
-
-
-
-
-
-
-
-
-
-
Explain about TNSPING
You can also use tnsping utility on command prompt to check Oracle Net connectivity. Follow these steps to check the connection to particular SID.Open Command prompt.Write tnsping < SID for the database connectivity you want to check >If you get the message �Used TNSNAMES adapter to resolve the alias� then tnsping utility is able to resolve the service name.If you get �TNS-03505: Failed to resolve...
-
-
-
-
-
What is a view?
A view is nothing but a window of an existing table by which one can view and can also change the values in tables. The main point aspect of view is views have no storage space. For this reason views are also called as virtual tables. Thus in other words a view is a database object that gives a logical representation of one or more database tables.
As we have seen above views have no data for... -
-
-
Oracle Basics Interview Questions
Ans