Info Management - Week 1

It is also called Data Description Language and is used to describe data structures, create and modify data.

______ commands include Revoke and Grant used to retrieve previously stored and saved data. The syntax of DCL commands is similar to programming languages.

______ commands include Select, Insert, Update, Delete, Merge and Call.

These are used to access and manipulate data in the Database

______ is used to handle all the transactions within Database Systems.

Commands include Commit, Rollback and SavePoint.

unifies data definition, data manipulation, and querying in a single language. It was one of the earliest commercial languages for the relational paradigm, albeit it differs in some ways from Codd’s description

Is one of the most extensive and complicated ones. It allows developers and programmers to normalize data and organize information as rationally independent tables.

Can store and manage unstructured and semistructured data (unlike a relational database, which specifies how all data added into the database must be structured)

Is a collection of structured or unstructured data stored on a public, private, or hybrid cloud platform.

This fundamental component of a DBMS is utilized to save data.

To store data, the DBMS must communicate with an OS-level file system.

This critical component of the DBMS controls concurrent access to the same data.

Locks are essential to ensure that several users are not attempting to edit the same data concurrently.