DBMS Basics - Technical Questions and Answers

DBMS - Database Management System
DBMS - Basics

31.	What is Data Storage - Definition Language?
	Answer: The storage structures and access methods used by database system are specified by a set of definition in a special type of DDL called data storage-definition language. Workspace Report errors ... Name : Email: View Answer

32.

What is DML (Data Manipulation Language)?

33.	What is DML Compiler?
	Answer: It translates DML statements in a query language into low-level instruction that the query evaluation engine can understand. Workspace Report errors ... Name : Email: View Answer

34.	What is Query evaluation engine?
	Answer: It executes low-level instruction generated by compiler. Workspace Report errors ... Name : Email: View Answer

35.	What is DDL Interpreter?
	Answer: It interprets DDL statements and record them in tables containing metadata. Workspace Report errors ... Name : Email: View Answer

36.	What is Record-at-a-time?
	Answer: The Low level or Procedural DML can specify and retrieve each record from a set of records. This retrieve of a record is said to be Record-at-a-time. Workspace Report errors ... Name : Email: View Answer

37.	What is Set-at-a-time or Set-oriented?
	Answer: The High level or Non-procedural DML can specify and retrieve many records in a single DML statement. This retrieve of a record is said to be Set-at-a-time or Set-oriented. Workspace Report errors ... Name : Email: View Answer

38.	What is Relational Algebra?
	Answer: It is procedural query language. It consists of a set of operations that take one or two relations as input and produce a new relation. Workspace Report errors ... Name : Email: View Answer

39.	What is Relational Calculus?
	Answer: It is an applied predicate calculus specifically tailored for relational databases proposed by E.F. Codd. E.g. of languages based on it are DSL ALPHA, QUEL. Workspace Report errors ... Name : Email: View Answer

40.	How does Tuple-oriented relational calculus differ from domain-oriented relational calculus?
	Answer: The tuple-oriented calculus uses a tuple variables i.e., variable whose only permitted values are tuples of that relation. E.g. QUEL The domain-oriented calculus has domain variables i.e., variables that range over the underlying domains instead of over relation. E.g. ILL, DEDUCE. Workspace Report errors ... Name : Email: View Answer