|
| |
ORACLE FOR DCSIANS WORKSHOP
EXAMINATION PAPER
CONDUCTOR: MR. ALI MAZAHIR QAMARI
E-MAIL :alidcs@super.net.pk
DEPARTMENT OF COMPUTER SCIENCE
UNIVERSITY OF KARACHI-PAKISTAN
December 31,1999
MAX. MARKS 100
YOUR NAME:
SECTION A
SQL, PL/SQL & ORACLE DEVELOPER
ATEMPT SIX QUESTIONS INCLUDING QUESTION NO. 4 (COMPULSORY)
LIST NAMES, JOB, HIREDATE, COMMISION OF ALL CLERKS IN TABLE EMP
- COUNT NUMBER OF EMPLOYEE IN DEPARTMENT 10?
- SELECT ALL COLUMNS AND ROWS ( OF YOUR CHOICE) FROM TABLE KU AND DCS TABLES WITH
EQUI-JOIN CONDITION HAVING STUDENT_ENROLMENT AS PRIMARY AND REFERENCE KEY?
- CREATE A TABLE HAVING FOLLOWING FIELDS
| INVOICE_NUMBER |
PRIMARY KEY |
NUMBER(10) |
| PURCHASE_ORDER |
REFERENCES KEY |
VARCHAR(20) |
| CURRENT_DATE |
|
DATE |
| ITEMS |
NOT NULL |
VARCHAR(50) |
| AMOUNT |
NOT NULL |
NUMBER (10) |
| SALES_TAX |
NULL |
NUMBER(5) |
| NET_TOTAL |
NOT NULL |
NUMBER (10) |
WRITE A PROGRAM TO GENERATE 1 TO 100 DIGIT NUMBERS IN PL/SQL ?
DIFFERENCE BETWEEN COMMIT AND ROLLBACK?
WRITE DIFFERENCE BETWEEN FORM AND MATRIX REPORTS ?
WHAT CONDITION IS IMPORTANT FOR MASTER-DETAIL FORM?
NAME ANY THREE TRIGGERS AND THEIR PURPOSES?
AFTER DELETING ORAWIN FOLDER FROM MICROSOFT WINDOW EXPLORER YOU CANNOT AGAIN
INSTALL ORACLE ON SAME HOME DIRECTORY (DESTINATION). WHAT WILL YOU DO TO INSTALL THE
PRODUCT?
SECTION B
ACCOUNTING, AUDITING, ADVERTISEMENT & MARKETING
Mr. Murtaza Habib Makda B.Com,
ICMAP
Institute of Cost & Management Accountants of
Pakistan
makda@inet.com.pk
ATEMPT EIGHT QUESTIONS INCLUDING 4,5,8,11 (COMPULSORY)
WHAT IS ACCOUNTING CYCLE ?
WHAT DO WE MEAN BY ACCOUNTING ALCER AND DEFINE ITS ABBREVIATIONS?
DIFFERENCIATE BETWEEN ASSETS AND LIABILITIES?
DIFFERENTIATE BETWEEN ACCOUNTING AND AUDITING ? ALSO DEFINE AIMS AND OBJECTIVES
OF AUDITING ?
ADVANTAGES AND DISADVANTAGES OF COMPUTERIZED ACCOUNTING SYSTEM ?
NAME THE MEDIUMS OF ADVERTISING?
"PROPER ADVERTISING PAVES THE WAY FOR LUCRATIVE MARKET AND
SALES" . DISCUSS?
YOUR DEPARTMENT HAS MADE AN OPERATING SYSTEM, THEY WANT TO ADVERTISE IT ON MAIN
SHARA-E-FAISAL ROAD BY A N IMPRESIVE NEON SIGN BOARD. WHAT
WILL BE ITS LOGO AND TEXT TO REPRESENT IT?MAKE A SKETCH OR ILLUSTRATE SOME POINTS?
SECTION C
DBA & RESOURCE
INFORMATION
NAME SOME PRODUCTS OF ORACLE CORPORATION? ALSO DISCUSS ORACLE 8I, WHY IT IS
BECOMING POPULAR FOR NETWORKS APPLICATION?
ILLUSTRATES SOME MAIN TASKS AND QUALITIES OF DATABASE ADMINISTRATOR? NAME SOME
DBA MONITORING UTILITIES?
PIA (PAKISTAN INTERNATIONAL AIRLINES ) WANTS TO DESIGN A DATABASE MODULE FOR
RECORDING OF PASSENGER INFORMATION AND FLIGHT SCHEDULES. WHAT ARE THE NECESSARY FIELDS
REQUIRE TO BE INCLUDE IN THE SCREEN FORM?
OR
SEMINAR LIBRARY OF DCS WANTED TO KEEP RECORDS OF
OLD AND NEW BOOKS,
MAGZINES, REPORTS, DOCUMENTS. WHAT ARE THE REQUIRE
ENTITIES AND HOW
THEY CREATE RELATIONS WITH MULTIPLE BOOKS
HAVING SAME
AUTHORS BUT DIFFERENT PUBLISHERS?
|
