. Which of the following in not Outer join?


Options: Left outer join B. Right outer join C. Full outer join D. All of the above

Ans: – D ,


Description: mcqquestions

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

Hits Today: 17175 | 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 term Incomplete for a UML has the same meaning as which of the following for an EER diagram?
Options: Overlapping rule,    Disjoint rule,    Total specialization rule,    Partial specialization rule

Ans:D ,D


A Processor
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 of the CPU's time to allow quick response to each user.

Ans:A ,A


Nonmodifiable procedures are called
Options: serially usable procedures,    concurrent procedures,    reentrant procedures,    topdown procedures

Ans:C ,C


What will be the output of the program ? #include<stdio.h> int main() { enum days {MON=-1, TUE, WED=6, THU, FRI, SAT}; printf("%d, %d, %d, %d, %d, %d\n", ++MON, TUE, WED, THU, FRI, SAT); return 0; }
Options: -1, 0, 1, 2, 3, 4,    Error,    0, 1, 6, 3, 4, 5,    0, 0, 6, 7, 8, 9

Ans:B ,B


. In a table, ______(s) are displayed in the order in which they were entered. Most often this order is not useful.
Options: a. formula b. format c. layout d. record

Ans:3 – d ,3 – d


If the processor of a computer does not have a direct and unassisted access to data items, these items are said to be
Options: offline,    remote,    disconnected,    detached

Ans:A ,A


How many devices can be used on a single SCSI bus? Keep in mind that the SCSI host adapter counts as a device.
Options: 1,    8,    20,    10

Ans:B ,B


. Which of the following class of computers can not support multiple users simultaneously?

Options: A) Mainframe Computer B) Mini Computers C) Micro Computers D) All of them can support

Ans:C,C


Which command is used to suppress the prompt that asks you to confirm that you want to delete the directory?
Options: DELTREE,    DELTREE/F,    DEL*.*,    ERASE *.*

Ans:B ,B


The reliability life cycle of a product:
Options: has three distinct rates of failure,    cannot be predicted,    All of the above,    stays constant with environmental conditions

Ans:A ,A


What is the default number of lines to drop for drop cap?
Options:  A) 3, B) 10, C) 15, D) 20,

Ans:-A,-A


An example of a global allocation problem is
Options: defining plant capacities,    scheduling an entire development project,    setting general inventory guidelines,    All of the above

Ans:D ,D


What is the recommended way to fix the registry description for the printer driver
Options: Delete the spool file,    Run regedit.exe and remove any reference to the printers,    Run sysedit.exe and remove any reference to the printers,    Remove the printer driver and re¬install it

Ans:D ,D


What will be the output of the program? #include<stdio.h> #include<string.h> int main() { char *s; char *fun(); s = fun(); printf("%s\n", s); return 0; } char *fun() { char buffer[30]; strcpy(buffer, "RAM"); return (buffer); }
Options: 0xffff,    Garbage value,    0xffee,    Error

Ans:B ,B


The Microsoft Access wildcards are ____ and ____ .
Options: asterisk (*); percent sign (%),    percent sign (%); underscore (_),    underscore(_); question mark (?),    question mark (?); asterisk (*)

Ans:D ,D


The way of thinking that might facilitate attainment of a single, integrated information system is the
Options: marketing concept,    marketing mix,    marketing grid,    marketing matrix

Ans:A ,A


. Which menu provides you options like Animation Scheme, custom Animation, Slide Transition?
Options: a.  Insert Menu b.  Format Menu c.  Tools Menu d.  Slide Show Menu

Ans:8 – D ,8 – D


Data Manipulation Language enables users to
Options: Retrieval of information stored in database B. Insertion of new information into the database C. Deletion of information from the database D. All of the above

Ans:– D ,


In Bourne shell, which file sets the Unix environment for the user when the logs into his HOME directory.
Options: .exrc,    .profile,    lastlogin,    .mbox

Ans:B ,B


Which of the following is not a characteristic of good test data
Options: users do not participate at this preliminary stage,    should be comprehensive,    every statement should be executed,    All of the above

Ans:A ,A


