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


. You created a query with two tables that have relationship of One-To-Many with referential rules applied. The first table has 3 records and the second has 8. With using a right outer join, how many records will the resulting recordset have?
Options: a. 5 b. 8 c. 24 d. Not enough information to tell

Ans:9 – c ,9 – c


What is route poisoning?
Options: It sends back the protocol received from a router as a poison pill, which stops the regular updates.,    It is information received from a router that can't be sent back to the originating router.,    It prevents regular update messages from reinstating a route that has just come up.,    It describes when a router sets the metric for a downed link to infinity.

Ans:D ,D


In DOS, which of the following keys will bypass the CONFIG.SYS and AUTOEXEC.BAT files?
Options: F8,    F5,    F4,    Fl

Ans:B ,B


. Which electronic component was made out of semiconductor material?
Options: A) Vacuum tubes B) Transistors C) Ics D) All of above

Ans:C,C


Which of the following method is used the results of a design analysis as a base for redesign decisions?
Options: The iterative design method,    The direct method,    The design selection method,    All of the above

Ans:A ,A


A modem that is attached to the telephone system by jamming the phone's handset into two flexible receptacles in the coupler?
Options: gateway,    bridge,    acoustic coupler,    time-division multiplexer

Ans:C ,C


Which of the following is not applications software?
Options: Word processing,    Spreadsheet,    UNIX,    Desktop publishing

Ans:C ,C


The section of the CPU that selects, interprets and sees to the execution of program instructions
Options: Memory,    Register unit,    Control unit,    ALU

Ans:C ,C


What command is used with vi editor to replace text from cursor to right
Options: S,    s,    R,    r

Ans:C ,C


The outstanding Invoice file should be stared on a Pardon Access Storage Device if
Options: invoice data entry is on-line.,    payment recording is done in a batch rode,    inquires concerning payable are to be answered on-line,    last record points to the first record

Ans:C ,C


Which approach to speech recognition avoids the problem caused by the differences in the way words are pronounced according to context?
Options: continuous speech recognition,    connected word recognition,    isolated word recognition,    speaker-dependent recognition

Ans:C ,C


In MS-DOS 5.0, which is the number that acts as a code to uniquely identify the software product?
Options: MS,    DOS,    MS DOS,    5.0

Ans:D ,D


In an Entity-Relationship Diagram “Ellipses” represents
Options: Attributes B. Weak entity set C. Relationship sets D. Multi-valued attributes

Ans:– A ,


In OLAP, we are interested in ________ .
Options: levels only,    dimensions only,    measures only,    measures and dimensions

Ans:D ,D


. How to change row height in Word 2010?
Options: Edit Table from the Layout ribbon, select Row tab B. Properties from the Layout ribbon, select Row tab C. Edit Height from the Design ribbon, select Row tab D. Row Height from the Table ribbon, select Row tab

Ans:– B ,


Skipping every other line and picking up the skipped lines on the second pass is called:
Options: interlacing,    refresh-vector,    raster-scan,    stroke writing

Ans:A ,A


Advantages of robots include:
Options: increased productivity,    ability to withstand hazardous environments,    good return on investment and better company image,    All of the above

Ans:D ,D


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

Ans:A ,A


. When using the MLA style, position explanatory notes either at the _____.
Options: a. top of the page as head notes or at the end of the paper as endnotes b. bottom of the page as footnotes or at the end of the paper as endnotes c. top of the page as head notes or at the beginning of the paper as front notes d. bottom of the page as footnotes or at the beginning of the paper as front notes

Ans: – B , – B


The Internet is an example of
Options: Cell switched network B. circuit switched network C. Packet switched network D. All of above

Ans:– C ,


. Which of the following is not a micro computer?
Options: A) Laptop PCs B) Tablet PCs C) Desktop PCs D) None of above

Ans:D,D


Which of the following are(is) Language Processor(s)
Options: assembles,    compilers,    interpreters,    All of the above

Ans:D ,D


Which of the following can be Software?
Options: Routers B. Firewalls C. Gateway D. Modems

Ans:– B ,


