which of the following is not an Aggregate function?

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

Ans:– C ,

More Database Systems Related questions:

1.It is an electronic commerce in services, i.e. the provision of services with the assistance of telecommunications and telecommunications-based tools. It excludes traffic in physical goods, and hence is concerned with applications of electronic business where, at least in principle, the entire activity can be performed electronically.
Options: (A)Electronic data interchange (EDI) (B) Electronic Publishing (C) Electronic Services Delivery (ES(D) (D) None of these 1

Ans:11. (C),11. (C)

1.In shared Memory
Options: (A)Changes in a memory location effected by one processor do not affect all other processors. (B) Changes in a memory location effected by one processor are visible to all other processors (C) Changes in a memory location effected by one processor are randomly visible to all other processors. (D) None of these 1

Ans:11. (B),11. (B)

20. Which command is used to display a list of deleted files that DOS can undelete?
Options: a. Undelete *.* b. Undelete/all c. Undelete/list d. None of the above

Ans:Correct Answer: c ,Correct Answer: c

. 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 language has been selected as the basis for the Japanese "fifth generation" computers.
Options: ALGOL,    COBOL,    PROLOG,    C

Ans:C ,C

Potato is a modified form (outgrowth) of
Options: root,    stem,    fruit,    leaf


Which is a unit representing the no bits of discrete.
Options: Baud,    Byte,    Bit,    All of the above


duggi jot darra
Options: lahaul-spiti, kangra-bharmaur, bharmaur-lahaul,chamba-pangi


The "walk-through" method of programming a robot involves:
Options: walking through your suggested procedure with your supervisor prior to programming,    physically moving the robot through all the motions it is to repeat,    moving the robot from one location to another,    All of the above.

Ans:B ,B

When integrating word and excel, word is usually the
Options: a. Server b. Destination c. Client d. Both b and c

Ans:#8211; d,#8211; d

48. Which option is not available in Insert Table Autofit behavior?
Options: a. Fixed Column Width b. AutoFit to Contents c. Autofit to Window d. Autofit to Column

Ans:– D ,– D

5.A coding structure in which characters are represented by means of a series of parallel bars is
Options: (A)Bar Code (B) Menu bar (C) Numeric bar (D) None of these 13

Ans:135. (A),135. (A)

Which is a machine-oriented high-level language for the GEC 4080 series machines.
Options: LOGO,    SNOBOL,    Babbage,    ALGOL

Ans:C ,C

Which of the following is false about disk when compared to main memory?
Options: non-volatile,    longer storage capacity,    lower price per bit,    faster

Ans:D ,D

In CRC the quotient at the sender
Options: becomes the dividend at the receiver,    becomes the divisor at the receiver,    is discarded,    is the remainder

Ans:C ,C

What is the byte capacity of a drum which is 5 inch high, 10 inch diameter, and which has 60 tracks per inch and bit density of 800 bits per inch?
Options: 942000 bytes,    9712478 bytes,    192300 bytes,    14384 bytes

Ans:A ,A

Silicon atoms combine into an orderly pattern called a
Options: Crystal,    Covalent bond,    Semiconductor,    Valence orbit

Ans:A ,A

Resistance is measured:
Options: in parallel,    in series,    after breaking the circuit,    after checking voltage

Ans:C ,C

Robots can increase productivity because:
Options: they do not take a vacation,    they do not get tired,    production quality is uniform,    All of the above

Ans:D ,D

Binary search algorithm can not be applied to
Options: a. sorted linked list b. sorted binary trees c. sorted linear array d. pointer array

Ans:- a,- a

The complexity of merge sort algorithm is
Options: a. O(n) b. O(log n) c. O(n2) d. O(n log n)  


One of the following is not a function of bones.
Options: Place for muscle attachment,    Protection of vital organs,    Secretion of hormones for calcium regulation in blood and bones,    Production of blood corpuscles


1.Adaptive measures are
Options: (A)Quality measures that address how easily a system can evolve or migrate (B) Piece of software that acts to accomplish tasks on behalf of its user (C) A quantitative option analysis that allows the cost of various options to be computed, and options can be compared on objective basis (D) Extent to which a software system or component allows for or supports anonymous transactions 11

Ans:111. (A),111. (A)

The magnetosphere becomes unstable during the magnetic storms during a period of
Options: initial phase,    storm sudden commencement phase,    main phase,    None of the above


Who invented Automobiles using gasoline?
Options: Leo H Baekeland,    Karl Benz,    Evangelista Torricelli,    Kirkpatrick Macmillan


A condition that led to the development of databases was
Options: a demand for more data to support information needs,    an increase in the amount of data handled by organizations,    the proliferation of data files,    All of the above

Ans:D ,D

The most fertile region of India is
Options: the Himalayas,    the central Highlands,    the Indo-Gangetic plain,    peninsular plateau


The parliament can legislate on the subject in the state list
Options: if the President issues an order authorizing it to do so,    if the Supreme Court of India gives authority to the Parliament of India in this regard,    if the Rajya Sabha passes a resolution by two-third of its to legislate on a state matter in the national interest,    None of the above


. In a folder, which of the following command is used to rename the file or folder
Options: a. F3 b. F4 c. F2 d. F7

Ans:0 – c ,0 – c

Radish is a
Options: bulb,    conn,    modified root,    tuber


When a moving bus stops suddenly, the passenger are pushed forward because of the
Options: friction between the earth and the bus,    friction between the passengers and the earth,    inertia of the passengers,    inertia of the bus


A technique for displaying applications where complex 3-D geometric are required for the exteror shall of a product is called:
Options: solid modeling,    2-D modeling,    3-D modeling,    surface modeling

Ans:D ,D

A database management system (DBMS) is a:
Options: hardware system used to create, maintain, and provide controlled access to a database.,    hardware system used to create, maintain, and provide uncontrolled access to a database.,    software system used to create, maintain, and provide controlled access to a database.,    software system used to create, maintain, and provide uncontrolled access to a database.

Ans:C ,C

.Which of the following data structure is linear data structure?
Options: A)Trees b.Graphs c.Arrays d.None of above


