In my previous articles i have given the proper idea about the complex sql queries and complex sql interview questions.This article gives you idea about different Real Time Scenarios in SQL Queries which contains simple SQL queries as well as complex sql queries. I have consolidated the different queries from my website so that user will get idea about different Real Time Scenarios in SQL Queries.Everyone have always question in mind that what will be different Real Time Scenarios in SQL Queries? You will find the answer of this query in this article.
SQL Interview Questions and answers Part 1 | SQL Scenario based Interview Question and Answer
Scenario 7 : Finding the procedures information
There are situations in Real Time Scenarios of SQL where user needs to find out the procedures information.
Query 1 :How to check Procedures?
Query 2:How to find procedure columns information?
Scenario 4 : Find a table specific information
There are times where user needs to find out the table specific information. There are so many system tables which will find a table specific information.
Query 1: How to Find table name and its owner?
Make sure that the database user have logged in with SYS user.
Query2:How to find Selected Tables from a User?
Scenario 5 : Find the constraint information
There are so many scenarios in real world that user needs to find out the constraint information.There are so many constraints used to make the database normalized.The following are some important queries which will gives us the information about the oracle constraints.
Query 1 : How to find all details about Constraints?
Query 2: How to find Constraint Name?
Query 3: How to find Constraint Name with Column_Name?
Query 4: How to find Selected Tables which have Constraint?
Query 5: How to find Constraint_Name, Constraint_Type, Table_Name?
What is a DEFAULT constraint?
Constraints in SQL are used to specify some sort of rules for processing data and limiting the type of data that can go into a table. Now, let us understand what is a default constraint.
A default constraint is used to define a default value for a column so that it is added to all new records if no other value is specified. For example, if we assign a default constraint for the E_salary column in the following table and set the default value to 85000, then all the entries of this column will have the default value of 85000, unless no other value has been assigned during the insertion.
Now, let us go through how to set a default constraint. We will start by creating a new table and adding a default constraint to one of its columns.
Code:
Output:
Now, we will insert the records.
Code:
Output:
Also, learn from our blog on MySQL Interview Questions and Answers to crack any Interview.
Can we link SQL Server with others?
SQL Server allows the OLEDB provider, which provides the link, to connect to all databases.
Example: Oracle, I have an OLEDB provider that has a link to connect with an SQL Server group.
What is a unique key?
The key that can accept only a null value and cannot accept duplicate values is called a unique key. The role of a unique key is to make sure that all columns and rows are unique.
The syntax for a unique key will be the same as the primary key. So, the query using a unique key for the employee table will be: