This is the online SQL Test for Software Testers!

If you have a good SQL question from the professional test engineer's common body of knowledge, please e-mail it to me and I will add it.

I would like to cover the following topics:

SQL basic principles for software testers.

Database principles and SQL

Basic knowledge of software development.

Knowledge of programming principles. Check your SQL knowledge. 5 minute SQL test for software testers.

1. What does the roll back mean?
(a) The new database feature to send the data back to the user.
(b) The ability to remove partially completed transactions after a database/ system failure.
(c) The period of time a transaction is maintained in the distibuted database.
(d) None of the above.

2. Which of the following statements are true of a single table?
(a) A single table can contain multiple Primary Keys
(b) A single table can contain only one index
(c) A single table can contain multiple Indexes and only one Primary Key
(d) A single table can contain multiple Indexes

3. What is a stored procedure?
(a) An operation that is stored with the database server.
(b) A named collection of Transact-SQL statements that execute together.
(c) A collection of rows that have associated columns.
(d) A value that is stored in a column if no other value is supplied.

4. What is the Primary Key also known as?
(a) Main Key
(b) Unique Field
(c) First Key
(d) All of the above

5. What is the highest value that can be stored in a BYTE data field?
(a) 32,767
(b) 1
(c) 255

6. List all the possible values that can be stored in a BOOLEAN data field.
(a) 0 to 255
(b) -32,768 to 32,767
(c) -1(true) and 0(false)

7. How many places to the right of the decimal can be stored in a CURRENCY data field??
(a) 2
(b) 3
(c) 4

8. The program according requirements expects the uppercase letters from A to Z. Analyze the following inputs and choose one that can cause the failure with greater probability. Help > character set is ASCII
(a) 1, 0
(b) @, [
(c) B, W

9. What is true about RDBMS?
(a) All data stored in text files.
(b) The system stores data in the form of related tables.
(c) All database tables are linked to one main table.

10. Which is true about deadlock?
(a) An OS failure
(b) The stalemate that occurs when two processes have each locked on a resource while each is trying to acquire a lock on the other's resource.
(c) A constraint defined on a table.

11. Which of the following best defines database testing?
(a) Testing is the process of proving that a database works according to specifications.
(b) Testing is the process of proving that a database is error-free.
(c) Testing is the process of locating errors.
(d) Testing is the process of confirming that a database meets its objectives.

12. Review the picture below and identify the area(s) returned by a right outer join query.
SQL join types picture

(a) 2
(b) 2 + 3
(c) 1 + 2 + 3

13. Review the picture above and identify the area(s) returned by an inner join query.
(a) 2 + 3
(b) 3
(c) 1 + 2
(d) 1 + 2 + 3

14. What is a query?
(a) Question.
(b) Answer.
(c) Report.
(d) Database.

15. Which is true about the NULL value in SQL statement?
(a) Null values are displayed first in the ascending sequences.
(b) Null values are not displayed.
(c) Null values are displayed last in the ascending sequences.
(d) All of the above.

16. What are the three main building blocks for relational database?
(a) data fields, data records, and data indexes.
(b) primary keys, foreign keys, unique keys.
(c) data fields, data records, and data tables.
(d) table, record, query.

17. What is the smallest building block in a relational database?
(a) data record
(b) data field
(c) index
(d) primary key

18. What is a database schema?
(a) Language used to handle the database
(b) Tables and Fields
(c) The Queries used to extract data
(d) Layout and structure of the database

19. ODBC stands for:
(a) Open Database Connection
(b) Open Database Connectivity
(c) Open Database Connector
(d) Open Database Connectors

20. What are component languages that make up SQL?
(a) DML (Data Manipulation Language)
(b) DDL (Data Definition Language)
(c) DCL (Data Control Language)
(d) All of the above.

21. DML (Data Manipulation Language) includes component:

(a) SELECT, UPDATE, INSERT, and DELETE statements.
(b) CREATE TABLE, DROP TABLE, CREATE VIEW, and DROP VIEW statements.
(c) GRANT and REVOKE statements.
(d) All of the above.

22. DDL (Data Definition Language) includes component:
(a) SELECT, UPDATE, INSERT, and DELETE statements.
(b) CREATE TABLE, DROP TABLE, CREATE VIEW, and DROP VIEW statements.
(c) GRANT and REVOKE statements.
(d) All of the above.

23.DCL (Data Control Language) includes component:
(a) SELECT, UPDATE, INSERT, and DELETE statements.
(b) CREATE TABLE, DROP TABLE, CREATE VIEW, and DROP VIEW statements.
(c) GRANT and REVOKE statements.
(d) All of the above.

24. What are the “mandatory clauses" in SQL?
(a) Select, FROM
(b) WHERE, GROUP BY
(c) HAVING, ORDER BY

25. What is a report?
(a) bridge between the database and the client
(b) A report is a formatted version of a query result.
(c) SQL query of database
20 more questions coming soon

RESULTS

Click CHECK button to calculate your SQL interview questions score

On this page I put Online SQL Test For Software Testers. Questions in the SQL Online Test (software testing, QA) found above are listed in order of complexity. However all new SQL interview questions (regardless of there difficulty) will be added to the bottom of the list. You can find more SQL Interview Questions searching the WEB. END Online SQL Test Interview Questions QA, software testing.

Interview Questions Software Testing Main Page