What is ACID properties of Transactions?


Options: Atomicity, Consistency, Isolation, Database B. Atomicity, Consistency, Isolation, Durability C. Atomicity, Consistency, Inconsistent, Durability D. Automatically, Concurrency, Isolation, Durability

Ans:– B ,


Description: mcqquestions

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

Hits Today: 5473 | 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:


.Which of the following case does not exist in complexity theory
Options: A)Best case b.Worst case c.Average case d.Null case

Ans:D,D


What is the full form of RAID ?
Options: Redundant Array of Independent Disks B. Redundant Array of Important Disks C. Random Access of Independent Disks D. Random Access of Important Disks

Ans:– A ,


. Ctrl + S
Options: Save Document with different name B. Save Document with same name C. Save Document and Close Word Application D. Save Document and Print whole Pages

Ans:– B ,


Communication circuits that transmit data in both directions but not at the same time are operating in
Options: a simplex mode,    a half-duplex mode,    a full-duplex mode,    an asynchronous mode

Ans:B ,B


You're on your PC at midnight and an electric storm pops up. What's the best way to protect your PC.
Options: you don't worry; you have a lightning rod on your house,    you don't worry; you've got a surge protector on your PC,    you don't worry; you've got a surge protector on your PC and phone line to your modem,    unplug the PC and remove phone line from the modem

Ans:D ,D


As per symbolic notation of DOS, which of the following indicates the ROOT directory
Options: a. * b. >  c. / d. None of the above

Ans:7 d.,7 d.


The first electronic digital computer contained?
Options: Electronic valves,    Vacuum tubes,    Transistors,    Semiconductor memory

Ans:B ,B


A type of core store that has a lower access time than the devices used for working store in the same processor is known as
Options: core memory,    buffer,    fast core,    address register

Ans:C ,C


. To center worksheet titles across a range of cell, you must
Options: a. Select the cells containing the title text and use the fill handle to center the text across a range of cells b. Select the cells containing the title text and click on Center button c. Select the cells in range containing the title text and use the Merge and Center tool d. Widen the column

Ans:– c,– c


. To display system boot menu which of the following command you must press?
Options: a. F4 b. F7 c. F8 d. F5

Ans:7 – c ,7 – c


The procedure for evaluating the relative performance of different computers, is done by the process called
Options: batch processing,    sequential processing,    bench marking,    All of the above

Ans:C ,C


A data structure where elements can be added or removed at either end but not in the middle
Options: a. Linked lists b. Stacks c. Queues d. Deque

Ans:- d,- d


Which number system is usually followed in a typical 32-bit computer?
Options:  2 B.  10      C.  16 D.  32

Ans:– A ,


Which of the following keys is used to move the cursor to the end of the paragraph.
Options: },    {,    |,    $

Ans:A ,A


A relationship between processes such that each has some part (critical section) which must not be executed while the critical section of another is being executed, is known as
Options: semaphore,    mutual exclusion,    multiprogramming,    multitasking

Ans:B ,B


As compared to diskettes, the hard disks are
Options: more expensive,    more portable,    less rigid,    slowly accessed

Ans:A ,A


. Size of the primary memory of a PC ranges between
Options: A) 2KB to 8KB B) 64KB & 256KB C) 256KB & 640KB D) None of these

Ans:C,C


Which of the following is not a relational database?
Options: a . dBase IV b. 4th Dimension c. FoxPro d. Reflex

Ans:.d,.d


. To copy the hidden system files of DOS to another disk you can use the command
Options: a. Copy b. Ren c. Sys d. Diskcopy

Ans:Correct Answer: c ,Correct Answer: c


When a computer is first turned on or restarted, a special type of absolute loader is executed, called a
Options: "Compile and Go" loader,    Boot loader,    Bootstrap loader,    Relating loader

Ans:C ,C


. Which of the following is not the classification of computers based on application?

Options: A) Electronic Computers B) Analog Computers C) Digital Computers D) Hybrid Computers

Ans:A,A


Which of the following types of decision-making would depend heavily on real-time information?
Options: strategic,    tactical,    operational,    nonprogrammable

Ans:C ,C


A memory that holds micro programs is
Options: Core memory,    ROM,    RAM,    Control memory

Ans:B ,B


. Number crunchier is the informal name for
Options: A) Mini computer B) Super computer C) Microcomputer D) Mainframe computer

Ans:b,b


The probability that a single bit will be in error on a typical public telephone line using 4800 bps modem is 10 to the power -3. If no error detection mechanism is used, the residual error rate for a communication line using 9-bit frames is approximately equal to
Options: 0.003,    0.009,    0.991,    0.999

Ans:B ,B


