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 ,






More Database Systems Related questions:


Quantitative evaluation of new products assures that
Options: the important factors receive management attention,    the factors are weighted according to their relative importance,    both (a) and (b),    neither (a) nor (b)

Ans:C ,C


. The memory which allocates space for DOS and application is called
Options: a. Expanded memory b. Cache memory c. Virtual memory d. Conventional memory

Ans: d,Conventional memory


. The ALU of a computer normally contains a number of high speed storage element called
Options: A) Semiconductor memory B) Registers C) Hard disks D) Magnetic disk

Ans:B,B


A memory space used for the temporary storage of data is
Options: PROM,    SAM,    Scratchpad storage,    Buffer

Ans:C,C


An MIS provides
Options: past information,    present information,    future information,    All of the above

Ans:D ,D


Layer 2 switching provides which of the following? Hardware-based bridging (ASIC) Wire speed Low latency Low cost
Options: 1 and 3,    2 and 4,    1, 2 and 4,    All of the above

Ans:D ,D


An ideal voltage source has
Options: Zero internal resistance,    Infinite internal resistance,    A load dependent voltage,    A load-dependent current

Ans:A ,A


. According to the Leszynski Naming Conventions, which of the following is the prefix for a text box control?
Options: a. txt b. txb c. tbc d. tex

Ans:1 – a ,1 – a


An optical input device that interprets pencil marks on paper media is
Options: O.M.R,    Punch card reader,    Optical scanners,    Magnetic tape

Ans:A,(Aanswer


Which of the following situation requires the use of ID-dependent entities?
Options: Association relationships only,    Multivalued attributes only,    Archetype/instance relationships only,    All of the above use ID dependent entities

Ans:D ,D


Who coordinates the sequencing of events within the central processor of a computer?
Options: Logic unit,    Arithmetic unit,    Register,    Control unit

Ans:D,D


A acronym for the organisation that publishes programming language standard is
Options: ASCn,    BCD,    ANSI,    EBCDIC

Ans:C ,C


In SQL, the _____ command is used to recompile a view
Options: COMPILE VIEW,    DEFINE VIEW,    CREATE VIEW,    ALTER VIEW

Ans:D ,D


. To exit from the Resume Wizard and return to the document window without creating a resume, click the _____ button in any panel in the Resume Wizard dialog box.
Options: a. Cancel b. Back c. Next d. Finish

Ans:– D,– D


In which year were chips used inside the computer for the first time?
Options: 1964,    1975,    1977,    1981

Ans:B ,B


Computer instructions written with the use of English words instead of binary machine code is called
Options: Mnemonics,    Symbolic code,    Gray code,    Op-code

Ans:B ,B


Point out the error in the following program. #include<stdio.h> #include<stdlib.h> int main() { int *a[3]; a = (int*) malloc(sizeof(int)*3); free(a); return 0; }
Options: Error: unable to allocate memory,    Error: We cannot store address of allocated memory in a,    Error: unable to free memory,    No error

Ans:B ,B


What should be first considered in choosing a plotter?
Options: The hardware you currently own,    The application for which it will be used,    The type of data you will input,    The cost

Ans:B ,B


. EBCDIC can code up to how many different characters?
Options: A) 256 B) 16 C) 32 D) 64

Ans:A,A


Your modem does not respond when you try to dial out. You try another modem on another computer and get the same result. What is the most likely problem?
Options: defective modem,    defective computer,    software bug,    bad phone line

Ans:D ,D


Which of the following indicates the maximum number of entities that can be involved in a relationship?
Options: Minimum cardinality,    Maximum cardinality,    ERD,    Greater Entity Count (GEC)

Ans:B ,B


. Which one of the following input device is user-programmable?
Options: A) Dumb terminal B) Smart terminal C) VDT D) Intelligent terminal

Ans:D,D


A _____ is simply an arrangement where multiple disk drives appear as a single disk drive to the user.
Options: disk,    disk array,    bunch of disks,    disk pack

Ans:B,B


Which of the following is not a filter?
Options: cat,    grep,    wc,    sort

Ans:E ,E


The command center of  access file that appears when you create or open the MS Access database file.
Options: a. Database Window b. Query Window c. Design View Window d. Switchboard

Ans:ndash; a,ndash; a


A mechanism for arranging controlled access to a shared resource is
Options: Retrieving,    Sorting,    Balleting,    Lock-out

