Programming & Computer Science Answers

Display the managerial hierarchy from Ruth Ellerbrock (person type – EM) up to CEO Ken Sanchez. Hint: use

[uspGetEmployeeManagers] (Schema(s) involved: [Person], [HumanResources])

DATABASE- AdverntureWorks2017

Two arrays are given. Write the C code to swap elements from each array such that after

swapping, sum of elements of array1=sum of elements of array2..

Example:

Array 1: 3, 2, 10, 12

Array 2: 6, 4, 9, 10

After swapping 3 (from Array 1) with 4 (from Array 2)

Array1: 4, 2, 10, 12 Sum = 28

Array2: 6, 3, 9, 10 Sum = 28

Q: Write a program which defines three integer variables, var1, var2 and var3, & initializing them to the values 100, 200 & 300, it then prints out their addresses.

Q: What is the data type of pointer variables? Suppose that we don‘t know the name of a variable but we do know its address. Can we access the contents of that variable? Explain briefly.

Q:Write a program which read the following (3x3 dimensional) array and then display it.

"\\begin{Bmatrix}\n 10 & 50 & 70 \\\\\n 40 & 80 & 30 \\\\\n 20 & 55 & 60 \\\\\n\\end{Bmatrix}"

in a school, the students are divided into two categories based on their rank. students whose rank is less than 10 are considered as honor student and all others are considered as normal student. based on the rank, find to which category a student belongs

Q: Many languages internally treat strings as character arrays, but somehow conceal this fact from the programmer. Character arrays or strings are used by programming languages to manipulate text such as words and sentences. Explain this statement with the help of a program.

Q: Create a function “square”, which calculate and displays square of any number entered through the keyboard.  

Q: To decompose the lengthy program into various segments (modules) each of which perform a specific task? Such segments are termed as functions in C++ language. Could you expand this statement further?

Suppose we have data about students of a class i.e. name, addresses, date of birth, GPA and courses of study. This information is related to only a single entity i.e. student.

Which type of programming method you will use to initialize and display this information. Explain with a program.