. A transaction completes its execution is said to be


Options: Saved B. Loaded C. Rolled D. Committed

Ans: – D ,


Description: mcqquestions

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

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


Networks that follow the 802.5 standard appear to be in a star topology but are actually operating in what type of topology?
Options: Linear bus,    Modified star,    Modified ring,    Ring

Ans:D ,D


. What is the result of ‘Select * from customer where CustID>10 and CustID<100’ query?
Options: a. display all customers with CustID from 10 to 100 b. display all customers with CustID above 10 c. display all customers with CustID below 100 d. display all customers with CustID from 11 to 99

Ans:– d,– d


The command used to compare the files is known as
Options: comp,    cmp,    do,    ccp

Ans:B ,B


. Press _____ to create a line break, which advances the insertion point to the beginning of the next physical line – ignoring any paragraph formatting instructions.
Options: a. shift+enter b. ctrl+enter c. shift+tab d. ctrl+tab

Ans:– a,– a


Which of the following provides a means of printing out feature notes with a miniature slide on a printed page?
Options: a. Slide with animation b. Outline view c. Notes page d. Audience handout

Ans: – D , – D


What will be the output of the program given below in 16-bit platform ? #include<stdio.h> int main() { enum value{VAL1=0, VAL2, VAL3, VAL4, VAL5} var; printf("%d\n", sizeof(var)); return 0; }
Options: 1,    2,    4,    10

Ans:B ,B


. Which of the following is correct regarding the Background of slides
Options: a. Background color of slides can be change b. Picture can be set as Slide Background c. Texture can be set as Slide Background d. All of the Above

Ans:1 – D ,1 – D


When not in use, it is very important to keep 5 VA diskettes in _____.
Options: Their protective sleeves,    In a plastic bag,    On a shelf in an upright position,    In the floppy drive

Ans:A ,A


System generation:
Options: is always quite simple,    is always very difficult,    varies in difficulty between systems,    requires extensive tools to be understandable

Ans:C ,C


Detailed project control answers the questions
Options: when and how much?,    who and why?,    when and where?,    who and when?

Ans:D ,D


We have Market Basket data for 1,000 rental transactions at a Video Store. There are four videos for rent -- Video A, Video B, Video C and Video D. The probability that Video D will be rented given that Video C has been rented is known as ________ .
Options: the basic probability,    support,    lift,    confidence

Ans:D ,D


Demodulation is a process of
Options: converting analog to digital signals,    converting digital to analog signals,    multiplexing various signals into one high speed line signals,    performing data description.

Ans:A ,A


Which gate sends on a pulse when it receives one at either or both of its terminals.
Options: NOR,    NOT,    OR,    NAND

Ans:C ,C


A supertype/subtype hierarchy has which of the following features?
Options: Subtypes at the lower lever in the hierarchy inherit attributes only from their immediate supertype.,    Attributes are assigned at the highest logical level.,    Subtypes at the higher lever in the hierarchy inherit attributes only from their immediate subtype.,    Attributes are assigned at the lowest logical level.

Ans:B ,B


The steady-state error is:
Options: independent of the type of input,    a function of the transient response,    zero for all inputs to type 1 systems,    decreased by increasing gain.

Ans:D ,D


Which of the following SQL statements are helpful in database redesign?
Options: Correlated subqueries only,    EXISTS/NOT EXISTS expressions only,    Both of the above are helpful,    None of the above are helpful.

Ans:C ,C


Which of the following commands sets a trunk port on a 2960 switch?
Options: trunk on,    trunk all,    switchport trunk on,    switchport mode trunk

Ans:D ,D


. Which function can not be used for calculated controls in a report?
Options: a. SUM b. AVG c. MPT d. COUNT

Ans:– c,– c


When operating above its resonant frequency, a series RLC circuit has the characteristics of a:
Options: series RL circuit,    series RC circuit,    series RLC circuit operated below its resonant frequency,    purely resistive circuit

Ans:A ,A


This data type allows alphanumeric characters and special symbols.
Options: a. text b. memo c. auto number d. None of the above

Ans:dash; a,dash; a


Information systems with common hardware, software, and network standards that provide easy access for end users and their networked computer systems. Select the best fit for answer:
Options: TCP/IP,    Protocol,    Open Systems,    Internetwork processor

Ans:C ,C


Tab scrolling button
Options: a. Allow you to view a different worksheet b. Allow you to view additional worksheet rows down c. Allow you to view additional worksheet columns to the right d. Allow you to view additional sheets tabs

Ans:#8211; d,#8211; d


The terms "red book", "yellow book", and "orange book" refer to:
Options: SCSI,    ide,    floppy drive technology,    CD-ROM standards

Ans:D ,D


MSD exe does not have information on:
Options: cache,    video,    operation system,    com ports

Ans:A ,A


. The most open source DBMS.
Options: a. Microsoft SQL Server b. Microsoft Access c. MySQL d. Oracle

Ans:9 – c ,9 – c


