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: 15206 | Level: Moderate




Got some suggestion about this question or to make this site better? Please leave your comments below.


Want to see where do you stand among other aspirants in "Computer" Category?

Click Here to take quick 5 mins MCQ test to find out.

More Database Systems Related questions:


Which of the following is not currently a topic in computer science?
Options: Speech recognition,    Artificial intelligence,    Thermodynamics,    Multiprocessing

Ans:C ,C


. To insert a hyperlink in a slide
Options: a.  Choose Insert >> Hyperlink b.  Press Ctrl + K c.  Hyperlinks can’t be inserted in slides d.  Both a & b

Ans:0 – D ,0 – D


A time sharing system imply
Options: a . more than one processor in the system b . more than one program in memory c . more than one memory in the system d. None of above

Ans:10.b,10.b


. Which is not executable file?
Options: a. .com b. .exe c. .bat d. .txt

Ans:3 – d ,3 – d


. You can merge the main document with data source in Excel. In mail merge operation, Word is usually
Options: a.  server b.  source c.  client d.  none

Ans:– c,– c


To select a block of text, click at the beginning of the selection, scroll to the end of the selection, position the mouse pointer at the end of the selection, hold down the _____ key, and then click (or drag through the text).
Options: a. ctrl b. alt c. shift d. tab

Ans:– c,– c


Which are considered the methods of NAT? Static IP NAT pool Dynamic NAT double-translation Overload
Options: 1 and 6,    3 only,    1, 3 and 5,    All of the above

Ans:C ,C


. Which language is directly understood by the computer without translation program?
Options: A) Machine language B) Assembly language C) High level language D) None of above

Ans:A,A


Point out the error in the following program. #include<stdio.h> int main() { char str[] = "IndiaBIX"; printf("%.#s %2s", str, str); return 0; }
Options: Error: in Array declaration,    Error: printf statement,    Error: unspecified character in printf,    No error

Ans:D ,D


. Special category of Number tab in Format Cells dialog box can be used to apply formats like
Options: a. Zip Code b. Phone Number c. Both of above d. None of above

Ans:– c,– c


38. What is the shortcut key to split a table?
Options: a. Ctrl + Alt + Enter b. Ctrl + Shift + Enter c. Alt + Shift + Enter d. Alt + Space + Enter

Ans:–  B ,–  B


The language that the computer can understand and execute is called
Options: Machine language,    Application software,    System program,    All of the above

Ans:A ,A


Expert Ease was developed under the direction of:
Options: John McCarthy,    Donald Michie,    Lofti Zadeh,    Alan Turing

Ans:B ,B


When mapping a multivalued attribute into a relation which of the following is true?
Options: One relation is created.,    Two relations are created.,    Three relations are created.,    Four relations are created.

Ans:B ,B


The core of an electromagnet is said to be in saturation when:
Options: the core is permitted to move freely within the coil,    an increase in current through the coil causes no further increase in the mmf,    frequent changes in the direction of current through the coil causes heating effects in the core material,    changing the polarity of the current in the coil changes the polarity of the magnetic field around the core

Ans:B ,B


. A .... is a named location on a disk where files are stored
Options: a. Folder b. Pod c. Version d. None of the above

Ans: a, a


Which one of the following statements is true for the currents in a parallel RL circuit?
Options: The total current is equal to the sum of the currents through the resistance and inductance,    The current always has the same amplitude and phase for every part of the circuit,    The total current is less than the sum of the currents through the resistance and inductance,    The total current leads the total voltage by less than 90

Ans:C ,C


. How do you rearrange the data in ascending or descending order?
Options: a. Data, Sort b. Data, Form c. Data, Table d. Data Subtotals

Ans:– a,– a


Which of the following commands is used to absolutely assign all permissions to the owner, read and write permissions to the group and only executable permission to the others of the file note?
Options: chmod 761 note,    chmod 671 note,    chmod 167 note,    chmod 4=rwx, g=rw note

Ans:A ,A


The brain of any computer system is
Options: A) ALU B) Memory C) CPU D) Control unit

Ans:C,C


Which of the following signs is used to back up over typing errors in vi?
Options: @,    #,    $,    !

Ans:B ,B


Which of the following is not Modification of the Database
Options: Deletion B. Insertion C. Sorting D. Updating

Ans:– C ,


A non-relocatable program is one which
Options: cannot be made to execute in any area of storage other than the one designated for it at the time of its coding or translation,    consists of a program and relevant information for its relocation,    can itself perform the relocation of its address-sensitive portions,    All Of the above

