Practice
Resources
Contests
Online IDE
New
Free Mock
Events New Scaler
Practice
Improve your coding skills with our resources
Contests
Compete in popular contests with top coders
logo
Events
Attend free live masterclass hosted by top tech professionals
New
Scaler
Explore Offerings by SCALER
/ Interview Guides / RDBMS MCQ

RDBMS MCQ

Last Updated: Nov 10, 2023
Certificate included
About the Speaker
What will you Learn?
Register Now

Relational Database Management System

  • An RDBMS is a database engine/system based on the relational model specified by Edgar F. Codd.
  • Most modern commercial and open-source database applications are relational in nature.
  • The most important relational database features include the ability to use tables for data storage while maintaining and enforcing certain data relationships.
     

Basics of RDBMS

  • Domain is a set of atomic values.
  • By atomic we mean that each value in the domain is indivisible as far as the formal relational model is concerned.
  • A common method of specifying a domain is to specify a data type from which the data forming the domain are drawn.
  • Table(Relation): A relation is a set of tupes/rows/entities/records.
  • Tuple: Each row of a relation/table is called tuple.
  • Degree: Number of columns/attributes of a relation.
  • Cardinality: Number of rows/tupes/record of a relational instance.
     

Properties of RDBMS

  • Cells contains atomic values.
  • Values in a column are of the same kind.
  • Each row is unique.
  • Each column has a unique name
  • No two tables can have the same name in a relational schema.
  • The sequence of rows is insignificant.
  • The sequence of columns is insignificant.

 

Problems in RDMS

  • Update anomalies: Anomalies that cause redundant work to be done during insertion into and modification of a relationship and that may cause accidental loss of information during a deletion from a relation.
  • Insertion anomalies: An independent piece of information cannot be recorded into a relationship unless an irrelevant must be inserted together at the same time.
  • Modification anomalies: The update of a piece of information must occur at multiple locations.
  • Deletion anomalies: The deletion of a piece of information unintentionally removes other information.
     

Normalization

  • Normalization may be simply defined as a refinement process.
  • It includes creating tables and establishing relationships between those tables according to rules designed both to protect data and make the database more flexible by eliminating two factors:
    • Redundancy
    • Inconsistent dependency.
  • Without normalization database systems are inaccurate, slow, and inefficient and they might not produce the data we expect.

Additional Resources

  1. DBMS Vs RDBMS
     

RDBMS MCQs

1. 

The full form of RDBMS is?

Create a free personalised study plan Create a FREE custom study plan
Get into your dream companies with expert guidance
Get into your dream companies with expert..
Real-Life Problems
Prep for Target Roles
Custom Plan Duration
Flexible Plans
2. 

Which of the following is the property of transaction that protects data from system failure?

3. 

Which of the following is preserved in the execution of transactions in isolation?

4. 

Which is the lowest level of abstraction that describes how the data are actually stored?

5. 

What is a relation in RDBMS?

Learn via our Video Courses

6. 

“RDBMS has ACID properties”-Which of the following options is true about this statement?

7. 

During transaction before commit which of the following statement is done automatically in case of shutdown?

Advance your career with   Mock Assessments Refine your coding skills with Mock Assessments
Real-world coding challenges for top company interviews
Real-world coding challenges for top companies
Real-Life Problems
Detailed reports
8. 

A relational database developer refers to a record as?

9. 

The database is always expected to satisfy which predicate?

10. 

Which of the following can replace the below query?

SELECT name, course_id  
            FROM instructor, teaches  
            WHERE instructor_ID= teaches_ID;
11. 

The database system catalog stores what kind of information?

12. 

The local variables that hold write operations are copied to the database work in which phase?

13. 

What does the following query do?

UPDATE student 
SET marks = marks * 1.20;
14. 

The relational model of RDBMS is concerned with?

15. 

The attribute which is the primary key should have its values never?

16. 

The referential integrity constraint of a relational database can be specified with the help of?

17. 

Minimal Superkeys are also called?

18. 

The part of database design linked to the logical design is?

19. 

Which of the following are applications of dynamic hashing?

20. 

How can we delete entries in an RDBMS?

21. 

Select the correct foreign key constraint?

22. 

What is the name of the query that is placed within a WHERE or HAVING clause of another query?

23. 

Modify operation is done after which operation?

24. 

Date when inserted into a database should be of the format?

25. 

Total view of a database is known as?

26. 

To select some particular columns, which of the following columns is used?

27. 

What is NTFS?

28. 

Which of the following are properties of entities?

29. 

Which of the following constraints does RDBMS checks before creating tables?

30. 

When is a domain called atomic?

31. 

Set of one or more attributes taken collectively to uniquely identify a record is called?

32. 

Language through which user requests data from a database is called?

33. 

The union operation performs the set union of 2 ‘_______’ tables.

34. 

The Select command is a part of what type of statement?

35. 

What kind of updates are not allowed in RDBMS?

36. 

The number of attributes in a relation is called its?

37. 

What kind of Joins is a default in SQL?

38. 

The primary key must be?

39. 

Which of the following are examples of aggregate functions in SQL?

40. 

SQL update statements that can only be used in the set clause are called?

41. 

Which conditions allows a general predicate over the relations being joined?

42. 

What is the maximum number of tables which can be joined with a join?

43. 

How can we make a transaction permanent in the database?

44. 

Maximum number of children of a B-tree of order N is?

45. 

How is the ranking of queries done?

46. 

What is the AS clause used for?

47. 

OLAP stands for?

48. 

What type of data can be modeled as dimensional and measure attributes?

49. 

Cross tabs in SQL are created using?

50. 

A set of entities of same type that share same properties or attributes is called?

Excel at your interview with Masterclasses Know More
Certificate included
What will you Learn?
Free Mock Assessment
Fill up the details for personalised experience.
Phone Number *
OTP will be sent to this number for verification
+1 *
+1
Change Number
Graduation Year *
Graduation Year *
1994
1995
1996
1997
1998
1999
2000
2001
2002
2003
2004
2005
2006
2007
2008
2009
2010
2011
2012
2013
2014
2015
2016
2017
2018
2019
2020
2021
2022
2023
2024
2025
2026
2027
2028
2029
*Enter the expected year of graduation if you're student
Current Employer
Company Name
College you graduated from
College/University Name
Job Title
Job Title
Engineering Leadership
Software Development Engineer (Backend)
Software Development Engineer (Frontend)
Software Development Engineer (Full Stack)
Data Scientist
Android Engineer
iOS Engineer
Devops Engineer
Support Engineer
Research Engineer
Engineering Intern
QA Engineer
Co-founder
SDET
Product Manager
Product Designer
Backend Architect
Program Manager
Release Engineer
Security Leadership
Database Administrator
Data Analyst
Data Engineer
Non Coder
Other
Please verify your phone number
Edit
Resend OTP
By clicking on Start Test, I agree to be contacted by Scaler in the future.
Already have an account? Log in
Free Mock Assessment
Instructions from Interviewbit
Start Test