• Placement Questions
• /
• RDBMS

RDBMS interview questions and answers for freshers

(#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 (9 years ago)

Unsolved Read Solution (4)

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

(#M40029887) RDBMS QUESTION RDBMS Keep an EYE

Select 'NORTH', CUSTOMER From CUST_DTLS Where REGION = 'N' Order By
CUSTOMER Union Select 'EAST', CUSTOMER From CUST_DTLS Where REGION = 'E' Order By CUSTOMER
The above is
a) Not an error
b) Error - the string in single quotes 'NORTH' and 'SOUTH'
c) Error - the string should be in double quotes
d) Error - ORDER BY clause

Asked In RDBMS MAN (11 years ago)

Unsolved Read Solution (3)

Is this Puzzle helpful?   (8)   (6) Submit Your Solution Interview

(#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

(#M40029884) RDBMS QUESTION RDBMS Keep an EYE

A B C is a set of attributes. The functional dependency is as follows
AB -> B
AC -> C
C -> B
a) is in 1NF
b) is in 2NF
c) is in 3NF
d) is in BCNF

Asked In RDBMS MAN (11 years ago)

Unsolved Read Solution (3)

Is this Puzzle helpful?   (4)   (2) Submit Your Solution Cryptography

(#M40029883) RDBMS QUESTION RDBMS Keep an EYE

Spurious tuples may occur due to
i. Bad normalization
ii. Theta joins
iii. Updating tables from join
option
a) i & ii
b) ii & iii
c) i & iii
d) ii & iii

Asked In RDBMS MAN (11 years ago)

Unsolved Read Solution (1)

Is this Puzzle helpful?   (4)   (5) Submit Your Solution

(#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

(#M40029881) RDBMS QUESTION RDBMS Keep an EYE

Does PL/SQL support "overloading"? Explain

Asked In RDBMS MAN (11 years ago)

Unsolved Read Solution (1)

Is this Puzzle helpful?   (0)   (2) Submit Your Solution

(#M40029880) RDBMS QUESTION RDBMS Keep an EYE

How are exceptions handled in PL/SQL? Give some of the internal exceptions' name?

Asked In RDBMS MAN (11 years ago)

Unsolved Read Solution (1)

Is this Puzzle helpful?   (0)   (0) Submit Your Solution Blood Relations