Ans:D ,D


In which stage the following code #include<stdio.h> gets replaced by the contents of the file stdio.h
Options: During editing,    During linking,    During execution,    During preprocessing

Ans:D ,D


What tool is used to test serial and parallel ports?
Options: high volt probe,    cable scanner,    loop backs (wrap plugs),    sniffer

Ans:C ,C


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


Who has developed the Linux?
Options: Bob Young,    Mark Eving,    Richard Stallman,    Linus Torvalds

Ans:D ,D


. Serial access memories are useful in applications where
Options: A) Data consists of numbers B) Short access time is required C) Each stored word is processed differently D) Data naturally needs to flow in and out in serial form

Ans:2-D,2-D


. Which one is true for unconditional disk formatting?
Options: a. Destroys every byte of data on a disk by overwriting itwith with blank spaces b. Do not check/scan surface after format c. Transfer system files after format d. All of above

Ans: a, a


To reconstruct a system, which of the following key element(s) must be considered :
Options: feedback and environment,    control and processors.,    outputs and inputs,    All of the above

Ans:D ,D


Which command will display the CHAP authentication process as it occurs between two routers in the network?
Options: show chap authentication,    show interface serial 0,    debug ppp authentication,    debug chap authentication

Ans:C ,C


What will be the output of the program ? #include<stdio.h> int main() { enum status {pass, fail, absent}; enum status stud1, stud2, stud3; stud1 = pass; stud2 = absent; stud3 = fail; printf("%d %d %d\n", stud1, stud2, stud3); return 0; }
Options: 0, 1, 2,    1, 2, 3,    0, 2, 1,    1, 3, 2

Ans:C ,C


. We can start the application from?
Options: a. Log off b. Network place c. Recycle bin d. Run

Ans:2 – d ,2 – d


The POST routine, which counts system board RAM first, is stored in:
Options: RAM,    microprocessor,    ROM BIOS,    CMOS

Ans:C ,C


While working with MS-DOS, which command is used to restore files that were backed up using the BACKUP command?
Options: COPY,    DISKCOPY,    RESTORE,    STORE

Ans:C ,C


Which command is used with vi editor to save file and remain in the editing mode?
Options: :q,    :w,    q!,    :x

Ans:B ,B


The PowerPoint view that displays only text (title and bullets) is
Options: a. Slide show b. Slide sorter view c. Notes page view d. Outline view

Ans: – D , – D


. Which unit is known as nerve center of computer?
Options: A) ALU B) CU C) Memory D) Registers

Ans:B,B


Graphic interfaces were first used in a Xerox product called:
Options: InterLISP,    Ethernet,    Smalltalk,    ZetaLISP

Ans:C ,C


What is the general name of the device which produces hardcopy graphics?
Options: COM,    Plotter,    Printer,    Microfilm

Ans:B ,B


Point out the correct statement will let you access the elements of the array using 'p' in the following program? #include<stdio.h> #include<stdlib.h> int main() { int i, j; int(*p)[3]; p = (int(*)[3])malloc(3*sizeof(*p)); return 0; }
Options: for(i=0; i<3; i++) { for(j=0; j<3; j++) printf("%d", p[i+j]); } ,    for(i=0; i<3; i++) printf("%d", p[i]); ,    for(i=0; i<3; i++) { for(j=0; j<3; j++) printf("%d", p[i][j]); } ,    for(j=0; j<3; j++) printf("%d", p[i][j]);

Ans:C ,C


. The box on …. that allows you to choose where to go and is located below the standard toolbar
Options: a. System menu b. Address bar c. Menu bar d. None of these

Ans:7 – b ,7 – b


The ability to combine name and addresses with a standard document is called _________
Options: document formatting B. database management C. mail merge D. form letters

Ans:– C ,


An example of digital, rather than analog, communication is
Options: DDD,    DDS,    WATS,    DDT

Ans:B ,B


. The
Options: A) Analog Computers B) Digital Computers C) Hybrid Computers D) Mainframe Computers

Ans:C,C


. CHKDSK command
Options: a. Check the disk b. Dos command c. Give information about disk d. All of the above

Ans:6 – d ,6 – d


What is the maximum number of IP addresses that can be assigned to hosts on a local subnet that uses the 255.255.255.224 subnet mask?
Options: 14,    15,    16,    30

Ans:D ,D

www.000webhost.com