Why a database is called as relational database model?
What are entities and attributes referring to?
What do you understand by relation in relational database model?
Why domain is of high importance?
What is the difference between base and derived relation?
What are constraints in database?
What are the two principles of relational database model? What is the difference between them?
What is the difference between primary and foreign key?
Why stored procedures are called as executable code?
Rdbms interview questions and answers on advance and basic Rdbms with example so this page for both freshers and experienced condidate. Fill the form below we will send the all interview questions on Rdbms also add your Questions if any you have to ask and for apply
in Rdbms Tutorials and Training course just send a mail on info@pcds.co.in in detail about your self.
Top Rdbms interview questions and answers for freshers and experienced
What is Rdbms ?
Answer :
Questions : 1 :: Advantages of DBMS?
Ø Redundancy is controlled.
Ø Unauthorized access is restricted.
Ø Providing multiple user interfaces.
Ø Enforcing integrity constraints.
Ø Providing backup and...View answers
Questions : 2 :: Disadvantage in File Processing System?
Ø Data redundancy & inconsistency.
Ø Difficult in accessing data.
Ø Data isolation.
Ø Data integrity.
Ø Concurrent access is not possible.
Ø...View answers
Questions : 3 :: Why a database is called as relational database model?
A database model represents the relationship between one or more databases. The relationship is known as the relational database model. It is an extension of the normal databases without relations....View answers
Questions : 4 :: What are entities and attributes referring to?
Table consists of some properties that are known as attributes. These consist of the representation of entity in the table. They are represented by columns in the table. Entity is referred to the...View answers
Questions : 5 :: What do you understand by relation in relational database model?
Relation in the relational database model is defined as the set of tuples that have the same attributes. Tuple represents an object and also the information that the object contains. Objects are...View answers
Questions : 6 :: Why domain is of high importance?
Domain describes possible values grouped together that can be given for an attribute. It is considered the same way as a constraint on the value of attribute. A domain can be attached to an attribute...View answers
Questions : 7 :: What is the difference between base and derived relation?
Relational database means the relationship between different databases. In relational database user can store and access all the data through the tables which are related to each other. Relationship...View answers
Questions : 8 :: What are constraints in database?
Constraints are kind of restrictions that are applied to the database or on the domain of an attribute. For example an integer attribute is restricted from 1-10 and not more than that. They provide...View answers
Questions : 9 :: What are the two principles of relational database model? What is the difference between them?
The two principal rules for the relational model are as follows:• Entity integrity: this is used to maintain the integrity at entity level• Referential integrity: it is used to maintain...View answers
Questions : 10 :: What is the difference between primary and foreign key?
• Primary key uniquely identify a relationship in a database, whereas foreign key is the key that is in other relation and it has been referenced from the primary key from other table.•...View answers
Questions : 11 :: Why stored procedures are called as executable code?
Stored procedure stored inside the database. This also includes the executable code that usually collects and customizes the operations like insert, encapsulation, etc. These stored procedures are...View answers
Disclimer: PCDS.CO.IN not responsible for any content, information, data or any feature of website.
If you are using this website then its your own responsibility to understand the content of the website