N A L A N D A O P E N U N I V E R S I T Y
Master of Computer Application Part-III
PAPER-XXIII
(Unix and Oracle)
SET-II
Annual Examination, 2018
Time 3 Hours. Full Marks 100
Answer all the Questions. All questions carry equal marks.
SECTION-A (UNIX)
1. Write and execute the following commands in UNIX
To change the ownership of a file.
To run a program at lower priority.
To compare two files and show their differences.
To display the first 10 lines of a text file.
To kill a process. Write a shell program to generate Fibonacci series up to "N" terms.
2. Write a shell program to write the initials of any given name.
For example:
Input: Rahul Mahindra
Output: RM
SECTION-B (DBMS)
3. Create a database with the following schema:
COMPANY Com_Name, Com_Address, Com_City,
PRODUCT P_Name, P_Size, P_Price)
SALE P-Target, P_Sold, Area_Code)
Select appropriate data types for all the fields. Identify appropriate keys. Also input 10
meaningful records.
4. For the above tables in answer the following queries using SQL
To print the names of all the company.
To display the city and address of the company whose Com_ID= 123.
To display the name of the Product whose Price> 1000.
To display all the company name, address and product name whose product_ID=111.
To display product name, price, target and area_code of the product whose
product_ID>111.