For More Quiz Questions click here to download Global Quiz on Google PlayStore

NATIONAL OPEN UNIVERSITY OF NIGERIA

UNIVERSITY VILLAGE, PLOT 91, CASDASTRAL ZONE, NNAMDI AZIKIWE EXPRESS WAY, JABI, ABUJA.
FACULTY OF SCIENCES
JANUARY 2021 EXAMINATION

COURSE: CIT 392 - Computer Laboratory II

Credit: 2 units

TIME ALLOWED: 2 Hours

INSTRUCTION: Answer Question 1 and any other THREE (3)

 

Questions 1a)

Discuss the procedural, structural and object-oriented programming paradigms.(3marks)

b) Describe the features of C++ programming language.(2 marks)

c) Construct the syntax for user-defined packages in Java(3 marks)

d) Briefly give 5 examples of Maths methods in Java and state the function of each method.(2 marks)

e)i.) Give the general form of a one-dimensional array with an example.(1 mark)

ii) Write a Java program to find the mean of an array of 10 arbitrary values.(4 marks)

f) i.)Explain the projection, selection and joining capabilities of SELECT statement in SQL .(1 marks)

ii. Use the EMPLOYEES table aboveand listing the output:

I. Write a query to retrieve the last name and salary from the EMPLOYEES table for any employee whose salary is between 2500 and 2600.(2.5 marks)

II. Write a query that retrieves the employee ID, first name, last name and the department ID of employees in department 30.(2.5 marks)

III. Write a query to retrieve the last name and salary from EMPLOYEES table for any employee whose salary is less than or equal to 2900.(2.5 marks)

 

2.a. State the features of ADA programming language.(5marks)

b. Write a ADA programming language that will find the roots of a quadratic equation ax2 + bx + c = 0 using the quadratic formula.(10 marks)

 

3. a . Differentiate between structural and object-oriented programming paradigm for COBOL.(3 marks)

b. Given a rate of exchange of the naira (Rate) to the US$ design a COBOL program to convert a certain amount of US$ to the naira (Dollar).Your result is Exchange(12 marks)

 

4.a) Describe an array.(1 mark)

b) Write a Java program to calculate the sum of integers from 1 to 100.( 8 marks)

c.) Multidimensional arrays are actually arrays of arrays in Java, write a Java program that allocatesa 2 by 3 array and assigns it to names. The array is {{"Mr. ", "Mrs. ", "Ms. "}, {"Alan", "Charles" }}. Show the output.(6 marks) 5a. Explain the connection between SQL and relational database.(1 mark) b. Using the EMPLOYEREES table above:

i. Write a query to retrieve the employee numbers, last name and salary from the EMPLOYEES table for any employee whose employee number is 101,103,105,106 or 110 (6 marks) Ii Write a query to display the employee number, first_name and hire_date of employees. The result should be displayed in such a way that the first names will be arranged alphabetically.(8 marks)

 

 

 

 

ii. Use the EMPLOYEES table aboveand listing the output:

I. Write a query to retrieve the last name and salary from the EMPLOYEES table for any employee whose salary is between 2500 and 2600.(2.5 marks)

II. Write a query that retrieves the employee ID, first name, last name and the department ID of employees in department 30.(2.5 marks)

III. Write a query to retrieve the last name and salary from EMPLOYEES table for any employee whose salary is less than or equal to 2900.(2.5 marks)

 

2.a. State the features of ADA programming language.(5marks)

b. Write a ADA programming language that will find the roots of a quadratic equation ax2 + bx + c = 0 using the quadratic formula.(10 marks)

 

3. a . Differentiate between structural and object-oriented programming paradigm for COBOL.(3 marks)

b. Given a rate of exchange of the naira (Rate) to the US$ design a COBOL program to convert a certain amount of US$ to the naira (Dollar).Your result is Exchange(12 marks)

 

4.a) Describe an array.(1 mark)

b) Write a Java program to calculate the sum of integers from 1 to 100.( 8 marks)

c.) Multidimensional arrays are actually arrays of arrays in Java, write a Java program that allocatesa 2 by 3 array and assigns it to names. The array is {{"Mr. ", "Mrs. ", "Ms. "}, {"Alan", "Charles" }}. Show the output.(6 marks)

 

5a. Explain the connection between SQL and relational database.(1 mark)

b. Using the EMPLOYEREES table above:

i. Write a query to retrieve the employee numbers, last name and salary from the EMPLOYEES table for any employee whose employee number is 101,103,105,106 or 110 (6 marks)

Ii Write a query to display the employee number, first_name and hire_date of employees. The result should be displayed in such a way that the first names will be arranged alphabetically.(8 marks)


For More Quiz Questions click here to download Global Quiz on Google PlayStore


Select NOUN Past Questions & Answers by Faculties

Sciences

National Open University of Nigeria (NOUN) Faculty of Sciences Past Questions and Answers.

Education

National Open University of Nigeria (NOUN) Faculty of Education Past Questions and Answers.

Arts & Social Sciences

National Open University of Nigeria (NOUN) Faculty of Arts and Social Sciences Past Questions and Answers.

Law

National Open University of Nigeria (NOUN) Faculty of Law Past Questions and Answers.

Management Sciences

National Open University of Nigeria (NOUN) Faculty of Management Sciences Past Questions and Answers.

Health Sciences

National Open University of Nigeria (NOUN) Faculty of Health Sciences Past Questions and Answers.

Agriculture Sciences

National Open University of Nigeria (NOUN) Faculty of Agricultural Sciences Past Questions and Answers.

Select Project Topics & Materials by Categories

Accounting

Universities, Polytechnic's and Colleges of Education Accounting Project Topics and Materials.

Biology

Universities, Polytechnic's and Colleges of Education Biology Project Topics and Materials.

Business Education

Universities, Polytechnic's and Colleges of Education Business Education Project Topics and Materials.

Chemistry

Universities, Polytechnic's and Colleges of Education Chemistry Project Topics and Materials.

Computer Science

Universities, Polytechnic's and Colleges of Education Computer Science Project Topics and Materials.

Criminology & Security

Universities, Polytechnic's and Colleges of Education Criminology & Security Project Topics and Materials.

Economics

Universities, Polytechnic's and Colleges of Education Economics Project Topics and Materials.

Education

Universities, Polytechnic's and Colleges of Education Education Project Topics and Materials.

English/Linguistic

Universities, Polytechnic's and Colleges of Education English/Linguistic Project Topics and Materials.

Entrepreneurship

Universities, Polytechnic's and Colleges of Education Entrepreneurship Project Topics and Materials.

Environmental Science

Universities, Polytechnic's and Colleges of Education Environmental Science Project Topics and Materials.

Law

Universities, Polytechnic's and Colleges of Education Law Project Topics and Materials.

Marketing

Universities, Polytechnic's and Colleges of Education Marketing Project Topics and Materials.

Physics

Universities, Polytechnic's and Colleges of Education Physics Project Topics and Materials.

Political Science

Universities, Polytechnic's and Colleges of Education Political Science Project Topics and Materials.

Public Administration

Universities, Polytechnic's and Colleges of Education Public Administration Project Topics and Materials.

How to login to NOUN Elearn Portal

You can now use you matric number to login as your username and  password in a lowercase.

https://elearn.nouedu2.net/login/

Note that you are to change your passw...

Facebook posts