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

. What is the symbol for multiplying?
Options: a. > b. / c. ! d. *

Ans:– d,– d

The advantage of Purchase Option is (are)
Options: No financing is requird. The risk of system obsolescence is shifted to the lessor,    the flexibility of modifying the system at will,    Insurances, maintenance, and other expenses are included in the rental charge,    All of the above

Ans:B ,B

45. Which of the following command is not available in Tools menu?
Options: a. Auto text b. Autocorrect c. Auto summarize d. Macro

Ans:– A ,– A

List Box and Text box
Options: a. are some other than that in a list box the bullets are enabled b. are different. List boxes are used to present lists and can’t be created with text boxes. c. Both of above d. None of above

Ans: – A , – A

Data can be arranged in a worksheet in a easy to understand manner using
Options: a. auto formatting b. applying styles c. changing fonts d. all of above

Ans:#8211; d,#8211; d

In the following code, the P2 is Integer Pointer or Integer? typedef int *ptr; ptr p1, p2;
Options: Integer,    Integer pointer,    Error in declaration,    None of above

Ans:B ,B

A device that can accept data hold them deliver them on demand at a later time is known as
Options: Buffer,    Memory,    CPU,    Register

Ans:B ,Memory

. Microsoft Excel is a powerful………..
Options: a. Word processing package b. Spreadsheet package c. Communication S/W Package d. DBMS package

Ans:– b,– b

Using Find command in Word, we can search?
Options: characters B. formats C. symbols D. All of the above

Ans:– D ,

. Which of the following toolbars provides different options in various master views?
Options: a. Common tasks toolbar b. Drawing toolbar c. Formatting toolbar d. Standard toolbar

Ans:7 – A ,7 – A

What type of magnetic material is normally used in bubble memories?
Options: Magnetic core,    Cobalt,    Garnet,    Metallic


The component that forms the electrical connection between the rotating coil of wire in a motor and the external source of electrical energy is called the:
Options: rotor,    armature,    battery,    commutator

Ans:D ,D

A central computer surrounded by one or more satellite computers is called a
Options: bus network,    ring network,    star network,    All of the above

Ans:C ,C

Websites without a database attached to them have which of the following characteristics?
Options: The ability to generate data via SQL.,    The inability to use a browser to display Web pages.,    Static information using HTML or JavaScript.,    The need to use TCP/IP as the network protocol.

Ans:C ,C

. Start/restart the computer is called
Options: a. Exit b. Run c. Option d. Boot

Ans:7 – d ,7 – d

. Hard disk is coated in both sides with
Options: A) Magnetic metallic oxide B) Optical metallic oxide C) Carbon layer D) All of the above


Natural language processing is divided into the two subfields of:
Options: symbolic and numeric,    time and motion,    algorithmic and heuristic,    understanding and generation

Ans:D ,D

The identifier of an entity will become the ________ of the new table.
Options: foreign key,    main attribute,    primary key,    identity key

Ans:C ,C

Which of the following will not cut information?
Options: a. Pressing Ctrl + C b. Selecting Edit>Cut from the menu c. Clicking the Cut button on the standard d. Pressing Ctrl+X

Ans:8211; a,8211; a

. A Chart can be put as a part of the presentation using
Options: a. Insert -> Pictures –> Chart b. Insert –> Chart c. Edit –> Chart d. View -> Chart

Ans:0 – A ,0 – A

To duplicate a controls formatting you can use___
Options: a. Manager b. Wizard c. Painter d. Control

Ans:ndash; c,ndash; c

You are working with a network that is and would like to support 600 hosts per subnet. What subnet mask should you use?

Ans:E ,E

The dispatcher
Options: actually schedules the tasks into the processor,    puts tasks in I/O wait,    is always small and simple,    never changes task priorities

Ans:A ,A

. How many types of storage loops exists in magnetic bubble memory
Options: A) 8 B) 4 C) 16 D) 2


. The language that the computer can understand and execute is called

Options: A) Machine language B) Application software C) System program D) All of above


