Read Best Answer

Editorial / Best Answer

opbang  

 Profile Answers by opbang Questions by opbang

• Member Since Mar-2006 | Sep 24th, 2006

---

Transaction Database Vs DataWarehouse Database-

1. Transaction Database is Relational Database with the normalised table, whereas DataWarehouse is with denormalised Table.

2. Transaction Database is highly volatile... Designed to maintain transaction of the business Where DataWarehouse is non volatile.. with periodic updates.

3. Transaction Database is OLTP...   Datawarehouse ... is for analysis... 

4. Transaction Database is functional data...  DataWarehouse database Data is subject oriented.

kalai

• Jan 29th, 2014

Transactional database means current data in database.
data warehouse means historical data.i.e old data that are flushed out.

sreenivas

• Nov 25th, 2012

A transactional database is defined for day-to-day operations like insert, delete and update and in a Datawarehouse databases (OLAP databases) are designed for Analytical purpose. So they require historical data for analysis. These databases are huge databases to store historical data.

Improve Answer

Read Best Answer

Editorial / Best Answer

Answered by: NITIN TOMER

• Sep 6th, 2011

---

sql is a structured query language........and t-sql is implementing on sql server........and t-sql having some more queries than sql .

kandriga murali

• Dec 8th, 2013

1) .SQL is non-procedural language since it deals with what data to be extracted.Whereas T-SQL is procedure language since it deals with what data to be executed and how it should be displayed.
2) . SQL can executed only single command whereas T-SQL can executed multiple statement at time.

Syed Umar Abbas

• Mar 28th, 2012

Microsoft SQL Server have some more additions to Database Standard Query Language (SQL) is called T-SQL

Improve Answer

Sheraz Baig

• Nov 22nd, 2013

Subquery is basically Query Withing Query.. and the Result of Subquery is used by Outer query and Subquery could be at any level its not level restricted...

DIPTENDU HUI

• Jan 28th, 2006

1.Subquery is nothing but a query inside a query which appears only after the WHERE clause of a select statement.2.Two types of subquery is there:a) Co-Related subqueryb) Non-Co-related subquery.3. Us...

Answer Question  Select Best Answer

Sheraz Baig

• Nov 22nd, 2013

GUI based

manishayadav_1

 Profile Answers by manishayadav_1 Questions by manishayadav_1

• Apr 9th, 2008

menu-driven

Answer Question  Select Best Answer

How does Export/Import feature differ from that of SQL Loader?

Sheraz Baig

• Nov 21st, 2013

Totally different Export/Import are oracle utilities to export data in the oracle format and to import the data which is been exported so the format will be the oracle one. While SQL Loader is the u...

dhiren21

 Profile Answers by dhiren21 Questions by dhiren21

• Sep 20th, 2009

Its Different.. For Export we are exporing the data from the Database to a Dump file..i.e EXP from user datafile buffer rows compress etcfor Imprting we are importing the data from a dump file to a da...

Answer Question  Select Best Answer

How to display nth lowest record in a table for example? How to display 4th lowest (salary) record from customer table?

Read Best Answer

Editorial / Best Answer

Answered by: Yadnesh

• Jun 1st, 2013

---

-- First of all Customers table wont have salary attribute. we need to use employees/employeesSalary table -- where we can find salary attribute. -- for finding nth lowest salary record we can obtain derived column using DENSE_RANK() in a subquery and -- obtain temporary result set and finding nth record in a temporary result set using WHERE clause -- for the given example, following is the solution.

Code
 

Yadnesh

• Jun 1st, 2013

-- First of all Customers table wont have salary attribute. we need to use employees/employeesSalary table -- where we can find salary attribute. -- for finding nth lowest salary record we can obtai...

Improve Answer

Read Best Answer

Editorial / Best Answer

daniel.doboseru  

 Profile Answers by daniel.doboseru Questions by daniel.doboseru

• Member Since Feb-2013 | Feb 6th, 2013

---

