If every non-key attribute is functionally dependent on the primary key, the relation will be in


Options: First Normal Form B. Second Normal Form C. Third Normal Form D. Fourth Formal Form

Ans:– C ,


Description: mcqquestions






More Database Systems Related questions:


The magnetic disks and drums are like recirculating shift registers because
Options: they have about the same storage capacity,    their storage is non volatile,    their access times are about the same,    stored data is available for reading over and over again in the same order.

Ans:D ,D


A set of information that defines the status of resources allocated to a process is
Options: A) Process control B) ALU C) Register Unit D) Process description

Ans:-D,-D


A pen shaped device which can sense light, and is used to point at spots on a video screen.
Options: Mouse,    Light pen,    Joystick,    Plotter

Ans:B,(Banswer


Which of the following is not an important principle for evaluating the raw data for decision-making:
Options: selection,    pattern,    everage,    overview

Ans:C ,C


Which command allows you to view your file 24 lines at a time?
Options: more,    pg,    cat,    lp

Ans:B ,B


In computer based information system (CBIS), DFD stands for:
Options: data flow diagram,    data flow descent,    dotted flow diagram,    such a terminology does not exist in CBIS

Ans:A ,A


    Each time you turn on your computer, it will check on the control file
Options: a.    Command.com, io.sys b.    Command.com, date.com, dir.com c.    Command.com, io.sys, msdos.sys d.    Chkdsk.exe

Ans:C, c. command.com, io.sys, msdos.sys


Which of the following function returns t if the object is a number in LISP?
Options: (number <object>),    (numberp <object>),    (numericp <object>),    (numeric <object>)

Ans:B ,B


The logic gate that will have HIGH or "1" at its output when any one of its inputs is HIGH is a(n):
Options: OR gate,    AND gate,    NOR gate,    NOT gate

Ans:A ,A


What is the smallest number of polarities required for current flow?
Options: One - a negative terminal,    Two - a negative terminal and a positive terminal,    Three - negative, positive and neutral terminals,    Four - two negative and two positive

Ans:B ,B


The number of records contained within a block of data on magnetic tape is defined by the
Options: block definition,    record contain clause,    blocking factor,    record per block factor

Ans:C ,C


. Which of the following computer implemented binary numbers, perform calculations using electronics and implemented separate computation and memory for the first time?
Options: A) Mark I B) ABC C) Z3 D) None of above

Ans:B,B


Which of the following is not a type of relationship that can be applied in Access database
Options: a. One to One b. One to Many c. Many to Many d. All of above can be applied

Ans:ndash; d,ndash; d


Which type of actuator generates a good deal of power but tends to be messy?
Options: electric,    hydraulic,    pneumatic,    (B) and (c) above

Ans:B ,B


An example of a hierarchical data structure is
Options: array,    link list,    tree,    All of the above

Ans:C ,C


Ctrl + M
Options: a. New Document b. Close Document c. Right Indent d. Left Indent

Ans:–  D,–  D


Which of the following is not an advantage of the structured approach to system development?
Options: it focuses on the physical aspects of the system,    the system specification is very graphic,    the user area is studied thoroughly,    the documentation is Cumulative

Ans:A ,A


The equivalent of 1 micro A is:
Options: 10000A,    1000 A,    one-millionth of an ampere,    one million amperes

Ans:C ,C


A large computer information system maintains many different computer files. Which amongst them is called a perpetual file?
Options: Specialized file,    Log file,    Master file,    Update file

Ans:C ,C


. Small squares, called _____, on the selection rectangle that surrounds a graphic can be used to change the dimensions of the graphic.
Options: a. scroll boxes b. sizing handles c. status indicators d. move handles

Ans:– B,– B


During system study, data can be collected through
Options: questionnaires,    interviews,    on-site observations,    All of the above

Ans:D ,D


Which of the following is NOT a type of Microsoft Access database object?
Options: a. Table b. Form c. Worksheets d. Modules

Ans:ndash; c,ndash; c


. when you work with large worksheets, you may need to
Options: a. size the worksheet to fit on the specific number of pages b. add and remove page breaks c. specify only certain print areas d. all of above

Ans:– d,– d


. Through which device the main components of the computer communicate with each other?
Options: Keyboard B. System Bus C. Monitor D. Memory

Ans: – B ,


Which of the following memories needs refresh?
Options: DRAM B. SRAM C. ROM D. All of above