A feature of MS Word that saves the document automatically after certain interval is available on
Options:  A) Save tab on Options dialog box, B) Save As dialog box, C) Both of above, D) None of above, 


Which of the following chips can be reprogrammed with special electric pulses?
Options: EPROM,    PROM,    ROM,    EEPROM

Ans:D ,D

. Which type of command requires additional files to perform specific operations?
Options: a. Internal commands b. External commands c. Valuable commands d. Primary commands

Ans: b, b

Before a disk drive can access any sector record, a computer program has to provide the record's disk address. What information does this address specify?
Options: Track number,    Sector number,    Surface number,    All of the above


On a class B network, how many hosts are available at each site with a subnet mask of 248?
Options: 16,382,    8,190,    4,094,    2,046

Ans:D ,D

. What are the benefits of network?
Options: a. To share hardware components b. To share information and share software c. It reduces cost d. All of above

Ans:4 – d ,4 – d

. If the values in A1 is “MCQ” and B1 is “Questions”, which function will return “MCQ@Questions” in cell C1?
Options: a. =A1 + “@” + B1 b. =A1 # “@” # B1 c. =A1 & “@” & B1 d. =A1 $ “@” $ B1

Ans:– c,– c

. It is an association established between common
Options: a. Line b. Relationship c. Primary key d. Records

Ans:0 – b ,0 – b

Which of the following file retrieval methods use hypermedia?
Options: HTTP,    WAIS,    Veronica,    Archie

Ans:A ,A

The arranging of data in a logical sequence is called:
Options: sorting,    classifying,    reproducing,    summarizing


Which of the following formulas will Excel Not be able to calculate?
Options: a. =SUM(Sales)-A3 b. =SUM(A1:A5)*.5 c. =SUM(A1:A5)/(10-10) d. =SUM(A1:A5)-10

Ans:#8211; a,#8211; a

Header labels contain
Options: creation data,    control totals,    both (a) and (b),    neither (a) nor (b)

Ans:A ,A

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

Ans:C ,C

Match the device driver HIMEM.SYS to its operation
Options: Supports (ANSI) terminal emulation,    Manages the use of extended memory,    Uses expanded memory on an 80386 processor,    Supports code page switching

Ans:B ,B

. Selecting the Column G & H then choose Insert->Columns. What will happen?
Options: 2 Columns will be inserted after Column F B. 2 Columns will be inserted after Column G C. 2 Columns will be inserted after Column H D. 2 Columns will be inserted after Column I

Ans:– A ,

The file structure that redefines its first record at a base of zero uses the term:
Options: relative organization,    key fielding,    dynamic reallocation,    hashing

Ans:A ,A

Which of the following is true regarding page Orientation of a Document?
Options: a. Page Orientation can be change at any time b. Page Orientation of document determines by printer c. Page Orientation must be set before start typing d. Page Orientation of a document cannot be changed.

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

Which of the following storage and retrieval methods would be well suited to your processing requirements if you only need to retrieve records one at a time and there is no fixed pattern to the requests for data and records?
Options: indexed sectors,    sequential,    direct,    indexed direct

Ans:D ,D

. Paper spreadsheets can have all the same advantages as an electronic spreadsheet except which of the following?
Options: a. Rows and columns b. Headings c. Speed d. None

Ans:– c,– c

A wrist grounding strap contains which of the following:
Options: Surge protector,    Capacitor,    Voltmeter,    Resistor

Ans:D ,D

A memory in which the information is stored last is on top & is retrieved first is known as
Options: PROM,    Buffer,    Stack,    RAM

Ans:C ,C

End-to-end connectivity is provided from host-to-host in:
Options: Network layer,    Session layer,    Data link layer,    Transport layer

Ans:D ,D

What command is used to terminate a process?
Options: kill,    cancel,    haltsys,    shutdown

Ans:A ,A

What do the following declaration signify? void (*cmp)();
Options: cmp is a pointer to an void function type.,    cmp is a void type pointer function.,    cmp is a function that return a void pointer.,    cmp is a pointer to a function which returns void .

Ans:D ,D