Database Testing MCQ Questions And Answers - Software Quality
Database Testing MCQs : This section focuses on "basics" of Database Testing. These Multiple Choice Questions (MCQ) should be practiced to improve the Database Testing skills required for various interviews (campus interviews, walk-in interviews, company interviews), placements, entrance exams and other competitive examinations.
1. Database Testing is also known as?
A. frontend testing
B. backend testing
C. Both A and B
D. None of the above
View Answer
Ans : B
Explanation: Database Testing is also known as Backend Testing.
2. Database Testing is segmented into _________ different categories.
A. 1
B. 2
C. 3
D. 4
View Answer
Ans : D
Explanation: Database Testing is segmented into four different categories: Testing of Data Integrity, Testing of Data Validity, Data base related performance and Testing of functions, procedure and triggers.
3. The outer join is divided again in _______ types.
A. 2
B. 3
C. 4
D. 5
View Answer
Ans : A
Explanation: The outer join is divided again in two: Left outer join and Right outer join
4. Without using Database Checkpoints, how you test a SQL Query in QTP?
A. By writing scripting procedure in Java
B. By writing scripting procedure in Javascript
C. By writing scripting procedure in Angular
D. By writing scripting procedure in VBScript
View Answer
Ans : D
Explanation: By writing scripting procedure in VBScript, we can connect to database and can test the queries and database.
5. By using this command user can access privilege to database.
A. Revoke
B. Grant
C. Both A and B
D. None of the above
View Answer
Ans : B
Explanation: Grant: By using this command user can access privilege to database.
6. To measure the system response, __________ is done.
A. unit testing
B. performance testing
C. load testing
D. All of the above
View Answer
Ans : C
Explanation: To measure the system response, load testing is done.
7. If the load exceeds the users pattern it is known as?
A. Alpha testing
B. Beta testing
C. Stress testing
D. Acceptance testing
View Answer
Ans : C
Explanation: If the load exceeds the users pattern it is known as stress testing.
8. The white box testing is done to check the accuracy of code and logic of the program.
A. TRUE
B. FALSE
C. Can be true or false
D. Can not say
View Answer
Ans : A
Explanation: True, The white box testing is done to check the accuracy of code and logic of the program.
9. Writing a testcases is like functional testing, First you have to know the functional requirement of the application.
A. Yes
B. No
C. Can be yes or no
D. Can not say
View Answer
Ans : A
Explanation: Yes, Writing a testcases is like functional testing, First you have to know the functional requirement of the application.
10. In data base testing, what are the steps to test data loading?
A. Source data should be known
B. Target data should be known
C. Compatibility of source and target should be checked
D. All of the above
View Answer
Ans : D
Explanation: All of the above are the steps to test data loading
Discussion