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: 18222 | 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:


MRP stands for
Options: management resource planning,    marketing research planning,    manufacturing resource planning,    material requirements planning

Ans:D ,D


Which of the following is tactical decision?
Options: capital-source decision,    product decision,    plant-location decision,    budget allocation

Ans:D ,D


Which option allows you to select line, curve, freeform or scribble tools?
Options: a. Create effect b. Insert motion path c. Draw custom path d. All of the above

Ans: – C , – C


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

Ans:A ,A


In which area of the primary storage section are the intermediate processing results held temporarily?
Options: Input storage area,    Program storage area,    Output storage area,    Working storage space

Ans:D ,D


To _____ is to decide in advance on a course of action.
Options: master,    decision,    plan,    control

Ans:C ,C


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

Ans:D ,D


A secondary key is which of the following?
Options: Nonunique key,    Primary key,    Useful for denormalization decisions,    Determines the tablespace required

Ans:A ,A


. Which of the following is not a font style?
Options: a. Bold b. Italics c. Regular d. Superscript

Ans:– D,– D


Which of the following statements is a true statement concerning the open database connectivity standard (ODBC)?
Options: Each vendor desiring to be ODBC-complaint provides an ODBC driver.,    Requires certain criteria to be met in order to establish an ODBC connection.,    Provides a programming interface that provides a common language for application programs to access and process SQL databases independent of the RDBMS accessed.,    All of the above.

Ans:D ,D


. Which tool do you use to create a query object?
Options: a. Database wizard b. Simple filter wizard c. Simple query wizard d. Table query wizard

Ans:– c,– c


Memory
Options: is a device that performs a sequence of operations specified by instructions in memory.,    is the device where information is stored,    is a sequence of instructions,    is typically characterized by interactive processing and time-slicing of the CPU's time to allow quick response to each user.

Ans:B ,B


Which is used for manufacturing chips?
Options: Bus,    Control unit,    Semiconductors,    (a) and (b) only

Ans:C ,C


. Which control types is most often associated with a bound control?
Options: a. command button b. label c. text box d. list box

Ans:– c,– c


The first electronic general purpose digital computer built by Mauchly and Eckert called ENIAC did not work on the stored program principle. How many numbers could it store in its internal memory?
Options: 100,    20,    40,    80

Ans:B ,B


. The Stepped Reckoner was invented by

Options: A) John Napier B) William Oughtred C) Gottfried Leibnitz D) Blaise Pascal

Ans:C,C


When did John Napier develop logarithm?
Options: 1416 B. 1614 C. 1641 D. 1804

Ans:– B ,


A _____ Contains fields of data about one entity.
Options: Record,    File,    Fields,    Document

Ans:A ,A


. Which of the following terms is the most closely related to main memory?
Options: A) Non volatile B) Permanent C) Control unit D) Temporary

Ans:D,D


. Bit map terminal
Options: A) support display containing multiple window B) require considerable amount of video RAM C) requires tremendous amount of copying and hence low performance D) all of above

Ans:D,D


Which of the following are unary operators in C? 1. ! 2. sizeof 3. ~ 4. &&
Options: 1, 2,    1, 3,    2, 4,    1, 2, 3

Ans:D ,D


A device designed to read information encoded into a small plastic card is
Options: Magnetic tape,    Badge reader,    Tape puncher,    Card puncher

