අන්තර්ගතයට යන්න
mcqdinethlive

Unit 8, Database Management

8.6 Database Management Systems (DBMS)

This lesson introduces the core components of Database Management Systems (DBMS) with a primary focus on Structured Query Language (SQL). It covers the categorization of SQL into Data Definition Language (DDL) and Data Manipulation Language (DML), and provides practical instructions on database creation, table modification, primary and foreign key constraints, data manipulation, and multi-table queries using inner joins.

ප්‍රධාන සංකල්ප

Database Management System (DBMS)
A software system used to create, manage, and facilitate structured access to databases.
Structured Query Language (SQL)
A standardized programming language used to define, manipulate, and query data within a relational database.
Data Definition Language (DDL)
A sub-language of SQL used to define and modify the database structure, schema, and constraints (e.g., CREATE, ALTER, DROP).
Data Manipulation Language (DML)
A sub-language of SQL used to manage and manipulate the actual data stored within the database tables (e.g., INSERT, UPDATE, SELECT, DELETE).
Primary Key
A unique identifier for a record within a database table, ensuring that no duplicate records exist.
Foreign Key
An attribute or a set of attributes in one table that refers to the primary key of another table, establishing a relationship between the two tables.
Query
A structured request or question presented to a database to retrieve specific data that meets predefined conditions.
Inner Join
An operation used to combine rows from multiple tables based on a related column common to both tables.

MCQ කට්ටල

MCQ 12

විභාගයේදී

  • Differentiating between DDL and DML commands in structured questions
  • Writing SQL DDL statements to create tables with primary keys, foreign keys, and specific data types
  • Writing SQL DML statements to insert, update, delete, or retrieve data
  • Formulating complex SELECT queries utilizing INNER JOIN, WHERE, and other conditional clauses based on provided relational schemas