PL/SQL Transaction You can use the COMMIT, ROLLBACK, SAVEPOINT, and SET TRANSACTION command to control the transaction. COMMIT : COMMIT command to make changes permanent save to a database during the current transaction. ROLLBACK : ROLLBACK command execute...
LOB data types used to store large objects such as image, video, graphics, text or audio. Maximum size is up to 4 Gigabytes. Following are the LOB data types in PL/SQL: BFILE BFILE data type is used to store large binary objects into Operating System...
Question: What is NO COUNT used for? Answer: It’s used to check whether the sql statement executed successfully or not. When no count is on than this message will not return and while it off then sql server returns the message. Question: What is SET ANSI...
Atomicity: This property of a transaction ensures that a transaction either completely or does not happen at all. E.g. transferring money from one account to another ransaction What is Transaction Server Implicit? Implicit: when the transaction is in...
What is Transaction Server Consistency? Consistency: This property ensures the data is consistent before the transaction and left in a consistent state after the transaction. If the transaction violates the rules, it must be rolled back. What is Transaction...
What is SQL Profiler? SQL Profiler is a tool that captures SQL Server events from the server and saves those events in what's known as a trace file. You can then analyze or use the trace file to troubleshoot logic or performance problems. You can use...
What is full outer join? * The Full Outer Join logical operator returns each row satisfying the join predicate from the first (top) input joined with each row from the second (bottom) input. It also returns rows from: The first input that had no matches...
What is view with check option? **** The with check option causes the where clause of the view to check the data being inserted or updated through the view in addition to the data being retrieved. In a sense, it makes the where clause a two-way restriction....
Database Tuning Advisior Database Engine Tuning Advisor analyzes a workload and the physical implementation of one or more databases. A workload is a set of Transact-SQL statements that execute against a database or databases that you want to tune. Database...
What are the different types of joins in SQL Server? 1. Inner join 2. Left join 3. Left outer join 4. Right outer join 5. Self-Join
