A table that displays data redundancies yields ____________ anomalies


Options: Insertion B. Deletion C. Update D. All of the above

Ans:– D ,


Description: mcqquestions

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

Hits Today: 5962 | 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 format you can decide to apply or not in AutoFormat dialog box?
Options: a. Number format b. Border format c. Font format d. All of above

Ans:– d,– d


. Who invented the microprocessor?
Options: A) Marcian E Huff B) Herman H Goldstein C) Joseph Jacquard D) All of above

Ans:A,A


Which of the following registers is loaded with the contents of the memory location pointed by the PC?
Options: Memory Address Register,    Memory Data Register,    Instruction Register,    Program Counter

Ans:C ,C


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 use of Notes in slides?
Options: It will be displays at the time of Slide Presentation B. This is just Note about the slide       C. This is just for printing purpose only D. Notes cannot be inserted in Slides

Ans:– B ,


Absolute Zero temperature equals
Options: 0o C,    -273o C,    -276o C,    25o C

Ans:B ,B


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


Which of the following is not true about documentation?
Options: Documentation, of a system, should be as clear and direct as possible,    Documentation increases the maintenance time and cost,    Documentation gives better understanding of the problem,    All of the above

Ans:B ,B


A network schema
Options: restricts the structure to a one-to-many relationship,    permits many-to-many relation¬ships,    stores data in tables,    All of the above

Ans:B ,B


The _____ layer is the layer closest to the transmission medium.
Options: transport,    network,    data link,    physical

Ans:D ,D


The memory sizes in mainframe computers and advanced technology micro computers are expressed as
Options: Bytes,    Kilo-bytes,    Bits,    Megabytes

Ans:D ,D


Today, programmable controllers:
Options: are more powerful then the first controllers on the market,    are relatively low cost compared with the original digital equipment available for industrial control,    can be cost effective even when replacing just a few relays,    All of the above

Ans:D ,D


Which of the following terms refers to the degree to which data in a database system are accurate and correct?
Options: data security,    data validity,    data independence,    data integrity

Ans:D ,D


. A Compiler is ____
Options: A) a combination of computer hardware B) a program which translates from one high-level language to another C) a program which translates from one high-level to a machine level language D) None of these

Ans:0-C,0-C


In which of the following areas may ICAI programs prove to be useful?
Options: educational institutions,    corporations,    department of Defence,    All of the above

Ans:D ,D


When data is encapsulated, which is the correct order?
Options: Data, frame, packet, segment, bit,    Segment, data, packet, frame, bit,    Data, segment, packet, frame, bit,    Data, segment, frame, packet, bit

Ans:C ,C


Which command is used to delete the directory that is empty?
Options: a. Del *.* b. RD c. Erase d. MD

Ans:Answer: b. RD,Answer: b. RD


The _____ is a short horizontal line indicating the conclusion of a document.
Options: a. insertion point b. end mark c. status indicator d. scroll box

Ans:– B,– B


An example of a medium-speed, switched communications service is
Options: Series 1000,    Dataphone 50,    DDD,    All of the above

Ans:C ,C


While working with MS-DOS, which command is used to restore only those files modified since the last backup, from the drive A to the currently logged drive or directory?
Options: RESTORE A: *.*/S,    RESTORE A: *.*/M,    RESTORE A: *.*/N,    RESTORE A: *.*/L

Ans:B ,B


Which of the following database activities determines the entities, attributes, and relationships of data?
Options: Conceptual data modeling,    Logical database design,    Physical database design and definition,    Database implementation

Ans:A ,A


    In MS-Dos 6.22, which part identifies the product uniquely  
Options: a.    MS b.    DOS c.    Ms-DOS d.    6.22

Ans:.b,Correct Answer: d. 6.22


. What is the quickest way to select entire worksheet?
Options: Choose Edit -> Select all from the Menu B. Click on the first column, press Ctrl, and then click on the last column C. Click on the first column, press Shift, and then click on the last column D. Click on the rectangle box on the upper left corner where column headings and row headings meet

Ans:– D ,


Which of the following is used to check for errors in RAM chips?
Options: ROM chip,    Microprocessor chip,    Parity chip,    EPROM chip

Ans:C ,C


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


