DATABASE MANAGEMENT SYSTEMS CONCEPTS OBJECTIVE INTERVIEW QUESTIONS 2
similar content
Q1 . what are DDL statements?
SOLUTION
They are the statements used to define the structure of the databases.They are used to create or alter tables.
Q2 . What are DCL statements?
SOLUTION
It expands to Data Control Language.It is mainly used to grant privileges to users .The main functions would be grant and revoke etc.
Q3 . what is the query to delete table contents?
SOLUTION
DELETE is used to delete the contents.Format of deletes is delete from where .
Q4 . what is the query to delete the table?
SOLUTION
DROP is used to delete the table and all its contents.The syntax is drop table
Q5 . what is the use of auto increment?
SOLUTION
It is used to insert the data in a field based on requirement as data is inserted in the table.
Q6 . what are database models?
SOLUTION
Database models define the structure of the databases.some examples of the database models are hierarchial model,Object oriented model etc.
Q7 . what is an in memory database?
SOLUTION
In this type ,The data base is in the main memory or the RAM.These type of databases are a priority when performance is the key.However it may be backed up is a hard disk
Q8 . what is a distributed database?
SOLUTION
The databases and the data may be spread across various systems across a network are called databases.
Q9 . what is a relational model?
SOLUTION
It is an approach by EC CODD where data are as tuples and grouped in relations.An database that uses relational models are called relational databases.
Q10 . What are deadlocks?
SOLUTION
It is a situation in which two resources are waiting for a same resource(Example:printer or scanner) for their completion.This situation in which none of the process can complete is called a deadlock.