Q1Database

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

What is DBMS?

• DBMS is a collection of queries

• DBMS is a high-level language

• DBMS is a programming language

• DBMS stores, modifies and retrieves data

Which type of data can be stored in the database?

• Image oriented data

• Text, files containing data

• Data in the form of audio or video

• All of the above

Which of the following is not an example of DBMS?

• MySQL

• Microsoft Acess

• IBM DB2

• Google

Which of the following is not a feature of DBMS?

• Minimum Duplication and Redundancy of Data

• High Level of Security

• Single-user Access only

• Support ACID Property

Which of the following is not a function of the database?

• Managing stored data

• Manipulating data

• Security for stored data

• Analysing code

What is information about data called?

• Hyper data

• Tera data

• Meta data

• Relations

The DBMS acts as an interface between ________________ and ________________ of an enterprise-class system.

• Data and the DBMS

• Application and SQL

• Database application and the database

• The user and the software

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 of the following command is correct to delete the values in the relation teaches?

• Delete from teaches;

• Delete from teaches where Id =’Null’;

• Remove table teaches;

• Drop table teaches;