Data Centric Testing Questions and Answers


Data Centric | Testing | Mock Test

1
With SQL, how can you return the number of records in the “Persons” table?
a. SELECT COUNT() FROM Persons
b. SELECT COUNT(*) FROM Persons
c. SELECT COLUMNS() FROM Persons
d. SELECT COLUMNS(*) FROM Persons

Answer : SELECT COLUMNS() FROM Persons
2
With SQL, how can you return all the records from a table named “Persons” sorted descending by “FirstName”?
a. SELECT * FROM Persons ORDER BY FirstName DESC
b. SELECT * FROM Persons SORT ‘FirstName’ DESC
c. SELECT * FROM Persons ORDER FirstName DESC
d. SELECT * FROM Persons SORT BY ‘FirstName’ DESC
Answer : SELECT * FROM Persons ORDER BY FirstName DESC
3
“Move all data to another table that is not dependent on the Primary Key” is the rule for which normal form
a. 1NF
b. 2NF
c. 3NF
d. 4NF
Answer : 3NF
4
___________ commits after deleting entire table ie can not be rolled back
a. TRUNCATE
b. DELETE
c. 1AND2
d. NONE
Answer : TRUNCATE
5
A man takes out some cash from an ATM machine. This activity can best be described as a
a. NLAP transaction
b. OLTP transaction
c. MOLAP transaction
d. ROLAP transaction
Answer : OLTP transaction
6
A software engineer executes by mistake an update query that makes changes to all the records. He is now in a fix
a. Restart the database
b. Do a database recovery
c. Do a ROLLBACK
d. Restart the server
Answer : Do a ROLLBACK
7
A software engineer is trying to insert an integer value in a character field. Which of the following constraint will prevent him form doing this action?
a. Primary key constraint
b. Foreign key constraint
c. Not null constraint
d. Domain Constraint
Answer : Domain Constraint
8
Consider the following SQL statement.SELECT qty FROM sales WHERE rate IN (300,800);Which of the following operators can be used to substitute the ‘IN’ operator?
a. AND
b. OR
c. BETWEEN
d. LIKE
Answer : OR
9
What is Data Mart
a. data warehouse
b. Subset of data ware house
c. Staging area
d. ODC(Operation Data Store)
Answer : Subset of data ware house
10
The Logical Data Independence is defined as
a. The Separation of the Conceptual View from the internal view enables us to provide a logical description of the Database without the need to specify the physical structures.
b. Separation of the Internal View and the Physical View
c. Separating the external views from the conceptual view enables us to change the conceptual view without affecting
d. Interface between Physical and Internal View.
Answer : Separating the external views from the conceptual view enables us to change the conceptual view without affecting

Have any Question or Comment?

Leave a Reply

Exciting Offers

Subscribe to Blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 90 other subscribers

Exciting Offers

Exciting Offers

Exciting Offers

Close
%d bloggers like this: