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 ,

Description: mcqquestions

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

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

What component would most likely cause a "parity error"?
Options: bad hard disk,    bad controller,    bad RAM,    bad software

Ans:C ,C

Ambiguity may be caused by:
Options: syntactic ambiguity,    multiple word meanings,    unclear antecedents,    All of the above

Ans:D ,D

What form of energy is used to maintain an imbalance of charges between the terminals of a battery?
Options: Electronical energy,    Mechanical energy,    Chemical energy,    Solar energy

Ans:C ,C

You should save your computer from?
Options: a. Viruses b. Time bombs c. Worms d. All of the above


A customer has just installed a new cd-rw. the system was working fine before the installation, but now the cdrom does not work, what should you suggest that the customer do?
Options: flash or upgrade the BIOS,    check the CONFIG.SYS,    add cdrw in the device manager,    check the jumper setting on the cd-rw

Ans:D ,D

The Paste Special command lets you copy and paste:
Options: a. Multiply the selection by a copied value b. Cell comments c. Formatting options d. The resulting values of a formula instead of the actual formula

Ans:#8211; d,#8211; d

A dialog box with a bomb appears oh a Macintosh screen. What type of problem has occurred?
Options: A RAM problem,    A software problem,    A ROM problem,    An ADB problem

Ans:B ,B

. In MS Word, Ctrl+S is for …..
Options: a. Scenarios b. Size c. Save d. Spelling Check

Ans:–  C,–  C

What is the shortcut key to Close Active Document in Microsoft Word?
Options: Ctrl + F4 B. Shift + F4 C. Ctrl + Shift + F4 D. None of above

Ans:– A ,

A communications medium that uses pulses of laser light in glass fibers. Select the best fit for answer:
Options: Fiber optic cables,    Cellular phone systems,    Telecommunications processors,    Telecommunications software

Ans:A ,A

A dielectric material is:
Options: a good conductor,    a good insulator,    a poor conductor of electrostatic fields,    a good conductor of magnetic fields

Ans:B ,B

With respect to personnel matters in the United States, ERISA stands for
Options: Earnings and Revenue Information System Administration,    Early Retirement Income Standards Act,    Employee Review-in-Service Administration,    Employee Retirement Income Security Act

Ans:D ,D

. Which is NOT a method of creating a table?
Options: a. Datasheet View b. Design View c. Layout View d. Template

Ans:3 – c ,3 – c

To be successful in implementing DSS, organizations should have the following characteristics except:
Options: a well-controlled data-processing system,    willingness to commit dollars and personnel to the project.,    education and training by the organization,    powerful central computer groups to initiate and manage system projects

Ans:D ,D

What do the following declaration signify? char **argv;
Options: argv is a pointer to pointer.,    argv is a pointer to a char pointer.,    argv is a function pointer.,    argv is a member of function pointer.

Ans:B ,B

What software packages are commonly used for businesses that have to track extensive lists of clients and inventory?
Options: Special purpose packages,    Custom made programs,    Single function application packages,    Data management packages

Ans:D ,D

. A(n) __________ is an Extensible Scheme Standard file that is an approved W3C standard design as a basic infrastructure.
Options: a. HTML b. XML c. XSD d. XSL

Ans:7 – c ,7 – c

    Which command lists the contents of current directory of a disk
Options: a.    Copy b.    Tree c.    Cd d.    Dir

Ans:D,Correct Answer: Dir

. Which of the following database objects extracts information from one or more tables or queries?
Options: a. Forms b. Queries c. Reports d. Tables

Ans:8 – b ,8 – b

In LISP, the function (endp <list>)
Options: returns a new list that is equal to <list> by copying the top-level element of <list>,    returns the length of <list>,    returns t if <list> is empty.,    All of the above

Ans:C ,C

Locations in the main memory of a computer are called
Options: Alphabets,    Words,    Data,    Characters

Ans:B ,B

Data manipulation language (DML)
Options: describes how data are structured in the data base,    specifies for the DBMS what is required; the techniques used to process data,    determine how data must be structured to produce the user's view,    All of the above

Ans:B ,B

Two files may be joined into a third file if
Options: they have a row in common,    they have a field in common,    they have no records with the same value in the common field,    both (b) and (c)

Ans:B ,B

An EOQ formula is an example of a(n)
Options: optimizing model,    static model,    deterministic model,    All of the above

