Oracle Programming (SQL/PlSQL)

47 Questions | Attempts: 110
Share

SettingsSettingsSettings
Oracle Programming (SQL/PlSQL) - Quiz


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

    Correct Answer
    A. AA28
  • 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

    Correct Answer
    B. O8
  • 3. 

    Flowcharts usually begin with symbol?

    • A.

      Annotation

    • B.

      Input/ output

    • C.

      Process

    • D.

      Terminal

    Correct Answer
    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

    Correct Answer
    B. 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

    Correct Answer
    B. FOR…..NEXT
  • 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

    Correct Answer
    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

    Correct Answer
    B. II only
  • 8. 

     How many bits are there in a megabyte?

    • A.

      2^12

    • B.

      2^18

    • C.

      2^20

    • D.

      2^23

    Correct Answer
    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

    Correct Answer
    B. 290 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

    Correct Answer
    A. Convert data from digital to analog and back again
  • 11. 

    What component of a typical computer system has a largest memory capacity?

    • A.

      RAM

    • B.

      ROM

    • C.

      Hard disk

    • D.

      Floppy disk

    Correct Answer
    C. Hard disk
  • 12. 

    The smallest piece of information that can be interpreted by a computer is the

    • A.

      Bit

    • B.

      Byte

    • C.

      Character

    • D.

      Word

    Correct Answer
    A. Bit
  • 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)

    Correct Answer
    C. A OR (A AND B)
  • 14. 

    Which of the following is the a volatile data storage device?

    • A.

      Hard disk

    • B.

      CD-ROM

    • C.

      WORM drive

    • D.

      RAM

    Correct Answer
    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

    Correct Answer
    C. [email protected]
  • 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

    Correct Answer
    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

    Correct Answer
    A. Protocol
  • 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

    Correct Answer
    B. As, joints, similar to the human arm
  • 19. 

    What form does an android takes

    • A.

      An insect

    • B.

      The human body

    • C.

      Simple robot arm

    • D.

      A stereo vision system

    Correct Answer
    B. The human body
  • 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

    Correct Answer
    A. A salesperson who is on the road.
  • 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

    Correct Answer
    C. A display that does not use interlacing
  • 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

    Correct Answer
    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

    Correct Answer
    A. Magnetic tape
  • 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

    Correct Answer
    C. A flash memory module
  • 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.

    Correct Answer
    A. It is easier to read data from the device than 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

    Correct Answer
    D. All of the above
  • 27. 

    What is the decimal binary code 1111?

    • A.

      15

    • B.

      63

    • C.

      31

    • D.

      127

    Correct Answer
    A. 15
  • 28. 

     What is the decimal binary code 1110?

    • A.

      14

    • B.

      15

    • C.

      31

    • D.

      127

    Correct Answer
    A. 14
  • 29. 

    What is the decimal binary code 1000?

    • A.

      9

    • B.

      8

    • C.

      5

    • D.

      1

    Correct Answer
    B. 8
  • 30. 

     A magnetic hard disk is usually part of

    • A.

      Computer

    • B.

      A dc motor

    • C.

      A tape recorder

    • D.

      An electromagnet

    Correct Answer
    A. Computer
  • 31. 

    Which one is not an output device?

    • A.

      Printer

    • B.

      Monitor

    • C.

      Keyboard

    • D.

      Modem

    Correct Answer
    C. Keyboard
  • 32. 

     Which one works as an output and input device?

    • A.

      Modem

    • B.

      Scanner

    • C.

      Mouse

    • D.

      Monitor

    Correct Answer
    A. Modem
  • 33. 

    All computers must have

    • A.

      Word processing software

    • B.

      A printer attached

    • C.

      An operating system

    • D.

      A virus checking program

    Correct Answer
    C. An operating system
  • 34. 

    Software is:

    • A.

      A computer program

    • B.

      A set of instructions

    • C.

      Only in operating system

    • D.

      All of the above

    Correct Answer
    D. All of the above
  • 35. 

    Which hard disk will be able to store more information?

    • A.

      24MB

    • B.

      2400KB

    • C.

      24GigB

    • D.

      240MB

    Correct Answer
    C. 24GigB
  • 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

    Correct Answer
    B. A sound card and speakers
  • 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

    Correct Answer
    A. An Internet connection, an Internet Service Provider and browser software
  • 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

    Correct Answer
    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

    Correct Answer
    C. Storage 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

    Correct Answer
    A. Processing device
  • 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

    Correct Answer
    B. Output 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

    Correct Answer
    A. Monitor
  • 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

    Correct Answer
    C. I and II
  • 44. 

    What command clears the screen in MS-DOS and the Windows command line?

    • A.

      Cd

    • B.

      Clear

    • C.

      Cls

    • D.

      Echo

    Correct Answer
    C. Cls
  • 45. 

    Which year was Microsoft Windows XP released?

    • A.

      2001

    • B.

      2004

    • C.

      2000

    • D.

      2005

    Correct Answer
    C. 2000
  • 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

    Correct Answer
    C. Jump 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

    Correct Answer
    C. Complementary Metal Oxide Semiconductor

Quiz Review Timeline +

Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.

  • Current Version
  • Dec 31, 2012
    Quiz Edited by
    ProProfs Editorial Team
  • Apr 25, 2009
    Quiz Created by
    Gilmon
Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.