Ans:B,(Banswer


How many worksheets can a workbook have?
Options: 3 B. 8 C. 255 D. none of above

Ans:– D ,


The function of CPU is
Options: to provide a hard copy,    to read, interpret and process the information and instruction,    to communicate with the operator,    to provide external storage of text

Ans:B ,B


Electron current is flowing through a conductor in a direction you might describe as straight into this page. What is the direction of the resulting magnetic field?
Options: Clockwise,    Counterclockwise,    Out of this page,    Into this page

Ans:B ,B


The Enterprise tier of the three-tiered database architecture includes:
Options: managing the data.,    managing the User-system interface.,    processing HTTP protocol.,    processing scripting tasks.

Ans:A ,A


Strong AI is
Options: the embodiment of human intellectual capabilities within a computer.,    a set of computer programs that produce output that would be considered to reflect intelligence if it were generated by humans.,    the study of mental faculties through the use of mental models implemented on a computer.,    All of the above

Ans:A ,A


. which function will calculate the number of workdays between 6/9/2004 and 8/12/2004?
Options: a. Workday b. Date c. Networkdays d. All of the above

Ans:– d,– d


In order to increase the amount of memory available for a system, what is the maximum size of a swap partition (with kernel version 2.2.x)?
Options: 2GB,    128MB,    64MB,    32MB

Ans:A ,A


A __________ enables you to view data from a table based on a specific criterion
Options: a. Form b. Query c. Macro d. Report

Ans:ndash; b,ndash; b


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

Ans:c,c


. The command center of access file that appears when you create or open the MS Access database file.
Options: a. Database window b. Query window c. Design view window d. Switchboard

Ans:8 – a ,8 – a


Excel probably considers the cell entry January 1, 2000 to be a
Options: a. Label b. Value c. Formula d. Text string

Ans:#8211; b,#8211; b


Which monitor would provide the highest level of performance?
Options: VGA,    XGA,    CGA,    SVGA

Ans:D ,D


The three dimensions of system integrity do not include
Options: accuracy,    completeness,    security,    appropriateness

Ans:B ,B


. The most recent version of MAC OS is based on the ... operating system
Options: a. Windows b. Linux c. Unix d. CMOS

Ans: c, c


The accuracy of a pick-and-place robot can be as good as:
Options: + 0.0005 inches,    + 0.05 inches,    0.008 inches,    + 3%

Ans:A ,A


Which layer of OSI determines the interface of the system with the user?
Options: Network,    Application,    Data-link,    Session

Ans:B ,B


Software in computer
Options: A) Enhances the capabilities of the hardware machine B) Increase the speed of central processing unit C) Both of above D) None of above

Ans:-A,-A


Which of the following statements is true concerning subqueries?
Options: Involves the use of an inner and outer query.,    Cannot return the same result as a query that is not a subquery.,    Does not start with the word SELECT.,    All of the above.

Ans:A ,A


The basic unit of measurement for resistance is the:
Options: volt,    ampere,    ohm,    watt

Ans:C ,C


. Which feature is used to replace straight quotes with smart quotes as you type?
Options: Auto Correct as you type B. Auto Change as you type C. Auto Format as you type D. Smart Tags as you type

Ans:– C ,


  Which of the following methods will not enter data in a cell?
Options: Pressing the Esc key B. Pressing an arrow key C. Pressing the tab key D. Clicking the enter button to the formula bar

Ans:– A ,


A distributed data processing configuration in which all activities must pass through a centrally located computer is called a:
Options: ring network,    spider network,    hierarchical network,    data control network

Ans:B ,B


Which of the following is the oldest spreadsheet package?
Options: a. VisiCalc b. Lotus 1-2-3 c. Excel d. StarCalc

Ans:#8211; a,#8211; a


Addressing modes
Options: defines the fundamental method of determining effective operand addresses,    are variations in the use of fundamental addressing structures, or some associated actions which are related to addressing.,    performs indicated operations on two fast registers of the machine and leave the result in one of the registers.,    all of the above

Ans:B ,B


The systems conversion technique of totally removing the existing system and immediately implementing the new system is called as
Options: crash conversion,    phased conversion,    pilot conversion,    parallel run

Ans:A ,A


A bidirectional feedback loop links computer modelling with:
Options: artificial science,    heuristic processing,    human intelligence,    cognitive science

Ans:D ,D


The ability of a computer system to remain operational despite various failures is
Options: Relation,    Schema,    Resilience,    Versatility

Ans:C ,C


The punched card used in the IBM System/3 contains
Options: 80 columns,    120 columns,    96 columns,    126 columns

Ans:C ,C

www.000webhost.com