Notes, summaries, assignments, exams, and problems for Computers

PL/SQL

PL/SQL is a procedural language designed specifically to embrace SQL statements within its syntax. PL/SQL program units are compiled by the Oracle Database server and stored inside the database. And at run-time, both PL/SQL and SQL run within the same server process, bringing optimal efficiency. PL/SQL includes procedural language elements like conditions and loops. It allows declaration of constants and variables, procedures and functions, types and variable of those types and triggers. It can support Array and handle exceptions (runtime errors).

Differences between SQL and PL/SQL

• SQL is a single query that is used to perform DML and DDL operations.
• PL/SQL is a block of codes that used to write the entire program blocks/ procedure/ function,

Fresh leaks from the Chinese forum Saraba1st point to the imminent release of refreshed Clevo gaming laptops powered by the new Comet Lake-S desktop-grade CPUs, expected to launch this spring. User Liaojings1 obtained internal slides detailing the upcoming X170 laptops, which replace the aging P7xx-series, finally bringing Clevo's designs in line with competitors like Dell/Alienware and MSI.

Chassis and Design Improvements

To accommodate desktop-grade CPUs, the X170 features a redesigned chassis with larger rear exhaust grills. Additional upgrades include:

• Enhanced Audio: More powerful stereo speakers and a dedicated woofer.
• RGB Lighting: Integrated lighting on the rear and underneath the chassis.

Display and Visuals

Clevo is adopting slim-bezel... Continue reading "Clevo X170 Gaming Laptops: Comet Lake-S Power and Upgrades" »

Key Concepts in Microsoft Word and Computer Applications

1. Microsoft Word Application Type

Which type of computer application is Microsoft Word an example of?

Word processing

2. Touchscreen Right-Click

Which action enables you to right-click on a touchscreen?

Press and hold for a few seconds

3. Word 2016 Document Starting Point

A preformatted document used as a starting point in Word 2016 is known as what?

A template

4. Wordwrap Functionality

Word uses wordwrap. If a word does not fit at the end of a line, what happens to that word?

It is automatically moved to the next line.

5. Understanding Inline Objects

What does inline object refer to?

A picture or object positioned directly in the text at the insertion point, just like a character in a sentence.

6.

Data Storage Conversion:

• 1 gigabyte (GB) equals 1,024 megabytes (MB).
• 1 megabyte (MB) equals 1,024 kilobytes (KB).
• To convert gigabytes to kilobytes, multiply by 1,024 twice. For example: 1 GB = 1,024 MB * 1,024 KB = 1,048,576 KB.
• To convert gigabytes to megabytes, multiply by 1,024. For example: 1 GB = 1,024 MB
• To convert 20 megabytes to bytes: 20 MB = 20 * 1,024 KB * 1,024 bytes = 20,971,520 bytes
• To convert 2 gigabytes to kilobytes: 2 GB = 2 * 1,024 MB * 1,024 KB = 2,097,152 KB

Example: SHKRONJA A has a value of 1010, B - 1011, C - 1100, D - 1101, E - 1110, F - 1111.

Binary Number Representations

There are three main ways to represent signed numbers in binary:

1. Signed Magnitude

• Positive Numbers: Standard binary representation.
• Negative Numbers: The

Implementing a New System Call in the Kernel

Required Files to Add

• /usr/src/test_kernel/SystemCalls/test_call.c:
  • Creates system call pointer.
  • Exports the pointer so that the system call module can access it.
  • Defines the system call wrapper.
• /usr/src/test_kernel/SystemCalls/Makefile: obj-y := test_call.o (Compiles files directly into the kernel).

System Module Implementation

• /usr/src/test_kernel/SystemModule/syscallModule.c:
  • Holds module code.
  • Implements system call behavior.
  • Registers system call pointer to the proper system call handler.
• /usr/src/test_kernel/SystemModule/Makefile: obj-m := syscallmodule.o (Compiles file as a module).

Required Files to Modify

• /usr/src/test_kernel/arch/x86/entry/syscalls/syscall_64.tbl: Add the system call to the table.
• /usr/

Mechatronics engineers are responsible for designing mechanical equipment. Combining their knowledge of computer, mechanical, and electrical engineering, they develop various automated products, such as cameras, cars, and aircraft. The engineering process typically involves designing and assembling components, testing products in development, making improvements, and evaluating finished products. Engineers must also assess equipment and publish reports outlining production factors, such as practical use, safety, and cost.

Work Areas:

• Electronics Development Unit
• Software Development Unit
• Project Management Unit
• Biomechanical Development Unit including our Mechanical Shop and Scientific Glassblower

Mechanical Engineer Job Duties:

• Evaluates mechanical

Network Fundamentals: LANs and WANs

• A Local Area Network (LAN) covers a small geographical area, such as a single site or building (e.g., a school or a college).

• A Wide Area Network (WAN) covers a large geographical area. Most WANs are formed by connecting several LANs, with the internet being a prime example.

Virtual Private Networks (VPNs) Explained

A Virtual Private Network (VPN) is programming that creates a safe, encrypted connection over a less secure network. It provides business travelers with secure access to software applications hosted on proprietary networks. To gain access to a restricted resource through a VPN, the user must be authorized to use the VPN application and provide one or more authentication factors, such as a password.... Continue reading "Networking Essentials: Devices, Protocols, Topologies" »

This section addresses key concepts regarding digital media processing, file formats, and data requirements.

1. Stereo vs. Mono Audio Data Requirements

   Question: What is the difference between stereo and mono audio?

   Answer: Stereo audio usually requires twice as much data as mono audio.

2. Quickest Audio Format for Web Download

   Question: Which audio format would be quickest to download from a website?

   Answer: AAC (Advanced Audio Coding).

3. Audio File Format Compatibility

   Statement: All audio file formats will work on all media players.

   Answer: FALSE. Compatibility depends on the specific media player and the codecs supported.

4. Defining Bit Depth

   Question: What is bit depth?

   Answer: Bit depth is the number of bits it is possible to have in each sample or frame of

Jabber JID to Email Conversion

def jid2email(jid):
    email = jid[:jid.find('/')]
    return email

if __name__ == '__main__':
    jabber = '[email protected]/quertyy'
    print(jid2email(jabber))

Lists vs. Tuples

Lists are mutable and can be changed by internal operations, whereas tuples are immutable.

Remove Duplicates from String

def remove_dup(string):
    result = []
    for char in string:
        if char not in result:
            result.append(char)
    return ''.join(result)

Identical Character Count

def count_max(in_string):
    d = dict()
    for c in in_string:
        d[c] = d.get(c, 0) + 1
    return max(d.items(), key=lambda x: x[1])

# Using collections
from collections import Counter
def counter_max(in_string):
    return Counter(in_

Authentication vs. Authorization: Key Differences

Authentication is the process of verifying that an entity is who they claim to be. Authorization refers to the rules that determine what an authenticated user is permitted to do. For example, Adam may be authorized to create and delete databases, while Usama is only authorized to read them.

These two concepts are orthogonal and independent, yet both are central to security design. Failure to implement either correctly creates vulnerabilities.

Alternative Perspectives on Identity

• Authentication binds a principal to an internal identity representation.
• Authentication verifies an external entity using factors such as what the entity knows, has, or is.
• Authorization verifies the role of an entity to determine