Ans:A ,A


"Parity" errors usually indicate bad memory.
Options: True,    False,    ,    

Ans:A ,A


. Which of the following field properties enforces the use of parentheses when keying an area code?
Options: a. Field Size b. Format c. Input Mask d. Validation Rule

Ans:0 – c ,0 – c


Some firms have created a combination position called
Options: manager / analyst,    programmer / operator,    analyst / programmer,    manager / operator

Ans:C ,C


. Which is valid statement
Options: A) 1 KB = 1024 Bytes B) 1 MB = 1024 Bytes C) 1 KB = 1000 Bytes D) 1 MB = 1000 Bytes

Ans:A,A


In which mode, each user has a local input/output device.
Options: Interactive,    Time sharing mode,    Batch processing mode,    All of the above

Ans:B ,B


. If you need a calculation in an unbound control, you can create a custom _____.
Options: a. string b. expression c. relationship d. syntax

Ans:4 – b ,4 – b


Corporate modeling languages often do provide for
Options: model definition,    DML commands,    editing,    report specification

Ans:A ,A


Which of the following access lists will allow only HTTP traffic into network 196.15.7.0?
Options: access-list 100 permit tcp any 196.15.7.0 0.0.0.255 eq www,    access-list 10 deny tcp any 196.15.7.0 eq www,    access-list 100 permit 196.15.7.0 0.0.0.255 eq www,    access-list 110 permit ip any 196.15.7.0 0.0.0.255

Ans:A ,A


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


. What is the maximum zoom percentage in Microsoft PowerPoint?
Options: a. 100 b. 200 c. 300 d. 400

Ans:7 – D ,7 – D


Which of the following is true concerning a procedure?
Options: You do not create them with SQL.,    They do not need to have a unique name.,    They include procedural and SQL statements.,    They are the same thing as a function.

Ans:C ,C


Which access method is used for obtaining a record from a cassette tape
Options: direct,    sequential,    random,    All of the above

Ans:B,B


High density double sided floppy disks could store _____ of data
Options: A) 1.40 MB B) 1.44 GB C) 1.40 GB D) 1.44 MB

Ans:-D,-D


. Formulas in Excel start with
Options: a. % b. = c. + d. –

Ans:– b,– b


The primary memory of a personal computer consists of:
Options: ROM only,    RAM only,    Both ROM and RAM,    Memory module

Ans:C ,C


. In Computer System Memory management operations are performed by
Options: User B. Hardware       C. Programmer D. Operating system

Ans:– D ,


The logical data structure with a one-to-many relationship is a :
Options: network,    tree,    chain,    relational

Ans:B ,B


Hard disks are formatted in the same manner as floppy disks. However, before a hard disk can be formatted, it must first be _____
Options: partitioned,    sectioned,    deleted,    inter-sectioned

Ans:A ,A


What are lines, curve, freeform, and scribble?
Options: a. Emphasis effects that can be applied to animations b. Types of custom motion paths c. Predefined entrance and exit effects d. All of the above

Ans: – B , – B


. What is the use of “Hide Slide” option?
Options: a. to hide the selected slides during Presentation b. to hide the selected slides during Editing c. to hide the selected slides during Printing d. to hide the selected slides during Deleting

Ans:8 – A ,8 – A


Suppose the voltage from a power outlet is 120 Vrms. What is the peak voltage?
Options: 100 V,    120 V,    170 V,    180 V

Ans:C ,C


Client-side extensions:
Options: add functionality to the server.,    add functionality to the browser.,    add functionality to the firewall.,    add functionality to the network.

Ans:B ,B


. Which setting you must modify to print a worksheet using letterhead?
Options: a. Paper b. Margin c. Layout d. Orientation

Ans:– b,– b


If you want to organize a file in multiple ways, it is better to _____ the data rather than to sort it.
Options: Delete,    Update,    Sort Key,    Index

Ans:D ,D


. Multiple calculations can be made in a single formula using…..
Options: a. Standard Formulas b. Array Formula c. Complex Formulas d. Smart Formula

Ans:– b,– b


Operator interaction directly with the CRT is accomplished via:
Options: a digitizing tablet,    vector scanning,    a stylus,    a touch terminal

Ans:D ,D


In DOS, which of the following keys will bypass the CONFIG.SYS and AUTOEXEC.BAT files?
Options: F8,    F5,    F4,    Fl

Ans:B ,B

www.000webhost.com