An ontology refers to a model that contains a set of classes (individuals) plus a set of relations between them. Lets consider a relational database model, having three tables: Human, Man, Woman. As you can observe, there is no relation defined between them. Well, in an ontology, besides that, you might also have a set of rules like: - Object X is Man, if and only if is Human, but is not Woman. - If object X is Human, then it is either Man or Woman, but not both. For defining ontologies there are several languages developed, the most representative being OWL (Web Ontology Language. And for querying them one must also use a specialized language (eg. SPARQL).

daniel.doboseru

 Profile Answers by daniel.doboseru Questions by daniel.doboseru

• Feb 6th, 2013

An ontology refers to a model that contains a set of classes (individuals) plus a set of relations between them. Lets consider a relational database model, having three tables: Human, Man, Woman. As ...

Improve Answer

Multiset table with UPI will allow duplicates or not?

Read Best Answer

Editorial / Best Answer

daniel.doboseru  

 Profile Answers by daniel.doboseru Questions by daniel.doboseru

• Member Since Feb-2013 | Feb 6th, 2013

---

UPI stands for Unique Primary Key, which constrain us to have unique keys, thus unique rows. Now even if the Multiset table allows duplicate rows by definition, the UPI constraint overrules it. Answer: No.

daniel.doboseru

 Profile Answers by daniel.doboseru Questions by daniel.doboseru

• Feb 6th, 2013

UPI stands for Unique Primary Key, which constrain us to have unique keys, thus unique rows. Now even if the Multiset table allows duplicate rows by definition, the UPI constraint overrules it.

Answer: No.

Improve Answer

avinash

• Jan 21st, 2013

Yes to store excel file in data base just you have to save the excel file in .CSV(comma delimiter) format and then insert the value as usually in database.....

Waqas Ahmed

• Oct 6th, 2012

Here is the query to export data into csv file.

Code
span style="color: #ff0000;">"
ESCAPED BY 
LINES TERMINATED BY 
FROM products

Answer Question  Select Best Answer

How to remove only one column values from the duplication of values in that column without using any other column references in that table?

dhanraj varshney

• Jan 6th, 2013

Two methods..
Use unique key
Run query such way-insert ignore into table.

Answer Question  Select Best Answer

saratchand

• Dec 8th, 2012

Two type

In software :top down and button up approach
IN DBMS: generalization and specialization other is aggregation

Answer Question  Select Best Answer

sarat chand

• Dec 8th, 2012

Logical memory is based on schema design. but virtual memory is based on data access that means we want a data from hard disk(physical memory ) to main memory.

Answer Question  Select Best Answer

Read Best Answer

Editorial / Best Answer

Answered by: Karanjeet

• Nov 22nd, 2005

---

Following are the tier types in a client server application:

a. 1 tier application:All the processing is done on one machines and number of clients are attached to this machine (mainframe applications)

b. 2 tier application: Clients and data base on different machines.Clients are thick clients i.e.? processing is done at client side.Application layer is on Clients.

c. 3 tier application.Client are partially thick.Apart from that there are two more layers application layer and database layer.

d. 4 tier application: Some clients may be totally non thick clients some clients may be partially thick and further there are 3 layers web layer, application layer and database layer.

Avinash

• Nov 24th, 2012

If I am not wrong

Class variables are variables which we create inside a class.

&

Class member are the variables & function declared inside class.

Manoj Kumar Chagantipati

• Jun 12th, 2012

In Two tier there will be Presentation layer and Data base layer
Where as in Three tire there will be Presentation layer,Data access layer and Data base layer

Improve Answer

Oracle stores information regarding the names of all the constraints on which table? A)USER_CONSTRAINTS B)DUAL C)USER D)None of these

Naresh kumar

• Oct 3rd, 2012

Constraints divided into 3 types those are: 1. domain integrity constraints:- not null,check 2. entity integrity constraints:- unique,Primary key 3. referential integrity constraints:- foreign key In...

sukrampal

 Profile Answers by sukrampal Questions by sukrampal

• Jul 12th, 2012

User-constraints and all_constraints

Answer Question  Select Best Answer

prathap

• Sep 14th, 2012

We can use "parallel" in the query and in the 11g we can use dynamic sampling.

dhivyavetriselvan

• Jul 26th, 2007

Select query can be made faster by using indexes.

Answer Question  Select Best Answer

What is the degree of relationship? Name the three degrees.

kishorkakade

 Profile Answers by kishorkakade Questions by kishorkakade

• Jul 27th, 2012

The number of entity type involved
i.e
One : Unary
Two : Binary
Three : Ternary

Sandhya.Kishan

 Profile Answers by Sandhya.Kishan Questions by Sandhya.Kishan

• Jul 6th, 2012

Degree of relationship is the cardinality of relationship that defines the number of instances of one entity as it relates to the number of instances of the other entity.Depending on the combinations ...

Answer Question  Select Best Answer

How do indexes increase the searching capabilities?

Sandhya.Kishan

 Profile Answers by Sandhya.Kishan Questions by Sandhya.Kishan

• Jul 25th, 2012

By using the concept of serial scanning the indexes can increase the searching capabilities.

Answer Question  Select Best Answer

What is an intersection table and why is it important?

Sandhya.Kishan

 Profile Answers by Sandhya.Kishan Questions by Sandhya.Kishan

• Jul 6th, 2012

An intersection table implements a many-to-many relationship between two business components.

scud021

 Profile Answers by scud021 Questions by scud021

• Jul 20th, 2008

A table added to the database to break down a many-to-many relationship to form two one-to-many relationships

Answer Question  Select Best Answer

Sandhya.Kishan

 Profile Answers by Sandhya.Kishan Questions by Sandhya.Kishan

• Jul 6th, 2012

Post block trigger belongs to Navigational triggers.

gemini burj

 Profile Answers by gemini burj Questions by gemini burj

• Oct 24th, 2007

Navigation Trigger

Answer Question  Select Best Answer

Sandhya.Kishan

 Profile Answers by Sandhya.Kishan Questions by Sandhya.Kishan

• Jul 6th, 2012

Value set is a collection of values.A value set associated with a report parameters, provides a list of values to the end user to accept one of the values as report parameter value.

kashyap_aseem

 Profile Answers by kashyap_aseem Questions by kashyap_aseem

• Feb 14th, 2008

I thhink it is simmilar to enum in c/c++

Answer Question  Select Best Answer