Database locking concept is used to solve the problem of


Options: Lost Update B. Uncommitted Dependency C. Inconsistent Data D. All of the above

Ans:– D ,


Description: mcqquestions

Asked in: KCC-2018   |   JOA 556-2018  |  HRTC JTO-2017

Hits Today: 11109 | Level: Moderate


******************************************************

Want to see where do you stand among other aspirants in "Computer" category?

Click Here to take quick 10 mins MCQ test to find out.




Got some suggestion about this question or to make this site better? Please leave your comments below.




More Database Systems Related questions:


The section of the CPU that selects, interprets and sees to the execution of program instructions
Options: Memory,    Register unit,    Control unit,    ALU

Ans:C,Control unit


Avalanche photodiode receivers can detect hits of transmitted data by receiving
Options: 100 photons,    200 photons,    300 photons,    400 photons

Ans:B ,B


The Santa Clara Valley, California is popularly known as Silicon Valley of America because
Options: huge deposits of silicon are found there,    many silicon chip manufacturing firms are located there,    Santa Claus visits it every Christmas,    it is full of large grain sand

Ans:B,B


. How to insert Tables in Slide?
Options: a. Insert Table from Insert menu b. Click on Insert Table in content pane of blank slide c. Option A & B d. Tables cannot be inserted in slides

Ans:4 – C ,4 – C


SQL*Plus will finish the statement and execute it when the user types in this:
Options: A left slash ( \ ) followed by [Enter].,    A colon ( : ) followed by [Enter].,    A semicolon ( ; ) followed by [Enter].,    A period ( . ) followed by [Enter].

Ans:C ,C


In a punched card system, data is processed by a
Options: keypunch machine, sorter, and posting machine,    accounting machine, posting machine, and billing machine,    sorter, posting machine, and billing machine,    accounting machine, keypunch machine, and sorter

Ans:D ,D


What is the minimum header size of an IP packet?
Options: 16 bytes B. 10 bytes             C. 20 bytes D. 32 bytes

Ans:– C ,


The transistor has a current gain of 175. If the base current is 0.1 mA, what is the collector current?
Options: 1750 mA,    17.5 mA,    175 mA,    1.75 mA

Ans:B ,B


Credit checking is done in the
Options: order processing system,    quotation system,    order entry system,    any of the above

Ans:C ,C


. Which unit converts computer data into human readable form?
Options: A) Input unit B) Output unit C) ALU D) Control Unit

Ans:B,B


Which of the following file organizations is most efficient for a file with a high degree of file activity?
Options: sequential,    ISAM,    VSAM,    B-Tree index

Ans:A ,A


Which of the following function will return a value of 8?
Options: ROUNDUP(8.4999, 0) B. ROUNDDOWN(8.4999, 0) C. ROUND(8.4999, 0) D. Only B and C

Ans:– D ,


Which of the following is not true about indexes?
Options: Indexes are created to enforce uniqueness on columns.,    Indexes are created to enable fast retrieval by column values.,    Columns that are frequently used with equal conditions in WHERE clauses are good candidates for indexes.,    Indexes are created with the ALTER TABLE command.

Ans:D ,D


The terminal device that functions as a cash register, computer terminal, and OCR reader is the:
Options: Data collection terminal,    OCR register terminal,    Video display terminal,    POS terminal

Ans:D,D


EDP auditing has become popular since
Options: 1980,    1950,    1970,    1975

Ans:C ,C


. What is the use of “Hide Slide” option?
Options: a. to hide the selected slides during Presentation b. to hide the selected slides during Editing c. to hide the selected slides during Printing d. to hide the selected slides during Deleting

Ans:8 – A ,8 – A


. In DOS, the maximum length of filename is
Options: a. 5 b. 8 c. 11 d. 10

Ans:0 – b ,0 – b


How many protons does the nucleus of a silicon atom contain?
Options: 4,    29,    14,    48

Ans:C ,C


The most commonly used standard data code to represent alphabetical, numerical and punctuation characters used in Electronic Data Processing system is called
Options: ASCII,    EBCDII,    BCD,    All of the above

Ans:A ,A


. What does Belady’s Anomaly related to?
Options: a. Page Replacement Algorithm b. Memory Management Algorithm c. Deadlock Prevention Algorithm d. Disk Scheduling Algorithm

Ans:6 – a ,6 – a


What are the requirements for the solution to critical section problem?
Options: Mutual Exclusion B. Progress C. Bounded Waiting D. All of Above

Ans:– D ,


The main function of the dispatcher (the portion of the process scheduler) is
Options: swapping a process to the disk,    assigning ready process to the CPU,    suspending some of the processes when the CPU load is high,    bring processes from the disk to the main memory

Ans:B ,B


