query/ assembly langues

What are the two levels of programming languages?

High-level and low-level programming languages.

What characterizes a high-level programming language?

It uses common English language to make code more understandable and speeds up coding and debugging.

Name three examples of high-level programming languages.

SQL, Pascal, and Python.

What defines a low-level programming language?

It uses a set of symbols to represent machine code.

Give three examples of low-level programming languages.

ARM, MIPS, and X86.

What is a query in the context of databases?

A request for information from a database.

Why is it important for the user application and database to speak the same language?

To ensure that the query is understood and processed correctly.

What is a query language?

A programming language used to request data from a database or to manipulate data.

What is the most prevalent query language for database management?

Structured Query Language (SQL).

What does NoSQL stand for?

Not Only SQL.

What is the key difference between SQL and NoSQL databases?

SQL databases are relational with structured schemas, while NoSQL databases are non-relational with dynamic schemas.

What does CRUD stand for in database operations?

Create, Read, Update, Delete.

What are the two types of database queries?

Select queries and action queries.

What do select queries do?

Request data from a database.

What do action queries do?

Manipulate data in a database.

What is the standard format of an assembly language statement?

It consists of an instruction (mnemonic) and parameters (operands), with optional comments.

How are assembly languages translated into machine code?

Using an assembler.

What is the relationship between assembly language instructions and machine code?

Each assembly instruction translates into one machine code instruction.

What is the role of opcodes in assembly language?

They tell the processor what to do with the data.

What do operands in assembly language indicate?

Where to find the data.

How do assembly languages relate to processor architecture?

They are closely tied to the architecture of specific hardware manufacturers.

What is a mnemonic in assembly language?

A symbolic name for a single machine code instruction.

What is the difference between a compiler and an assembler?

An assembler translates assembly language into machine code, while a compiler translates high-level languages.

What is the significance of the term 'statement' in SQL?

It describes commands used to query or manipulate data.

What is the purpose of comments in assembly language statements?

To provide additional information about the code for clarity.