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 ,






More Database Systems Related questions:


. Each excel file is a workbook that contains different sheets. Which of the following can not be a sheet in workbook?
Options: a.  work sheet b.  chart sheet c.  module sheet d.  data sheet

Ans:– d,– d


HIPO
Options: is a forms-driven technique in which standard forms are used to document the information,    consists of a hierarchy chart and an associated set of input/process/ output charts,    captures the essence of top down decomposition.,    All of the above

Ans:D ,D


The barcode which is used on all types of items, is read by a scanning device directly into the computer. What is the name of this scanning device?
Options: Laser scanner,    Wand,    OCR,    MICR

Ans:A ,A


. In Excel, a Data Series is defined as what?
Options: a. A type of chart. b. A cell reference. c. A collection of related data d. A division of results

Ans:– c,– c


A required characteristic of an online real-time system is:
Options: more than one CPU,    offline batch processing,    no delay in processing,    All of the above

Ans:C ,C


. Copying a process from memory to disk to allow space for other processes is Called
Options: a. Swapping b. Deadlock c. Demand Paging d. Page Fault

Ans:9 – a ,9 – a


Composition is a stronger form of which of the following?
Options: Aggregation,    Encapsulation,    Inheritance,    All of the above.

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 languages is often translated to pseudo code?
Options: Assembly,    FORTRAN,    PASCAL,    BASIC

Ans:C ,C


. How to remove the unwanted action from recorded macro without recording the whole macro again?
Options: a. By using the Find and Edit Action Option b. By clicking on the Refresh button in the Macro toolbar c. By edit the macro in the Visual Basic Editor d. Macro cannot be edited.

Ans:– c,– c


While working with MS-DOS, which command is used to restore only those files modified since the last backup, from the drive A to the currently logged drive or directory?
Options: RESTORE A: *.*/S,    RESTORE A: *.*/M,    RESTORE A: *.*/N,    RESTORE A: *.*/L

Ans:B ,B


Who founded the FSF?
Options: Linus Torvalds,    Richard Stallman,    Bob Young,    All of the above

Ans:B ,B


. What should be the extension to execute files?
Options: EXE B. BAT C. COM D. All of the above

Ans: – D ,


The recipe instruction "Beat until smooth' is an example of the _____ structure.
Options: Control,    Repetition,    Selection,    Sequence

Ans:B ,B


The SQL WHERE clause:
Options: limits the column data that are returned.,    limits the row data are returned.,    Both A and B are correct.,    Neither A nor B are correct.

Ans:B ,B


To produce high quality graphics (hardcopy) in color, you would want to use a/n
Options: A) RGB monitor B) Plotter C) Ink-jet printer D) Laser printer

Ans:-B,-B


. To start slide show of a presentation
Options: a.  Hit F5 key b.  From Slide Show menu choose View Show option c.  From Slide Show menu choose Rehearse timing d.  Both a & b

Ans:8 – D ,8 – D


A data warehouse administrator is concerned with which of the following?
Options: The time to make a decision but not the typical roles of a database administrator,    The time to make a decision and the typical roles of a database administrator,    The typical roles of a data administrator and redesigning existing applications,    The typical roles of a database administrator and redesigning existing applications

Ans:B ,B


. Background color or effects applied on a document is not visible in
Options: a. Web layout view b. Print Layout view c. Reading View d. Print Preview

Ans:– D,– D


. Ctrl + Q
Options: Paragraph formatting (Line Space and Paragraph Space) B. Close Word Application without saving Document C. Print Whole Document without confirmation D. Does nothing

Ans:– A ,


Which of the following can be output by a computer?
Options: graphics,    voice,    text,    computer-usable data or information

Ans:E ,E


Backup and recovery procedures are primarily implemented to
Options: handle the contingency when a file gets corrupted,    to provide data redundancy,    to show different versions of data and programs,    All of the above

Ans:A ,A


What is a portion of memory that serves as a temporary repository for data as it waits for a given action?
Options: Memory Pool,    Cache,    Processor,    Processor pool

Ans:B ,B


The ESD wrist strap is designed to protect PC Components or Service Technicians ?
Options: PC Components,    Service Technicians,    Both,    

Ans:C ,C


....... transforms one interface into other interface
Options: a. Program b. Software c. Data d. None

Ans:1 – b ,1 – b


Which of the following is the default page setup orientation of slide in PowerPoint
Options: a. Vertical b. Landscape c. Portrait d. None of above

