A type of query that is placed within a WHERE or HAVING clause of another query is called


Options: Super query B. Sub query C. Master query D. Multi-query

Ans:– B ,


Description: mcqquestions

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

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


Because it contains a description of its own structure, a database is considered to be ________ .
Options: described,    metadata compatible,    self-describing,    an application program

Ans:C ,C


A computer with CPU speed around 100 million instructions per second & with the word length of around 64 bits is known as
Options: Super computer,    Mini computer,    Micro computer,    Micro computer

Ans:A ,A


What is meant by a dedicated computer?
Options: Which is used by one person only,    Which is assigned one and only one task,    Which uses on kind of software,    Which is meant for application software only

Ans:B,B


. Which one is the largest space?
Options: A) kilobyte B) petabyte C) terrabyte D) gigabyte

Ans:B,B


Which one of the following statements is true for the voltage in a parallel RC circuit?
Options: The voltage always has the same amplitude and phase for every part of the circuit,    The total voltage is equal to the sum of the voltages across the resistance and capacitance,    The total voltage leads the total current by less than 90 degree,    The total voltage is less than the sum of the voltages across the resistance and capacitance

Ans:A ,A


. To start Microsoft PowerPoint application
Options: a.  Click on Start >> Programs >> All Programs >> Microsoft PowerPoint b.  Hit Ctrl + R then type ppoint.exe and Enter c.  Click Start >> Run then type powerpnt then press Enter d.  All of above

Ans:1 – C ,1 – C


Which of the following is requirement to develop a successful management information system?
Options: a staff of technical specialists with the skills necessary to develop the computer based parts of the system,    the development of a short-range goal for the system,    the development of a long-range goal for the system,    a commitment from management to allocate the personnel and resources necessary to get the job done

Ans:E ,E


68. Uppercase on Change Case dialog box and All Caps on Fonts dialog box both converts selected text into Capital Letters. What’s the difference between the two?
Options: a. Both are same. They are only two different ways of capitalize text. b. It is faster to convert from Change Case than from Font dialog box c. Change Case makes conversion permanent but All Caps on Font can always be reverted d. All Caps on Font dialog box makes the change permanent where Change Case can be always reverted

Ans:– C ,– C


. Ctrl + N
Options: Save Document B. Open Document C. New Document D. Close Document

Ans:– C ,


Which file transfer protocol uses UDP?
Options: NFS,    TELNET,    TFTP,    FTP

Ans:C ,C


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

Ans:B ,B


.  Which of the following syntax is correct regarding to SUM function in Excel?
Options: a. =SUM (A1, B1) b. =SUM (A1:B9) c. =SUM (A1:A9, B1:B9) d. All of the above

Ans:– d,– d


The ALU of a computer responds to the commands coming from
Options: primary memory,    control section,    external memory,    cache memory

Ans:B ,B


Which menu do you choose to create footer? (in MS Office 2003)
Options: format, header and footer B. view, footer C. insert, header and footer D. view, header and footer

Ans:– D ,


What do the following declaration signify? int *ptr[30];
Options: ptr is a pointer to an array of 30 integer pointers.,    ptr is a array of 30 pointers to integers.,    ptr is a array of 30 integer pointers.,    ptr is a array 30 pointers.

Ans:B ,B


The effect applied to display when slides changes in slide show view is
Options: a. Slide Animation b. Custom Animation c. Custom Transition d. Slide Transition

Ans: – D , – D


How can you print three copies of a workbook?
Options: a. Select File>Properties form the menu and type 3 in the Copies to print text box. b. Select File >Print from the menu and type 3 in the Number of copies text box. c. Click the Print button on the standard toolbar to print the document then take it to Kinko’s and have 2 more copies made d. Press Ctrl+P+3

Ans:8211; b,8211; b


A register in which of the following that holds the current instruction while it is being executed is called instruction register.
Options: ALU,    CPU,    Memory,    Address

Ans:B ,B


An inventory management system should answer the questions
Options: what and why,    when and how much,    who and why,    where and when

Ans:B ,B


When you are testing a fuse, you should set the Volt-OHM meter to what scale?
Options: AC,    DC,    AMPS,    OHMS

Ans:D ,D


To reconstruct a system, which of the following key element(s) must be considered :
Options: feedback and environment,    control and processors.,    outputs and inputs,    All of the above

Ans:D ,D


A periodic report can facilitate management by exception by
Options: including complete alphabetic descriptions for each numeric entry,    including only those transactions that fall within predetermined limits of acceptable performance,    consolidation of multiple transactions into a summary form,    comparing actual performance with acceptable standards

