closepop
closepop

Would you like to submit the test?


DBMS :

Basic




1.
What is DBMS ?

The database management system is a collection of programs that enables user to store, retrieve, update and delete information from a database.




2.
What is RDBMS ?

Relational Database Management system (RDBMS) is a database management system (DBMS) that is based on the relational model.




3.
What is SQL ?

Structured Query Language(SQL) is a language designed specifically for communicating with databases.




4.
what is a field in a database ?

A field is an area within a record reserved for a specific piece of data.




5.
What is a Record in a database ?

A record is the collection of values / fields of a specific entity: i.e. an Employee, Salary etc.




6.
What is a Database Lock ?

Database lock tells a transaction, if the data item in questions is currently being used by other transactions.




7.
What is a Unique Key ?

Unique key is same as primary with the difference being the existence of null. Unique key field allows one value as NULL value.




8.
What is Self-Join?

Self-join is query used to join a table to itself. Aliases should be used for the same table comparison.




9.
What is a view?

The views are virtual tables. Unlike tables that contain data, views simply contain queries that dynamically retrieve data when used




10.
What is Collation?

Collation refers to a set of rules that determine how data is sorted and compared.




11.
What is Trigger?

A trigger is a SQL procedure that initiates an action when an event (INSERT, DELETE or UPDATE) occurs.




12.
What is Index?

An index is a physical structure containing pointers to the data. Indices are created in an existing table to locate rows more quickly and efficiently.




13.
What is a stored procedure?

Stored Procedure is a function which contains a collection of SQL Queries. The procedure can take inputs , process them and send back output.










FreshersLive - No.1 Job site in India. Here you can find latest 2016 government as well as private job recruitment notifications for different posts vacancies in India. Get top company jobs for both fresher and experienced. Job Seekers can get useful interview tips, resume services & interview Question and answer. Practice online test free which is helpful for interview preparation. Register with us to get latest employment news/rojgar samachar notifications. Also get latest free govt and other sarkari naukri job alerts daily through E-mail.


FreshersLive - No.1 Job site in India. Here you can find latest 2016 government as well as private job recruitment notifications for different posts vacancies in India. Get top company jobs for both fresher and experienced. Job Seekers can get useful interview tips, resume services & interview Question and answer. Practice online test free which is helpful for interview preparation. Register with us to get latest employment news/rojgar samachar notifications. Also get latest free govt and other sarkari naukri job alerts daily through E-mail.