One of a class of storage devices that can access storage locations in any order is
Options: DTE,    DASD,    DDE,    DDC

Ans:B ,B


When seeking to upgrade for a particular motherboard what do you need to know?
Options: memory,    hard drive,    make & model,    dimm

Ans:C ,C


Which of the following would not be a major deliverable of the structured systems analysis phase.
Options: data dictionaries,    data flow diagrams,    entity relationship diagrams,    prototype model

Ans:D ,D


Indicate whether the statement LDA B is a statement, in
Options: Machine language,    Assembly language,    High level language,    All of the above

Ans:B ,B


Top Management is more interested in
Options: day-to-day operations,    strategic decisions,    tactical decision,    both b and c

Ans:D ,D


Everything computer does is controlled by its
Options: RAM,    ROM,    CPU,    Storage devices

Ans:C ,C


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


Bubble memory is a
Options: Sequential access device only,    Direct access device only,    Combination of sequential and direct access devices,    All of the above

Ans:C ,C


The brain of any computer system is
Options: ALU,    Memory,    CPU,    Control unit

Ans:C,(Canswer


. Which command is used to copy files?
Options: a. Copy b. Diskcopy c. Type d. All of the above

Ans:Correct Answer: a ,Correct Answer: a


Binary search algorithm can not be applied to
Options: a. sorted linked list b. sorted binary trees c. sorted linear array d. pointer array  

Ans:a,a


. The category of operating system that you most likely have running on your PDA computer is a_________Operating system
Options: a. Real time b. Single user, single task c. Single user, multitask d. Multiuser, multitask

Ans:5 – b ,5 – b


A computer has no more sense than a light
Options: bulb,    pen,    switch,    pad

Ans:C ,C


How many times "IndiaBIX" is get printed? #include<stdio.h> int main() { int x; for(x=-1; x<=10; x++) { if(x < 5) continue; else break; printf("IndiaBIX"); } return 0; }
Options: Infinite times,    11 times,    0 times,    10 times

Ans:C ,C


6. Which of the following statements is true in regard to diskcopy?
Options: a. Copy and discopy are same b. Discopy is a built in command in dos c. Diskcopy can be used on hard disks d. Diskcopy can be used with a floppy and a hard disk

Ans:Correct Answer: c,Correct Answer: c


A 32 bit microprocessor has the word length equal to
Options: 2 bytes,    32 bytes,    4 bytes,    8 bytes

Ans:C ,C


The invention of the slide rule is attributed to
Options: Babbage,    Oughtred,    Pascal,    Napier

Ans:B ,B


A system program that sets up an executable program in main memory ready for execution is
Options: assembler,    linker,    loader,    compiler

Ans:C ,C


. What is the shortcut key to insert new sheet in current workbook?
Options: F11 B. Alt + F11 C. Ctrl + F11 D. Shift + F11

Ans:– D ,


Every table in relational database contain a field or combination of fields that can uniquely identify each records, it is called
Options: a. Foreign key b. Native key c. Composite key d. Primary key

Ans:ndash; d,ndash; 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


. _____ formatting is the process of changing the way letters, numbers, punctuation marks, and symbols appear on the screen and in print.
Options: a. Document b. Character c. Paragraph d. Object

Ans:– B,– B


. We can replace a font on all sides with another font using the option :
Options: a. Edit –> Fonts b. Tools –> Fonts c. Tools -> Replace Fonts d. Format -> Replace Fonts

Ans:1 – D ,1 – D


If you write criteria values vertically (one in a row) it will mean
Options: a. OR conditions b. AND conditions c. NOT condition d. None of above

Ans:ndash; a,ndash; a


. A(n) _____ is an image control that displays in the background of a page on a form or report.
Options: a. legend b. icon c. logo d. watermark

Ans:9 – d ,9 – d


. In Datasheet View, new records are added to a table ____.
Options: a. in alphabetical order b. at the end of the table c. at the beginning of the table d. in numerical order

Ans:7 – b ,7 – b


Which of the following devices could be part of a sensor?
Options: thermometer,    brake,    relay,    clutch.

Ans:A ,A

www.000webhost.com