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
Show Answer

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
Show Answer
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
Show Answer
4
___________ commits after deleting entire table ie can not be rolled back
a. TRUNCATE
b. DELETE
c. 1AND2
d. NONE
Show Answer
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
Show Answer
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
Show Answer
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
Show Answer
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
Show Answer
9
What is Data Mart
a. data warehouse
b. Subset of data ware house
c. Staging area
d. ODC(Operation Data Store)
Show Answer
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.
Show Answer