Ans:D ,D


A device mounted on a communication satellite which receives, amplifies and re-transmits signals from earth station is
Options: Track,    Transponder,    Transistor,    Terminal

Ans:B ,B


. Getting data from a cell located in a different sheet is called….
Options: a. Accessing b. Referencing c. Updating d. Functioning

Ans:– b,– b


With an IP address starting at 200, you currently have 10 subnets. What subnet mask should you use to maximize the number of available hosts?
Options: 192,    224,    240,    248

Ans:C ,C


Telecommunications networks come in a wide range of speed and capacity capabilities. Select the best fit for answer:
Options: Bandwidth alternatives,    Switching alternating,    Inter organizational networks,    Extranets

Ans:A ,A


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


A tuple is a(n):
Options: column of a table.,    two dimensional table.,    row of a table.,    key of a table.

Ans:C ,C


What is the shortcut key for “Font ” dialog box?
Options: Ctrl + F B. Ctrl + D C. Ctrl + G D. None of the above

Ans:– B ,


In analyzing the compilation of PL/I program, the term "Syntax analysis" is associated with
Options: recognition of basic syntactic constructs through reductions,    recognition of basic elements and creation of uniform symbols,    creation of more optional matrix,    use of macro processor to produce more optimal assembly code

Ans:A ,A


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

Ans:C ,C


What was the name of the first stored program electronic computer which was built in 1949 at Cambridge University in England?
Options: EDVAC,    EDSAC,    UNIVAC,    MARK-I

Ans:B ,B


Which of the following is considered to be the destination host before translation?
Options: Inside local,    Outside local,    Inside global,    Outside global

Ans:B ,B


A data warehouse is which of the following?
Options: Can be updated by end users.,    Contains numerous naming conventions and formats.,    Organized around important subject areas.,    Contains only current data.

Ans:C ,C


The brain of any computer system is
Options: A) ALU B) Memory C) CPU D) Control unit

Ans:C,C


What will be the output of the program? #include<stdio.h> int main() { typedef float f; static f *fptr; float fval = 90; fptr = &fval; printf("%f\n", *fptr); return 0; }
Options: 9,    0,    90.000000,    90

Ans:C ,C


Benchmarking is used
Options: to select computer systems,    to maintain files in up-to-data condition,    for application proto-typing,    for system acceptance

Ans:A ,A


Four basic elements are required for an automated machine tool or production process. They are: input interface, memory, output interface and:
Options: logic,    software,    NC tape programming,    computer graphics workstation

Ans:A ,A


What is the standard protocol for network management features?
Options: SNA,    FTP,    SNMP,    SMS

Ans:C ,C


A printed document reader which scans the characters and then encodes them in a computer-compatible code for direct transmission to the computer is called
Options: Optical character reader,    Kurzweil Data Entry Machine (KDEM),    MICR,    Laser scanner

Ans:B ,B


. Most of the inexpensive personal computers do not have any disk or diskette drive. What is the name of such computes?

Options: A) Home computers B) Diskless computers C) Dedicated computers D) General purpose computers

Ans:B,B


. Which of the following are the two main components of the CPU?
Options: A) Control Unit and Registers B) Registers and Main Memory C) Control unit and ALU D) ALU and bus

Ans:C,C


. Which data type is better to use for storing the price of an item?
Options: a. Text b. AutoNumber c. Number d. Currency

Ans:– d,– d


Data collection terminals
Options: track the flow of materials from one production area to another,    record employee attendance,    record start and stop of production steps,    All of the above

Ans:D ,D


CBCT stands for
Options: Customer Bank Credit Terminal,    Commercial Banking Credit Terminal,    Customer-Bank Communication Terminal,    Commercial Bank Communication Terminal

Ans:C ,C


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


RTS stands for:
Options: ready to start,    ready to switch,    request to send,    request to scan

Ans:C ,C


. Which of the following methods can not be used to enter data in a cell?
Options: a. Pressing an arrow key b. Pressing the tab key c. Pressing the Esc key d. Clicking the enter button to the formula bar

Ans:– c,– c


Microfilm reader is a
Options: OCR device,    COM device,    MICR device,    None of the above

Ans:B ,B


System prototyping helps the designer in
Options: making the programmers understand how the system will function.,    communicating to the user, quickly, how the system, when developed, will look like and get a feedback.,    giving a demo of the software, to the system manager to whom he reports,    both (a) and (b)

Ans:B ,B

www.000webhost.com