Answer to Question #246210 in Databases | SQL | Oracle | MS Access for Roy

Question

1) a. Explain the concept of ACID properties in DBMS in your own words?

b. How is the pattern matching done in the SQL?

2) Identify and with practical examples give the different types of languages that are

available in the DBMS?

Answer 1

The ACID properties are steps that are followed to maintain consistency in a database before and after transaction. The transaction is a single logical unit that access or modifies a database.

ATOMICITY

The changes made by transactions aren't partial, they either occur or do not occur

CONSISTENCY

The integrity constraints must be maintained through out the database

ISOLATION

Transactions can occur independently without leading to any inconsistencies

DURABILITY

This property ensures that once transaction has completed execution, the updates and modifications to the database are stored and persists even in case of system failure.

SQL pattern matching allows you to search for patterns in data if you to search for patterns in data if you don't know the exact word or phrase you are seeking. We can use the LIKE statement and % keyword to do pattern matching.

Data definition languages, which are used to declare schemas (perhaps including application-specific integrity constraints).

Data Definition Language (DDL) Statements. Data definition language (DDL) statements enable you to perform these tasks: The CREATE, ALTER, and DROP commands require exclusive access to the specified object. For example, an ALTER TABLE statement fails if another user has an open transaction on the specified table.

Data manipulation languages, which are used to retrieve and manipulate the stored data. It can be categorized into procedural and declarative languages(We can use MYSQL for both). The below are

examples of statements

Select/ From/ Where

Insert/ Into/ Values

Update/ Set/ Where

Delete/ From/ Where

Relational Database Language

SQL is the ISO/ANSI standard for a relational database language. SQL is both a data definition and a data manipulation language. It is also both a query language and capable of expressing updates.