Explain the representation of a one-to-many strong entity relationship in a relational database design.

chaitra murthy

 Profile Answers by chaitra murthy Questions by chaitra murthy

• Jan 16th, 2009

Department-Employees  Under one Department many employees are working.Project-Employees

Answer Question  Select Best Answer

Describe the process of converting an extended E-R model into a relational database design.

chaitra murthy

 Profile Answers by chaitra murthy Questions by chaitra murthy

• Jan 16th, 2009

ER Model->Logical schema->Normalization->Creating database with tables.

Answer Question  Select Best Answer

Discuss the difference between unique and non-unique keys

mudkhedkar

 Profile Answers by mudkhedkar Questions by mudkhedkar

• Nov 7th, 2008

Unique - Take for example employee table, it has column empno which is called as unique key where as non-unique key is column workdept, i.e when we do relationship between two tables as employee & department tables, dept. table also contains deptno as column so it is called as non-unique key.

KamalChauhan

 Profile Answers by KamalChauhan Questions by KamalChauhan

• Jul 11th, 2008

Unique keys can have only one null value or rather i should say that every value in the column(which is marked as unique key) must be unique.

Answer Question  Select Best Answer

zaneizane

 Profile Answers by zaneizane Questions by zaneizane

• Jul 22nd, 2008

This may be considered as the mapping of the data and data relations into an indefinitely large linear address space. This specifies some or all of the data structures necessary to support the data and data relations declared in the conceptual schema.

ALOK BATHAM VAISH

• Dec 24th, 2006

THhe overall design of the database is called Scheema.

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

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

Show the basic architecture of Data Warehouse and briefly describe its components.

Differentiate between Microsoft and Oracle's XML technology support for database.

What are the reasons of developing Object Oriented Database management system? Describe the various features of Object Oriented programming languages that are being supported by SQL with the help of an example each.

Types of users with their duties using suitable examples

johnjustin

 Profile Answers by johnjustin Questions by johnjustin

• Apr 8th, 2008

There is no much difference between user and enduser. A person who uses a system or application is a user. If a software engineer uses Sql server for application development then the person is also ca...

abhay.parashar

 Profile Answers by abhay.parashar Questions by abhay.parashar

• Nov 19th, 2007

 The final or ultimate user of a computer system. The end user is the individual who uses the product after it has been fully developed and marketed. The term is useful because it distinguishes t...

Answer Question  Select Best Answer

kashyap_aseem

 Profile Answers by kashyap_aseem Questions by kashyap_aseem

• Feb 14th, 2008

DAO is quite older one and doesnt support few rdbms'swhile ado is the later one that supports all dbms as well as rdbms

Answer Question  Select Best Answer

kumar1974

 Profile Answers by kumar1974 Questions by kumar1974

• Jan 22nd, 2008

Latches are the seriliazation mechanisms to protect shared data structures in System Global Area. Example Latches protect the list of users presently accessing the database and protect the data struct...

Answer Question  Select Best Answer

Provide VBScript code that that outputs the contents of a SQL table into a CSV formatted file called Output.csv. Your code must include the connection string and must use the following SQL criteria: SQL Server Name: DBServerDatabase Name: DBNameSQL User Login: SQLUserSQL User Password: SQLPasswordSQL Table: dbo.Exam (2 fields: FirstName, LastName)

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

anbum

• Oct 17th, 2007

Normalization is based on the functional dependency and primary key.1NF- Attribute should be atomic value and there must be?no composite attribute, no multivalued attribute and no relation with in re...

bhawesh

• Jul 19th, 2007

First NF---Attribute should be atomic an no redundant row. (functional dependancy) Second Normal Form : All Non-Key attribute should be fully functionally dependent on primary?key.(removes partial dependancy)Third normal Form : There is no transitivity dependency between attribute.

Answer Question  Select Best Answer

manish

• Oct 15th, 2007

user_tab_partitions,all_tab_partitions,dba_tab_partitions

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

kailash prasad

• Aug 21st, 2007

The basic reason for Mutation error is the way that Oracle manages a read consistent view of data. The error is encountered when a row-level trigger accesses the same table on which it is based, w...

Answer Question  Select Best Answer

sudhir

• Aug 8th, 2007

1) Identify the data file to be moved.2) Identify the diskgroup on to which the file has to be moved.3) Take the file offline.4) Copy the file to new diskgroup using Either RMAN or DBMS_FILE_TRANSFER....

Answer Question  Select Best Answer

sudip Barman

• Aug 8th, 2007

No, more then one query can not been run on same tables becasues if osme query fire a delete operation and the other query some how update the same row then it gives some error cause it may be po...

Answer Question  Select Best Answer