For instance, if a relation called "R1" includes the characteristics "Y" and "Z," then the functional dependence between these two attributes may be represented as "Y->Z," indicating that Z is dependent on Y in order to operate. Q19)What is 1NF in the DBMS stand for? The First Norma...
Q9. Procedural code that is automatically executed in response to certain events on a particular table of view in a database: (A) Cursor (B) Transaction (C) Trigger (D) Stored Procedure Q10. DML is stands for (A) Data Manipulation Language (B) Data Maintaining Language (C) Discrete Mode...
Chapterwise Multiple Choice Questions on DBMS Our 1000+ MCQs focus on all topics of the DBMS subject, covering 100+ topics. This will help you to prepare for exams, contests, online tests, quizzes, viva-voce, interviews, and certifications. You can practice these MCQs chapter by chapter sta...
A relation is said to be in 2NF if and only if it is in 1NF and every non key attribute is fully dependent on the primary key. After 2NF, we can still have redundant data Third Normal Form (3NF) A relation is said to be in 3NF, if and only if it is in 2NF and every non ...
2NF or the second normal form: This normalization states that each and every non-key value of the column has to function according to the whole primary key. 3NF or the third normal form: This normalization depends on the main or the primary key without depending on the non-key supporting ...
DBMS Decomposition Algorithms MCQs: This section contains multiple-choice questions and answers on Decomposition Algorithms in DBMS. Submitted byAnushree Goswami, on April 28, 2022 1. This method of decomposition focuses on ___ while preserving dependencies. ...
So, if you’re looking to advance your career in the tech industry, having a strong understanding of DBMS and related technologies is a great way to stand out and increase your earning potential.That’s why we’ve put together this blog post on top DBMS interview questions and answers that...
SQL> Set ServerOutput On; SQL> Declare 2 3 Type Mobile_Numbers_Type IS VARRAY(2) OF NUMBER; 4 5 Mobile_Numbers Mobile_Numbers_Type; 6 7 Begin 8 9 Mobile_Numbers := Mobile_Numbers_Type(1111111111,1000000000); 10 11 DBMS_OUTPUT.PUT_LINE('First value is: ' || Mobile_Numbers(1)); ...
Inline: returns a table data type based on a single SELECT statement. Multi-statement: returns a tabular result-set but, unlike inline, multiple SELECT statements can be used inside the function body.9. What is a UNIQUE constraint? A UNIQUE constraint ensures that all values in a column are...
2NF: Eliminate Redundant Data If an attribute depends on only part of a multi-valued key, remove it to a separate table. 3NF: Eliminate Columns Not Dependent On Key If attributes do not contribute to a description of the key, remove them to a separate table.All attributes must be directly...