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






More Database Systems Related questions:


Where are EIGRP successor routes stored?
Options: In the routing table only,    In the neighbor table only,    In the topology table only,    In the routing table and the topology table

Ans:D ,D


Which of the following is not a disadvantage of wireless LAN?
Options: Slower data transmission,    higher error rate,    interference of transmissions from different computers,    All of the above

Ans:D ,D


The contents of information are stored in
Options: Memory data register B. Memory address register C. Memory arithmetic registers D. Memory access register

Ans:– A ,


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

Ans:A,A


What will function gcvt() do?
Options: Convert vector to integer value,    Convert floating-point number to a string,    Convert 2D array in to 1D array.,    Covert multi Dimensional array to 1D array

Ans:B ,B


.   To import text from a word document that uses headings into a PowerPoint presentation:
Options: a. This cannot be done in PowerPoint b. Click Insert, Slides from Outline c. Click Import, Word Document Headings d. Click File, New, Presentation from Word Headings

Ans:2 – B ,2 – B


. Personnel who design, program, operates and maintains computer equipment refers to
Options: A) Console-operator B) Programmer C) Peopleware D) System Analyst

Ans:C,C


The records in a file on magnetic tape
Options: can only be accessed serially,    are meant for backup,    cannot be transformed to a disk file,    have to be arranged in a key sequence

Ans:A ,A


. What is the symbol for dividing?
Options: a. A ./ b. % c. & d. #

Ans:– a,– a


Structured design produces computer programs that are
Options: easily,    maintained,    easily understood,    both (a) and (b)

Ans:D ,D


The first step to the system study project is to
Options: define system performance criteria,    describe information needs,    staff for the study project,    announce the study project

Ans:D ,D


Access time is the highest in the case of
Options: floppy disk,    cache,    swapping devices,    magnetic disk

Ans:D ,D


. The Width of a processor’s data path is measured in bits. Which of the following are common data paths?
Options: A) 8 bits B) 12 bits C) 16 bits D) 32 bits

Ans:A,A


Unix Operating System is an A)  Multi User Operating System B)  Time Sharing Operating System C)  Multi Tasking Operating System D)  All the Above
Options:

Ans:– D ,


A step-up transformer has a turns ratio of 1:4. If the line voltage is 115 V rms, what is the peak secondary voltage?
Options: 700 V,    707 V,    651 V,    208 V

Ans:C ,C


. Long text can be broken down into many lines within a cell. You can do this through
Options: a.  Wrap Text in Format >> Cells b.  Justify in Edit >> Cells c.  Text Wraping in Format >> Cells, Layout tab d.  All of above

Ans:– a,– a


Which of the following is the allocation method of a disk space?
Options: Contiguous allocation B. Linked allocation C. Indexed allocation D. All of the Above

Ans:– D ,


Virtual Memory
Options: is a method of memory allocation by which the program is subdivided into equal portions, or pages and core is subdivided into equal portions or blocks.,    consists of those addresses that may be generated by a processor during execution of a computation.,    is a method of allocating processor time.,    allows multiple programs to reside in separate areas of core at the time.

Ans:B ,B


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


When using ODBC, which of the following serves as an intermediary between the application and the DBMS drivers?
Options: Data source,    Driver,    Driver manager,    OLE DB

Ans:C ,C


What frequency range is used for TV transmission and low power microwave applications?
Options: Very Low Frequency : 3 kHz to 30 kHz,    Medium Frequency : 300 kHz to 3 MHz,    Ultra High Frequency : 300 MHz to 3000 MHz,    Super High Frequency : 3000 MHz to 30000 MHz

Ans:C ,C


RAM is used as a short memory because it is
Options: Volatile,    Has small capacity,    Is very expensive,    Is programmable

Ans:A ,A


A functional dependency between two or more non-key attributes is called
Options: Transitive dependency B. Partial transitive dependency C. Functional dependency D. Partial functional dependency

Ans:– A ,


If a piece of data is stored in two places in the database, then
Options: storage space is wasted,    changing the data is one spot will cause data inconsistency,    it can be more easily accessed,    both (a) and (b)

Ans:D ,D


Which technique enables the designer to mold and shape, rather than construct on object using a series of lines?
Options: Solid modeling,    Wire-frame modeling,    Surface modeling,    FEM (Finite Element Modeling)

Ans:A ,A


