Technology Questions

There are two major platforms that providing hosting and servers to host on. The differences between them are as follows:

- Unix are more efficient in performing offsite and onsite, whereas windows doesn’t provide very good efficiency to work with. 

- Unix provide lower hosting cost for the website using the high bandwidth, whereas windows take more resources and have the cost higher for the storage. 

- Unix is better for the websites that are static and includes HTML and graphics, whereas Windows is used for heavy websites and having more requirements. 

- Unix supports the scripting languages like PHP and databases like MySQL and other related categories, whereas Windows supports IIS, coldfusion and big applications that take more space.

Interface data is static data why bcoz interface supports multiple inheritance.

if inteface data is non-static then there is chance for replication of the data (bcoz of replication of data ambiguity problem occurs )

An app will be in InActive state if it is running in the foreground but is currently not receiving events. An app stays in InActive state only briefly as it transitions to a different state.

Both JavaScript and Jscript are almost similar. JavaScript was developed by Netscape. Microsoft reverse engineered Javascript and called it JScript.

SQL statement gets executed when we open cursor

Joins are used to combine data of one or more tables. Joins should be used when there is abundant data. Joins can be LEFT, RIGHT, OUTER, INNER or even SELF JOIN. The purpose is to bind data from multiple tables without any receptivity

A unique constraint on a column uniquely identifies the record by a combination of one or more fields. Few unique constraint fields can have a NULL value as long as the combination of values is unique.

Example:
create table employee ( id number NOT NULL, dob DATE, professor_id NOT NULL, Name varchar(200) Constraint id_unique UNIQUE(id,dob) );

First we need to create an instance of a JDBC driver or load JDBC drivers, then we need to register this driver with DriverManager class. Then we can open a connection. By using this connection , we can create a statement object and this object will help us to execute the query.