Oracle Programming (SQL/plSQL)

47 Questions

Settings
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.

  • 26. 
    Which of the following codes is digital
    • A. 

      Morse code

    • B. 

      Baudot code

    • C. 

      ASCII

    • D. 

      All of the above

  • 27. 
    What is the decimal binary code 1111?
    • A. 

      15

    • B. 

      63

    • C. 

      31

    • D. 

      127

  • 28. 
     What is the decimal binary code 1110?
    • A. 

      14

    • B. 

      15

    • C. 

      31

    • D. 

      127

  • 29. 
    What is the decimal binary code 1000?
    • A. 

      9

    • B. 

      8

    • C. 

      5

    • D. 

      1

  • 30. 
     A magnetic hard disk is usually part of
    • A. 

      Computer

    • B. 

      A dc motor

    • C. 

      A tape recorder

    • D. 

      An electromagnet

  • 31. 
    Which one is not an output device?
    • A. 

      Printer

    • B. 

      Monitor

    • C. 

      Keyboard

    • D. 

      Modem

  • 32. 
     Which one works as an output and input device?
    • A. 

      Modem

    • B. 

      Scanner

    • C. 

      Mouse

    • D. 

      Monitor

  • 33. 
    All computers must have
    • A. 

      Word processing software

    • B. 

      A printer attached

    • C. 

      An operating system

    • D. 

      A virus checking program

  • 34. 
    Software is:
    • A. 

      A computer program

    • B. 

      A set of instructions

    • C. 

      Only in operating system

    • D. 

      All of the above

  • 35. 
    Which hard disk will be able to store more information?
    • A. 

      24MB

    • B. 

      2400KB

    • C. 

      24GigB

    • D. 

      240MB

  • 36. 
     In order for your computer to play music you need:
    • A. 

      A network card and speakers

    • B. 

      A sound card and speakers

    • C. 

      Nothing more than the internal speaker

    • D. 

      A CD-ROM drive

  • 37. 
    In order to access the World Wide Web you need:
    • A. 

      An Internet connection, an Internet Service Provider and browser software

    • B. 

      Only Internet Explorer or Netscape Navigator

    • C. 

      A modem and a browser

    • D. 

      Nothing. All computers can access the Internet

  • 38. 
    If you have two different printers attached to your computer, what would you need to make it work both ways?
    • A. 

      It is not possible to have two printers attached to a single computer

    • B. 

      You need to install a single printer driver

    • C. 

      You need to use application software that can recognize both printers

    • D. 

      You need to install two different printer drivers in order to be able to print to either printer

  • 39. 
    Parts of the computer that holds information.
    • A. 

      Processing device

    • B. 

      Output devices

    • C. 

      Storage devices

    • D. 

      Input devices

  • 40. 
    Part of the computer that processes and controls the flow of information
    • A. 

      Processing device

    • B. 

      Output devices

    • C. 

      Storage devices

    • D. 

      Input devices

  • 41. 
    Parts of the computer that give out information generated by the computer
    • A. 

      Processing device

    • B. 

      Output devices

    • C. 

      Storage devices

    • D. 

      Input devices

  • 42. 
    The________ provides basic output for a user to see and interact with the computer.
    • A. 

      Monitor

    • B. 

      Keyboard

    • C. 

      CR-R

    • D. 

      Hard disk

  • 43. 
    Which of the following control structures are looping statements? (I) DO…….WHILE (II) FOR…..NEXT (III) IF……THEN
    • A. 

      Only I

    • B. 

      III only

    • C. 

      I and II

    • D. 

      II and III

  • 44. 
    What command clears the screen in MS-DOS and the Windows command line?
    • A. 

      Cd

    • B. 

      Clear

    • C. 

      Cls

    • D. 

      Echo

  • 45. 
    Which year was Microsoft Windows XP released?
    • A. 

      2001

    • B. 

      2004

    • C. 

      2000

    • D. 

      2005

  • 46. 
    The address of the first instruction of the BIOS is called the ______.
    • A. 

      Local address

    • B. 

      Log address

    • C. 

      Jump address

    • D. 

      Warn address

  • 47. 
    CMOS refers to ______.
    • A. 

      Complementary Movement of Semiconductor

    • B. 

      Complementary Meter Oxide Semiconductor

    • C. 

      Complementary Metal Oxide Semiconductor

    • D. 

      Complement Move Of Semiconductor