Database online test - sql practice test

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

Click here to start Database quiz/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

Define Truncate and Delete commands.

Answer - Truncate command is used to remove all rows of the column.The removed records are not recorded in the transaction log......

Define Primary and Unique key.

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.....

What is index? Define its types.

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......... 



Write your comment - Share Knowledge and Experience

Discussion Board
Database Online Test - SQL Practice Test

A top-to-bottom relationship among the items in a database is established by a

Hierarchical schema
Network schema
Relational schema
All of the above


Database Online Test 05-11-2012 03:04 AM

Database Online Test - SQL Practice Test

Report generators are used to

Store data input by a user
Retrieve information from files
Answer queries
Both b and c


Database Online Test 05-11-2012 03:04 AM

Database Online Test - SQL Practice Test

The highest level in the hierarchy of data organization is called

Data bank
Data base
Data file
Data record


Database Online Test 05-11-2012 03:04 AM

Database Online Test - SQL Practice Test

An audit trail is

Used to make backup copies
The recorded history of operations performed on a file
Be used to restore lost information
None of the above


Database Online Test 05-11-2012 03:04 AM

More online test

SQL Server DBA questions
Datawarehousing test
Biztalk Test
Networking Test
Iphone Test
Android Quiz
Wireless Communication Test
OS test
Linux Test
Linux Quiz
Linux Certification
C Online Quiz
C++ Online Test


Career 12-20-2011 03:51 AM

 


Latest MCQs
» General awareness - Banking » ASP.NET » PL/SQL » Mechanical Engineering
» IAS Prelims GS » Java » Programming Language » Electrical Engineering
» English » C++ » Software Engineering » Electronic Engineering
» Quantitative Aptitude » Oracle » English » Finance
Home | About us | Sitemap | Contact us | We are hiring