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 ,

Description: mcqquestions

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

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

. To start slide show of a presentation
Options: a.  Hit F5 key b.  From Slide Show menu choose View Show option c.  From Slide Show menu choose Rehearse timing d.  Both a & b

Ans:8 – D ,8 – D

. Which of the following cannot be toggled from View >> Toolbars?
Options: a.  Control Toolbox b.  Slides c.  Revisions d.  Reviewing

Ans:5 – B ,5 – B

The NOT EXISTS keyword will be true if:
Options: any row in the subquery meets the condition.,    all rows in the subquery fail the condition.,    both of these two conditions are met.,    neither of these two conditions is met.

Ans:B ,B

Trend analysis:
Options: is used only in financial planning,    can improve control system response,    requires a very expensive system to implement,    is a brand new concept

Ans:B ,B

Which type of digitizer measures a wave traveling at the speed of sound?
Options: Electrostatic,    Sonic,    Digitizing sr amer,    Caparitive

Ans:B ,B

How many steps are there between Start and Finish in AutoContent Wizard?
Options: a. 3 b. 4 c. 5 d. 6

Ans: – A , – A

. How can you apply exactly the same formatting you did to another text?
Options: a. Copy the text and paste in new location. Then type the new text again. b. Copy the text and click on Paste Special tool on new place c. Select the text then click on Format Painter and select the new text d. All of above

Ans:– C,– C

The most important advantage of a video disk is
Options: Compactness,    Potential capacity,    Durability,    Cost effectiveness


What switch would you use to view Smartdrive statistics?
Options: /x,    /e:,    /s,    /o:n

Ans:C ,C

When UPC is used, the price of the item is located
Options: on the item,    on the item and on the shelf,    in computer storage,    on the shelf and in computer storage

Ans:D ,D

If you delete the contents of NVRAM and reboot the router, what mode will you be in?
Options: Privileged mode,    Global mode,    Setup mode,    NVRAM loaded mode

Ans:C ,C

. After right click the field selector button, which do you choose to delete a field in design view?
Options: a. Delete field b. delete rows c. remove field d. remove rows

Ans:– b,– b

_____ write computer programs that perform jobs specified by the user.
Options: Programmer,    Data entry operator,    System Analyst,    Computer operator

Ans:A ,A

Which of the following way(s) the information system and capability are related to each other:
Options: improved processing speed,    increased volume of activities,    faster retrieval of information,    All of the above

Ans:D ,D

. Punched cards were first introduced by

Options: A) Powers B) Pascal C) Jacquard D) Herman Hollerith


. A(n) _______________ query makes changes to or moves records in a dynaset, in a single operation.
Options: a. select b. summary c. parameter d. action

Ans:3 – d ,3 – d

. The core of operating system is:
Options: a. Unix b. Kernel c. Command . com d. None of these

Ans:8 – b ,8 – b

A language which is close to that used within the computer is
Options: High-level language,    Assembly language,    Low-level language,    All of the above

Ans:C ,C

What will be the output of the program? #include<stdio.h> int main() { float a=0.7; if(a < 0.7f) printf("C\n"); else printf("C++\n"); return 0; }
Options: C,    C++,    Compiler error,    Non of above

Ans:B ,B

The total capacitive reactance of a parallel capacitor circuit is:
Options: equal to the sum 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 capacitance value of the smallest capacitor

Ans:C ,C

When using ODBC, which of the following serves as an intermediary between the application and the DBMS drivers?
Options: Data source,    Driver,    Driver manager,    OLE DB

Ans:C ,C

. What is placed to the left of horizontal scroll bar
Options: a. Tab stop buttons b. View buttons c. Split buttons d. Indicators

Ans:– B,– B

A periodic report can be used to
Options: identify the problem,    evaluate solutions,    identify solutions,    select solutions

Ans:A ,A

Which is another name for functional language?
Options: Machine,    Application language,    Low-level language,    High-level language

Ans:B ,B

“Ctrl + Home” is used to
Options: a. Moves the cursor to the beginning of Document b. Moves the cursor to the beginning of Line c. Moves the cursor to the beginning of Paragraph d. All of the above

Ans:–  A,–  A

. What is a light pen?
Options: Mechanical Input device B. Optical input device C. Electronic input device D. Optical output device

Ans: – B ,

A language which is close to that used within the computer is
Options: High-level language,    Assembly language,    Low-level language,    All of the above


The POST routine, which counts system board RAM first, is stored in:
Options: RAM,    microprocessor,    ROM BIOS,    CMOS

Ans:C ,C

Which of the following would be a logical first step in troubleshooting a PC?
Options: Check the computer CMOS,    Define the circumstances of the problem,    Call the vendor,    Define what applications are being used

Ans:B ,B

Columns dialog box can be opened from
Options:  A) Format menu Columns submenu, B) Double click on column space in ruler, C) Press Alt + O + C, D) All of above, 


All worksheet formula
Options: a. Manipulate values b. Manipulate labels c. Return a formula result d. Use the addition operator

Ans:#8211; c,#8211; c

Which of the following button will allow you to add, delete, or change records in your Data Source?
Options:  A) ‘Data Source’ button, B) ‘Edit’ button, C) ‘Edit Data Source’ button, D) ‘Data editing’ button,


.   Which of the following are types of sound files?
Options: a. LOG files b. DAT files c. WAV files d. DRV files

Ans:1 – C ,1 – C

Changes made periodically to a system, after its implementation, is known as system
Options: analysis,    design,    development,    maintenance

Ans:D ,D

Switches operates in which layer of the OSI model?
Options: Physical layer B. Data link layer C. Network layer D. Transport layer

Ans:B,Data link layer

After doing a low-level format, what would be the next step in configuring the hard drive in a system?
Options: Format DOS partition,    Install operating system,    Configure DMA channel and back-up interrupt,    Partition had disk

Ans:A ,A

Which of the following is TRUE about argv?
Options: It is an array of character pointers,    It is a pointer to an array of character pointers,    It is an array of strings,    None of above

Ans:A ,A

In LISP, the function evaluates both <variable> and <object> is
Options: set,    setq,    add,    eva

Ans:A ,A

. The title bar always displays on
Options: a. Top of the open windows b. Left side of the open window c. Right side of the open window d. All of above

Ans:3 – a ,3 – a

If you wanted to deny FTP access from network to network but allow everything else, which of the following command strings is valid?
Options: access-list 110 deny to network eq ftp access-list 111 permit ip any,    access-list 1 deny ftp any any,    access-list 100 deny tcp eq ftp,    access-list 198 deny tcp eq ftp access-list 198 permit ip any

Ans:D ,D

The computer industry uses prefixes of Greek origin to measure large amounts of data. Which term describes 1024 bytes.
Options: Kilobyte,    Megabyte,    Gigabyte,    Terabyte

Ans:A ,A

Doubling the number of turns of wire in an inductor:
Options: reduces the value of inductance by one-half,    multiplies the value of inductance by two,    multiplies the value of inductance by four,    reduces the value of inductance by one-fourth

Ans:C ,C

On a dot matrix printer, you should never lubricate which part?
Options: carriage rails,    printhead pins,    paper advance bearings,    carriage bearings

Ans:B ,B

. This is the menu command used to apply a design template in PowerPoint.
Options: a. Tools -> Slide Design b. Format -> Slide Design c. Insert -> Slide Design d. Insert -> Slide Design

Ans:7 – B ,7 – B

What will be the output of the program (sample.c) given below if it is executed from the command line? cmd> sample 1 2 3 cmd> sample 2 2 3 cmd> sample 3 2 3 /* sample.c */ #include<stdio.h> int main(int argc, char *argv[]) { printf("%s\n", argv[0]); return 0; }
Options: sample 3 2 3,    sample 1 2 3,    sample,    Error

Ans:C ,C

Insert Date, Format Page Number, and Insert AutoText are buttons on the _____ toolbar.
Options: a. Formatting b. Header and Footer c. Standard d. Edit

Ans:– B,– B

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

Ans:A ,A

In the following code what is 'P'? typedef char *charp; const charp P;
Options: P is a constant,    P is a character constant,    P is character type,    None of above

Ans:A ,A

What command is used with vi editor to move back to the beginning of a word?
Options: w,    e,    a,    b

Ans:D ,D

What is the name of the operating system which was originally designed by scientists and engineers for use by scientists and engineers?
Options: XENIX,    UNIX,    OS/2,    MS DOS

Ans:B ,B