Which of the following is an essential file of a MS-DOS boot disk?


9.A computer language for informing the DBMS regarding the data structure used is

Ans:139. (B),139. (B)

The main electronic component used in first generation computers was
Options: A) Transistors B) Vacuum Tubes and Valves C) Integrated Circuits D) None of above


997. bhaarat ke kitane pratishat kshetraphal par khetee hotee hai?
Options: NA

Ans: 51%, 51%

The magnetic field of earth, Magnetosphere expands to about
Options: 9600 km above the earth's surface,    8000 km above the earth's surface,    64,000 km above the earth's surface,    None of the above


Dot-matrix is a type of
Options: Tape,    Printer,    Disk,    Bus

Ans:B ,B

Which type device is a piece of equipment that receives information from a CPU?
Options: Input,    Output,    CPU,    Memory

Ans:B ,B

Which part of the computer were is used for calculating and comparing?
Options: Disk unit,    Control unit,    ALU,    Modem


Depreciation means
Options: closure of a plant due to lock out,    closure of a plant due to labour trouble,    loss of equipment over time due to wear and tear,    destruction of a plant in a fire accident


CD-ROM is a
Options: A) Semiconductor memory B) Memory register C) Magnetic memory D) None of above


0.In Access press to Open the Choose Builder dialog box (Design view window of forms and reports)
Options: (A)F6 (B) F7 (C) F8 (D) None of these 4

Ans:40. (B),40. (B)

Which of the following is true regarding access lists applied to an interface?
Options: You can place as many access lists as you want on any interface until you run out of memory.,    You can apply only one access list on any interface.,    One access list may be configured, per direction, for each layer 3 protocol configured on an interface.,    You can apply two access lists to any interface.

Ans:C ,C

. Which device can understand difference between data & programs?
Options: A) Input device B) Output device C) Memory D) Microprocessor


Which of the following is used for serial access storage only?
Options: RAM,    Magnetic tape,    Magnetic disk,    Core memory

Ans:B ,B

The term used to describe a sudden fall of a government, brought about by illegal force is called
Options: credit squeeze,    loup de' etat,    deficit financing,    deflation


. To print documents from Windows
Options: a. File >> Print b. Drag the document icon over your printers icon c. Edit print d. Both a and B

Ans:8 – d ,8 – d