Data Centric | Testing | Mock Test
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
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
“Move all data to another table that is not dependent on the Primary Key” is the rule for which normal form
___________ commits after deleting entire table ie can not be rolled back
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
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
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
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?
What is Data Mart
a. data warehouse
b. Subset of data ware house
c. Staging area
d. ODC(Operation Data Store)
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.