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______ b) Attributes❌ c) Tables✅ d) Rows❌ |
RDBMS Objective Set_1
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment