Which of the following is correct regarding Aggregate functions?


Options: it takes a list of values and return a single values as result B. it takes a list of values and return a list of values as result C. it takes a single value and returns a list of values as result D. it takes a single value and returns a single value as result

Ans:– A ,

More Database Systems Related questions:


What will be the output of the program? #include<stdio.h> #define SWAP(a, b) int t; t=a, a=b, b=t; int main() { int a=10, b=12; SWAP(a, b); printf("a = %d, b = %d\n", a, b); return 0; }
Options: a = 10, b = 12,    a = 12, b = 10,    Error: Declaration not allowed in macro,    Error: Undefined symbol 't'

Ans:B ,B


sirimao bhandaaranaayake
Options: NA

Ans: 555. hadappa kee sabhyata kis yug se sambandhit hai?, 555. hadappa kee sabhyata kis yug se sambandhit hai?


Michael Faraday discovered
Options: electromagnetism,    benzene, liquid gases and optical glass,    the induction of electric current,    All of the above

Ans:D,D


who was last ruler of trigart riyasat
Options: shivram chand, veer chand, hari chand, dhruv dev chand

Ans:dhruv dev chand,dhruv dev chand


. The__ button on the tool box display data from a related table
Options: a. Sub form sub report b. Relationships c. Select objects d. More controls

Ans:3 – a ,3 – a


Which one of the following rivers forms an estuary?
Options: NA

Ans:Narmada,Narmada


Which of the following is correct for a gated D-type flip-flop?
Options: The Q output is either SET or RESET as soon as the D input goes HIGH or LOW.,    The output complement follows the input when enabled.,    Only one of the inputs can be HIGH at a time.,    The output toggles if one of the inputs is held HIGH.

Ans:A ,A


264. deshabandhu ke naam se kon jaane jaate hai?
Options: NA

Ans: chitaranjan daas, chitaranjan daas


A gate is a logic circuit with one or more input signals but _____ output signal.
Options: two,    double,    one,    more than one

Ans:C ,C


198. pratham bhaarateey upagrah ka naam kya hain aur ise kab chhoda gaya ?
Options: NA

Ans: aaryabhatat san, 1975 mein, aaryabhatat san, 1975 mein


Which, of the following is not true about the description of a decision table?
Options: A decision table is easy to modify,    A decision table is directly understood by the computer,    A decision table is easy to understand,    All of the above

Ans:B ,B


Ergonomics refers to:
Options: the human aspect of the environment around the workstation as well as the workstation itself,    the cost relationship of the workstation versus productivity,    the level of involvement the operator has with the workstation,    the technology involved in the workstation itself

Ans:A ,A


The total capacitance of a series capacitor circuit is:
Options: equal to the sun of the individual capacitive-reactance values,    equal to the sum of the individual capacitance values,    equal to the source voltage divided by total current,    less than the value of the smallest capacitor

Ans:D ,D


When the minimum number of instances of an entity is one, you know which of the following?
Options: Mandatory one,    Optional one,    Mandatory many,    Cannot tell

Ans:D ,D


Which of the following products was the first to implement true relational algebra in a PC DBMS?
Options: IDMS,    Oracle,    dBase-II,    R:base

Ans:D ,D


A computer program that converts an entire program into machine language at one time is called a/an
Options: a . interpreter b . simulator c . compiler d . commander 

Ans:4.c,4.c


What is a URL?
Options: A computer software program,    A type of UFO,    The address of a document or "page" on the World Wide Web,    An acronym for Uniform Resources Learning

Ans:C,C


5.In Access press ALT+F11 to
Options: (A)Display the Control menu (B) Display the shortcut menu (C) Close the active window (D) None of these 2

Ans:25. (D),25. (D)


. What is the use of Cascade Delete Option in MS Access?
Options: a. It makes sure that all the records from the parent table and child table is deleted from selected database b. It makes sure that all the related records will be deleted automatically from child table when the records from parent table is deleted c. It makes sure that all the related records will be deleted automatically from Parent table when the records from child table is deleted d. None of above

Ans:– b,– b


.  Power Point can display data from which of the following add-in software of MS Office?
Options: Equation Editor B. Organization Chart C. Photo Album D. All of these

Ans: – D ,


What type of software is used for creating letters papers and other documents?
Options: (A) Database (B) Word Processor (C) Spreadsheet (D) Operating Program 7.

Ans:6. (B),6. (B)


where is biggest glashior of HP
Options: kinnaur , lahul, kullu, chamba

Ans:lahaul spiti,lahaul spiti


792. vishv mein sabase bada daakatantr kis desh ka hai?
Options: NA

Ans: bhaarat, bhaarat


The function(s) of file system is (are):
Options: to provide complete file naming freedom to the users and to permit controlled sharing of files,    to provide for long and short term storage of files with appropriate economic tradeoffs.,    to provide security against loss of information due to system failure,    all of the above

Ans:D ,D


The _____, or typeface, defines the appearance and shape of letters, numbers, and special characters.
Options: a. font b. font size c. point d. paragraph formatting

Ans:– A,– A


What is the shortcut key for “Superscript ” the selected text?
Options: Ctrl + = B. Ctrl + – C. Ctrl + Shift + = D. Ctrl + Shift + –

Ans:– C ,


. Which of the following database object hold data?
Options: a. Forms b. Reports c. Queries d. Tables

Ans:3 – d ,3 – d


649. kis maulik adhikaar ko 44ven sanvidhaan sanshodhan dvaara hata diya gaya?
Options: NA

Ans: sampatti ka adhikaar, sampatti ka adhikaar


In which addressing mode the operand is given explicitly in the instruction?
Options: absolute mode,    immediate mode,    indirect mode,    index mode

Ans:B ,B


What PPP protocol provides dynamic addressing, authentication, and multilink?
Options: NCP,    HDLC,    LCP,    X.25

Ans:C ,C


You should never put floppy drives, hard drives, or even VCR tapes or cassette tapes on top of speakers (or near any other source of magnetism) because of:
Options: RFI,    EMI,    EXE,    FYI

Ans:B ,B


The intersection of a column and row in a spreadsheet is called a bon or
Options: Key,    Field,    Cell,    Menu

Ans:C ,C


3.One of the type libraries that you can use to programmatically connect to Microsoft Access data is
Options: (A)Collaborative Data Objects (B) ActiveX Data Objects (C) Dynamic Data Interfaces (D) None of the above 7

Ans:73. (B),73. (B)


The smallest country of the world is
Options: Russia,    Vatican city,    Brazil,    Canada

Ans:B,B


Which class network is used for a collection of a small number of networks with a large number of nodes?
Options: Class A,    Class B,    Class C,    All of the above

Ans:A ,A


What is the name of the logic circuit which can add two binary digits?
Options: Full adder,    Half adder,    Buffer,    Register

Ans:B,B


What's the best way to protect your hard drive data?
Options: regular backups,    periodically defrag it,    run chkdsk at least once a week,    run scandisk at least once a week

Ans:A ,A


What kind of data can you send by e-mail?
Options: Audio,    Pictures,    Video,    All of the above

Ans:D,D


Sales invoking is a:
Options: pre-sales activity,    job of finance department,    post-sales activity,    All of the above

Ans:A ,A


You can add a row using SQL in a database with which of the following?
Options: ADD,    CREATE,    INSERT,    MAKE

Ans:C ,C


4.In Windows operating system to copy something the following shortcut is used
Options: (A)CTRL+C (B) CTRL+X (C) CTRL+V (D) None of these 2

Ans:24. (A),24. (A)


Telecommunication networks frequently interconnect an organization with its customers and suppliers. Select the best fit for answer:
Options: Bandwidth alternatives,    Switching alternating,    Inter organizational networks,    Extranets

Ans:C ,C


. Ctrl + F
Options: a. Open Find and Replace Dialog box with activating Find Tab b. Open Page Setup Dialog box with activating Layout Tab c. Open Font Dialog Box with activating Font tab d. Open File Save as Dialog box

Ans:–  A,–  A


What is the first step in diagnosing a completely dead computer at the client site that was working the day before.
Options: Test the power supply,    replace the CMOS battery,    check the AC outlet,    reseat the hard drive controller cable

Ans:C ,C


Most modern TV's draw power even if turned off. The circuit the power is used in does what function?
Options: Sound,    Remote control,    Color balance,    High voltage

Ans:B,B


3.I/O OBR (I/O Buffer register) is
Options: (A)Used for the exchange of data between an I/O module and the processor. (B) Specifies particular I/O device. 64 | (C) (A)and (B) both true. (D) (A)and (B) both false. 1

Ans:13. (A),13. (A)


Business Intelligence (BI) reporting analyses can be performed using ________ .
Options: standard SQL only,    extensions to SQL only,    OLAP only,    both standard SQL and extensions to SQL

Ans:A ,A


What is the middle name of Parthiv Patel?
Options: Rohan,    Jaichandra,    Ajay,    Karan

Ans:C,C


294. gaayatree mantr’ ka ullekh kis granth mein hai?
Options: NA

Ans: rgved, rgved


The three key elements for a graphics workstation include the host processor, display controller, and:
Options: mouse,    keyboard,    CRT,    digitizer

Ans:C ,C

www.000webhost.com