Ans: – B , – B


Artificial intelligence is
Options: the embodiment of human intellectual capabilities within a computer.,    a set of computer programs that produce output that would be considered to reflect intelligence if it were generated by humans.,    the study of mental faculties through the use of mental models implemented on a computer.,    All of the above

Ans:D ,D


. Personnel who design, program, operates and maintains computer equipment refers to
Options: A) Console-operator B) Programmer C) Peopleware D) System Analyst

Ans:C,C


X.21 is
Options: a method of determining which device has access to the transmission medium at any time,    a method access control technique for multiple-access transmission media,    a very common bit-oriented data link protocol issued by ISO,    network access standard for connecting stations to a circuit-switched network

Ans:D ,D


. Which of the following statement is true?
Options: a. Foreign key fields don’t allow duplicate values b. In primary key field you can enter duplicate value c. In an indexed field you may or may not enter duplicate value depending upon setting d. All statements are true

Ans:3 – c ,3 – c


Which of the following code is used in present day computing was developed by IBM corporation ?
Options: a. ASCII b. Hollerith Code c. Baudot code d. EBCDIC code

Ans:6.d,6.d


The advantage(s) of incorporating the macro processor into pass 1 is/ are:
Options: many functions do not have to be implemented twice,    Functions are combined and it is not necessary to create intermediate files as output from the macro processor and input to the assembler,    more flexibility is available to the programmer in which he/she may use all the features of the assembler in conjunction with macros,    All of the above

Ans:D ,D


. Which of the following can be use as slide background?
Options: a. Gradient b. Texture c. Picture d. All of the Above

Ans:7 – D ,7 – D


. How many steps are there between Start and Finish in AutoContent Wizard?
Options: a. 3 b. 4 c. 5 d. 6

Ans:9 – A ,9 – A


If the ASCII character H is sent and the character I is received, what type of error is this?
Options: single-bit,    multiple-bit,    burst,    recoverable

Ans:A ,A


In a worksheet you can select
Options: a. The entire worksheet b. Rows c. Columns d. All of the above

Ans:#8211; b,#8211; b


The data model that is produced from reverse engineering is:
Options: a conceptual model.,    an internal model.,    a logical model.,    None of the above is correct.

Ans:D ,D


Comments can be added to cells using
Options: a. Edit > Comments b. Insert > Comments c. File > Comments d. View > Comments

Ans:#8211; b,#8211; b


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

Ans:C ,C


Which of the following command is used to access an SMB share on a Linux system?
Options: NFS,    SMD,    smbclient,    smbserver

Ans:C ,C


A flip-flop:
Options: is a combinational logic device,    is a sequential logic device,    remembers what was previously stored in it,    (a) and (c)

Ans:D ,D


A T-switch is used to
Options: control how messages are passed between computers,    echo every character that is received,    transmit characters one at a time,    rearrange the connections between computing equipment

Ans:D ,D


The two main components of the CPU is
Options: Control unit and registers,    Control unit and ALU,    Registers and main memory,    ALU and bus

Ans:B ,B


Which of the following is still useful for adding numbers?
Options: EDSAC,    ENIAC,    Abacus,    UNIVAC

Ans:C ,C


Which of the following divides the high speed signal into frequency bands?
Options: t-switch,    modem,    frequency-division multiplexer,    time-division multiplexer

Ans:C ,C


The component of an ICAI (Intelligent Computer-Asslsted Instruction) presenting information to the student is the:
Options: student model,    problem-solving expertise,    tutoring module,    All of the above

Ans:C ,C


Advantage(s) of using assembly language rather than machine language is (are):
Options: It is mnemonic and easy to read.,    Addresses any symbolic, not absolute,    Introduction of data to program is easier,    all of the above

Ans:D ,D


A subquery in an SQL SELECT statement is enclosed in:
Options: braces -- {...}.,    CAPITAL LETTERS.,    parenthesis -- (...) .,    brackets -- [...].

Ans:C ,C


  Power Point presentation is a collection of ________
Options: Slides and Handouts B. Speaker’s notes C. Outlines D. All of the above

Ans:– D ,


Your router has the following IP address on Ethernet0: 172.16.2.1/23. Which of the following can be valid host IDs on the LAN interface attached to the router? 172.16.1.100 172.16.1.198 172.16.2.255 172.16.3.0
Options: 1 only,    2 and 3 only,    3 and 4 only,    None of the above

Ans:C ,C

www.000webhost.com