Follow Quotesrain
  • Result
  • Today's Puzzle
    • Previous Puzzles
    • Prize & Rules
  • Discussion Board
    • Suggestion Board
    • Trending Articles
  • Maths Tricks
  • Placement Papers
    • Placement Questions
    • Interview Experience
    • Placed user Comment
    • Group Discussion
  • English APP
  • login
  • Result
  • Today's Puzzle
    • Previous Puzzles
    • Prize & Rules
  • Discussion Board
    • Suggestion Board
    • Trending Articles
  • Maths Tricks
  • Placement Papers
    • Placement Questions
    • Interview Experience
    • Placed user Comment
    • Group Discussion
  • Walkins
    • Corporate Job Exam
    • Government Job Exam
    • Entrance Exam
  • Training
    • Internship
  • Placement Questions
  • /
  • RDBMS

Frequently Asked RDBMS interview questions and answers for freshers

RDBMS Select Another Category Select Another Topic

Programming and Technical

  • Android 118
  • ASP.NET 60
  • C 459
  • C++ 448
  • DATA STRUCTURE 66
  • DBMS 77
  • ELECTRONICS 39
  • Java 260
  • OOPs Concepts 117
  • Operating Syst 103
  • RDBMS 109
  • UNIX 70

RDBMS Question Topics

    HR Interview (2)

  • Interview (2)
  • Logical Reasoning (3)

  • Blood Relations (1)
  • Cryptography (1)
  • Mathematical Reasoning (1)
  • Numerical Ability (1)

  • Algebra (1)
  • Programming (6)

  • Arrays (1)
  • Database (4)
  • Definition (1)
Keep an EYE (0)
Solved Question (0) UnSolved Question (109)
Pages: 11123456789NextLast
Advertisements

(#M40029887) RDBMS QUESTION RDBMS Keep an EYE Keep an eye puzzle Keep an eye puzzle

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 Keep an eye puzzle Keep an eye puzzle

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
Advertisements

(#M40029575) RDBMS QUESTION RDBMS Keep an EYE Keep an eye puzzle Keep an eye puzzle

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 Keep an eye puzzle Keep an eye puzzle

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 Keep an eye puzzle Keep an eye puzzle

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 Keep an eye puzzle Keep an eye puzzle

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 Keep an eye puzzle Keep an eye puzzle

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 Keep an eye puzzle Keep an eye puzzle

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 Keep an eye puzzle Keep an eye puzzle

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 Keep an eye puzzle Keep an eye puzzle

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
Keep an EYE (0)
Solved Question (0) UnSolved Question (109)
Pages: 11123456789NextLast
  • Login
  • Register

Resend

Sponsored Links

Advertisements

Challenger of the Day

no image
Dimple
India
Punjab
Time: 00:01:33
Points
19

Maths Quotes

"There is nothing called attitude, its just the presence or absence of courage"

Sandeep Upadhyay

"maths is all around us, in everything we do"

aashna thakral

Placed User Comments

M4Math helped me a lot.

Vipul Chavan 2 years ago

Thanks m4 maths for helping to get placed in several companies.
I must recommend this website for placement preparations.

yash mittal 3 years ago
  • 2475K+Registerd user
  • 1733K+Engineers
  • 742K+MBA Asprirant
  • 3K+Enginnering College
  • 250+Company Exam
  • 150K+Interview Questions
  • Site Links
  • Home
  • Result
  • Today's Puzzle
  • Discussion Board
  • Maths Tricks
  • Advertise with us
  • Contact Us
  • Useful Info
  • Maths Quotes
  • Previous Puzzles
  • Prize
  • Privacy Policy
  • Disclaimer and Copyright
  • Terms and Conditions
  • Sitemap
  • Placement papers
  • TCS Placement Paper
  • HCL Placement Paper
  • INFOSYS Placement Paper
  • IBM Placement Paper
  • SYNTEL Placement Paper
  • TECHNICAL Interview
  • HR Interview
All rights are reserved to @m4maths.com