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

 

No comments:

Post a Comment