RDBMS Objective Set_1

OBJECTIVE QUESTIONS RELATIONAL DATABASE MANAGEMENT SYSTEM-(RDBMS) (CA-202)

1) Which of the following is a database management tool developed by Microsoft: a) Dbase❌                b) Access✅                 c) Oracle❌            d) Physical view❌ 2) A field used to access a specific record is called: a) Key✅                     b) Attribute❌           c) Domain❌          d) None of these❌ 3) Which are DML statements: a) Create & Drop❌  b) Update, Insert & Delete✅  c) Commit❌  d) Alter Session❌ 4) In SQL, which command is used to add new row to a table: a) Alter table❌               b) add row❌                   c) Insert✅            d) Append❌ 5) What is SQL? a) Summarized Query Language❌                 b) Stored Query Language❌              c) Systematic Query Language ❌                   d) Structured Query Language✅ 6) What is DDL: a) Data Definition Language✅                       b) Drawing Definition Language❌ c) Distributed Definition Language❌              d) Defined Definition Language❌ 7) In RDBMS, tuple is also called: a) Column❌               b) Row✅              c) Attribute❌               d) None of These❌ 8) CREATE command is: a) DDL Command✅              b) DML Command❌                c) DCL Command❌ d) TCL Command❌ 9) In RDBMS, Attribute is also called: a) Column✅                  b) Row❌                    c) Cell❌                   d) Record❌ 10) Which command is used to delete a table: a) DELETE❌              b) DROP✅         c) DESTROY❌        d) None of these❌ 11) Which are DDL statement: a) CREATE✅               b) INSERT❌            c) COMMIT❌       d) None of these❌ 12) What is DCL: a) Data Currency Language❌                         b) Data Control Language✅               c) Data Concurrent Language❌                      d) Data Customized Language❌ 13) The view of Total Database is: a) Conceptual view✅   b) Internal view❌    c) External view❌  d) Physical view❌ 14) In SQL, which command is used to edit record in a table? a) Manipulate❌              b) Edit❌               c) Update✅            d) None of these❌ 15) What is TCL statement: a) savepoint❌                b) rollback❌         c) commit❌              d) All of these.✅ 16) Related fields in a database are grouped to form a_______ a) File❌                     b) Record✅                   c) Menu❌                    d) Bank❌ 17) In the Architecture of DBMS System external level is the_______ a) Physical❌             b) Logical❌                c) Conceptual❌               d) View✅ 18) In case of Entity Integrity, the primary key may be_______       a) Not Null✅                   b) Null❌                          c) both a and b❌                 d) any value❌ 19) The database Schema is written in________       a) TCL❌                       b) DML ❌                             c) DDL✅                              d) DCL❌ 20) In a relational model, relations are termed as______             a) Tuples❌                        b) Attributes❌                            c) Tables✅                                d) Rows❌