DBMS Basics - Technical Questions and Answers

DBMS - Database Management System
DBMS - Basics

71.	Which part of the RDBMS takes care of the data dictionary? How?
	Answer: Data dictionary is a set of tables and database objects that is stored in a special area of the database and maintained exclusively by the kernel. Workspace Report errors ... Name : Email: View Answer

72.	What is the job of the information stored in data-dictionary?
	Answer: The information in the data dictionary validates the existence of the objects, provides access to them, and maps the actual physical storage location. Workspace Report errors ... Name : Email: View Answer

73.	How do you communicate with an RDBMS?
	Answer: You communicate with an RDBMS using Structured Query Language (SQL). Workspace Report errors ... Name : Email: View Answer

74.	Define SQL and state the differences between SQL and other conventional programming Languages.
	Answer: SQL is a nonprocedural language that is designed specifically for data access operations on normalized relational database structures. The primary difference between SQL and other conventional programming languages is that SQL statements specify what data operations should be performed rather than how to perform them. Workspace Report errors ... Name : Email: View Answer

75.

Name the three major set of files on disk that compose a database in Oracle.

76.

What is database Trigger?

77.	What are stored-procedures? And what are the advantages of using them?
	Answer: Stored procedures are database objects that perform a user defined operation. A stored procedure can have a set of compound SQL statements. A stored procedure executes the SQL commands and returns the result to the client. Stored procedures are used to reduce network traffic. Workspace Report errors ... Name : Email: View Answer

78.	What is Storage Manager?
	Answer: It is a program module that provides the interface between the low-level data stored in database, application programs and queries submitted to the system. Workspace Report errors ... Name : Email: View Answer

79.	What is Buffer Manager?
	Answer: It is a program module, which is responsible for fetching data from disk storage into main memory and deciding what data to be cache in memory. Workspace Report errors ... Name : Email: View Answer

80.	What is Transaction Manager?
	Answer: It is a program module, which ensures that database, remains in a consistent state despite system failures and concurrent transaction execution proceeds without conflicting. Workspace Report errors ... Name : Email: View Answer