• Placement Questions
• /
• RDBMS
• /
• Programming

RDBMS Programming Technical Interview Questions

(#M40154990) RDBMS QUESTION Assign a Foreign Key Relationship Keep an EYE

How Can you assign a foreign key relationship between two tables in sql server..Give a example and write a steps.

Asked In RDBMS Inshu Malhotra (9 years ago)

Unsolved Read Solution (1)

Is this Puzzle helpful?   (8)   (1) Submit Your Solution Database

(#M40153957) RDBMS QUESTION Keep an EYE

Sunil is working on a database management system. He wants to program transactions such that a transaction is completed only if all the database operations are completed and commited, otherwise the transaction is aborted and rolled back. Which of the following database characteristics is he trying to implement?

o Atomicity
o Consistency
o Isolation
o Durability

Asked In RDBMS swastika (10 years ago)

Unsolved Read Solution (4)

Is this Puzzle helpful?   (19)   (16) Submit Your Solution Database

(#M40029886) RDBMS QUESTION RDBMS Keep an EYE

A dominant entity is the entity
a) on the N side in a 1 : N relationship
b) on the 1 side in a 1 : N relationship
c) on either side in a 1 : 1 relationship
d) nothing to do with 1 : 1 or 1 : N relationship

Asked In RDBMS MAN (11 years ago)

Unsolved Read Solution (2)

Is this Puzzle helpful?   (7)   (5) Submit Your Solution Database

(#M40029885) RDBMS QUESTION RDBMS Keep an EYE

In mapping of ERD to DFD
a) entities in ERD should correspond to an existing entity/store in DFD
b) entity in DFD is converted to attributes of an entity in ERD
c) relations in ERD has 1 to 1 correspondence to processes in DFD
d) relationships in ERD has 1 to 1 correspondence to flows in DFD

Asked In RDBMS MAN (11 years ago)

Unsolved Read Solution (1)

Is this Puzzle helpful?   (5)   (2) Submit Your Solution Definition

(#M40029882) RDBMS QUESTION RDBMS Keep an EYE

what are function of Tables derived from the ERD??

Asked In RDBMS MAN (11 years ago)

Unsolved Read Solution (1)

Is this Puzzle helpful?   (1)   (1) Submit Your Solution Database

(#M40029877) RDBMS QUESTION RDBMS Keep an EYE

What is database Trigger?

Asked In RDBMS MAN (11 years ago)

Unsolved Read Solution (2)

Is this Puzzle helpful?   (1)   (2) Submit Your Solution Arrays