• Placement Questions
• /
• RDBMS

Frequently Asked RDBMS interview questions and answers for freshers

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

Unsolved Read Solution (3)

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

(#M40029858) RDBMS QUESTION RDBMS Keep an EYE

Name the buffer in which all the commands that are typed in are stored

Asked In RDBMS MAN (9 years ago)

Unsolved Read Solution (1)

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

(#M40029575) RDBMS QUESTION RDBMS Keep an EYE

Q. Advantages of DBMS?

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

Asked In RDBMS MAN (9 years ago)

Unsolved

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

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

Unsolved Read Solution (1)

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

(#M40029879) RDBMS QUESTION RDBMS Keep an EYE

What are stored-procedures? And what are the advantages of using them.

Asked In RDBMS MAN (9 years ago)

Unsolved Read Solution (3)

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

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

Unsolved Read Solution (4)

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

(#M40029861) RDBMS QUESTION RDBMS Keep an EYE

What is RDBMS KERNEL?
Two important pieces of RDBMS architecture are the kernel, which is the software, and the data dictionary, which consists of the system-level data structures used by the kernel to manage the database 143 You might think of an RDBMS as an operating system (or set of subsystems), designed specifically for controlling data access; its primary functions are storing, retrieving, and securing data. An RDBMS maintains its own list of authorized users and
their associated privileges; manages memory caches and paging; controls locking for concurrent resource usage; dispatches and schedules user requests; and manages space usage within its table-space structures

Asked In RDBMS MAN (9 years ago)

Unsolved

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

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

Unsolved Read Solution (1)

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

(#M40029882) RDBMS QUESTION RDBMS Keep an EYE

what are function of Tables derived from the ERD??

Asked In RDBMS MAN (9 years ago)

Unsolved Read Solution (1)

Is this Puzzle helpful?   (1)   (1) 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 (9 years ago)

Unsolved Read Solution (2)

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