DBMS Database Management System - Technical Questions and Answers

DBMS - Database Management System
DBMS - Basics

61.	Why is XML a better markup language than HTML?
	Answer: XML is a better markup language than HTML, primarily because XML provides a clear separation between document structure, content, and materialization. Symbols cannot be used ambiguously with XML. Workspace Report errors ... Name : Email: View Answer

62.

What are the two means to describe the content of XML documents?

63.	What is the difference between simple elements and complexType elements?
	Answer: Simple elements have only one data value. ComplexType elements can have multiple elements nested within them. ComplexTypes may also have attributes. The elements contained in a complexType may be simple or other complexTypes. ComplexTypes may also define element sequences. Workspace Report errors ... Name : Email: View Answer

64.

What is ADO.NET?

65.

What is a dataset?

66.

Briefly describe the four JDBC driver types that Sun defines.

67.	What is the difference between a Java servlet and a Java applet?
	Answer: An applet is a compiled Java bytecode program that is transmitted to a browser via HTTP and is invoked using the HTTP protocol on the user's workstation. A servlet is a Java program that is invoked on the server to respond to HTTP requests. Workspace Report errors ... Name : Email: View Answer

68.	What is the coding pattern for using a JDBC driver?
	Answer: 1. Load the driver. 2. Establish a connection to the database. 3. Create a statement. 4. Do something with the statement. Workspace Report errors ... Name : Email: View Answer

69.	What is a Java bean?
	Answer: A Java bean is a Java class that has the following three properties. (1) There are no public instance variables. (2) All persistent values are accessed using methods named getxxx and setxxx. (3) The bean class must either have no constructors or it must have one explicitly defined zero-argument constructor. Workspace Report errors ... Name : Email: View Answer

70.	How are surrogate keys and metadata handled in MySQL?
	Answer: MySQL uses integer data types combined with the property AUTO_INCREMENT to create surrogate keys. This creates a sequence that starts at one (1) and increases by one (1) for each new record. MySql maintain its metadata in a database named mysql. For example, this database maintains two tables named user and db. Workspace Report errors ... Name : Email: View Answer