You are working with a network that has the network ID 192.168.10.0. What subnet should you use that supports up to 25 hosts and a maximum number of subnets?
Options: 255.255.255.192,    255.255.255.224,    255.255.255.240,    255.255.255.248

Ans:B ,B


91. What is the shortcut key you can press to create a copyright symbol?
Options: a. Alt+Ctrl+C b. Alt + C c. Ctrl + C d. Ctrl + Shift + C

Ans:– A ,– A


While working with MS-DOS, which command is used to sort the file in ascending order?
Options: SORT filename,    SORT < filename,    SORT > filename,    SORT | filename

Ans:B ,B


1 nibble equals to
Options: A. 1 bits B. 2 bits C. 4 bits D. 8 bits

Ans:C,


Personal computers use a number of chips mounted on a main circuit board. What is the common name for such boards?
Options: Daughterboard,    Motherboard,    Fatherboard,    Breadboard

Ans:B,B


. Which report section prints once at the bottom of every printed page?
Options: a. Detail b. Page Header c. Page Footer d. Report Header

Ans:5 – c ,5 – c


To organize files on a disk, MS-DOS separates them into areas called _____
Options: directories,    buckets,    areas,    area directories

Ans:A ,A


Which of the following is a machine language instruction?
Options: ADD 5,    10001101,    GOTO XOUT,    All of the above

Ans:B ,B


. Which of the following setup options can not be set in the page setup dialog box?
Options: a. Printer selection b. Vertical or horizontal placement c. Orientation d. Row and column titles

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


The minimum number of MOS transistors required to make a dynamic RAM cell is
Options: 1,    2,    3,    4

Ans:A ,A


Which menu do you choose to shade words and paragraph?
Options: format, borders and shading, insert, borders and shading, view, shading,none of the above

Ans:D ,


Which is built directly on the hardware?
Options: Computer Environment B. Application Software C. Operating System D. Database System

Ans:– C ,


Queries to a database
Options: are written in English,    can use aggregate functions like SUM and COUNT,    both (a) and (b),    All of the above

Ans:B ,B


A loader is
Options: a program that places programs into memory and prepares them for execution,    a program that automate the translation of assembly language into machine language,    is a program that appears to execute a source program as if it were machine language,    program that accepts a program written in a high level language and produces an object program

Ans:A ,A


A microprocessor is:
Options: controlled by a program,    an integrated circuit,    relatively inexpensive,    All of the above

Ans:D ,D


Daisy chain is a device for
Options: connecting a number of controllers to a device,    connecting a number of devices to a controller,    interconnecting a number of devices to a number of controllers,    all of the above

Ans:B ,B


What is the purpose of fflush() function.
Options: flushes all streams and specified streams.,    flushes only specified stream.,    flushes input/output buffer.,    flushes file buffer.

Ans:A ,A


The keyword "inverse" is used in which of the following?
Options: Class,    Attribute,    Relationship,    All of the above.

Ans:C ,C


In a document what is the maximum number of columns that can be inserted in MS Word Table?
Options:  A) 35, B) 15, C) 63, D) 65, 

Ans:-C,-C


What will be the output of the program? #include<stdio.h> int main() { const char *s = ""; char str[] = "Hello"; s = str; while(*s) printf("%c", *s++); return 0; }
Options: Error,    H,    Hello,    Hel

Ans:C ,C


What does Router do in a network?
Options: Forwards a packet to all outgoing links B. Forwards a packet to the next free outgoing link C. Determines on which outing link a packet is to be forwarded D. Forwards a packet to all outgoing links except the originated link

Ans:– C ,


. When a row of data is to be converted into columns
Options: a.  Copy the cells in row, select the same number of cells in row and paste b.  Copy the cells in column then choose Edit >> Paste Special, then click Transpose and OK c.  Copy the cells then go to Format >> Cells then on Alignment tab click Transpose check box and click OK d.  Select the cells then place the cell pointer on new cell and choose Edit >> Paste Special, mark Transpose check box and click OK.

Ans:– d,– d


To sort the results of a query use:
Options: SORT BY.,    GROUP BY.,    ORDER BY.,    None of the above is correct.

Ans:C ,C


If you see a diskette with a piece of foil covering its notch, it is said to be
Options: write-protected,    copy-protected,    write-enabled,    foil-covered

Ans:A ,A

www.000webhost.com