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


******************************************************

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

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




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




More Database Systems Related questions:


. The date and time displays on
Options: a. Taskbar b. Status bar c. System tray d. Launch pad

Ans: c, c


A floppy disk contains
Options: Circular tracks only,    Sectors only,    Both circular tracks and sector,    All of the above

Ans:C ,C


In general, American buyers will purchase goods:
Options: that offer the best quality for the least money.,    that are made in America, even at higher costs.,    without regard to country of manufacturer.,    (a) and (c)

Ans:D ,D


. Internet Explorer is
Options: a. an Internet browser b. provided by Windows OS c. an access point for Word Wide Web d. All of above

Ans:7 – d ,7 – d


An entity name should be which of the following?
Options: A singular noun,    Specific to the organization,    Concise,    All of the above.

Ans:D ,D


In the system concepts, term Integration
Options: implies structure and order,    refers to the manner in which each component functions with other components of the system.,    means that parts of the computer system depend on one another.,    refers to the holism of systems

Ans:D ,D


Which of the following is a type of preventative maintenance used on a hard drive?
Options: Disk check diagnostics,    Head alignment diagnostics,    Initializing,    Uninstalling programs

Ans:A ,A


A memory that holds micro programs is
Options: Core memory,    ROM,    RAM,    Control memory

Ans:B,(Banswer


Several objectives are required to achieve a successful data base management program. These are availability of data, quality of data, and
Options: compatibility of data,    transmission of data,    desirability of data,    up-to-date data

Ans:D ,D


Research scientists all over the world are taking steps towards building computers with circuits patterned after the complex inter connections existing among the human brain's nerve cells. What name is given to such type of computers?
Options: Intelligent computers,    Supercomputers,    Neural network computers,    Smart computers

Ans:C ,C


What protocol is used between E-Mail servers?
Options: FTP,    SMTP,    SNMP,    POP3

Ans:B ,B


Devices on one network can communicate with devices on another network via a
Options: file server,    utility server,    printer server,    gateway

Ans:D ,D


. Formatting a cell in Number format you can’t set
Options: a. Decimal Places b. Use 1000 separator c. Negative numbers d. Currency Symbol

Ans:– d,– d


Suppose a current source has an Ideal current of 10 mA and an internal resistance of 20 MW. For what values of load resistance will the current source appear stiff?
Options: 20 k Ohm or more,    200 k Ohm or less,    200 k Ohm or more,    20 km or less

Ans:B ,B


Which of the following can you use to add times to the slides in a presentation?
Options: a. Slide show menu b. Rehearse timings button c. Slide transition button d. All of the above

Ans: – B , – B


Which term is not used to describe the memory component of a computer?
Options: ROM,    PROM,    RAM,    SAM

Ans:D ,D


Which of the following keys is used to replace a single character with new text?
Options: S,    s,    r,    C

Ans:B ,B


.   Special effects used to introduce slides in a presentation are called
Options: a. Effects b. Custom animations c. Transitions d. Preset animations

Ans:4 – C ,4 – C


Condensing output data to exhibit specific information is
Options: Calculating,    Recording,    Merging,    Summarising

Ans:D ,D


. The Cancel and Enter buttons appear in the:
Options: a. Title bar b. Formula bar c. Menu bar d. Sheet tabs

Ans:– b,– b


Which of the following are true regarding OSPF areas? You must have separate loopback interfaces configured in each area. The numbers you can assign an area go up to 65,535. The backbone area is also called area 0. If your design is hierarchical, then you don't need multiple areas. All areas must connect to area 0.
Options: 1 only,    1 and 2 only,    3 and 4 only,    3, 4 and 5

Ans:D ,D


. If you need to double underline a word, how will  you do that?
Options: a. Go to Format menu and then Font option. Open Underline Style and choose Double Underline b. From Format menu choose Font option and then from Font tab open Underline Style and select Double Underline c. Select the text then choose Format >> Font and on Font tab, open Underline Style and choose Double Underline d. Click double underline tool on formatting toolbar

Ans:– C,– C


Which of the following decides which systems development projects to work on first ?
Options: data diagram,    project dictionary,    systems flowcharts,    steering committee

Ans:A ,A


. Which of the following is an example of utility?
Options: a. Antivirus b. Word c. Operating system d. Data recovery

Ans:9 – a ,9 – a


What hardware architectures are not supported by Red Hat?
Options: SPARC,    IBM-compatible,    Alpha,    Macintosh

Ans:D ,D


In order to email a Word document from withing MS Word
Options: a. Office button >> Send to >> Mail Recipient b. Save the file as an email attachment c. Start Outlook and attach the file while open in Word d. This is an impossible operation

Ans:– A,– A


Using the following illustration, what would be the IP address of E0 if you were using the eighth subnet? The network ID is 192.168.10.0/28 and you need to use the last available IP address in the range. The zero subnet should not be considered valid for this question.
Options: 192.168.10.142,    192.168.10.66,    192.168.100.254,    192.168.10.143

Ans:A ,A


Convert the .BYTE h#F8 assembly language pseudo-ops into hexadecimal machine language:
Options: 0111EF,    03 16,    F8,    42 65 61 72

Ans:C ,C


The 7-bit ASCII code widely used
Options: For data communication work,    In IBM mainframe models,    For coding external memory,    In large machines produced by non-IBM vendors

Ans:A ,A


. Which of the following is extension of notepad?
Options: a. .txt b. .bmp c. .ppt d. .xls

Ans:9 – a ,9 – a


For a type 1 system, the steady-state:
Options: error for a step input is always zero,    error for a velocity input is always zero,    input for acceleration input is always non-zero,    (a) and (c)

Ans:D ,D


Which controller would support an external CD-ROM drive?
Options: ESDI,    ARLL,    MFM,    SCSI

Ans:D ,D


Which would you choose to create a bar diagram?
Options: Edit, Chart B. Insert, Chart C. Tools, Chart D. Format, Chart

Ans:– B ,


EBCDIC can code up to how many different characters?
Options: 8,    16,    32,    64

Ans:E,E


A brownout is defined as:
Options: a slightly elevated voltage lasting from seconds to minutes or more,    a slightly decreased voltage lasting from seconds to minutes or more,    complete power out lasting a few minutes,    alternating power out, power on lasting a few minutes

Ans:B ,B


You are connecting your access point and it is set to root. What does Extended Service Set ID mean?
Options: That you have more than one access point and they are in the same SSID connected by a distribution system.,    That you have more than one access point and they are in separate SSIDs connected by a distribution system.,    That you have multiple access points, but they are placed physically in different buildings.,    That you have multiple access points, but one is a repeater access point.

Ans:A ,A


Which of the following registers hold the information before it goes to the decoder
Options: control register,    data register,    accumulator,    address register

Ans:B,B


For every relationship, how many possible sets of minimum cardinalities are there?
Options: Two,    Three,    Four,    Six

Ans:C ,C


In an absolute loading scheme, which loader function is accomplished by assembler.
Options: Reallocation,    Allocation,    Linking,    Loading

Ans:A ,A


A constraint that does not, affect the feasible solution region is known as
Options: redundant constraint,    unbounded solution,    slack variable,    surplus variable

Ans:A ,A


hich of the following is true regarding page Orientation of a Document?
Options: Page Orientation can be change at any time B. Page Orientation of document determines by printer C. Page Orientation must be set before start typing D. Page Orientation of a document cannot be changed.

Ans:– A ,


Which of the following communications lines is best suited to interactive processing applications?
Options: narrowband channels,    simplex lines,    full-duplex lines,    mixed band channels

Ans:C ,C


. Serial access memories are useful in applications where
Options: A) Data consists of numbers B) Short access time is required C) Each stored word is processed differently D) Data naturally needs to flow in and out in serial form

Ans:2-D,2-D


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


If you want to keep track of different editions of a document which features will you use?
Options:  A) Editions, B) Versions, C) Track Change, D) All of above, 

Ans:-B,-B


In MS-Word, for what does ruler help?
Options: to set tabs B. to set indents C. to change page margins D. All of the above

Ans:– D ,


Which was the first commercial computer built by M.V. Wilkies.
Options: Super computer,    LEO,    Mainframe,    Micro computer

Ans:B ,B


How many bits are used in the data bus?
Options: 7,    8,    9,    16

Ans:B ,B


. An Excel Workbook is a collection of …….
Options: a. Workbooks b. Worksheets c. Charts d. Worksheets and Charts

Ans:– d,– d


A turnkey package includes
Options: software,    hardware,    training,    All of the above

Ans:D ,D

www.000webhost.com