قواعد البيانات الشابتر 3

comes with various integrated components and tools necessary to carry out almost all database management tasks.

• Network Management Software
• Data Analysis Tool
• File Management System
• Database Management System (DBMS)

even provides the ability to extend beyond the core functionality by integrating with third-party tools and services.

• Query Language

• Storage Engine

• DBMS software

is the core component of the DBMS that interacts with the file system at an OS level to store data.

• Query Language

• Storage Engine

• DBMS

All SQL queries which interact with the underlying data go through the ........................................

• Query Language

• Storage Engine

• DBMS

A database access language is required for interacting with a database, from creating databases to simply inserting or retrieving data

• Query Language

• MongoDB

• Structured Query Language (SQL) and MongoDB Query Language (MQL)

are two query languages that are used to interact with the databases.

• XML and JSON query languages
• Structured Query Language (SQL) and MongoDB Query Language (MQL)

• HTML and CSS query languages
• Python and Java query languages

This consists of commands that can be used to define database schemas or modify the structure of database objects.

• Data Definition Language (DDL)
• Structured Query Language (SQL)
• Data Control Language (DCL)
• Data Manipulation Language (DML)

Commands that directly deal with the data in the database

• Data Manipulation Language (DML)

• Data Control Language (DCL)

• Data Query Language (DQL)

• Data Definition Language (DDL)

All CRUD operations come under .........................................

• Data Definition Language (DDL)

• Data Manipulation Language (DML)

• Data Control Language (DCL)

• Data Query Language (DQL)

This deals with the permissions and other access controls of the database.

• Data Control Language (DCL)

• User authentication protocols
• Data encryption methods
• Transaction Control Language (TCL)