Oracle Programming (SQL/PlSQL)

47 Questions | Total Attempts: 99

SettingsSettingsSettings
Please wait...
Oracle Programming (SQL/PlSQL)


Questions and Answers
  • 1. 
    How would you express the address of the cell located at the intersection of row 28 and column 27?
    • A. 

      AA28

    • B. 

      AB28

    • C. 

      28.27

    • D. 

      27.AB

    • E. 

      76.XS

  • 2. 
     In a typical spreadsheet, the reference H$8 is type into cell T5. If this reference is copied into cell AA8, which cell will it refer to?
    • A. 

      AA5

    • B. 

      O8

    • C. 

      O11

    • D. 

      T8

  • 3. 
    Flowcharts usually begin with symbol?
    • A. 

      Annotation

    • B. 

      Input/ output

    • C. 

      Process

    • D. 

      Terminal

  • 4. 
    What is the value of the following logical expression when the Boolean variables A, B, and C are set to TRUE, TRUE, and FALSE, respectively?
    • A. 

      TRUE

    • B. 

      FALSE

    • C. 

      Neither TRUE nor FALSE

    • D. 

      Both TRUE and FALSE

  • 5. 
    Which control Structure is used to Execute a block of code a specified number of times?
    • A. 

      DO…….WHILE

    • B. 

      FOR…..NEXT

    • C. 

      GOTO

    • D. 

      IF…..THEN

    • E. 

      Gilmon....frankie

  • 6. 
    Which control structure is used to decide between two alternate courses of action?
    • A. 

      DO…….WHILE

    • B. 

      FOR…..NEXT

    • C. 

      GOTO

    • D. 

      IF….THEN

  • 7. 
    Which of the following control structures are branching statements?  (I)        FOR…. NEXT (II)        GOTO (III)       IF……THEN
    • A. 

      I only

    • B. 

      II only

    • C. 

      I and II

    • D. 

      II and III

  • 8. 
     How many bits are there in a megabyte?
    • A. 

      2^12

    • B. 

      2^18

    • C. 

      2^20

    • D. 

      2^23

  • 9. 
     What is the shortest time that a 28,8800 bps modem can transmit a 1MB file?
    • A. 

      36 s

    • B. 

      290 s

    • C. 

      980 s

    • D. 

      2300 s

  • 10. 
    What is a MODEM
    • A. 

      Convert data from digital to analog and back again

    • B. 

      Communicates between CPU and peripherals

    • C. 

      Manage data transmission between CPU storage devices

    • D. 

      Stores data which must be accessed frequently

  • 11. 
    What component of a typical computer system has a largest memory capacity?
    • A. 

      RAM

    • B. 

      ROM

    • C. 

      Hard disk

    • D. 

      Floppy disk

  • 12. 
    The smallest piece of information that can be interpreted by a computer is the
    • A. 

      Bit

    • B. 

      Byte

    • C. 

      Character

    • D. 

      Word

  • 13. 
     If A = TRUE and B = FALSE, which of the following Expressions evaluates to TRUE?
    • A. 

      A AND B

    • B. 

      NOT (A OR B)

    • C. 

      A OR (A AND B)

    • D. 

      B AND (A OR B)

  • 14. 
    Which of the following is the a volatile data storage device?
    • A. 

      Hard disk

    • B. 

      CD-ROM

    • C. 

      WORM drive

    • D. 

      RAM

  • 15. 
    Which of the following is an e-mail address in the proper Format?
    • A. 

      WWW.gilmon.net

    • B. 

      Logic.think.net/stangib

    • C. 
    • D. 

      Http://google.com

    • E. 

      All of the above

  • 16. 
    A robot can be guided along a specific route by means of a current-carrying wire beneath the surface. The robot detects, and follows, the magnetic field produced by the current, thus following wire. This is called
    • A. 

      An epipolar system

    • B. 

      A fluxgate magnetometer

    • C. 

      A servo system

    • D. 

      An electronic router

    • E. 

      An embedded path

  • 17. 
    Fill in the blanks in the following sentences to make it true: “On the web, data is transmitted by means of a ______ that allows the file on distant computers to appear as if they are on your own computer.”
    • A. 

      Protocol

    • B. 

      Memory chip

    • C. 

      Microprocessor

    • D. 

      CD-R

    • E. 

      Tape drive

  • 18. 
    A robot arm with articulated geometry works as what?
    • A. 

      Has only one degree of freedom

    • B. 

      As, joints, similar to the human arm

    • C. 

      Can functions in only two dimensional

    • D. 

      Can rotate up and down but cannot bend

    • E. 

      Can perform only coarse movements

  • 19. 
    What form does an android takes
    • A. 

      An insect

    • B. 

      The human body

    • C. 

      Simple robot arm

    • D. 

      A stereo vision system

  • 20. 
     A thermal printer might be an ideal choice for
    • A. 

      A salesperson who is on the road.

    • B. 

      Someone working with animated graphics

    • C. 

      An author who needs to print a huge text document

    • D. 

      A photographer who needs top-quality color printouts

  • 21. 
    Which of the following devices is best suited for animated graphics work involving fast motion, such as high-end gaming?
    • A. 

      A laser printer

    • B. 

      An external hard drive or flash drive

    • C. 

      A display that does not use interlacing

    • D. 

      A stereo vision system

    • E. 

      Tape drive

  • 22. 
    Which of the following strings is the proper format for an E-mail address?
    • A. 

      Http://www.gilmon.net

    • B. 

      Www.logioc-think.com

    • C. 

      MAY_Logicthink.com

    • D. 

      All of the above

    • E. 

      None of the above

  • 23. 
    Which of the following is the serial access medium?
    • A. 

      Magnetic tape

    • B. 

      A diskette

    • C. 

      A hard drive

    • D. 

      A CD-RW

    • E. 

      Gilmon drive

  • 24. 
    Which of the following types of external storage provide the fastest time, provide no software conflicts occur?
    • A. 

      A magnetic hard drive

    • B. 

      A CD-R or CD-RW drive

    • C. 

      A flash memory module

    • D. 

      An external hard drive

  • 25. 
    what is the purpose of a ROM chip
    • A. 

      It is easier to read data from the device than to write data into it.

    • B. 

      It is more difficult to read data from the device than to write data into it.

    • C. 

      It is easy to read data from the device, and just as easy to write data into it.

    • D. 

      It is difficult to read data from the device, and equally difficult to write data into it.