Technology Questions

Q:

State the difference between View and Materialized View ?

Answer

The main differenc between View and Materialized View states that -


1. View means it stores the SQL statement in the database and let you use it as a table. Everytime you access the view, the SQL statement executes.


2. Materialized view means it stores the results of the SQL in table form in the database. SQL statement only executes once and after that everytime you run the query, the stored result set is used. Advantage include quick query results.

Report Error

View answer Workspace Report Error Discuss

6 3868
Q:

When is the finalize() called ? What is the purpose of finalization ?

Answer

The finalize method is called by the garbage collector, just before releasing the object’s memory. It is normally advised to release resources held by the object inside the finalize method.

Report Error

View answer Workspace Report Error Discuss

Subject: Java

1 3857
Q:

How would you automatically transfer your visitors to a new web page?

Answer

- You can do it with the help of meta tag mentioned below: 


<META HTTP-EQUIV="Refresh" CONTENT="2"; URL="https://www.yourname.com"> 


- Place this tag between <HEAD></HEAD> . 


- It will load yousite.com in 2 seconds.

Report Error

View answer Workspace Report Error Discuss

Subject: Web Technology

1 3854
Q:

Where is the reference stored?

A) stack B) heap
C) queue D) None
 
Answer & Explanation Answer: A) stack

Explanation:

Referencee is stored in stack

Report Error

View Answer Report Error Discuss

Filed Under: C++

1 3847
Q:

What is difference between baseband and broadband transmission?

Answer

In a baseband transmission, the entire bandwidth of the cable is consumed by a single signal. In broadband


transmission, signals are sent on multiple frequencies, allowing multiple signals to be sent simultaneously.

Report Error

View answer Workspace Report Error Discuss

1 3843
Q:

Which utility allows you to reference an assembly in an application?

Answer

An assembly can be referenced by using the gacutil.exe utility with the /r option. The /r option requires a reference type, a reference ID, and a description.

Report Error

View answer Workspace Report Error Discuss

Subject: .NET

1 3841
Q:

What do you know about the big-O notation and can you give some examples with respect to different data structures ?

Answer

The Big-O notation simply describes how well an algorithm scales or performs in the worst case scenario as the number of elements in a data structure increases. The Big-O notation can also be used to describe other behavior such as memory consumption. Since the collection classes are actually data structures, we usually use the Big-O notation to chose the best implementation to use, based on time, memory and performance. Big-O notation can give a good indication about performance for large amounts of data.

Report Error

View answer Workspace Report Error Discuss

Subject: Java

0 3831
Q:

What is PHP's mysqli Extension?

Answer

The mysqli extension , or as it is sometimes known, the MYSQL improved extension ,was developed to take advantage of new features found in MYSQL systems versions 4.1.3 and later.

The mysqli extension has a number of benfits,the key enhancements over the mysql extension being:
=> Object-oriented interface
=> Support for prepared statements
=> Support for multiple statements
=> Support for transactions
=> Enhanced debugging capabilities
=> Embedded server support

Report Error

View answer Workspace Report Error Discuss

Subject: PHP

0 3821