which of the following is not an Aggregate function?


Options: Min B. Max C. Select D. Avg

Ans:– C ,


Description: mcqquestions

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

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


A _____ is a program that serves as an interface between application program and a set of coordinated and integrated files called a database.
Options: DDS,    DBMS,    MIS,    Control

Ans:B ,B


The terminal device that functions as a cash register, computer terminal, and OCR reader is the:
Options: Data collection terminal,    OCR register terminal,    Video display terminal,    POS terminal

Ans:D,D


Which command is used to send the contents of file named REPORT/TXT to the standard printing device?
Options: TYPE REPORT.TXT TO PRINTER,    TYPE REPORT.TXT > PRN,    TYPE REPORT.TXT | PRN,    TYPE REPORT.TXT | PRINTER

Ans:B ,B


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

Ans:B,(Banswer


Which of the following file retrieval methods use hypermedia?
Options: HTTP,    WAIS,    Veronica,    Archie

Ans:A ,A


How many bits are used in the address bus?
Options: 7,    8,    9,    16

Ans:D ,D


. Which of the following is first generation computer?
Options: A) EDSAC B) IBM 1401 C) CDC 1604 D) ICL 2950

Ans:0-A,0-A


. Press the enter key in all of the following circumstances except _____.
Options: a. to insert a blank line into a document b. when the insertion point reaches the right margin c. to begin a new paragraph d. in response to certain Word commands

Ans: – B , – B


The process of communicating with a file from a terminal is
Options: Interactive,    Interrogation,    Heuristic,    All of the above

Ans:B,(Banswer


Which of the following is a function of the process step of data processing?
Options: protect,    index,    retrieval,    update

Ans:C ,C


What is the abbreviation used for a software package that permits the users to create, retrieve and maintain records in a database?
Options: DASD,    FMS,    EMMS,    DBMS

Ans:D ,D


. When was the transistors invented?

Options: A) 1948 B) 1938 C) 1958 D) 1968

Ans:A,A


Which command is used to display all the lines with the string 'sales' from the file empl.lst?
Options: cut sales empl.lst,    /sales > empl.lst,    grep sales empl.lst,    cat | /sales > empl.lst

Ans:C ,C


Which type of computers uses the 8-bit code called EBCDIC?
Options: A) Minicomputers B) Microcomputers C) Mainframe computers D) Super computer

Ans:-C,-C


A half byte is know is
Options: Data,    Bit,    Half byte,    Nibble

Ans:D ,D


. An Excel Workbook is a collection of …….
Options: a. Workbooks b. Worksheets c. Charts d. Worksheets and Charts

Ans:– d,– d


What will be the output of the program? #include<stdio.h> int main() { char far *near *ptr1; char far *far *ptr2; char far *huge *ptr3; printf("%d, %d, %d\n", sizeof(ptr1), sizeof(ptr2), sizeof(ptr3)); return 0; }
Options: 4, 4, 8,    4, 4, 4,    2, 4, 4,    2, 4, 8

Ans:C ,C


This option allows you to build a new table by entering data directly into the datasheet.
Options: a. datasheet view b. design view c. link table d. None of the above

Ans:ndash; a,ndash; a


The first cell in EXCEL worksheet is labeled as
Options: AA B. A1 C. Aa D. A0

Ans:– B ,


Concurrency control is important for which of the following reasons?
Options: To ensure data integrity when updates occur to the database in a multiuser environment,    To ensure data integrity when updates occur to the database in a single-user environment,    To ensure data integrity while reading data occurs to the database in a multiuser environment,    To ensure data integrity while reading data occurs to the database in a single-user environment

Ans:A ,A


Cost-Benefit analysis
Options: evaluates the tangible and non-tangible factors,    compares the cost, with the benefits, of introducing a computer-based system,    estimates the hardware and software costs,    All of the above

Ans:D ,D


Which of the following instruction steps, would be written within the diamond-shaped box, of a flowchart?
Options: S = B - C,    IS A<10,    PRINT A,    DATA X,4Z

Ans:B ,B


PowerPoint Application allows you to produce
Options: Animated Presentations B. Paper Printouts of Slides C. Notes for the Speaker D. All of the above.

Ans:– D ,


Which of the following abilities is/are required for both the system programmer and the EDP auditor?
Options: knowledge in computer science,    knowledge in accounting applications,    two of the above,    knowledge in information systems

Ans:A ,A


Which of the following is not the part of standard office suite?
Options:  A) Word Processor, B) Database, C) Image Editor, D) File manager, 

Ans:-D,-D