.   After moving a clip art image to a particular location on the slide, you can immediately reverse the action using the
Options: a. Click the not do move object command on the edit menu b. Click on the undo button c. Click on redo button d. All of above

Ans:9 – B ,9 – B


Part of a program where the shared memory is accessed and which should be executed invisibly, is called
Options: semaphores,    directory,    critical section,    mutual exclusion

Ans:C ,C


Cursor is a ____
Options: Pixel B. Thin blinking line C. Pointing device D. None of these

Ans:– B ,


Which type of system puts the user into direct conversation with the computer through a keyboard?
Options: Real time processing,    Interactive computer,    Batch processing,    Time sharing

Ans:B ,B


Database management systems are intended to 
Options: a. eliminate data redundancy b. establish relationship among records in different files c. manage file access D. all of the above 

Ans:D,All of above


. How to split a table in Word 2010?
Options: Tables group on the Insert ribbon and click the Split Table button B. Split group on the Layout ribbon and click the Split Table button C. Merge group on the Layout ribbon and click the Split Table button D. Split group on the Table ribbon and click the Split Table button

Ans:– C ,


Which protocol does DHCP use at the Transport layer?
Options: IP,    TCP,    UDP,    ARP

Ans:C ,C


. Which part of the computer is used for calculating and comparing?
Options: A) Disk unit B) Control unit C) ALU D) Modem

Ans:C,C


  To select more than one slide in the presentation A.  Just Click on slide B.  Ctrl + Click on slide C.  Alt + Click on slide D.  Shift + Click on slide
Options:

Ans:– B ,


ESD potential decreases with the use of:
Options: De-ionizing fans,    A wrist strap,    Rubber gloves with matching cap,    A static meter

Ans:B ,B


In SQL, which command(s) is(are) used to redefine an index's future storage allocation
Options: ALTER INDEX,    REDEFINE INDEX,    MODIFY INDEX,    DO INDEX

Ans:A ,A


The program execution time:
Options: must be slower than the fastest mechanical operation that is to be controlled,    will vary depending on the language used,    cannot be changed once the program is written,    All of the above

Ans:B ,B


ICMP (Internet Control Message Protocol) is
Options: a TCP/IP protocol used to dynamically bind a high level IP Address to a low-level physical hardware address,    a TCP/IP high level protocol for transferring files from one machine to another,    a protocol used to monitor computers,    a protocol that handles error and control messages

Ans:D ,D


Which tab is not available on left panel when you open a presentation?
Options: a. Outline b. Slides c. Notes d. All of above are available

Ans:– C ,– C


The Memory Address Register
Options: is a hardware memory device which denotes the location of the current instruction being executed.,    is a group of electrical circuits (hardware), that performs the intent of instructions fetched from memory.,    contains the address of the memory location that is to be read from or stored into.,    contains a copy of the designated memory location specified by the MAR after a "read" or the new contents of the memory prior to a "write".

Ans:C ,C


. Which of the following is the largest unit?
Options: A) data B) field C) record D) database file

Ans:4-D,4-D


The person communicating with the manager to identify information needs is the
Options: executive vice-president,    vice- president of information system,    programmer,    system analyst

Ans:D ,D


What is the shortcut key to “Undo ” the last action in a document?
Options: Ctrl + X B. Ctrl + Y      C. Ctrl + Z D. None of above

Ans:– C ,


Which is a basic technique, using activity networks.
Options: CPA,    VLSI,    GIGO,    MSI

Ans:A ,A


What command is used to hand up a MODEM when using the "AT Answer Command set"?
Options: ATZ,    ATD,    ATR,    ATH

Ans:D ,D


The system/370 assembler language
Options: allows the programmer to write base registers and displacements explicitly in the source program.,    is used to remember which of the general-purpose registers are currently available as base registers, and what base addresses they contain.,    allows multiple programs to reside in separate areas of core at the same time.,    is a term that refers to the control programs of an operating system.

Ans:A ,A


. A zip is a program used to
Options: a. Speed up the computer memory b. Speed up the disk access c. Compress files d. All of above

Ans:7 – c ,7 – c


A Processor
Options: is a device that performs a sequence of operations specified by instructions in memory.,    is the device where information is stored,    is a sequence of instructions,    is typically characterized by interactive processing and time of the CPU's time to allow quick response to each user.

Ans:A ,A


Which option on the custom animation task pane allows you to apply a preset or custom motion path?
Options: a. Add effect b. Emphasis c. Animate now d. All of the above

Ans: – A , – A


In an Entity-Relationship Diagram “Ellipses” represents
Options: Attributes B. Weak entity set C. Relationship sets D. Multi-valued attributes

Ans:– A ,

www.000webhost.com