Why session is created ?
How is it related to security concern for the application?
Why session ID is created ?

Gaurav.khurana

 Profile Answers by Gaurav.khurana Questions by Gaurav.khurana

• May 9th, 2015

Its like to maintain some information during a particular conversation. Suppose you open gmail so some information has to be maintain during the whole conversation with server from browser(client) ..
So that information is stored somewhere till the time you logout.(example)

abha maurya

• Apr 18th, 2015

Session creation ?is very important for security purpose....suppose various people on the same website trying to fill form so how does server understand the request of diff. Users that's why we use s...

Answer Question  Select Best Answer

Login Screen

User ID -> textbox
Password -> textbox

Sign in-> button..

Can someone send me how to write test cases for the above requirement?

Haritha

• Apr 17th, 2015

Enter Blank details and click on sign in button
Enter valid user name,Invalid password and click on sign in button
Enter Invalid user name ,valid password and click on sign in button
Enter Both invalid details and click on sign in button
Enter Valid User name& password click on sign in button

msrajeshreddy

• Oct 25th, 2013

1.enter valid username and valid password.
2.enter invalid username and valid password.
3.enter invalid username and invalid password.
4.enter blank username and valid password.
5.enter valid username and blank password.
6.enter blank username and blank password.

Answer Question  Select Best Answer

Suppose we have two database in one database there are 10 block ? then we want only eight block import in second dba how????

Differentiate between Controlled and Uncontrolled Redundancy

Azad

• Feb 13th, 2015

Drawback of traditional file system

supriya_pict

 Profile Answers by supriya_pict Questions by supriya_pict

• Sep 11th, 2009

Redundancy is Direct if a value is a copy of another Indirect if the value can be derived from other values: Simplifies retrieval but complicates update Conversely integration makes...

Answer Question  Select Best Answer

Nirali Dedhia

• Aug 15th, 2014

State and explain categories os specialization?

Gajanan K

• Jul 13th, 2007

Aggregation: Selecting the data in group of records is called aggregation. There are five aggregate system functions they are viz. Sum, Min, Max, Avg, Count. They all have their own purpose Decomp...

Answer Question  Select Best Answer

Why is the choice of primary key important and are three characteristics of an ideal primary key?

sanit kale

• Apr 24th, 2014

The PRIMARY KEY constraint uniquely identifies each record in a database table.

Primary keys must contain unique values.

A primary key column cannot contain NULL values.

Each table should have a primary key, and each table can have only ONE primary key.

chaitra murthy

 Profile Answers by chaitra murthy Questions by chaitra murthy

• Jan 16th, 2009

Primary key will let the retrieval operation to be fast.It will not allow you to insert duplicate and null values.It is used to uniquely identify a row in a table.

Answer Question  Select Best Answer

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

Why excessive redo generation in hot backups ?How to resolve it ?

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