Which of the following is a voiceband channel?
Options: Telephone line,    Telegraph line,    Coaxial cable,    Microwave systems

Ans:A ,A


What is the name given to the specialized storage element in the processor unit of a computer which is used as a "scratch pad" during processing operations?
Options: storage register,    primary memory,    cache memory,    accumulator

Ans:C ,C


DHCP is the abbreviation of
Options:  Dynamic Host Control Protocol B.  Dynamic Host Configuration Protocol C.  Dynamic Hyper Control Protocol D.  Dynamic Hyper Configuration Protocol

Ans:– B ,


. Which of the following functions is used to all the values in a numeric field?
Options: a. Num b. Count c. Sum d. Total

Ans:6 – b ,6 – b


The primary purpose of an operating system is to:
Options: make computer easier to use,    keep system programmers employed,    make the most efficient use of the hardware,    allow people to sue the computers

Ans:A ,A


One of the following is not considered a method of input control in a CAD system.
Options: Joystick,    Programmable function box,    Plotter,    Touch terminal

Ans:C ,C


The extract process is which of the following?
Options: Capturing all of the data contained in various operational systems,    Capturing a subset of the data contained in various operational systems,    Capturing all of the data contained in various decision support systems,    Capturing a subset of the data contained in various decision support systems

Ans:B ,B


How will you free the memory allocated by the following program? #include<stdio.h> #include<stdlib.h> #define MAXROW 3 #define MAXCOL 4 int main() { int **p, i, j; p = (int **) malloc(MAXROW * sizeof(int*)); return 0; }
Options: memfree(int p);,    dealloc(p);,    malloc(p, 0);,    free(p);

Ans:D ,D


The model base cannot be prepared until
Options: the computer has been selected,    the MIS staff has been acquired and organized,    the preparation of physical facilities,    both (a) and (b)

Ans:D ,D


How many pins on a VGA?
Options: 15.,    9,    25,    32

Ans:A ,A


. A small or intelligent device is so called because it contains within it a

Options: A) Computer B) Microcomputer C) Programmable D) Sensor

Ans:D,D


To build a modularized kernel, the kernel-headers and kernel-source packages must first be installed. Where will you find the kernel-headers and kernel-source?
Options: /usr/local,    /usr/src/linux,    /usr/sre/redhat,    /usr/bin

Ans:B ,B


The microprocessor of a computer cannot operate on any information if that information is not in its.
Options: secondary storage,    main storage,    ALU,    logic unit

Ans:B ,B


9. What is the name of the batch file that is automatically run when MSDOS is booted?
Options: a. Run.bat b. Config.sys c. Config.bat d. Autoexec.bat

Ans:Correct Answer: d ,Correct Answer: d


. Presentation designs regulate the formatting and layout for the slide and are commonly called
Options: a. Design templates b. Templates c. Placeholders d. Blueprints

Ans:4 – B ,4 – B


Long-range planning reports produced in an MIS are primarily designed for:
Options: top management,    middle management,    lower management,    both (a) and (c)

Ans:A ,A


. Which command is used to list out deleted files in DOS?
Options: a. list b. Undelete/list c. Recover d. All of the above

Ans:3 – b ,3 – b


An input device which can read characters directly from an ordinary piece of paper is
Options: OCR,    OMR,    MSI,    POS

Ans:A ,A


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


6. Which command is used to see the contents of a file?
Options: a. Type b. Copy c. Ed d. None of above

Ans:Correct Answer: a ,Correct Answer: a


What are the most likely conditions for ESD?
Options: Hot and dry,    Hot and wet,    Cold and dry,    Cold and wet

Ans:B ,B


. What will be the command if you want to copy rdoc file that resides in the floppy disk into work sub-directory of hard disk while you are in C prompt
Options: a. Copy c: doc a:work b. Copy A: doc c:work c. Copy rdoc c:work d. Copy c:>work a:doc

Ans:1 – b ,1 – b


Suppose you had an incurable computer virus and decided to wipe out all the data and partitions on your hard drive and reformat. What is the order in which you must delete the partitions?
Options: Extended, Logical, Primary,    Primary, Extended, Logical,    Logical, Extended, Primary,    Logical, Primary, Extended

Ans:C ,C


Which of the following is not available on the Ruler of MS Word screen?
Options:  A) Tab stop box, B) Left Indent, C) Right Indent, D) Center Indent, E) All of them are available on ruler

Ans:-D,-D


With DOS, you may use the * and ?
Options: a. when changing the default settings b. to represent unspecified characters in a filename c. instead of wildcard characters d. in the extension but not in the drive name or the file name

Ans:9 b.,9 b.

www.000webhost.com