-
Data Models
Explain the three data models and examine a range of issues that are intergral to database environment such as the end user and different platforms compatibility?
-
What parameters define RDBMS?
sangam.princesalim
- Apr 8th, 2010
There are a set of rules known as Codd's rules. In all there are 13 rules. 12 were defined by Codd & the 0th rule is interpreted by Subject experts. Altough there is no Database which is fully compliant with the Codd's rules and hence we do not have a perfect / accurate RDBMS as of now.
-
If we have a table which is accessed by multiple users and two or more user's are simultaniously trying to modify the table. Then what happens and how can we manage such situations?
dj_dj_dj
- Mar 18th, 2010
Simultaneously modification of same table by two or more users cause Oracle server to go into hang state, to avoid such a state first user who used dml statement should issue commit or rollback comand...
Gajanan
- Jul 13th, 2007
There are two ways of changing the rows in particular table.One to delete the rowSecond to modify/Change the data of row in table.In every case we opt for exclusive locks So when one user has exclusiv...
-
Size of Oracle package
“Bigger the size of a Oracle package, the better”. Do you agree? Justify.
dhiren21
- Sep 20th, 2009
No - I do not agreeFunctionality depends..What are you trying to do in a package depends a lot...A Package can call Views, Functions and Triggers, Update, Insert, Delete.. Purpose of a Package, For...
-
Data Redundancy
Explain what are controlled and uncontrolled data redundancy?
dhs01
- Apr 15th, 2009
I view this as planned and unplanned. Generally planned redundancy for performance reasons has some steps taken to ensure that there is syncronicity between the data. I am not sure if there are formal...
-
What is Sub-schema?
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.
-
Type of Participation
What is meant by type of participation? Name the three types of relationship participation.
chaitra murthy
- Jan 16th, 2009
I just know two types of Participation: Total and Partial.Lets take an example of 2 entities Department and Employee. Relation: For each department there is an Head of the Department (who is an emplo...
-
One to many
Explain the representation of a one-to-many strong entity relationship in a relational database design.
chaitra murthy
- Jan 16th, 2009
Department-Employees Under one Department many employees are working.Project-Employees
-
Converting extended E-R model
Describe the process of converting an extended E-R model into a relational database design.
chaitra murthy
- Jan 16th, 2009
ER Model->Logical schema->Normalization->Creating database with tables.
-
Unique and Non-unique keys
Discuss the difference between unique and non-unique keys
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
- 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.
-
What is an internal schema in a database and how can a business analyst prepare an ERD?
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.
-
What is Null Interface? What are the important in Java?
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
-
Can i write commit in trigger? not then? why i cant write commit in trigger?
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..
-
Difference between user and end-user
Types of users with their duties using suitable examples
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
- 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...
-
What is difference between ADO & DAO?
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
-
What are latches in Oracle 9i Database? Can you name the latches.How do you resolve contention on latches.
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...
-
What is the difference between Primary Key and Aggregate Key What is the difference between varchar and varchar2?
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
- 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.
-
-
-
Database Interview Questions
Sub Category
Questions
Answers
Last Updated
Ans