Database lock tell a transaction, if the data item in questions is currently being used by other transactions. SQL INTERVIEW QUESTIONS AND ANSWERS 10 | P a g e What are the type of locks ? Shared Lock When a shared lock is applied on data item, other transactions can only read the ite...
The following are specific procedures that are conserved and are used to implement automatically in place or else implement the following after the improvement and upgrading of data. The following also allows the user to deploy a batch containing code when any kind of issue, like an insert or u...
Conditional Statements:These includeIFandCASEstatements, which execute different blocks of code based on conditions.TheDECODE() functionis another good example of a conditional that is worth studying. Intermediate PL/SQL Interview Questions Having covered the basic questions, now let's move on to some...
An ORM library is written in our language of choice and encapsulates the code needed to manipulate the data. Therefore we don’t need to directly use the SQL; we can interact instantly with an object from our code, instead of a database table. The ORM tool translates the interaction into ...
CREATE TABLE customers ( customer_id INT NOT NULL AUTO_INCREMENT PRIMARY KEY, first_name VARCHAR(255) NOT NULL, last_name VARCHAR(255) NOT NULL, email VARCHAR(255) NOT NULL, address VARCHAR(255) DEFAULT NULL, city VARCHAR(255) DEFAULT NULL, state VARCHAR(2) DEFAULT NULL, zip_code VARCHAR...
(Note: I created this test question based on a real SQL interview question that I heard from a friend, who applied at one of the biggest social media companies (name starts with ‘F.’ ;)) Solution of SQL Interview Question #1 The solution code is: SELECT authors.author_name, SUM(books...
Code that can be save and reused over and over again. Day03 What is a trigger? A stored procedure that is invoked automatically when a predefined event (INSERT, DELETE, or UPDATE) occurs. Day03 What are the different types of triggers?
Raise_Application_Error(Error_Code,Error_Message); Example : Raise_Application_Error(-20343, ‘The balance is too low.’); 8.What is commit?RollBack?Savepoint? Answer : Commit : When user commits the data after transaction that changes are permanent changes. ...
SQL Server Interview Questions and Answers – Part 2 What is the difference between clustered and a non-clustered index? Aclustered indexis a special type of index that reorders the way records in the table are physically stored. Therefore table can have only one clustered index. The leaf ...
Java Source Code Java Applet Java Servlet JavaServer Pages Criticism of Java SQL Tutorial PLSQL Tutorial PLSQL Examples HTML Tutorial What is XML? XML Tutorial Job Interview Questions Java Interview SQL Interview XML Interview HTML Interview Partner websites Bird Watching Haryana Online Asia Newscast ...