Frequently asked SQL Interview Questions oracle pl sql interview questions and answers pdf free download detailed answers and examples. Tips and Tricks for cracking SQL interview. We have taken full care to give correct answers for all the questions.
Do comment your thoughts Happy Job Hunting! It is a tool used to duplicate enormous quantity of information from tables and views. It does not facsimile the structures same as foundation to target. When is the UPDATE_STATISTICS command used? This command is used, ones the processing of large data is done. Explain the steps needed to Create the scheduled job? Right click on jobs and choose Add New.
A New Job window will come into view. Give an associated name for the same. An SQL job can have multiple steps either in the form of SQL declaration or a stored practice call. An SQL job can comprise of one or supplementary schedules. It is basically the instance at which SQL job will jog itself. We can spell out returning schedules also.
When are we going to use truncate and delete? TRUNCATE is a DDL command, whereas DELETE is a DML command. We can’t execute a trigger in case of TRUNCATE whilst with DELETE, we can accomplish a trigger. TRUNCATE is quicker than DELETE, for the reason that when we use DELETE to delete the data, at that time it store the whole statistics in the rollback gap on or after where we can get the data back after removal. In case of TRUNCATE, it will not store data in rollback gap and will unswervingly rub it out. TRUNCATE do not recover the deleted data.
We can use any condition in WHERE clause using DELETE but it is not possible with TRUNCATE. If a table is referenced by any foreign key constraints, then TRUNCATE won’t work. It’s most important to be attentive of the arrange of operations in an interrelated subquery. In correlated subquery, each time a line is worked for Emp1, the subquery will also make a decision on the exacting row’s value for Emp1. And the outer query will move on to the next row, and the subquery will execute for that row’s value of Emp1. When is the Explicit Cursor Used ?