Ans:D ,D

_____ means that the manager spends his or her time dealing with exceptions or those situations which are out of control
Options: relevant,    management by exception,    predictive reports,    control

Ans:B ,B

You wished to justify text over the height of paper, which option will you choose
Options:  A) Page Setup from File menu, B) Paragraph from Format menu, C) From formatting toolbar, D) Font from Format menu, 


What is the main purpose of the secondary storage device?
Options: To increase the speed of Computer B. To Install Operating System C. To Networking D. To Store Data

Ans:– D ,

Point out the error in the program? struct emp { int ecode; struct emp e; };
Options: Error: in structure declaration,    Linker Error,    No Error,    None of above

Ans:A ,A

Which of the following is not a quotation system procedure set?
Options: delivery planning,    product data retrieval,    quotation preparation,    all of the above

Ans:A ,A

How many copies of a JSP page can be in memory at a time?
Options: One,    Two,    Three,    Unlimited

Ans:A ,A

. How many margins sare there on a page?
Options: a. Two (header and footer) b. Four (top, bottom, right and left) c. Two (landscape and portrait) d. Four (center, top, left and bottom)

Ans: – B , – B

Which is a unit representing the no bits of discrete.
Options: Baud,    Byte,    Bit,    All of the above


87. Which of the following is not available in Font Spacing?
Options: a. Normal b. Loosely c. Condensed d. Expanded

Ans:– B ,– B

. Excel displays the current cell address in the ……….
Options: a. Formula bar b. Status Bar c. Name Box d. Title Bar

Ans:– c,– c

Which command displays the configuration register setting?
Options: show ip route,    show boot version,    show version,    show flash

Ans:C ,C

During the laser printer's conditioning phase a uniform charge of _____ is placed on the photosensitive drum.
Options: +1000 volt,    +600 volts,    -600 volts,    -1000 volts

Ans:C ,C

A battery is a device composed of one or more:
Options: chemical cells,    voltage generators,    solar cells,    piezoeletric cells

Ans:A ,A

Which of the following hardware components is the most important to the operation of a database management system?
Options: high-resolution video display,    printer,    high speed, large-capacity disk,    plotter

Ans:C ,C

If you see a diskette with a piece of foil covering its notch, it is said to be
Options: write-protected,    copy-protected,    write-enabled,    foil-covered

Ans:A ,A

. In a query, using the keyword _______________ will return records in which the field value is between two numbers.
Options: a. Between b. Is Null c. Like d. Not

Ans:7 – a ,7 – a

Which of the following data constraints would be used to specify that the value of a cell in one column must be less than the value of a cell in another column in the same row of the same table?
Options: A domain constraint,    A range constraint,    An intrarelation constraint,    An interrelation constraint

Ans:C ,C

. What is the function ofradio button?
Options: a. To select multiple option b. To select single option c. To select all option d. All of above

Ans: b, b

A lockbox service is used for
Options: depositing cash when bank is closed,    paying bank customer bills automatically,    storing papers in a bank vault,    depositing payments to bank customers

Ans:D ,D

One advantage of a PC in industrial control is that it:
Options: has a reliable long life compared to relay logic,    is very difficult for the inexperienced programmer to understand,    is unreliable because there are no moving parts,    All of the above

Ans:A ,A

. What do you do to start the slide show?
Options: a. Click on Go b. Turn on transition c. Click on the Slide Show icon d. All of the above

Ans:8 – C ,8 – C

A word field may consist of an optional field instruction called a(n) ______ 
Options: a. subdocument b. symbol c. signal d. switch

Ans:–  D,–  D

A regular TV set can be hooked up to a computer so as to received computer signal instead of a television program. This hooking up is achieved with the help of a
Options: modem,    adapter,    cable,    aerial

Ans:B ,B

. While creating relationship, when you drag a field of a field to drop into another table the mouse pointer changes into
Options: a. A doctor’s sign b. Thin + sign c. Outline rectangle d. None of above

Ans:9 – c ,9 – c

Which of the following is a serious problem of file management systems?
Options: difficult to update,    lack of data independence,    data redundancy,    program dependence

Ans:E ,E

The practice of "bundling" refers to
Options: selling computers alone,    selling peripheral devices with computer,    selling software to run on computers,    giving away software with a computer purchase

Ans:D ,D