IGRP uses which of the following as default parameters for finding the best path to a remote network? Hop count MTU Cumulative interface delay STP Path bandwidth value
Options: 1 and 3,    3 and 5,    2, 3 and 5,    All of the above

Ans:B ,B


A double sided magnetic disk pack has six disks. Can you tell how many surfaces of this pack are normally used?
Options: 10,    12,    6,    9

Ans:A ,A


GNOME is based on
Options: CORBA toolkit,    COM/DCOM toolkit,    ORE toolkit,    OLE DB toolkit

Ans:A ,A


The Register - to - Register (RR) instructions
Options: have both their operands in the main store.,    which perform an operation on a register operand and an operand which is located in the main store, generally leaving the result in the register, except in the case of store operation when it is also written into the specified storage location.,    which perform indicated operations on two fast registers of the machine and leave the result in one of the registers.,    all of the above

Ans:C ,C


.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


In Computer terminology ‘CAD’ is stands for
Options: A. Computer And Design B. Computer Algorithm in Design C. Computer Aided Design D. None of the above

Ans:C,


Normalization ________ data duplication.
Options: eliminates,    reduces,    increases,    maximizes

Ans:A ,A


A program that converts a high-level language program to a set of instructions that can run on a computer is called a
Options: Compiler,    Debugger,    Editor,    All of the above

Ans:A ,A


Which of the following technique is used for encapsulation?
Options: a technique used in best-effort delivery systems to avoid endlessly looping packets.,    a technique used by protocols in which a lower level protocol accepts a message from a higher level protocol and places it in the data portion of the low level frame.,    One of the pieces that results when an IP gateway divides an IP datagram into smaller pieces for transmission across a network that cannot handle the original datagram size,    All of the above

Ans:B ,B


What will be the output of the program? #include<stdio.h> int main() { typedef float f; static f *fptr; float fval = 90; fptr = &fval; printf("%f\n", *fptr); return 0; }
Options: 9,    0,    90.000000,    90

Ans:C ,C


The signal to noise ratio for a voice grade line is 30.1 dB (decibels) or a power ratio of 1023:1. The maximum achievable data rate on this line whose spectrum ranges from 300 Hz to 4300 Hz is
Options: 6200 bps,    9600 bps,    34000 bps,    31000 bps

Ans:D ,D


. A floppy disk contains

Options: A) Circular tracks only B) Sectors only C) Both circular tracks and sectors D) None of the above

Ans:C,C


Press _____ to create a line break, which advances the insertion point to the beginning of the next physical line – ignoring any paragraph formatting instructions.
Options: a. shift+enter b. ctrl+enter c. shift+tab d. ctrl+tab

Ans:– a,– a


The term gigabyte refers to
Options: 1024 bytes,    1024 kilobytes,    1024 megabytes,    1024 gigabytes

Ans:C ,C


What will be the output of the program (sample.c) given below if it is executed from the command line? cmd> sample Jan Feb Mar /* sample.c */ #include<stdio.h> #include<dos.h> int main(int arc, char *arv[]) { int i; for(i=1; i<_argc; i++) printf("%s ", _argv[i]); return 0; }
Options: No output,    sample Jan Feb Mar,    Jan Feb Mar,    Error

Ans:C ,C


. Which of the following option is not available in Paste Special dialog box?
Options: a.  Add b.  Subtract c.  Divide d.  SQRT

Ans:– d,– d


. Who invented EDSAC?
Options: A) John v. Neumann B) J.p. Eckert and John Mauchley C) Maurice Wilkes D) Howard Aiken

Ans:C,C


. What is a portion of a document in which you set certain page formatting options?
Options: a. Page b. Document c. Section d. Page Setup

Ans:– C,– C


Which best describes a fragmented hard drive:
Options: The platters are bad,    Data files are corrupted,    Clusters of data are damaged,    Files are not stored in consecutive clusters

Ans:D ,D


Virtual Memory is A)  Extremely Large Main memory B)  Extremely Large Secondary memory C)  An illusion of extremely large main memory D)  An illusion of extremely large secondary memory
Options:

Ans:– C ,


Which of the following is not a characteristic of a daisy chaining priority control scheme?
Options: priority is programmable,    it is relatively easy to add more devices to the chain,    the failure of one device may affect other devices on the chain,    the number of control lines is independent of the number of devices on the chain

Ans:A ,A


The "Turing Machine" showed that you could use a/an _____ system to program any algorithmic task.
Options: binary,    electro-chemical,    recursive,    semantic

Ans:A ,A


Filename extensions help identify certain files. What filename extension identifies command files?
Options: COM,    BAT,    EXE,    SYS

Ans:A ,A


Which of the following does not affect the resolution of a video display image?
Options: bandwidth,    raster scan rate,    vertical and horizontal lines of resolution,    screen size

Ans:D ,D


. To select more than one slide in the presentation
Options: a. Just Click on slide b. Ctrl + Click on slide c. Alt + Click on slide d. Shift + Click on slide

Ans:2 – B ,2 – B

www.000webhost.com