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

Sort by
Subject
Level

Telecom Standards: Business Values, Bodies, and Acronyms

Classified in Computers

Written on in English with a size of 2.5 KB

Business Values of Telecom Standardization for Operators

  1. Multiple sources of supply (decrease risk of sole supplier dependencies/lock-in, improve choice at competitive prices).
  2. Interoperability, e.g., multi-vendor networks, service interop.
  3. Assurance that investment in technology should not abruptly change or fail.

Business Values of Telecom Standardization for Vendors

  1. Network vendors can sell to all service operators, freed from vendor-specific R&D.
  2. Reduce customization.
  3. Build reputation / customer confidence - strong standards brand.
  4. Larger markets from wide adoption, greater economies of scale.

Types of Standards Bodies

  1. Accredited
  2. Treaty-based
  3. Partnerships

Telecom Acronyms Explained

  1. ITU: International Telecommunication Union
  2. IETF: Internet Engineering
... Continue reading "Telecom Standards: Business Values, Bodies, and Acronyms" »

SQL*Plus and Oracle Database: Test Questions and Answers

Classified in Computers

Written on in English with a size of 7.44 KB

SQL*Plus is the version of SQL used to access Oracle databases

1.True

2.False

SQL*Plus del command can delete all lines from the buffer at once

1.True

2.False

There is no difference between the CHAR and VARCHAR2 data types. They are just spelled differently

1.True

2.False

Which command(s) set the title of SQL*Plus report

  1. Set Headsep
  2. Column
  3. Set PageSize
  4. Set Line Size
  5. Edit
  6. Define_Editor
  7. Start
  8. Remark
  9. /* */
  10. Host
  11. Ttitle
  12. Btitile
  13. @
  14. Break On
  15. Compute Sum
  16. Set NewPage
  17. Set Pause
  18. Save
  19. Host
  20. Command is not in the list
  21. Command does not exist

Table in Oracle cannot be created if the primary key is not specified

1.True

2.False

Alternate key may contain NULL values

1.True

2.False

Table can have several alternate keys, but only one primary key and one foreign key

1.True

2.False

Which command(s) is/... Continue reading "SQL*Plus and Oracle Database: Test Questions and Answers" »

SQL Aggregate Functions: COUNT, SUM, MIN, MAX, AVG

Classified in Computers

Written on in English with a size of 12.36 KB

Aggregations

Consider the case of sports tournaments like cricket. Players' performances are analyzed based on their batting average, the maximum number of sixes hit, the lowest score in a tournament, etc.

In such scenarios, we perform aggregations to combine multiple values into a single value, i.e., individual scores into an average score.

Let's learn more about aggregations to perform insightful analysis using the following database.

Database: The database consists of a player_match_details table that stores information about players' details in a match, such as name, match, score, year, and the number of fours and sixes scored.

Schema