. Which of the following shutdown method is often called Warm Boot?
Options: a. Shut Down b. Restart c. Sleep d. Hibernate

Ans:1 – b ,1 – b


Union officials receive the same type of education as
Options: top level managers,    the rank and file employees,    low level managers,    All of the above

Ans:C ,C


The memory which is ultraviolet light erasable and electrically programmable is
Options: ROM,    PROM,    RAM,    EPROM

Ans:D,D


In the third generation of computers:
Options: distributed data processing first became popular,    an operating system was first developed,    high-level procedural languages were first used,    on-line, realtime systems first became popular

Ans:D ,D


Which hole is used to mark the location of the first sector in a soft-sectored disk.
Options: Address,    Location,    Index,    Label

Ans:C ,C


. Which is not utility program?
Options: a. Backup b. Scandisk c. Data recovery d. XCOPY

Ans:8 – d ,8 – d


The 32-bit internet address 10000000 00001010 00000010 00011110 will be written in dotted decimal notation as
Options: 128.10.2.30,    210.20.2.64,    164.100.9.61,    148.20.2.30

Ans:A ,A


Which part of the computer were is used for calculating and comparing?
Options: Disk unit,    Control unit,    ALU,    Modem

Ans:C ,C


Who is considered the 'father' of the minicomputer and one of the founder fathers of the modern computer industry world-wide?
Options: George Tate,    Kenneth H. Olsen,    Seymour Cray,    Basic Pascal

Ans:B ,B


. … are list of commands that appear on the screen
Options: a. GUIS b. Icons c. Menus d. Windows

Ans:6 – c ,6 – c


Which is a unit representing the no bits of discrete.
Options: Baud,    Byte,    Bit,    All of the above

Ans:A,(Aanswer


For connecting modem, a computer must be equipped with a port that conforms to the RS-232 standard of the Electronic Industries Association of America. What do the letters 'RS' stand for?
Options: Recognised standard,    Random sequence,    Recommended standard,    Registered source

Ans:C ,C


Sophisticated report generators can
Options: print row-oriented reports,    perform arithmetic operations,    selectively retrieve and print portions of a list,    All of the above

Ans:D ,D


Software is:
Options: printer output,    a set of instructions,    tape input.,    a programming language

Ans:B ,B


Which of the following statements is true?
Options: Two SCSI devices connected to a computer can have the same ID if they are both hard drives.,    Each SCSI device must have its own ID,    All SCSI devices must have the same ID,    SCSI ID's are irrelevant

Ans:B ,B


Microcomputer-based control sys¬tems
Options: will just keep their present capability,    will have more standard industrial application software available in the future.,    will tend to increase in cost.,    All of the above

Ans:B ,B


What does Ctrl + = key effect?
Options:  A) Superscript, B) Subscript, C) All Caps, D) Shadow,

Ans:-B,-B


. Validation Rule in a field will
Options: a. Checks the value entered when user leaves the field b. Displays the value in specified format when user leaves the field c. Defines the appearance for the text d. There is no option of Validation Rule

Ans:– a,– a


Which of the following statement is correct?
Options: Buffering is the process of temporarily storing the data to allow for small variation in device speeds,    Buffering is a method to reduce cross-talks,    Buffering is a method to reduce the routing overhead,    Buffering is storage of data within the transmitting medium until the receiver is ready to receive

Ans:A ,A


. Gridlines
Options: a. May be turned off for display but turned on for printing b. May be turned on or off for printing c. The be turned off for display and printing d. a, b and c

Ans:– d,– d


. For which of the following computers can’t be used?

Options: A) gathering data B) calculating data C) comparing data D) Arranging data

Ans:A,A


The paperwork that travels with the materials through the production process is called a
Options: shop packet,    weigh bill,    picking ticket,    work order

Ans:A ,A


An example of a management by exception report is a(n)
Options: aged accounts receivable report,    overtime earnings report,    both (a) and (b),    neither (a) nor (b)

Ans:C ,C


Where can you change the vertical alignment?
Options:  A) Formatting toolbar, B) Paragraph dialog box, C) Page Setup dialog box, D) Standard toolbar,

Ans:-C,-C


. Tree structure displays the
Options: a. File only b. Directory only c. File and directory name d. None of above

Ans:2 – c ,2 – c


How do you display current date only in MS Excel?
Options: date () B. Today () C. now () D. time ()

Ans:– B ,


A storage area used to store data to a compensate for the difference in speed at which the different units can handle data is
Options: A) Memory B) Buffer C) Accumulator D) Address

Ans:-B,-B


A structure chart is
Options: a document of what has to be accomplished,    a hierarchical partitioning of the program,    a statement of information processing requirements,    All of the above

Ans:B ,B

www.000webhost.com