Thursday, February 20, 2020
DB Locks in SQL

DB Locks in SQL

1. What is a database lock in the context of SQL? When two sessions or users of database try to update or delete the same...
Indexes in SQL Interview Questions

Indexes in SQL Interview Questions

1. What is an index? Index is a data structure which is created on one or more columns of the table. In most of the...
Joins in SQL Interview Questions

Joins in SQL Interview Questions

What is Join and Why it is required? Database is mainly composed of many tables. If we access any one table at a time, then...
Keys in SQL

Keys in SQL

What is a key? Why do we need them in SQL? A database is composed of tables. Each table has lots of records / rows...
Optimization in SQL

Optimization in SQL

1. What is Optimization? Optimization is part of RDBMS. It analyzes the query and tells the parser which path is the best path to execute...
Oracle in SQL

Oracle in SQL

1) What is oracle database? Oracle Database is developed on the basis of relational database management system (RDBMS) It can store and retrieve the large...
Parameterized Query in SQL

Parameterized Query in SQL

Normal 0 false false false EN-US X-NONE X-NONE MicrosoftInternetExplorer4 /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-priority:99; mso-style-qformat:yes; mso-style-parent:""; mso-padding-alt:0in 5.4pt 0in 5.4pt; mso-para-margin:0in; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:10.0pt; font-family:"Calibri","sans-serif";} 1. Provide an example of SQL Injection? In simple words, SQL injection is...
Privileges and Roles in SQL

Privileges and Roles in SQL

1. What is a privilege? Suppose we have created a table EMPLOYEES in the database. Now who can view or access these tables? No one...
SQL Query Interview Questions

SQL Query Interview Questions

Let us try to answer common interview questions using below two tables – Employee and Incentive SQL Basics 1. Get all employee details from the employee...
SQL Server Interview Questions

SQL Server Interview Questions

1) What is SQL or Structured Query Language? SQL is a Structured Query Language used to communicate with database. A database is the one which...

Stay connected

9,272FansLike

Latest article

Multiplication of two matrices

Multiplication of two matrices

Given two matrices, this function will multiply the two matrices and prints the result. Here, necessary and sufficient condition is the number of columns...
Subtraction of two matrices

Subtraction of two matrices

Given two matrices, we will write a function that subtracts the given matrices. Example INPUT A = { {1, 4, 7, 9}, {1, 6, 7, 6}, {6, 3, 7,...
Check if two given matrices are identical

Check if two given matrices are identical

Given two matrices, we will write a function to check whether the two matrices are identical or not. That is, if all the elements...