which of the following is not an Aggregate function?


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

Ans:– C ,






More Database Systems Related questions:


The ideal solution is to have a system coordinator who will interface with the engineering and manufacturing managers, as well as the:
Options: finance manager,    president,    marketing manager,    MIS manager

Ans:D ,D


What is ACID properties of Transactions?
Options: Atomicity, Consistency, Isolation, Database B. Atomicity, Consistency, Isolation, Durability C. Atomicity, Consistency, Inconsistent, Durability D. Automatically, Concurrency, Isolation, Durability

Ans:– B ,


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


Computer is free from tiresome and boardoom. We call it
Options: A) Accuracy B) Reliability C) Diligence D) Versatility

Ans:-C,-C


You cannot close MS Word application by
Options:  A) Choosing File menu then Exit submenu, B) Press Alt+F4, C) Click X button on title bar, D) From File menu choose Close submenu, 

Ans:-D,-D


. Which statement is valid about interpreter?
Options: A) It translates one instruction at a time B) Object code is saved for future use C) Repeated interpretation is not necessary D) All of above

Ans:A,A


The file key of the fixed assets file includes the
Options: fixed asset account number,    acquisition date,    asset identification number,    depreciation account number

Ans:C ,C


. Which of the following is not a valid Zoom percentage in Excel?
Options: a. 10 b. 100 c. 300 d. 500

Ans:– d,– d


A data item which is not broken down into smaller units is _____
Options: Data element,    Elementary data item,    Data entry,    Database management

Ans:B ,B


. On the works cited page, list works by each author’s last name and _____ the title of the work.
Options: a. italicize or underline b. boldface or italicize c. underline or boldface d. enlarge or underline

Ans: – A , – A


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

Ans:D ,D


A sizeable geographical area with communication based on the telephone system is though as
Options: Local area network,    Wide area network,    Modulator-Demodulator,    All of the above

Ans:B ,B


. Which of the following Excel screen components can NOT be turned on or off?
Options: a.  Formula Bar b.  Status Bar c.  Tool Bar d.  None of above

Ans:– d,– d


Which is the correct for MIS:
Options: communication process wherein information is recorded, stored, processed and retrieved for managerial decision-making,    communication process wherein data is recorded, stored, processed and retrieved for managerial decision-making,    communication process wherein data is converted into information,    All of the above

Ans:B ,B


Terminal Table
Options: a permanent table which lists all key words and special symbols of the language in symbolic form,    a permanent table of decision rules in the form of patterns for matching with the uniform symbol table to discover syntactic structure,    consists of a full or partial list of the tokens as they appear in the program. Created by Lexical analysis and used for syntax analysis and interpretation,    contains all constants in the program

Ans:A ,A


. Who invented punched cards?

Options: A) Charles Babbage B) Dr. Herman Hollerith C) Howard Aikin D) Joseph Jacquard

Ans:D,D


The command chmod 761 note is equivalent to
Options: chmod 167 note,    chmod u=rwx, g=rw, o=x note,    chmo a =761 note,    chmod 4=7, g=6,0 =1 note

Ans:B ,B


Batch files contain a group of MS-DOS commands that are run in successive order. What filename extension identifies batch files?
Options: COM,    BAT,    EXE,    SYS

Ans:B ,B


Which of the following communications modes support two-way traffic but in only one direction of a time?
Options: simplex,    half-duplex,    three-quarters duplex,    full-of the above

Ans:B ,B


What are the most commonly used transmission speeds in BPS used in data communication?
Options: 300,    1200,    2400,    9600

Ans:D ,D


User-Friendly Systems are:
Options: required for object-oriented programming,    easy to develop,    common among traditional mainframe operating systems,    becoming more common

Ans:D ,D


. In a report, you need to show the monthly rainfall in NepaThe best way to do this is to insert a
Options: a. calendar b. photograph of rainfall c. chart showing rainfall amounts d. database of rainfall

Ans:– c,– c


What beep codes could indicate a system board or power supply failure?
Options: steady short beep,    no beep,    one long continuous beep tone, All of the above

Ans:E ,D


In EXCEL, you can sum a large range of data by simply selecting a tool button called …..?
Options: AutoFill B. Auto correct C. Auto sum D. Auto format

Ans:– C ,


Which of the following occurs when a transaction rereads data it has previously read and finds modification or deletions caused by a committed transaction?
Options: Nonrepeatable read,    Phantom read,    Dirty read,    Consistent read

