Make your own free website on Tripod.com

Examination Paper
Home Up Next

 

  Theory

Projects

Articles

 Written Books

Report

Technical Report

Survey Reports

Workshop

Presentations

Tutorials

Algorithms

Contact Me

Yourself

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)

 

  1. LIST NAMES, JOB, HIREDATE, COMMISION OF ALL CLERKS IN TABLE EMP
  2.  

  3. COUNT NUMBER OF EMPLOYEE IN DEPARTMENT 10?
  4.  

  5. 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?
  6.  

  7. CREATE A TABLE HAVING FOLLOWING FIELDS
  8.  

    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)
  9. WRITE A PROGRAM TO GENERATE 1 TO 100 DIGIT NUMBERS IN PL/SQL ?
  10.  

  11. DIFFERENCE BETWEEN COMMIT AND ROLLBACK?
  12.  

  13. WRITE DIFFERENCE BETWEEN FORM AND MATRIX REPORTS ?
  14.  

  15. WHAT CONDITION IS IMPORTANT FOR MASTER-DETAIL FORM?
  16.  

  17. NAME ANY THREE TRIGGERS AND THEIR PURPOSES?
  18.  

  19. 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)

 

  1. WHAT IS ACCOUNTING CYCLE ?
  2.  

  3. WHAT DO WE MEAN BY ACCOUNTING ALCER AND DEFINE ITS ABBREVIATIONS?
  4.  

  5. DIFFERENCIATE BETWEEN ASSETS AND LIABILITIES?
  6.  

  7. DIFFERENTIATE BETWEEN ACCOUNTING AND AUDITING ? ALSO DEFINE AIMS AND OBJECTIVES OF AUDITING ?
  8.  

  9. ADVANTAGES AND DISADVANTAGES OF COMPUTERIZED ACCOUNTING SYSTEM ?
  10.  

  11. NAME THE MEDIUMS OF ADVERTISING?
  12.  

  13. "PROPER ADVERTISING PAVES THE WAY FOR LUCRATIVE MARKET AND SALES" . DISCUSS?
  14.  

  15. 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?
  16. SECTION C

    DBA & RESOURCE INFORMATION

  17. NAME SOME PRODUCTS OF ORACLE CORPORATION? ALSO DISCUSS ORACLE 8I, WHY IT IS BECOMING POPULAR FOR NETWORKS APPLICATION?
  18.  

  19. ILLUSTRATES SOME MAIN TASKS AND QUALITIES OF DATABASE ADMINISTRATOR? NAME SOME DBA MONITORING UTILITIES?
  20.  

  21. 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?