2
Q:

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

Answer:



Q:

A data warehouse is composed of

A) current data B) internal and external data sources
C) historical data from legacy systems D) historical & current data
 
Answer & Explanation Answer: C) historical data from legacy systems

Explanation:

A data warehouse is a relational database that is designed for query and analysis rather than transaction processing. It usually contains historical data that is derived from transaction data, but it can include data from other sources. Data warehouses are designed to help you analyze your data.

Report Error

View Answer Report Error Discuss

Filed Under: Oracle
Job Role: Database Administration , IT Trainer

1 2067
Q:

Which of the following are elements of SQL?

A) base-table-identifier ::= user-defined-name B) base-table-name ::= base-table-identifier
C) boolean-primary ::= comparison-predicate D) All the above
 
Answer & Explanation Answer: D) All the above

Explanation:
Report Error

View Answer Report Error Discuss

1 4876
Q:

What is the maximum number of Triggers can be applied in a table ?

A) 8 B) 9
C) 12 D) 14
 
Answer & Explanation Answer: C) 12

Explanation:

We can apply at max of 12 triggers in a table.

Report Error

View Answer Report Error Discuss

Filed Under: Oracle
Job Role: Analyst , IT Trainer

1 4460
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
Job Role: Analyst , IT Trainer

2 5315
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

2 2460
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
Job Role: Analyst , IT Trainer

1 3409
Q:

Difference between clustering and mirroring .

Answer

- Clustering means one than one database server configured for the same user connection. When users connect, one of the server’s responds and connects based on availability. The user is completely ignorant of the fact that there are more than one database servers. It demands high cost due to infrastructure needs. Clustering is hence done on server level.


- Mirroring means, one has many configured databases on the same server. Mirrors are basically copies of the original database. Mirroring is hence done on database level. 

Report Error

View answer Workspace Report Error Discuss

Subject: Oracle

2 4873
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

3 3491