InterviewUp – Job Interview Questions and Answers – Search Results for database engineer

Describe Referential Integrity ?

Add or view comments about this interview question

Share this interview question with your friend

Inappropriate

View all interview questions asked by this user

Asked By: tom77 |

See Answer

Edit

Your Name:

To Email:

Subject:

Note to go along with the question: (Optional, no more than 1,000 characters)

Referential Integrity defines that the Primary key of one table should be match to the foreign key of other tables .

Create Date

Saturday, May 10, 2008

Tags

ORACLE DATA ACCESS, Sql

Asked At

None

Job Positions

Click here to improve the Interview Question, Answer and other fields.

Comments (0) :

303

What is Fully Functional dependency?

Inappropriate

Asked By: mariann |

See Answer

Edit

Your Name:

To Email:

Subject:

Note to go along with the question: (Optional, no more than 1,000 characters)

It is based on concept of full functional dependency. A functional dependency X Y is full functional dependency if removal of any attribute A from X means that the dependency does not hold any more.

Create Date

Tuesday, May 13, 2008

Tags

database, RDBMS, Data Warehousing

Asked At

None

Job Positions

Click here to improve the Interview Question, Answer and other fields.

Comments (0) :

274

Disadvantage in File Processing System?

Inappropriate

Asked By: edward |

See Answer

Edit

Your Name:

To Email:

Subject:

Note to go along with the question: (Optional, no more than 1,000 characters)

Data redundancy & inconsistency.
Difficult in accessing data.
Data isolation.
Data integrity.
Concurrent access is not possible.
Security Problems.

Create Date

Tuesday, May 13, 2008

Tags

Asked At

None

Job Positions

Click here to improve the Interview Question, Answer and other fields.

Comments (0) :

149

What is extension and intension?

Inappropriate

Asked By: edward |

See Answer

Edit

Your Name:

To Email:

Subject:

Note to go along with the question: (Optional, no more than 1,000 characters)

Extension -It is the number of tuples present in a table at any instance. This is time dependent.

Intension -It is a constant value that gives the name, structure of table and the constraints laid on it.

Create Date

Tuesday, May 13, 2008

Tags

Asked At

None

Job Positions

Click here to improve the Interview Question, Answer and other fields.

Comments (0) :

321

Advantages of DBMS?

Inappropriate

Asked By: edward |

See Answer

Edit

Your Name:

To Email:

Subject:

Note to go along with the question: (Optional, no more than 1,000 characters)

Redundancy is controlled.
Unauthorised access is restricted.
Providing multiple user interfaces.
Enforcing integrity constraints.
Providing backup and recovery.

Create Date

Tuesday, May 13, 2008

Tags

Asked At

None

Job Positions

Click here to improve the Interview Question, Answer and other fields.

Comments (0) :

347

Define the "integrity rules"

Inappropriate

Asked By: edward |

See Answer

Edit

Your Name:

To Email:

Subject:

Note to go along with the question: (Optional, no more than 1,000 characters)

There are two Integrity rules. Entity Integrity: States that "Primary key cannot have NULL value"
Referential Integrity: States that "Foreign Key can be either a NULL value or should be Primary Key value of other relation.

Create Date

Tuesday, May 13, 2008

Tags

Asked At

None

Job Positions

Click here to improve the Interview Question, Answer and other fields.

Comments (0) :

227

Describe the three levels of data abstraction?

Inappropriate

Asked By: edward |

See Answer

Edit

Your Name:

To Email:

Subject:

Note to go along with the question: (Optional, no more than 1,000 characters)

The are three levels of abstraction:
Physical level: The lowest level of abstraction describes how data are stored.
Logical level: The next higher level of abstraction, describes what data are stored in database and what relationship among those data.
View level: The highest level of abstraction describes only part of entire database.

Create Date

Tuesday, May 13, 2008

Tags

Asked At

None

Job Positions

Click here to improve the Interview Question, Answer and other fields.

Comments (0) :

283

What is a Database system?

Inappropriate

Asked By: edward |

See Answer

Edit

Your Name:

To Email:

Subject:

Note to go along with the question: (Optional, no more than 1,000 characters)

The database and DBMS software together is called as Database system.

Create Date

Tuesday, May 13, 2008

Tags

database, RDBMS, Data Warehousing

Asked At

None

Job Positions

Click here to improve the Interview Question, Answer and other fields.

Comments (0) :

210

What is DBMS?

Inappropriate

Asked By: edward |

See Answer

Edit

Your Name:

To Email:

Subject:

Note to go along with the question: (Optional, no more than 1,000 characters)

It is a collection of programs that enables user to create and maintain a database. In other words it is general-purpose software that provides the users with the processes of defining, constructing and manipulating the database for various applications.

Create Date

Tuesday, May 13, 2008

Tags

Asked At

None

Job Positions

Click here to improve the Interview Question, Answer and other fields.

Comments (0) :

279

What is database?

Inappropriate

Asked By: edward |

See Answer

Edit

Your Name:

To Email:

Subject:

Note to go along with the question: (Optional, no more than 1,000 characters)

A database is a logically coherent collection of data with some inherent meaning, representing some aspect of real world and which is designed, built and populated with data for a specific purpose.

Create Date

Tuesday, May 13, 2008

Tags

Asked At

None

Job Positions