Database Management System

What is the full form of DBMS?

• Data of Binary Management System

• Database Management System

• Database Management Service

• Data Backup Management System

What is a database?

• Organized collection of information that cannot be accessed, updated, and managed

• Collection of data or information without organizing

• Organized collection of data or information that can be accessed, updated, and managed

•   Organized collection of data that cannot be updated

In which of the following formats data is stored in the database management system?

• Table

• Image

• Text

• Graph

The ability to query data, as well as insert, delete, and alter tuples, is offered by ____________

• TCL (Transaction Control Language)

• DCL (Data Control Language)

• DDL (Data Definition Langauge)

• DML (Data Manipulation Langauge

Which command is used to remove a relation from an SQL?

• Drop table

• Delete

• Purge

• Remove

  In E-R diagram an entity set is represented by a

• Rectangle

•   Ellipse

•   Diamond box

•     Circle

Which of the following are the properties of entities?

• Groups

• Tables

• Attributes

• Switchboards

  E-R model uses this symbol to represent weak entity set?

• Dotted rectangle

•       Diamond

•   Doubly outlined rectangle

•    None of these

  To which of the following the term "DBA" referred?

•   Data Bank Administrator

•   Database Administrator

•   Data Administrator

•   None of the above

 IIn general, a file is basically a collection of all related______.

•   Rows & Columns

• Fields

• Database

• Records