DB II A3

Which type of data can be stored in the database?

• Image

• Text

• Table

• 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

Which of the following is not the utility of DBMS?

• Backup

• Data Loading

• Process Organization

• File organization

The logical design, and the snapshot of the data at a given instant in time is known as?

• Instance & Relation

• Relation & Schema

• Domain & Schema

• Schema & Instance

Which of the following refers to the level of data abstraction that describes exactly how the data actually stored?

• 1. Conceptual Level

• 1. Physical Level

• 1. File Level

• 1. Logical Level

The term "Data" refers to:

• 1. The electronic representation of the information( or data)

• 1. Basic information

• 1. Row Facts and figures

• 1. Both A and C

Which of the following commands is used to save any transaction permanently into the database?

• 1. Commit

• 1. Rollback

• 1. Savepoint

• 1. None of the above

The database management system can be considered as the collection of ______ that enables us to create and maintain the database.

• 1. Translators

• 1. Programs

• 1. Keys

• 1. Language activity

The term "Data independence" refers to____

• 1. Data is defined separately and not included in the programs

• 1. Programs are not dependent on the logical attributes of the data

• 1. Programs are not dependent on the physical attributes of the data

• 1. Both B & C