Notes, summaries, assignments, exams, and problems for Vocational training

Creating a User

SQL Command

CREATE USER <nombre_usuario> IDENTIFIED BY <password>;

Granting Privileges

SQL Command

GRANT CONNECT TO <nombre_usuario>;

Creating a Profile

SQL Command

CREATE PROFILE profile_name LIMIT limit(s) range;

Limits

• SESSIONS_PER_USER
• CPU_PER_SESSION
• CPU_PER_CALL
• CONNECT_TIME
• IDLE_TIME
• LOGICAL_READS_PER_SESSION
• LOGICAL_READS_PER_CALL
• COMPOSITE_LIMIT
• PRIVATE_SGA

Range Options

• UNLIMITED
• DEFAULT
• Integer value

Example Profile Creation

CREATE PROFILE MyProfile LIMIT PRIVATE_SGA 50K;

CREATE PROFILE app_user LIMIT

• SESSIONS_PER_USER UNLIMITED
• CPU_PER_SESSION UNLIMITED
• CPU_PER_CALL 3000
• CONNECT_TIME 45
• LOGICAL_READS_PER_SESSION DEFAULT
• LOGICAL_READS_PER_CALL 1000
• PRIVATE_SGA 15K
• COMPOSITE_LIMIT 5000000;

Creating Additional Profiles

CREATE PROFILE

1. Essential Car Components

Interior and Exterior Parts

• Sun visor
• Horn
• Steering wheel
• Airbag
• Dashboard
• Ignition
• Rear-view mirror
• Hands-free telephone system
• Cigarette lighter
• Glove compartment
• Air vent
• Door handle
• Door tray
• Headrest
• Seatbelt
• Cup holder
• Handbrake
• Gearstick (or Gear lever)
• Ashtray
• Accelerator pedal
• Brake pedal
• Clutch pedal

2. Dashboard Instruments and Exterior Features

Key Indicators and Vehicle Body Parts

• Fuel level gauge
• Speedometer
• Engine oil temperature gauge
• Rev counter (Tachometer)
• Voltmeter
• Gearstick (or Gear lever)
• Indicator lights
• Ignition
• Steering wheel
• Seatbelt
• Ashtray
• Dashboard
• Brake pedal
• Sun visor
• Gearstick/Clutch (referring to controls)
• Headrest
• Handbrake
• Glove compartment
• Rear-view mirror
• Rear lights
• Alloy wheels (or Alloy rims)
• Bonnet (Hood)
• Boot (Trunk)
• Roof

Swift's Utopian Visions and Literary Influences

In the tradition of extraordinary voyages, most significant for Swift were the two posthumous works of Cyrano de Bergerac (1619-1655):

• Histoire comique des états et empires de la lune (1656)
• Histoire comique des états et empires du soleil (1657)

Cyrano de Bergerac: A Key Influence on Swift

The Society of Moon Dwellers: Cyrano's Utopia

Cyrano's lunar society is depicted as:

• A crimeless idyll with a natural abundance of food, minimal work, beautiful females, and eternal spring.
• As there is no crime, there are no lawyers.
• Physicians are unnecessary since the Lunarians live healthy lives.
• Upon death, there is no grief but a kind of rejoicing at passing into heaven.

Cyrano's Lunar Voyage and Brobdingnag Parallels

Swift... Continue reading "Jonathan Swift's Utopian Satire and Literary Roots" »

Essential Commercial and Financial Documents

Understanding the various commercial and financial documents is crucial for smooth business operations and international trade. Each document serves a specific purpose, ensuring clarity, legality, and proper record-keeping.

Order Proposal

An Order Proposal is a document by which the buyer or customer agrees to acquire goods ordered from the supplier.

• It is always signed by the person who makes the request.
• Each company will settle its own order.

Delivery Note

A Delivery Note is a document issued by the supplier or seller, detailing the goods being delivered.

• It accompanies a shipment of goods.
• It lists the description and quantity of the goods delivered.
• It is returned to the seller or consignor as proof of

Lanzarote Hotel Recommendations: Palm Beach vs. Jaime I

Oihana (Eroski Viajes): Good morning, Eroski Viajes. Oihana speaking. Can I help you?

Client: Hello! I'm planning to go to Lanzarote and I'd like some information about the hotels you recommend.

