DBMS-Intro

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

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

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

• Image

• Text

• Table

• Graph

Which of the following is not an example of DBMS?

• MySQL

• Microsoft Access

• IBM DB2

• Google

Which of the following is not a type of SQL statement?

• Data Manipulation Language (DML)

• Data Definition Language (DDL)

• Data Control Language (DCL)

• Data Communication Language (DCL)

In SQL, which of the following is not a data Manipulation Language Commands?

• INSERT

• UPDATE

• DELETE

• CREATE

TRUNCATE statement in SQL is a –

• DML statement

• DDL statement

• DCL statement

• TCL statement

In SQL, which command is used to add new rows to a table?

• Alter Table

• Add row

• Insert

• Append

In SQL, which command(s) is(are) used to change a table’s storage characteristics?

• ALTER TABLE

• MODIFY TABLE

• CHANGE TABLE

• All of the Mentioned