Your proficiency in SQL Database is judged by your performance in the online
tests. Reading books after books on SQL Server alone can not help you crack an
interview or clear a certification test. Practice with this online test on SQL
Database to ensure that you choose the correct answer from very closely related
options and finish the test on time.
Online Practice
Test > Database online test
Here are few sample Database test/quiz questions
Which of the following contains a complete record of all activity that
affected the contents of a database during a certain period of time?
Report writer
Query language
Data manipulation language
Transaction log
Referential integrity controls relationship between
Attributes in a table
Operations of an object
Instances of a class
Tables in a database
Which of the database property says "When an update occurs to a database,
either all or none of the update becomes available to anyone"
Isolation
Atomicity
Consistency
Durability
Click here to
start Database quiz/test
More Links
Answer - Truncate command is used to remove all rows of the
column.The removed records are not recorded in the transaction log......
Answer - The column or columns of the table whose value
uniquely identifies each row in the table is called primary key. You can define
column as primary key using primary key constraint while you create table.....
Answer - Index can be thought as index of the book that is used
for fast retrieval of information. Index uses one or more column index keys and
pointers to the record to locate record.........
|
