Technology Questions

Q:

Can you explain how to insert an image in table in oracle?

Answer

Insert image into a table


Create the following table:


      create table pics_table (


      bfile_id number,


      bfile_desc varchar2(30),


      bfile_loc bfile,


      bfile_type varchar2(4))


      TABLESPACE appl_data


      storage (initial 1m next 1m pctincrease 0) 


Insert Query:


      INSERT INTO pics_table


      VALUES(4,'test image',bfilename('GIF_FILES','Test.JPG'),'JPEG'); 

Report Error

View answer Workspace Report Error Discuss

Subject: Oracle

2 3874
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 3855
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 3854
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 3845
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 3844
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 3833
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 3827