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-I
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 rename a file.
To create a file using "vi" editor.
To display the inode number of any file.
To create a subdirectory "xyz" in the current directory.
To display the long listing of all the files in the current directory.
2. Write a shell program to generate Fibonacci series up to "N" terms.
SECTION-B (DBMS)
3. Create a database with the following schema:
BOOK_CLUB:
CATALOG TITLE, AUTHOR_ID, PUBLISHER_ID, YEAR_OF_PUB, PRICE)
AUTHOR (AUTHOR_ID, NAME, CITY, COUNTRY)
PUBLISHER (PUBLISHER_ID, NAME, CITY, COUNTRY)
CATEGORY DESCRIPTION)
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 all the category details.
To display the country and city of AUTHOR_ID 123.
To display the name of the PUBLISHER whose ID 444.
To display all the books whose price is T 500.
To display all the AUTHOR_ID's who belong to "CHENNAI".