rubin2008

 Profile Answers by rubin2008 Questions by rubin2008

• Jan 31st, 2010

Yes it is possible to have primary key and foreign key in one table.For e.g the schema for table category is as followsCategory_id: int primary keyCategory_title: varchar(30)parent_id: int(3)In the ab...

Shri

• Nov 1st, 2007

Dear Vivek,If I understand your question well, you mean to say that "is there any possibility to have both?primary & foreign keys in the same table".Well, the answer is No. The foreign key (by defini...

Answer Question  Select Best Answer

NOTNULL

 Profile Answers by NOTNULL Questions by NOTNULL

• May 18th, 2009

View is mainly created to provide security for the data and data definitions. Mainly used to retrieve the data in a secure manner.View cannot use space in the physical memory means virtually it w...

rajakumar_na

 Profile Answers by rajakumar_na Questions by rajakumar_na

• Nov 14th, 2007

One more point isView is a Schema ObjectJoin is not a schema object

Answer Question  Select Best Answer

nishant s mevawala

• Aug 30th, 2011

1.Information Rule
2.Guaranteed Access Rule
3.Systematic Treatment of Nulls Rule
4.Active On-line catalog based on the relational model
5.Comprehensive Data Sub-language Rule

rajakumar_na

 Profile Answers by rajakumar_na Questions by rajakumar_na

• Nov 14th, 2007

Dr. E.F. Codd, an IBM researcher, first developed the relational data model in 1970. In 1985, Dr. Codd published a list of 12 rules that concisely define an ideal relational database, which have provi...

Answer Question  Select Best Answer

Difference between the three levels of data abstraction, and between a schema and instances.. Consider a two dimensional integer array of size n*m that is to be used in your favorite programming language. Using the array as an example, illustrate the difference (a) between the three levels of data abstraction, and (b) between a schema and instances.

Lokesh M

 Profile Answers by Lokesh M Questions by Lokesh M

• Nov 20th, 2011

Data Abstraction means suppression of information / details of data organization and storage. Data Abstraction gives importance to mainly essential aspects in order to help better understanding of th...

Answer Question  Select Best Answer

What is the relationship between a company's databases and its data warehouse?

Hirru

• Feb 10th, 2012

Database is a structured collection of relational data. Database is used to store the relational, network or hierarchical data. It contains some sort of data and it is being used by the organization...

Lokesh M

 Profile Answers by Lokesh M Questions by Lokesh M

• Nov 20th, 2011

In simple words, a database is used to store information, and a data warehouse is used to query and analyse the stored data in several ways. Data warehouse helps business management to take important...

Answer Question  Select Best Answer

raman sharma

• Mar 2nd, 2012

normal are of five type 1) 1 normal form 2) 2 normal form 3) 3 normal form 4) 4 normal form 5) 5 normal form all normal are created to connected a table with each other and data are retrieve very ea...

Answer Question  Select Best Answer

Been given this question from my son and he has told me that he googled the question but got no satisfactory answer. Would much appreciate an answer.

raman sharma

• Mar 2nd, 2012

DBMS is a when data are not stored in table and RDBMS is used to all data are stored in table and distributed database when more than one table are connected with each other so its is called a distributed database

suji

 Profile Answers by suji Questions by suji

• Dec 21st, 2011

DBMS - Its a software package combination of various computer programs which can be used to control, administer, maintain and use of the database. RDBMS - Its a database management system (DBMS) b...

Answer Question  Select Best Answer

Explain a one-to-many strong vs. one-to-many weak entity relationship.

raman sharma

• Mar 2nd, 2012

Entity relationship when attribute are connected to entity there are different different type attribute are available weak entity and strong entity when we are using key that called strong entity and when key are not connected that called weak entity

Lokesh M

 Profile Answers by Lokesh M Questions by Lokesh M

• Nov 20th, 2011

Weak Entity generally don't possess key attributes of their own whereas a Strong Entity possess its own key attributes that are independent of other entities. Weak entity is usually existence-dependent on another entity type and does not have enough attributes to form its own primary key.

Answer Question  Select Best Answer

raman sharma

• Mar 2nd, 2012

There are two type of join

1)inner join
inner join have a three type
I)equi join
II)nonequi join
III)self join

and outer join have a two type

I)right outer join
II)left outer join

and one is a ANSI join that a advance

Pradeep

• Feb 21st, 2012

Join, Inner join, Outer join, Left join, Right join, Full join

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

Which types of trigger can be fired on DDL operation?
A. Instead of triggerB. DML triggerC. System triggerD. DDL trigger

Sandhya.Kishan

 Profile Answers by Sandhya.Kishan Questions by Sandhya.Kishan

• Apr 5th, 2012

The trigger which can be fired on DDL operator is DDL trigger.

Answer Question  Select Best Answer

Name three activities involved in requirement gathering

Sandhya.Kishan

 Profile Answers by Sandhya.Kishan Questions by Sandhya.Kishan

• Apr 5th, 2012

Three activities involved in requirement gathering are
1.Eliciting requirement
2.Analyzing requirement
3.Recording requirement

Answer Question  Select Best Answer

Functions for error trapping are contained in which section of a PL/SQL block?

Sandhya.Kishan

 Profile Answers by Sandhya.Kishan Questions by Sandhya.Kishan

• Apr 5th, 2012

The Exception section of the PL/SQL block contains the functions for error handling.

Answer Question  Select Best Answer

List the rules used to enforce table level integrity.

Sandhya.Kishan

 Profile Answers by Sandhya.Kishan Questions by Sandhya.Kishan

• Apr 5th, 2012

There are 3 rules to enforce table level integrity. 1.Foreign key value can be modified only if we want to match the corresponding primary key value. 2.We cannot delete records either from parent or c...

Answer Question  Select Best Answer

Hi, I recently tried to get employee names and their dept names without a join condition, this query, although succeeds, I can't figure how it works. please help.

select ename,(select dname from dept where deptno=e.deptno) from emp e;

Mark Haynes

 Profile Answers by Mark Haynes Questions by Mark Haynes

• Apr 11th, 2012

Youre using a Sub-query -- [(select dname from dept where deptno = e.deptno)] -- to get around using a join clause like -- [FROM EMP E INNER JOIN DEPT D ON (D.DEPTNO = E.DEPTNO)] -- however, you are n...

Blaster_Ayub_Khan

• Apr 10th, 2012

SQL coins the term query as the name for its commands. Basically, all SQL code is written in the form of a query statement and then executed against a database. All SQL queries perform some type of da...

Answer Question  Select Best Answer

Hi, I am starting oracle services on redhat linux ,
but unable to start " sql * plus service" from console as well as from em(oracle enterprise manager)
Error : "The connection was refused when attempting to contact localhost : 5560"

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

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

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

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