12345678
player_match_details (name VARCHAR(250),match VARCHAR(10),score INTEGER,fours INTEGER,sixes INTEGER,year
... Continue reading "SQL Aggregate Functions: COUNT, SUM, MIN, MAX, AVG" »

Python Class: Store Management System

Classified in Computers

Written on in English with a size of 4.38 KB

Python Store Management System

This code defines a Store class in Python, designed to manage customers, sellers, and orders. It uses basic object-oriented principles and data structures.

Class Definition

from Problema2.Cliente import Cliente
from Problema2.Vendedor import Vendedor

class Tienda():
    def __init__(self):
        self.__personas = []
        self.__pedidos = []

    def altaCliente(self, Cliente):
        alta = False
        if Cliente in self.__personas:
            alta = False
        else:
            self.__personas.append(Cliente)
            alta = True
        return alta

    def altaVendedor(self, Vendedor):
        alta = False
        if Vendedor in self.__personas:
            alta = False
        else:
... Continue reading "Python Class: Store Management System" »

Inheritance and Method Overriding in Java: A Comprehensive Guide

Classified in Computers

Written on in English with a size of 2.3 KB

Inheritance in Java

Inheritance in Java is a mechanism where one object acquires all the properties and behaviors of another object. Inheritance represents the IS-A relationship, also known as a parent-child relationship.

Using inheritance, you can create a general class that defines common traits for a set of related items. This class can then be inherited by other classes, each adding its unique elements.

The keyword extends defines a new class from an existing class. The existing class is called the parent/base/superclass, and the new class is called the child/derived/subclass.

Here's a breakdown:

  • Child classes inherit all members of their parent class.
  • Child classes cannot access the private members of the parent class directly.
  • To access private
... Continue reading "Inheritance and Method Overriding in Java: A Comprehensive Guide" »

Understanding Maps and Double Linked Lists in Java

Classified in Computers

Written on in English with a size of 8.4 KB

Map & Diccionarios

Import Statements

import java.security.InvalidParameterException;
import java.util.*;

RedCarreteras Class

public class RedCarreteras { 
    private Map<String, Map<String, Integer>> red;

    //CONSTRUCTORES
    public RedCarreteras() {
        red = new HashMap<>();// Nuevo dicc a 0
    }

    //METODOS
    private void validarTramo(String una, String otra, int distancia) {
        if (una == null || otra == null || una.equals(otra) || distancia < 1)
            throw new InvalidParameterException();
    }

    public Set<String> ciudades() {
        return red.keySet();
    }

    public int nuevoTramo(String una, String otra, int distancia) {
        validarTramo(una, otra, distancia);
... Continue reading "Understanding Maps and Double Linked Lists in Java" »

Essential Tech Terms: A Comprehensive Glossary

Classified in Computers

Written on in English with a size of 4.83 KB

RAM (Random Access Memory)

Random Access Memory is one of two basic types of memory. Portions of programs are stored in RAM when the program is launched so that the program will run faster. Though a PC has a fixed amount of RAM, only portions of it will be accessed by the computer at any given time. Also called memory.

Scrolling

Scrolling allows lines displayed on the screen to be moved up or down by one line as a new line is added and an existing one is removed.

Shooter

A shooter is a game whose main focus is combat involving guns or other projectile weapons such as missiles.

Shopping Cart

A shopping cart is software that keeps track of what you buy on a site.

Software Engineer

A software engineer is a person that writes computer programs.

Speech Recognition

Speech

... Continue reading "Essential Tech Terms: A Comprehensive Glossary" »

CPU Scheduling: Understanding Processes and Threads

Posted by miko_rodri and classified in Computers

Written on in English with a size of 5.07 KB

1. Processes

A process is a program in execution. It is a unit of work within the system. A program is a passive entity, while a process is an active one. A process needs resources to accomplish its task (CPU, memory, I/O, files). Process termination requires the reclamation of any reusable resources. A single-threaded process has one program counter, specifying the location of the next instruction to execute. The process executes instructions sequentially, one at a time, until completion. A multithreaded process has one program counter per thread. Concurrency is achieved by multiplexing the CPUs among the processes or threads.

2. Process States

As a process executes, it changes its state:

  • New: The process is being created.
  • Running: Instructions
... Continue reading "CPU Scheduling: Understanding Processes and Threads" »

Web Development Fundamentals

Classified in Computers

Written on in English with a size of 117.12 KB

Pseudo Classes

Pseudo classes are selectors that can be used to style elements based on their state or position in the document. For example, the :hover pseudo class can be used to style an element when the user hovers over it with the mouse.

:nth-of-type(an+b || even || a || an)

The :nth-of-type pseudo class is used to select elements based on their position in a group of siblings. It takes an argument that specifies which elements to select. The argument can be one of the following:

  • an+b: Selects every nth element, starting with the bth element. For example, 2n would select every other element, and 2n+1 would select every odd element.
  • even: Selects every even-numbered element.
  • odd: Selects every odd-numbered element.
  • a: Selects every element.

For... Continue reading "Web Development Fundamentals" »

Public vs. Private Blockchains: Understanding the Key Differences

Classified in Computers

Written on in English with a size of 2.03 KB

1. What is a Public Blockchain?

Public blockchains are open networks that allow anyone to participate. This permissionless nature means anyone can join the network and read, write, or participate in the blockchain.

Public blockchains are decentralized, meaning no single entity controls the network. Data on a public blockchain is secure because it is virtually impossible to modify or alter data once validated on the blockchain.

Features of Public Blockchains:

  • High Security: Secured by mining and the 51% rule.
  • Open Environment: Open for anyone to join.
  • Anonymous Nature: Participants can remain anonymous, enhancing privacy.
  • No Regulations: No strict regulations on platform usage.
  • Full Transparency: The ledger is publicly viewable, ensuring transparency.
... Continue reading "Public vs. Private Blockchains: Understanding the Key Differences" »