All categories

3 years ago

Create a query that will list all technician names, employee numbers, and year hired in order by year hired (Newest to Oldest).

Computers and Technology

1 answer:

Oliga [24]3 years ago

7 0

Answer:

SELECT TECHNAME, EMPNUM, YEAR FROM EMPLOYEE ORDER BY YEAR DESC

Explanation:

The table definition is not given;

However, I'll make the following assumptions

Table Name:

Employee

Columns:

Technician name will be represented with Techname

Employee number will be represented with Empnum

Year Hired will be represented with Year

Having said that; the sql code is as follows:

SELECT TECHNAME, EMPNUM, YEAR FROM EMPLOYEE ORDER BY YEAR DESC

The newest year hired will be the largest of the years;

Take for instance:

An employee hired in 2020 is new compared to an employee hired in 2019

This implies that the year has to be sorted in descending order to maintain the from newest to oldest.

You might be interested in

An organization is trying to decide which type of access control is most appropriate for the network. The current access control

alisha [4.7K]

Answer: D.) Discretionary access control

Explanation: Access control modes provides networks with a security system used for moderating, risk prevention and privacy maintainance of data and computing systems. Several access control modes exists depending on the degree of control required. In the discretionary access control approach, users are afforded the freedom and flexibility of making choices regarding permissions granted to programs. Hence, in this mode, permission are user-defined and as such sets privileges based on how the user deems fit.

8 0

4 years ago

Victoria is creating a brochure for her photography studio. She designed the layout and placed a photo in the center of the page

cestrela7 [59]

Assuming Victoria is using Adobe Photoshop to create her brochure, below are the steps she is required to follow.

She should first open the image on Photoshop, click on the image option and select duplicate just in case the resized image is not what she wants.

Still on the image option, she should select Image size. A screen will pop up at this point, indicating the image’s current size. For the purposes of image resizing, Victoria should select Pixel dimensions category.

She should be able to type her preferred dimensions for both the width and height. She should make sure ‘Constrain Proportions’ is unchecked to be able to type in separate values.

If she decides to use the photo editing program, she can simply click on the image, and if resize handles appear around it, she can click and drag those to the desired size.

3 0

4 years ago

Select the two true statements about functions with parameters:

kondor19780726 [428]

Answer:

Option (B) and (C) is the correct option to the following question.

Explanation:

Because the function is the module of the program and we call that function again and again anywhere whenever we need that function in the program.

Function is used to carry out any operation which is used in the program many times and it creates the program short and simple.

For example: if we need to add or multiply two numbers many times in the program then, we create one or two functions for addition and subtraction or one program for both, when we need them we call them.

4 0

3 years ago

A command used to find the id number of each running process

Goshia [24]

Tasklist would be the answer.

(:

3 0

4 years ago

Write a Java program that prompts the user to enter integer values for the sides of a triangle and then displays the values and

satela [25.4K]

Answer:

import java.util.Scanner;

public class triangle {

public static void main (String [] args) {

int sideOne, sideTwo, sideThree;

Scanner in = new Scanner (System.in);

System.out.println("Enter the first side of the triangle");

sideOne = in.nextInt();

System.out.println("Enter the secon side of the triangle");

sideTwo = in.nextInt();

System.out.println("Enter the third side of the triangle");

sideThree = in.nextInt();

if ( sideOne<=0||sideTwo<=0|| sideThree<=0){

System.out.println(" The Values enter are "+sideOne+ "," +sideThree+ ","+sideThree+ " These values don't make a valid triangle");

}

else if ((sideOne + sideTwo> sideThree) || (sideOne+sideThree > sideTwo) || (sideThree+sideTwo > sideOne))

{

System.out.println ("The triangle is Valid");

}

else {

System.out.println(" The Values enter are "+sideOne+ "," +sideTwo+ ","+sideThree+ " These values don't make a valid triangle");

}

Explanation:

for a Triangle to be Valid one of the three sides of the triangle must greater than the other two sides. The code above enforces this condition using an if statement in combination with the Or Operator

The following conditions where enforced

side one, side two and side three != 0

Side One + Side Three > Side Two

Side Three + Side Two> Side One

Side Two + Side One > Side Three

7 0

3 years ago