2
Q:

Difference between clustering and mirroring . 

Answer:
Q:

What are the advantages of LINQ ?

Answer

- Debugging is esy.
- Reduces Development Time.
- LINQ offers IntelliSense which means writing more accurate queries easily.

Report Error

View answer Workspace Report Error Discuss

Subject: Oracle - Technology
Job Role: Analyst , IT Trainer

1 1
Q:

What is LINQ ?

Answer

LINQ stands for " Language Integrated Query " and it is pronounced as "LINK".
LINQ was introduced in with .NET framework 3.5 including VS2008. It enables you to query the data from various data source like SQL, XML document, ADO .NET data source, web services and any other objects such as Collection, Generics etc...

Report Error

View answer Workspace Report Error Discuss

Subject: Oracle - Technology Exam Prep: AIEEE , Bank Exams , CAT
Job Role: Bank Clerk , Bank PO

1 1
Q:

What is DocumentDB ?

Answer

DocumentDB is a NoSQL document-oriented database and records saves in key-value pairs. It's same as the other NoSQL document-oriented such as MongoDB.

Report Error

View answer Workspace Report Error Discuss

Subject: Oracle - Technology
Job Role: Analyst , IT Trainer

1 14
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 - Technology

1 540
Q:

What is WATER MARK in oracle? Explain the significance of High water mark.

Answer

WATER MARK is a divided segment of used and free blocks. Blocks which are below high WATER MARK i.e. used blocks, have at least once contained some data. This data might have been deleted later. Oracle knows that blocks beyond high WATER MARK don’t have data; it only reads blocks up to the high WATER MARK during a full table scan. 

Report Error

View answer Workspace Report Error Discuss

Subject: Oracle - Technology

2 576