IMDBSYS31 PRELIM

What does DBMS stand for?

• Data Base Management Service

• Database Management System

• Data Base Management System

• Database Management Service

Which of the following is NOT an application area of DBMS?

• Airlines

• Manufacturing

• Cooking

• Banking

What is one of the main purposes of using a DBMS?

• To increase data redundancy

• To eliminate the need for data security

• To avoid data inconsistency

• To make data less accessible

What does the term 'atomicity' refer to in DBMS?

• The ability to store large amounts of data

• The ability to create complex queries

• The ability to handle multiple users

• The ability to ensure complete transactions

Which of the following is a type of database user?

• Application programmers

• Database designers

• Network engineers

• Hardware technicians

What is the role of a Database Administrator?

• To coordinate all activities of the database system

• To write application programs

• To perform data entry tasks

• To manage hardware resources

What is a transaction in the context of a DBMS?

• A type of database query

• A method of data storage

• A collection of operations that performs a single logical function

• A single operation in a database

Which SQL command is used to create a new database?

• NEW DATABASE

• CREATE DATABASE

• ADD DATABASE

• INSERT DATABASE

What does DDL stand for in SQL?

• Data Definition Language

• Data Description Language

• Database Definition Language

• Database Description Language

Which SQL command is used to insert new records into a table?

• NEW ENTRY

• ADD RECORD

• UPDATE TABLE

• INSERT INTO