Database Management System and My SQL

What does DBMS stand for?

• a) Data Based Management System

• b) Database Management System

• c) Digital Base Management System

• d) Data Base for Management System

1. In SQL, which clause is used to filter rows based on a specified condition?

1. Which of the following is NOT a type of DBMS?

• a) Relational DBMS

• b) Hierarchical DBMS

• c) Network DBMS

• d) Distributed DBMS

1. In a relational database, what is a tuple?

• a) A row

• b) A column

• c) A table

• d) A cell

1. Which SQL keyword is used to retrieve data from a database?

• a) GET

• b) FETCH

• c) SELECT

• d) EXTRACT

1. Which of the following is NOT a SQL data type?

• a) TEXT

• b) INTEGER

• c) DECIMAL

• d) CLASS

1. What is the purpose of the SQL keyword 'UPDATE'?

• a) Insert new data

• b) Delete existing data

• c) Modify existing data

• d) Retrieve data

1. What does the term 'DBMS' refer to in the context of databases?

• a) Database Management System

• b) Data Backup System

• c) Data Retrieval System

• d) Database Migration System

1. Which SQL command is used to remove a table from a database?

• a) DELETE TABLE

• b) DROP TABLE

• c) REMOVE TABLE

• d) ERASE TABLE

What is the purpose of the SQL keyword 'DELETE'?

• a) Insert new data

• b) Delete existing data

• c) Modify existing data

• d) Retrieve data