Practice
Resources
Contests
Online IDE
New
Free Mock
Scaler Events New
Practice
Improve your coding skills with our resources
Contests
Compete in popular contests with top coders
Scaler
Explore Offerings by SCALER
Events
Checkout Scaler Academy Events
New

RDBMS MCQ

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 be inaccurate, slow, and inefficient and they might not produce the data we expect.
     

RDBMS MCQs

Events | Powered By
1. 

The full form of RDBMS is?

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?

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?

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?

Get Placed at Top Product Companies with Scaler Know More 
Get Placed at Top Product Companies with Scaler Know More 
Get Placed at Top Product Companies with Scaler
Sat transparent 640a34d454880bf68e3bfdf33f2389f2214043f59ad18b4c7f7b114e834fb257.svg

Point markers b3add1cc88e4996b2df6e0aedb9f0d1b65fa73c51b7ada8fbee3895a2aa11802.svg Personalised feedback report with solutions
Point markers b3add1cc88e4996b2df6e0aedb9f0d1b65fa73c51b7ada8fbee3895a2aa11802.svg Real life Interview Questions
Point markers b3add1cc88e4996b2df6e0aedb9f0d1b65fa73c51b7ada8fbee3895a2aa11802.svg Identify exact topics to improve

Your feedback is important to help us improve.
Free Mock Assessment
Fill up the details for personalised experience.
All fields are mandatory
Current Employer *
Enter company name *
Graduation Year *
Select an option *
1992
1993
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
Phone Number *
OTP will be sent to this number for verification
+1 *
+1
Change Number
Phone Number *
OTP will be sent to this number for verification
+1 *
+1
Change Number
Graduation Year *
Graduation Year *
1992
1993
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
*Enter the expected year of graduation if you're student
Current Employer *
Company Name *
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