Database Testing is also known as Backend Testing. Database . Free PDF Download: Database Testing Interview Questions & Answers. In the above article, we have kept the most asked Database Testing Interview Questions with their detailed answers to it. + Database Testing Interview Questions and Answers, Question1: What is data-base testing? Question2: In database testing, what do we need to check.
|Language:||English, Spanish, German|
|Genre:||Academic & Education|
|Distribution:||Free* [*Register to download]|
Database testing includes performing data validity, data integrity testing, . Database Testing Vs Front-End Testing. .. DB Testing – Interview Questions. 5 days ago Sql Database Testing Interview Questions And Answers - [Free] Sql Interview Questions And Answers [PDF] [EPUB] SQL - SQL interview. Database Testing Interview Questions - Free download as Word Doc .doc), PDF File .pdf), Text File .txt) or read online for free.
What is a self-join in SQL? You can join a single table to itself. In this case, you are using the same table twice. Here, the select query can be written. Explain the steps to test a Stored Procedures in database. First, check the requirement of the stored procedure. The next step is to check if indexes, joins, deletions, update are correct in comparison with tables mentioned in stored procedure. Re-execute the available procedures by sending different parameters, and check the results against expected values.
Concluding to the process, automate the tests with WinRunner. The tester should call the stored procedure in the database using the EXEC command. If any parameters are required, they must be passed. Different values of parameters must be passed to confirm if the stored procedure is executed or not. Normally, the things that we check in database testing are: Constraint Check Validation of a Field size Stored procedure Matching application field size to database Indexes for performance based issues Question 3.
Join is used to display two or more than two table and the types of joins are: Left outer join Right outer join Question 5. Different types of indexes are: Following steps need to follow to test data loading Source data should be known Target data should be known Compatibility of source and target should be checked In SQL Enterprise manager, run the DTS package after opening the corresponding DTS package You have to compare the columns of target and data source Number of rows of target and source should be checked After updating data in the source, check whether the changes appears in the target or not.
Then you have to decide the parameters for writing testcases like Objective: Write the objective that you would like to test Input method: Write the method of action or input you want to execute Expected: Open the database project in solution explorer Now in View menu, click the database schema Open the project folder from schema View menu Right click on the object that has to be tested, and then click on the dialog box that says Create Unit Tests After that create a new language test project Select either a Insert the unit test or b Create a new test and then click OK Project that has to be configured will be done by clicking on the Project Configuration dialog box.
Once it configured click on OK Question By using this command user cannot access the database Question Identifies the GUI object which has to be tested Creating test scripts: Test scripts are recorded Debug tests: Test should be debugged Run tests: Testcases should be run.
View results: The results reflects the success or failure of the tests Report detects: If the test is failed, the reasons will be recorded in the report detect file Question Five CMM Maturity levels for an organization are: To do so: First examine the requirement to understand overall functionality. Once you decide which test design method is suitable, write your test cases in requirement analysis and design phase.
In this way you will be ensure that all the requirements are testable. Next, design the test case according to the following consideration: Data type that has been used. Each and every task should be organized correctly.
Knowledge of following things is required before writing the database test cases: At first, understand the application completely and functional requirement of the application. Second, check-out other entities that have been used in an application; back-end database tables, joins between the tables, cursors if any , triggers if any , stored procedures if any , input parameter and output parameters for developing that requirement.
After collecting all necessary information, write down the test case with different input values for examining all the resources. Writing test cases for back end testing is opposite to functional testing, one should use the white box testing technique. Retesting is also called Data Driven Testing, but the difference between both is, Retesting: For data load testing: You need to have knowledge about source database data tables, columns, associated constraints, data types and destination database data tables, columns, data types, and constraints.
You need to check the compatibility between source database and destination database via the DTS package. You have to check the number to rows of Source and Target. After updating data in the Source database, you need to check whether the changes have been reflected on destination database or not.
You need to check about junk character and NULLs. Database load testing, check the volume of the database server to process the queries, and also check the response time of database server and client. Job Recommendation Latest. Jobs in Meghalaya Jobs in Shillong.
View All Locations. Making a great Resume: How to design your resume? Have you ever lie on your resume? Read This Tips for writing resume in slowdown What do employers look for in a resume? Interview Tips 5 ways to be authentic in an interview Tips to help you face your job interview Top 10 commonly asked BPO Interview questions 5 things you should never talk in any job interview Best job interview tips for job seekers 7 Tips to recruit the right candidates in 5 Important interview questions techies fumble most What are avoidable questions in an Interview?
Top 10 facts why you need a cover letter? Report Attrition rate dips in corporate India: Survey Most Productive year for Staffing: Study The impact of Demonetization across sectors Most important skills required to get hired How startups are innovating with interview formats Does chemistry workout in job interviews?
Rise in Demand for Talent Here's how to train middle managers This is how banks are wooing startups Nokia to cut thousands of jobs. Our Portals: Username Password. A database query can be either a select query or an action query. What is a Subquery? A Subquery is a SQL query within another query. It is a subset of a Select statement whose return values are used in filtering the conditions of the main query. What are the types of subquery? There are two types of subquery: In a SQL database query, a correlated subquery is a subquery that uses values from the outer query in order to complete.
Because a correlated subquery requires the outer query to be executed first, the correlated subquery must run once for every row in the outer query. It is also known as a synchronized subquery. A Non-correlated subquery is a subquery in which both outer query and inner query are independent to each other. What is the difference between Local Variables and Global Variables? Local Variables: Local variables can be used or exist only inside the function.
These variables are not used or referred by any other functions. These are not known to other functions. Variables can be created whenever that function is called. Global Variables: Global variables can be used or exist throughout the program.
Same variable declared in global cannot be used in functions. Global variables cannot be created whenever that function is called.
What is data Integrity? Data integrity defines the accuracy and consistency of the data stored in a database. It also defines integrity constraints to enforce business rules on the data when it is entered into an application or a database.
Auto increment keyword allows the user to create a unique number to get generated when a new record is inserted into a table. Auto increment keyword can be used whenever Primary Key is used. What is a temp table? A temp table is a temporary storage structure to store the data temporarily. It eliminates all the duplicated values.
View Detailed Post.
Join is a query, which retrieves related columns or rows from multiple tables. What is the difference between an inner and outer join?
An outer join returns rows from both tables that include the records that are unmatched from one or both the tables. What are SQL constraints? SQL constraints are the set of rules that enforced some restriction while inserting, deleting or updating of data in the databases.
What are the constraints available in SQL? What is a Unique constraint? What is a Primary Key? What is a NULL value? A field with a NULL value is a field with no value.
A NULL value is different from a zero value or a field that contains spaces. A field with a NULL value is one that has been left blank during record creation.
Assume, there is a field in a table is optional and it is possible to insert a record without adding a value to the optional field then the field will be saved with a NULL value. As I mentioned earlier, Null value is field with no value which is different from zero value and blank space. Null value is a field with no value. Zero is a number Blank space is the value we provide.
What is Normalization? Normalization is the process of table design to minimize the data redundancy. What are all the different Normalization?
There are different types of Normalization forms in SQL. What is Denormalization? Denormalization is a database optimization technique used to increase the performance of a database infrastructure.
It involves in the process of adding redundant data to one or more tables. In a normalized database, we store data in separate logical tables and attempt to minimize redundant data. What is Stored procedure? The stored procedure accepts input parameters and processes them and returns a single value such as a number or text value or a result set set of rows.
What is a Trigger? We need to decide what type of data to store inside each and every column of a table while creating a SQL table. What is the largest value that can be stored in a BYTE data field? The largest number that can be represented in a single byte is or The number of possible values is i. These guarantees that the database transactions are processed reliably. The new table will be created with the column-names and types as defined in the old table.
You can create new column names using the AS clause. What is the difference between Delete, Truncate and Drop command? The difference between the Delete, and Truncate are. What is the difference between Union and Union All command? Interviewer may ask you this question in another way as what are the advantages of Union All over Union. Both Union and Union All concatenate the result of two tables but the way these two queries handle duplicates are different.