Java

Python

SQL

C++

To manipulate data

To define data structures

To enhance performance

To create backups

To modify the SQL software

To control user access and permissions

To manage data in a database

To configure network settings

SELECT

INSERT

UPDATE

DELETE

To link tables together

To ensure only valid data is entered into tables

To increase processing speed

To duplicate data for backup purposes

To link two tables together

To uniquely identify a row in a table

To set default values for a column

To enforce data validation rules

It cannot reference a primary key in another table

It must have a different data type than the primary key it references

It ensures referential integrity by linking to a primary key in another table

It must always be a unique value

The column must always have a numeric value

The column cannot have duplicate values

The column must not have any value

The column can have empty values

To ensure all rows in a table can have identical values.

To prevent duplicate entries in a column that is not a primary key.

To link two tables together.

To automatically update data in a table.

It ensures that all SQL commands are checked for errors before execution.

It restricts the type of data that can be inserted into a table based on specific conditions.

It checks and removes incorrect entries from a table automatically.

It verifies user permissions before allowing data insertion.

Because all companies use the same software systems

Because different companies in the same field have different naming conventions

Because naming conventions are legally protected

Because naming conventions are irrelevant in modern databases

Ignore naming conventions as they are outdated

Choose naming conventions randomly

Identify and follow a naming convention

Create a new naming convention for each project

Tables should be named in plural form

Tables should be named in singular form

Tables should include numerals

Tables should use multiple words without linking

A simple name related to the table

A composite name identifying tables and functionality

Only the primary key of the parent table

Numerals to distinguish different foreign keys

To store fixed-length strings.

To store variable-length strings up to a specified number of characters.

To store integers only.

To store boolean values.

Data Manipulation Language, used to retrieve and manipulate database data

Data Modification Language, used to define database structures

Data Management Language, used to control access to data

Data Mapping Language, used to map data structures

SELECT

UPDATE

CREATE TABLE

GRANT

INSERT

ALTER TABLE

DELETE

UPDATE

To import data from SQL files

To manipulate records in database tables using SQL queries

To modify the phpMyAdmin user interface

To export data to CSV files

DELETE

UPDATE

SELECT

INSERT INTO

INSERT INTO [table_name] VALUES ([value1], [value2]...)

UPDATE [table_name] SET [column1]=[value1], [column2]=[value2]...

DELETE FROM [table_name] WHERE [condition]

INSERT INTO [table_name] ([column1], [column2]...) VALUES ([value1], [value2]...)