Home » Posts filed under INTERVIEW QUESTIONS
08:24
Unknown
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.
1) What are most important DDL Commands in SQL?
CREATE TABLE - creates a new database table ALTER TABLE - alters (changes) a database table DROP TABLE - deletes a database table CREATE INDEX - creates an index (search key) DROP INDEX - deletes an index
2) What are the Operators used in SELECT statements?
= Equal <> or != Not equal > Greater than < Less than >= Greater than or equal <= Less than or equal BETWEEN Between an inclusive range LIKE Search for a pattern 3) How to INSERT Values into Tables? INSERT INTO table_name VALUES (value1, value2,....) INSERT INTO table_name (column1, column2,...) VALUES (value1, value2,....) 4) How to Update a Column Name? UPDATE table_name SET column_name = new_value WHERE column_name = some_value 5) How to Delete Columns, Rows? Delete a particular column: DELETE FROM table_name WHERE column_name = some_value Delete All Rows: DELETE FROM table_name or DELETE * FROM table_name 6) Give an usage for BETWEEN ... AND? SELECT column_name FROM table_name WHERE column_name BETWEEN value1 AND value2 The values can be numbers, text, or dates.
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
08:19
Unknown
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 type of Sql's? 1. DDL – Data Definition Language DDL is used to define the structure that holds the data. For example. table 2. DML – Data Manipulation Language DML is used for manipulation of the data itself. Typical operations are Insert,Delete,Update and retrieving the data from the table 3. DCL – Data Control Language DCL is used to control the visibility of data like granting database access and set privileges to create table etc. What are the Advantages of SQL ?
SQL is not a proprietary language used by specific database vendors. Almost every major DBMS supports SQL, so learning this one language will enable programmer to interact with any database like ORACLE, SQL ,MYSQL etc. SQL is easy to learn. The statements are all made up of descriptive English words, and there aren't that many of them.
SQL is actually a very powerful language and by using its language elements you can perform very complex and sophisticated database operations. what is a field in a database ? A field is an area within a record reserved for a specific piece of data. Examples: Employee Name , Employee ID etc What is a Record in a database ? A record is the collection of values / fields of a specific entity: i.e. a Employee , Salary etc What is a Table in a database ?
A table is a collection of records of a specific type. For example, employee table , salary table etc .
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
08:10
Unknown
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.
1. What is DBMS ?
Database management system is a collection of programs that enables
user to store , retrieve , update and delete information from a database
. 2. What is RDBMS ?
Relational Database Management system (RDBMS) is a database management
system (DBMS) that is based on the relational model . Data from
relational database can be accessed or reassembled in many different
ways without having to reorganize the database tables . Data from
relational database can be accessed using a API , Structured Query
Language (SQL) 3. What is SQL ?
Structured Query Language(SQL) is a language designed specifically for
communicating with databases. SQL is an ANSI (American National
Standards Institute) standard . 4. What are the different type of Sql's? 1. DDL – Data Definition Language DDL is used to define the structure that holds the data. For example. table 2. DML – Data Manipulation Language DML
is used for manipulation of the data itself. Typical operations are
Insert,Delete,Update and retrieving the data from the table 3. DCL – Data Control Language DCL is used to control the visibility of data like granting database access and set privileges to create table etc. 5. What are the Advantages of SQL ? 1.
SQL is not a proprietary language used by specific database
vendors. Almost every major DBMS supports SQL, so learning this one
language will enable programmer to interact with any database like
ORACLE, SQL ,MYSQL etc. 2. SQL is easy to learn. The statements are all made up of descriptive English words, and there aren't that many of them. 3.
SQL is actually a very powerful language and by using its language
elements you can perform very complex and sophisticated database
operations.
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
08:07
Unknown
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.
1. What is DBMS ? Database management system is a collection of programs that enables user to store , retrieve , update and delete information from a database . 2. What is RDBMS ? Relational Database Management system (RDBMS) is a database management system (DBMS) that is based on the relational model . Data from relational database can be accessed or reassembled in many different ways without having to reorganize the database tables . Data from relational database can be accessed using a API , Structured Query Language (SQL) 3. What is SQL ? Structured Query Language(SQL) is a language designed specifically for communicating with databases. SQL is an ANSI (American National Standards Institute) standard . 4. What are the different type of Sql's? 1. DDL – Data Definition Language DDL is used to define the structure that holds the data. For example. table 2. DML – Data Manipulation Language DML is used for manipulation of the data itself. Typical operations are Insert,Delete,Update and retrieving the data from the table 3. DCL – Data Control Language DCL is used to control the visibility of data like granting database access and set privileges to create table etc. 5. What are the Advantages of SQL ? 1. SQL is not a proprietary language used by specific database vendors. Almost every major DBMS supports SQL, so learning this one language will enable programmer to interact with any database like ORACLE, SQL ,MYSQL etc. 2. SQL is easy to learn. The statements are all made up of descriptive English words, and there aren't that many of them. 3. SQL is actually a very powerful language and by using its language elements you can perform very complex and sophisticated database operations.
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
03:55
Unknown
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>
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
03:42
Unknown
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.
Define testing?
Testing is a process of executing a program with the intent of finding of an error.
What are the types of software?
There are two types of software. There are • System Software• Application Software
What is the difference between system and application software?
Computer software is often divided into two categories : • System software : This software includes the operating system and all utilities that enable the computer to function.• Application software : These consist of programs that do real work for users.
What is the difference between verification and validation?
Verification is the process of determining whether the output of one phase of software development confirms to that of its previous phase. Validation is the process of determining whether a fully developed system confirms to its requirement specifications.
What is SQA?
Software Quality Assurance is a set of activities designed to evaluate the process by which software is developed and/or maintained.
What is the difference between syntax and logical errors?
• Syntax Error : A syntax error is a program statement that violates one or more rules of the language in which it is written.• Logic Error : A logic error deals with incorrect data fields, out–of–range terms, and invalid combinations.
What is fault?
A fault is a condition that causes a system to fail in performing its required function.
What is failure?
Failure is the inability of the software to perform a required function to its specification.
What is a bug?
A software bug may be defined as a coding error that causes an unexpected defect, fault, flaw, or imperfection in a computer program. In other words, if a program does not perform as intended, it is most likely a bug.
What is test log?
A test log is used by the test team to record what occurred during test execution.
What is the difference between static and dynamic testing?
Static testing : is performed using the software documentation. The code is not executing during static testing.
Dynamic testing : requires the code to be in an executable state to perform the tests.
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
03:34
Unknown
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.
Define software engineering?
According to IEEE, Software engineering is the application of a systematic, disciplined, quantifiable approach to the development, operation and maintenance of sofware.
What are the categories of software?
• System software• Application software• Embedded software• Web Applications• Artificial Intelligence software• Scientific software.
Define testing?
Testing is a process of executing a program with the intent of finding of an error.
What is white box testing?
White box testing is a test case design method that uses the control structure of the procedural design to derive test cases. It is otherwise called as structural testing.
What is Black box testing?
Black box testing is a test case design method that focuses on the functional requirements of the software. It is otherwise called as functional testing.
What is verification and validation?
Verification refers to the set of activities that ensure that software correctly implements a specific function.Validation refers to the set of activities that ensure that the software that has been built is traceable to customer requirements.
What is meant by loop testing?
Loop testing is a white box testing techniques that focuses exclusively on the validity of loop constructs. This technique can be applied to simple loops, nested loops, concatenated loops and unstructured loops.
What is meant by smoke testing?
Smoke testing is an integration testing approach that is commonly used ehen “shrink wrapped ” software products are being developed.
What is alpha and beta tests?
Alpha test is the test that is conducted at the developer’s site by a customer. Beta test is the test that is conducted at one or more customer sites by the end-user of the software.
What is system image?
The system image combines the outward manifestation of the computer based system, coupled with all supporting information that describes system syntax and semantics.
what is transform mapping?
Transform mapping is a set of design steps that allows a DFD with transform flow charactersistics to be mapped into a specific architectural style.
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