Ans:– A ,


. Before creating a master document, you must switch to _________ 
Options: a. Normal View b. Outline View c. Web Layout View d. Print Layout View

Ans: –  B , –  B


A system program that combines the separately compiled modules of a program into a form suitable for execution
Options: assembler,    linking loader,    cross compiler,    load and go

Ans:B ,B


A common way to take x, y coordinates off a drawing is to use a
Options: light pen,    digitiser,    Direct view storage tube (DVST),    Tablet

Ans:B ,B


What is the maximum number of entries in the HOSTS file?
Options: 8,    255,    500,    Unlimited

Ans:D ,D


The refresh-vector CRT uses which of the following techniques?
Options: The beam constantly travels across the screen to turn on/off a series of pixels.,    Makes changes on the image by increasing the anode voltage.,    Uses an electron gun to continuously flood the surface of the tube.,    Creates images on the screen by scanning straight-line vectors between selected points.

Ans:D ,D


A computer program that converts an entire program into machine language at one time is called a/an
Options: interpreter,    simulator,    compiler,    commander

Ans:C ,C


Computers in a LAN can be interconnected by radio and infrared technologies.
Options: Wireless LANs,    Network Topologies,    Multiplexer,    Modem

Ans:A ,A


Which particular generation of computers is associated with artificial intelligence?
Options: Second,    Fourth,    Fifth,    Third

Ans:C ,C


Which of the following function returns t If the object is a symbol m LISP?
Options: (* <object>),    (symbolp <object>),    (nonnumeric <object>),    (constantp <object>)

Ans:B ,B


. Who invented punched cards?

Options: A) Charles Babbage B) Dr. Herman Hollerith C) Howard Aikin D) Joseph Jacquard

Ans:D,D


A _____ means that one record in a particular record type may be related to more than one record of another record type.
Options: One-to-one relationship,    One-to-many relationship,    Many-to-one relationship,    Many-to many relationship

Ans:B ,B


. Ctrl + S
Options: Save Document with different name B. Save Document with same name C. Save Document and Close Word Application D. Save Document and Print whole Pages

Ans:– B ,


D/A (digital to analog) conversion:
Options: results in a binary code as the final output,    has to be sampled at 1/2 the highest input frequency,    must be fed through a filter to reproduce the original signal accurately,    both (b) and (c)

Ans:C ,C


Which is a secondary memory device?
Options: CPU,    ALU,    Floppy disk,    Mouse

Ans:C ,C


. In a datasheet, what does each column represent?
Options: a. Record b. Field c. Database d. Table

Ans:– b,– b


Within a database, the sequential organization of data by a common key is called:
Options: logical structure,    inverted structure,    simple structure,    All of the above

Ans:C ,C


Which of the following is the latest version of MS Word?
Options:  A) Word 2000, B) Word 2007, C) Word 2010, D) Word 2011, 

Ans:-C,-C


How many NAND circuits are contained in a 7400 NAND IC?
Options: 1,    2,    4,    8

Ans:C ,C


Which of the following printers, are you sure will not to use if your objective is to print on multicarbon forms?
Options: daisy wheel,    dot-matrix,    laser,    thimble

Ans:C ,C


Storage capacity of magnetic disk depends on
Options: A) tracks per inch of surface B) bits per inch of tracks C) disk pack in disk surface D) All of above

Ans:D,D


What are the two types of Semaphore?
Options: Digital Semaphores and Binary Semaphores B. Analog Semaphores and Octal Semaphores          C. Counting Semaphores and Binary Semaphores D. Critical Semaphores and System Semaphores

Ans:– C ,


. A small or intelligent device is so called because it contains within it a

Options: A) Computer B) Microcomputer C) Programmable D) Sensor

Ans:D,D


Which of the following bypasses the print dialog box when printing individual slides or an entire presentation?
Options: a. File, print, preview b. The print button c. File, print d. Ctrl + p

Ans: – B , – B


An Oracle System Change Number (SCN):
Options: is a value that is incremented whenever a dirty read occurs.,    is incremented whenever a deadlock occurs.,    is a value that keeps track of explicit locks.,    is a value that is incremented whenever database changes are made.

Ans:D ,D


Current is
Options: The flow of charged particles through a material,    An imbalance of electrical charges,    The force that causes electrons to flow,    The number of free electrons in an atom

Ans:A ,A

www.000webhost.com