Which of the following would be good reasons to run NAT? You need to connect to the Internet and your hosts don't have globally unique IP addresses. You change to a new ISP that requires you to renumber your network. You don't want any hosts connecting to the Internet. You require two intranets with duplicate addresses to merge.
Options: 1, 2 and 4,    2 and 4,    3 only,    All of the above

Ans:A ,A


In a transistor operates at the middle of the load line, an increase in the base resistance will move the Q point
Options: down,    up,    nowhere,    off the load line

Ans:A ,A


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


Which of the following activities, does not belong to the Implementation phase of the SDLC?
Options: File conversion,    Program testing,    User training,    All of the above

Ans:B ,B


. The magnetic storage chip used to provide non-volatile direct access storage of data and that have no moving parts are known as
Options: A) Magnetic core memory B) Magnetic tape memory C) Magnetic disk memory D) Magnetic bubble memory

Ans:D,D


When installing a SCSI CD-ROM drive, you must set the CD-ROM SCSI adapter to:
Options: B0007,    An unused SCSI address,    The same address as the SCSI device before the CD-ROM,    SCSI ID=1

Ans:B ,B


The acronym HDI stands for:
Options: Half duplex interface,    Hard disk interface,    Head to disk interference,    Help desk interference

Ans:D ,D


Long-range planning reports produced in an MIS are primarily designed for:
Options: top management,    middle management,    lower management,    both (a) and (c)

Ans:A ,A


There can be many ways to insert page number in a document. Which of the following lets you insert page number
Options:  A) Page number from Insert menu, B) Page Setup from file menu, C) Footnote from Insert menu, D) Both a & c, 

Ans:A,A


.Which of the following data structure is linear data structure?
Options: A)Trees b.Graphs c.Arrays d.None of above

Ans:C,C


The truth table for an S-R flip-flop has how many VALID entries?
Options: 3,    1,    4,    2

Ans:A ,A


A functional dependency between two or more non-key attributes is called
Options: Transitive dependency B. Partial transitive dependency C. Functional dependency D. Partial functional dependency

Ans:– A ,


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


An AI system developed by Daniel Bobrow to read and solve algebra word problems
Options: SHRDLU,    SIMD,    BACON,    STUDENT

Ans:D ,D


. After entering all fields required for a table, if you realize that the third field is not needed, how will you remove?
Options: a. You need to delete the whole table. There is no method to remove a particular field only. b. Delete all the fields from third downwards and reenter the required fields again. c. Select the third column in datasheet view then delete d. Select the third row in table design view then delete

Ans:3 – d ,3 – d


Computer memory consists of
Options: RAM,    ROM,    PROM,    All of the above

Ans:D ,D


An Access database object that is used to enter, view or edit records
Options: a. Table b. Form c. Query d. Report

Ans:ndash; b,ndash; b


Detailed project control answers the questions
Options: when and how much?,    who and why?,    when and where?,    who and when?

Ans:D ,D


In Microsoft PowerPoint the entry effect as one slide replaces another in a show is called a (an)
Options: a. animation b. slide transition c. custom animation d. preset animation

Ans: – B , – B


A path by which communication is achieved between a central processor and other devices is called
Options: Audit trail,    Network,    Bus,    Channel

Ans:C ,C


. Which device is required for the Internet connection?

Options: A) Joystick B) Modem C) CD Drive D) NIC Card

Ans:B,B


. 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


The educational program can be conducted by
Options: personnel department instructors,    members of the information systems staff,    supervisors,    All of the above

Ans:D ,D


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


Which of the following is not a computer bus?
Options: data bus,    timer bus,    control bus,    address bus

Ans:B ,B


Timing using a TM990 micro¬computer:
Options: require an external timer added by the user,    is available on the standard CPU board,    can be handled in software,    both (b) and (c)

Ans:D ,D


Which kind of storage device can be carried around?
Options: Floppy disk,    Hard disk,    System cabinet,    Hard disk drive

Ans:A ,A


A device used to bring information into a computer is
Options: ALU,    Input device,    Control unit,    Output device

Ans:B ,B


What command is used to display the characteristics of a process?
Options: au,    ps,    du,    pid

Ans:B ,B


The steady-state error is:
Options: independent of the type of input,    a function of the transient response,    zero for all inputs to type 1 systems,    decreased by increasing gain.

Ans:D ,D

www.000webhost.com