HI FRIENDS,
HERE YOU CAN GET SOME IMPORTANT QUESTIONS THAT ARE ASK IN ALL INTERVIEW AND VI-VA.
HERE I COVERED MANY TOPIC WITH DIFFERENT QUESTIONS. THESE QUESTIONS ARE FOR BEGINNER OR PROFESSIONALS.
INTERVIEW QUESTIONS ARE ON TOPIC THAT ARE COVERED IN THIS BLOG AREJAVA, C. C++, SOFTWARE TESTING, SOFTWARE ENGG, NETWORKING ETC.
What are the different types of joins and explain them
Inner Join
Left Outer Join
Right Outer Join
Full Outer Join
Write syntax for views and stored procedures
View Syntax:
Create view <view-name> as select <column names> from <table-name> where <condition>
Stored Procedure Sysntax:
Create procedure <procedure-name> as begin select <column names> from <table-name> end
Note: These are only sample examples, we can write in different ways also.
Relation between views and the their parent tables
If we modify the views table,it effects the parent tables and vice versa
Write syntax for update query
Update <table-name> set some_co1l=value1, some_col2=value2 where some_col3=value3
What are the different constraints available in sql and Explain
Not Null -> enforces a column to Not accept Null values
Unique -> uniquely identifies each record in a database table
Primary Key -> uniquely identifies each record in a database table and it cannot contain NULL values.
Foreign Key -> A Foreign Key in one table points to a PRIMARY KEY in another table.
Check -> It is used to limit the value range that can be placed in a column.
Default -> It is used to insert a default value into a column.
By default how the column data would display if use order by <column>
By default the order by would display the data in ascending order
Syntax:
a. select <col-names> from <table-name> order by <col-names>
It will display the results in ascending order
select <col-names> from <table-name> order by <col-names> desc
It will display the results in descending order
select <col-names> from <table-name> order by <col-names> asc
It will display the results in ascending order
What is the operator in sql to find pattern match
Like
Select <colnames> from <table-name> where <col> like <pattern>
Ex:
a.
Select ename from emp where ename like ‘v%’
It will display all the names which are start with ‘v’
b.
Select ename from emp where ename not like ‘v%’
It will display other than all the names which are start with ‘v’
What is the purpose of ‘distinct’ in sql
Distinct is used to display only the different values
Ex:
Select distinct <col-names> from <table-name>
Select distinct ename from emp
What is the difference between union and union allThe UNION operator selects only distinct values by default. To allow duplicate values, use UNION ALL
Select <col-names> from <table1> union select <col-names> from <table2>
Select <col-names> from <table1> union all select <col-names> from <table2>
SO DOWNLOAD INTERVIEW QUESTION FROM BELOW LINK.
BEST OF LUCK IN ADVANCE......GOD IS ALWAYS WITH YOU
IF yOU HAVE ANY STOCK OF QUESTION, THEN PLEASE SEND ME FOR OTHER HELPFUL STUDENTS.
THANK
HERE YOU CAN GET SOME IMPORTANT QUESTIONS THAT ARE ASK IN ALL INTERVIEW AND VI-VA.
HERE I COVERED MANY TOPIC WITH DIFFERENT QUESTIONS. THESE QUESTIONS ARE FOR BEGINNER OR PROFESSIONALS.
INTERVIEW QUESTIONS ARE ON TOPIC THAT ARE COVERED IN THIS BLOG AREJAVA, C. C++, SOFTWARE TESTING, SOFTWARE ENGG, NETWORKING ETC.
What are the different types of joins and explain them
Inner Join
Left Outer Join
Right Outer Join
Full Outer Join
Write syntax for views and stored procedures
View Syntax:
Create view <view-name> as select <column names> from <table-name> where <condition>
Stored Procedure Sysntax:
Create procedure <procedure-name> as begin select <column names> from <table-name> end
Note: These are only sample examples, we can write in different ways also.
Relation between views and the their parent tables
If we modify the views table,it effects the parent tables and vice versa
Write syntax for update query
Update <table-name> set some_co1l=value1, some_col2=value2 where some_col3=value3
What are the different constraints available in sql and Explain
Not Null -> enforces a column to Not accept Null values
Unique -> uniquely identifies each record in a database table
Primary Key -> uniquely identifies each record in a database table and it cannot contain NULL values.
Foreign Key -> A Foreign Key in one table points to a PRIMARY KEY in another table.
Check -> It is used to limit the value range that can be placed in a column.
Default -> It is used to insert a default value into a column.
By default how the column data would display if use order by <column>
By default the order by would display the data in ascending order
Syntax:
a. select <col-names> from <table-name> order by <col-names>
It will display the results in ascending order
select <col-names> from <table-name> order by <col-names> desc
It will display the results in descending order
select <col-names> from <table-name> order by <col-names> asc
It will display the results in ascending order
What is the operator in sql to find pattern match
Like
Select <colnames> from <table-name> where <col> like <pattern>
Ex:
a.
Select ename from emp where ename like ‘v%’
It will display all the names which are start with ‘v’
b.
Select ename from emp where ename not like ‘v%’
It will display other than all the names which are start with ‘v’
What is the purpose of ‘distinct’ in sql
Distinct is used to display only the different values
Ex:
Select distinct <col-names> from <table-name>
Select distinct ename from emp
What is the difference between union and union allThe UNION operator selects only distinct values by default. To allow duplicate values, use UNION ALL
Select <col-names> from <table1> union select <col-names> from <table2>
Select <col-names> from <table1> union all select <col-names> from <table2>
FOR MORE DOWNLOAD FROM BELOW LINK
SO DOWNLOAD INTERVIEW QUESTION FROM BELOW LINK.
BEST OF LUCK IN ADVANCE......GOD IS ALWAYS WITH YOU
IF yOU HAVE ANY STOCK OF QUESTION, THEN PLEASE SEND ME FOR OTHER HELPFUL STUDENTS.
THANK
0 comments:
Post a Comment