Oihana: Right, well, there are two hotels that we usually recommend: the Palm Beach, which is in Lanzarote itself, and the Jaime I.

Client: Is the Jaime I actually in Lanzarote, too?

Oihana: No, it is about seven miles away. What sort of accommodation are you looking for?

Client: I'm not sure, really. Could you tell me a bit about the first one?

Hotel Comparison

Palm Beach Hotel (Lanzarote)

• First-class hotel.
• Full facilities expected of a high-end resort.
• Features include: a good choice of restaurants, a

Employment Contracts

What is an Employment Contract?

An employment contract is an agreement between an employer and an employee. The employee provides services to the employer in exchange for remuneration. The contract marks the beginning of the employment relationship and establishes a series of rights and obligations for both parties. The employee works under the direction and organization of the employer.

Key Elements of an Employment Contract

Essential components include:

• Consent: Represents the free will of both parties to agree, without deception or fraud.
• Object: Defines the obligations of each party. The work performed must be personal, voluntary, paid, and dependent (under the employer's direction).
• Cause: The reason for the agreement –

Linking Words: Relative Pronouns (Part I)

I. Function of Relative Pronouns

Relative pronouns are used to join two sentences, avoiding the repetition of elements that have already been stated.

Example:

Original sentences:

The programmer required the control volume. The control volume is part of a catalogued procedure.

Combined sentence:

The programmer required the control volume which is part of a catalogued procedure.

Common Relative Pronouns:

• WHICH
• THAT
• WHO
• WHOSE
• WHOM

Exercises: Sentence Combination

Rewrite the following pairs of sentences into one by connecting them with the suggested relative pronoun [WHICH, THAT, WHO, WHOSE]. Translate the final combined sentence into your language.

1. Decisions and Cruciality

The manager made important decisions.
These... Continue reading "Mastering Relative Pronouns for Sentence Combining" »

Candidate Assessment: A Comprehensive Guide

Profile Study

• Assessment of CV presentation
• Analysis of cover letter
• Check for 5/6 essential profile factors: Age, degree, training, experience.
• Selection of suitable candidates
• Communication to rejected candidates

Preliminary Interview

Important for removing unsuitable candidates.

• Short
• Informs the candidate of basic workplace features: salary, contract type, position, specific location.

Assessment and Psychometric Tests

• Aims to measure personality, skills, and knowledge.
• Predicts future behavior in a specific job.

In-Depth Interview

• Introduce the candidate to the job and company.
• Evaluate the candidate's real potential for development.
• Evaluate opportunities for future development.
• Report on past behavior in similar

Relive the sound of Summer 2012 with the official tracklist from Flaix FM.

1. Sak Noel – Where? (I Lost My Underwear)
2. Nicki Minaj – Starships (Radio Edit)
3. DJ Antoine feat. The Beat Shakers – Ma Chérie (DJ Antoine vs. Mad Mark 2k12 Radio Edit)
4. Pitbull & Chris Brown – International Love (Album Edit)
5. Bob Sinclar feat. Gilbere Forte, Dragonfly & Fatman Scoop – Rock The Boat
6. Alexandra Stan feat. Carlprit & Jason Ray - 1.000.000
7. Havana Brown – We Run the Night
8. Deniz Koyu – Tung!
9. Victor Magan & Aritz feat. Lessus – Give (Radio Edit)
10. Ian Carey & Rosette feat. Timbaland & Brasco – Amnesia
11. Basto – Again And Again
12. Elena – Your Captain Tonight
13. Tom Hangs & Shermanology – Blessed (Avicii Radio Edit)
14. Mike T feat. Rawanne

Causative Have Practice Exercises

• They had arranged for their house to be cleaned by the end of the week. Now it is clean. What had they done? (They had had their house cleaned.)
• The grass has grown too much. What should they have done? (They should have had the grass cut.)
• His tooth was filled yesterday. What happened to him? (He had his tooth filled yesterday.)
• No one has informed them of the meeting. What should he have done for them? (He should have had them informed of the meeting.)

Examples of Daily Tasks and Changes

• We are having the furniture rearranged (furniture/rearrange). We got tired of having it in the same place for so long.
• That’s a good idea. We are going to have our furniture replaced (our furniture/replace) next week. I’m sick