Which of the following is an example of a standard IP access list?
Options: access-list 110 permit host 1.1.1.1,    access-list 1 deny 172.16.10.1 0.0.0.0,    access-list 1 permit 172.16.10.1 255.255.0.0,    access-list standard 1.1.1.1

Ans:B ,B


In a computer _____ is capable to store single binary bit.
Options: Capacitor B. Flip flop C. Register D. Inductor

Ans:– B ,


The difference between linear array and a record is
Options: a. An array is suitable for homogeneous data but hte data items in a record may have different data type b. In a record, there may not be a natural ordering in opposed to linear array. c. A record form a hierarchical structure but a lienear array does not d. All of above  

Ans:d,d


A step-down transformer has turns ration of 5:1. If the primary voltage is 120 Vrms, what is the secondary voltage?
Options: 12 V,    18 V,    24 V,    30 V

Ans:C ,C


Ctrl + W
Options: a. Save and Print the Document b. Save and Close Word Application c. Save and Close document d. Without Save, Close Document

Ans:–  C,–  C


A method for representing digital data analog signals by changing the phase of the analog carrier to represent the digital information is known as
Options: PIA,    PSK,    PM,    PM

Ans:B ,B


How many columns can you insert in a word document in maximum?
Options:  A) 35, B) 45, C) 55, D) 65,

Ans:-B,-B


Which of the following commands is used to obtain a list of all files by modification time?
Options: ls -1,    ls -t,    ls -i,    ls -R

Ans:B ,B


The terminal device that functions as a cash register, computer terminal, and OCR reader is the:
Options: A) Data collection terminal B) OCR register terminal C) Video Display terminal D) POS terminal

Ans:-D,-D


Upper Memory blocks are located where?
Options: Conventional Memory,    Extended Memory,    Expanded memory,    Reserved Memory

Ans:D ,D


LISP was developed by
Options: John Mc Carthy,    Blaise Pascal,    Dr. Hollerith,    John Napier

Ans:A ,A


Conversion of an octal number 208 to its binary number is
Options: 100002,    101112,    101102,    111102

Ans:A ,A


A _____ is software that is designed for drawing diagrams of information systems, writing process specifications, and maintaining data dictionaries.
Options: System Development Life Cycle,    CASE tool,    Phased Conversion,    Success factors

Ans:B ,B


Which table is a permanent database that has an entry for each terminal symbol.
Options: Terminal table,    Literal table,    Identifier table,    Reductions

Ans:A ,A


Which output device is used for translating information from a computer into pictorial form on paper.
Options: Mouse,    Plotter,    Touch panel,    Card punch

Ans:B ,B


In a report, you need to show the monthly rainfall in Nepal. The best way to do this is to insert a
Options: calendar B. photograph of rainfall C. chart showing rainfall amounts D. database of rainfall

Ans:– C ,


A part located in the central processing unit that stores data & information is known as
Options: Core memory,    PROM,    EPROM,    ROM

Ans:A ,A


17. What is the smallest width of a column?
Options: a. 0″ b. 0.5″ c. 1″ d. 1.5″

Ans:– B ,– B


A basic S-R flip-flop can be constructed by cross-coupling which basic logic gates?
Options: AND or OR gates,    XOR or XNOR gates,    NOR or NAND gates,    AND or NOR gates

Ans:C ,C


Which is a device that changes information into digital form?
Options: Modem,    Digitizer,    Mouse,    Light pen

Ans:B,(Banswer


. Give me an example of a cell address.
Options: a. 11 25 b. 911 c. 41A d. A21

Ans:– d,– d


If I create ‘Student’ field in ‘Fees’ table to store ‘student_id’ of ‘Students’ table, then this ‘Student’ field in ‘Fees’ table is called:
Options: a. Foreign key b. Native key c. Composite key d. Primary key

Ans:ndash; a,ndash; a


. Which function will you use to enter current time in a woksheet cell?
Options: a. =today() b. =now() c. =time() d. =currentTime()

Ans:– b,– b


. We can restore the deleted files and folders from
Options: a. Recycle bin b. My document c. Control panel d. All of the above

Ans:2 – a ,2 – a


In which of the following is a single-entity instance of one type related to many entity instances of another type?
Options: One-to-One Relationship,    One-to-Many Relationship,    Many-to-Many Relationship,    Composite Relationship

Ans:B ,B

www.000webhost.com