Ans:A ,A


In the language of the computer profession, one thousand position of main storage is represented with the letter
Options: K,    L,    M,    C

Ans:A ,A


Which of the following statement is true?
Options: a. Foreign key fields don't allow duplicate values b. In primary key field you can enter duplicate value c. In an indexed field you may or may not enter duplicate value depending upon setting d. All statements are true

Ans:c, c


An intranet provides which of the following?
Options: Connectivity to all customers,    Connectivity to selected customers,    Connectivity to no customers,    Connectivity to all of the above

Ans:C ,C


When a router is connected to a Frame Relay WAN link using a serial DTE interface, how is the clock rate determined?
Options: Supplied by the CSU/DSU,    By the far end router,    By the clock rate command,    By the Physical layer bit stream timing

Ans:A ,A


. In Microsoft windows, the graphical pattern on the desktop used as background for windows is
Options: a. Icons b. Wall paper c. Picture d. Background

Ans:0 – b ,0 – b


What will be the output of the program if the array begins at address 65486? #include<stdio.h> int main() { int arr[] = {12, 14, 15, 23, 45}; printf("%u, %u\n", arr, &arr); return 0; }
Options: 65486, 65488,    65486, 65486,    65486, 65490,    65486, 65487

Ans:B ,B


Which device does the general population associate most with automation?
Options: Flexible manufacturing,    Robots,    Numerical control machine,    Computer graphics workstation

Ans:B ,B


Which selection below best describes the term data processing?
Options: The collection of information or data,    The distribution of information or data,    The manipulation of information or data,    The storage of information or data

Ans:C ,C


An error-detecting code inserted as a field in a block of data to be transmitted is known as
Options: Frame check sequence,    Error detecting code,    Checksum,    flow control

Ans:A ,A


How much should an organisation spend for information can be determined by some type of a:
Options: cost analysis,    benefit analysis,    cost-benefit analysis,    any of the above

Ans:C ,C


Localizing an object in an image and selectively analyzing the object in a series of redundant layers is referred to as the:
Options: Turing test,    pyramid,    Gaussian pyramid,    Maxwell pyramid

Ans:C ,C


An atomic literal is which of the following?
Options: Strings,    Boolean,    Long,    All of the above.

Ans:D ,D


. Which of the following store command to retrieve data from database?
Options: a. Forms b. Reports c. Queries d. Tables

Ans:4 – c ,4 – c


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


Point out the error if any in the following program (Turbo C). #include<stdio.h> #include<stdarg.h> void display(int num, ...); int main() { display(4, 'A', 'a', 'b', 'c'); return 0; } void display(int num, ...) { char c; int j; va_list ptr; va_start(ptr, num); for(j=1; j<=num; j++) { c = va_arg(ptr, char); printf("%c", c); } }
Options: Error: unknown variable ptr,    Error: Lvalue required for parameter,    No error and print A a b c,    No error and print 4 A a b c

Ans:C ,C


Which of the following is not true of the traditional approach to information processing?
Options: There is common sharing of data among the various applications,    It is file-oriented,    Programs are dependent on the files,    It is inflexible

Ans:A ,A


A memory bus is mainly used for communication between
Options: processor and memory,    processor and I/O devices,    I/O devices and memory,    input device and output device

Ans:A ,A


As alternatives are evaluated, the best one is recognized as the one
Options: best enabling the system to meet its objectives,    representing lowest cost,    with the most advantages,    with the least disadvantages

Ans:A ,A


A factor which would strongly influence a businessperson to adopt a computer is its:
Options: Accuracy,    Reliability,    Speed,    All of the above

Ans:D,D


What type of commands are individual programs kept, as separate files on the hard disk (DOS diskette)?
Options: External,    Internal,    Change,    File

Ans:A ,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


What command is used to remove jobs from the print queue?
Options: lpq,    lpr,    lprm,    lpc

Ans:C ,C


D/A (digital to analog) conversion:
Options: results in a binary code as the final output,    has to be sampled at 1/2 the highest input frequency,    must be fed through a filter to reproduce the original signal accurately,    both (b) and (c)

Ans:C ,C


What could cause a fixed disk error.
Options: No-CD installed,    bad ram,    slow processor,    Incorrect CMOS settings

Ans:D ,D


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

Ans:9-A,9-A

www.000webhost.com