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

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

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

Sharath

• Jun 8th, 2015

Select ename ,count(ename) from emp group by ename

ashbittu

 Profile Answers by ashbittu Questions by ashbittu

• Jun 1st, 2015

Code
 

Answer Question  Select Best Answer

shravanam

 Profile Answers by shravanam Questions by shravanam

• Oct 25th, 2007

In varchar u can store upto 2000 bytesIn varchar2 u can store upto 4000 bytesIn Oracle  even if u declare a variable with varchar it takes varchar2 into consideration and creates that variable with varchar2

yuvarajan2000

 Profile Answers by yuvarajan2000 Questions by yuvarajan2000

• Apr 24th, 2007

Varchar and Varchar2 is different.Varchar and varchar2 store is 2000 char. varchar2 size is automatically reduce. It will take on using char size based.

Answer Question  Select Best Answer

priyanka

• Sep 26th, 2007

When the database is taken in backup mode the checkpoint takes place and the datafile header gets frozenAs the checkpoint takes place the database writer writes all the blocks from database buffer cac...

Priyanka P

• Nov 1st, 2006

. while taking hotbackup (begin end backup) what will happend backend 2. You system performs a nightly backup of all the data in the /sales_data file system using ufsdump to an 8mm DAT tape. Recently,...

Answer Question  Select Best Answer

sreyaskvmce&it

 Profile Answers by sreyaskvmce&it Questions by sreyaskvmce&it

• Mar 31st, 2006

Drop user username cascade

ram vara prasad

• Mar 9th, 2006

tx paa,         drop user user_name cascade;           This command really works..

Answer Question  Select Best Answer

23kannan

 Profile Answers by 23kannan Questions by 23kannan

• May 8th, 2008

Null interfaces act as markers. They just tell the compiler that the objects of this class need to be treated differently. some marker interfaces are : Serializable, Remote, Cloneable

srinivas

• Dec 24th, 2006

Null interface is a markup interface

Answer Question  Select Best Answer

sachin s

• Apr 4th, 2007

IS Predicate comes with Create and AS comes with replace.

shailendra_suman

• Feb 19th, 2007

I don't think there is any difference.  I tried both and worked fineSQL> SQL> create procedure testing is  2    3  begin  4    5  dbms_output.put...

Answer Question  Select Best Answer

ZAHID

• Nov 20th, 2016

Three Components:
1. Data Structure (Data organization in the form of table with row and table)
2. Data Manipulation (Operation perform(using SQL) on data stored in relation)
3. Data Integrity (Maintain data stored in relation for long time)

Sandhya.Kishan

 Profile Answers by Sandhya.Kishan Questions by Sandhya.Kishan

• Jul 6th, 2012

The Relational model contains 3 components 1)set of relations and set of domains ( data structure).
2)Integrity rules (data integrity) and
3)The operation that can be operate on the data (data manipulation).

Answer Question  Select Best Answer

soumya.rampalli

 Profile Answers by soumya.rampalli Questions by soumya.rampalli

• Mar 7th, 2007

Yes what is the different between schema and database

yuvaraj.r

• Mar 6th, 2007

Normally we are reteriving datas internally in the tables of the database

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

Culver_lake

 Profile Answers by Culver_lake Questions by Culver_lake

• Mar 19th, 2006

These answers are probably all correct---if it's SQLServer or Sybase. I don't think the DBMS was identified and for sure the data dictionary/relational catalog/system tables are not standard in naming...

rajnarayan yadav

• Jan 16th, 2006

 Index information in : user_indexes Constraint information in : user_constraints and user_cons_columns

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

viswanath

• Aug 23rd, 2015

I did not found any "demobld.sql" in my system, then how can import default tables ?

smartrameshdwh

• Apr 4th, 2007

step1) Search "demobld.sql" file in the directory where you installed Oracle using Search option. step2) Make a copy of it (demobld.sql) in C drive or D drive step3)Execute "@c:demobld....

Answer Question  Select Best Answer

Fakruddin Khan

• Mar 30th, 2012

The top-down method starts from the general and moves to the specific. Basically, you start with a general idea of what is needed for the system and then ask the end-users what data they need to stor...

chaitra murthy

 Profile Answers by chaitra murthy Questions by chaitra murthy

• Jan 28th, 2009

Top Down approach:- ER ModellingBottom Up approach:- Normalization

Answer Question  Select Best Answer

Kanhucharan

 Profile Answers by Kanhucharan Questions by Kanhucharan

• Apr 25th, 2008

 As trigger is implicitly fired, u can not commit.Here I m giving one example. Let u wrote a trigger for inserting 100 records,And after that U wrote commit,When the particular event occures...

harsh

• Jan 20th, 2007

since we know -triggers r statement that r executed automatically as sideeffect of data modification.therefore we can not write commit in triggers..but we write for data security.. 

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

prakash

• Oct 30th, 2006

Perform is purely based on executionhow we get the result, ie Time , spped etcbutexecute is purely depends on logic of how we had done the design and code,itslike the output for given input for a written logic

anand sharma

• Sep 8th, 2006

what is the difference between perform and execute?

Answer Question  Select Best Answer

Madhu Kalla

 Profile Answers by Madhu Kalla Questions by Madhu Kalla

• Feb 10th, 2009

The subschema is the logical view of the data as it appears to the applications program

Dheeraj

• Aug 29th, 2006

In database management, an individual user's partial view of the database. The schema is the entire database.

Answer Question  Select Best Answer