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 ,






More Database Systems Related questions:


. Operating system is like a
Options: a. Government b. Police c. Parliament d. All of above

Ans:3 – a ,3 – a


To add a Header/Footer in Handout
Options: View -> Page Setup B. View -> Header/Footer C. View -> Handout Master D. None of Above

Ans:– C ,


The input unit of a computer
Options: feeds data to the CPU or memory,    retrieves data from CPU,    directs all other units,    All of the above

Ans:A ,A


Missing slot covers on a computer can cause?
Options: over heat,    power surges,    EMI.,    incomplete path for ESD

Ans:A ,A


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

Ans:C ,C


The physical arrangement of equipment in a network is called:
Options: topology,    pairing,    queuing,    logic

Ans:A ,A


The transistorized computer circuits were introduced in the
Options: First generation,    Second generation,    Third generation,    Fourth generation

Ans:B,B


A method for representing digital data analog signals by changing the phase of the analog carrier to represent the digital information is known as
Options: PIA,    PSK,    PM,    PM

Ans:B ,B


The first large scale electronic computer which became operational in 1946 and contained approximately 18000 vacuum tubes and could perform 300 multiplications per second was known as
Options: ILLIAC,    ENIAC,    JOHNIAC,    EDSAC

Ans:B ,B


The receive equalizer reduces delay distortions using a
Options: tapped delay lines,    gearshift,    descrambler,    difference engine

Ans:A ,A


Large collections of files are called
Options: fields,    records,    databases,    file system

Ans:C ,C


The logical data structure with a one-to-many relationship is a :
Options: network,    tree,    chain,    relational

Ans:B ,B


The ideal solution is to have a system coordinator who will interface with the engineering and manufacturing managers, as well as the:
Options: finance manager,    president,    marketing manager,    MIS manager

Ans:D ,D


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

Ans:D ,D


Which of the following editor(s) is(are) incorporated into general CAD system?
Options: Point Editor,    Line Editor,    Macro and symbol Editor,    All of the above

Ans:D ,D


You see the message "invalid media device" after installing a new hard drive. What do you do next?
Options: Format,    Fdisk,    Partition,    Add the OS

Ans:A ,A


Which of the following registers is used to keep track of address of the memory location where the next instruction is located?
Options: Memory Address Register,    Memory Data Register,    Instruction Register,    Program Counter

Ans:D ,D


A beam of light used to record and retrieve data on optical disks is known as
Options: polarized light,    unpolarized concentric light,    laser,    coloured light

Ans:C ,C


The process of communicating with a file from a terminal is
Options: Interactive,    Interrogation,    Heuristic,    All of the above

Ans:B,(Banswer


Electron current is flowing through a conductor in a direction you might describe as straight into this page. What is the direction of the resulting magnetic field?
Options: Clockwise,    Counterclockwise,    Out of this page,    Into this page

Ans:B ,B


The computer translates the condition of each switch to a number. What number is represented by the ON state?
Options: +7,    +3.75,    1,    0

Ans:C ,C


The ODBC core API consists of which of the following functions?
Options: Commit or rollback transactions only,    Connect to data sources with driver-specific information only,    Connect to data sources only,    Both 1 and 3 above are in the OBDC core API.

Ans:D ,D


To enable RIPng, which of the following would you use?
Options: Router1(config-if)# ipv6 ospf 10 area 0.0.0.0,    Router1(config-if)# ipv6 router rip 1,    Router1(config)# ipv6 router eigrp 10,    Router1(config-rtr)# no shutdown

Ans:B ,B


. UNIX operating system is a(n)
Options: a. Time sharing operating system b. Multi-user operating system c. Multi-tasking operating system d. All of the above

Ans:2 – d ,2 – d


. To delete a file without allowing it to store in recycle bin
Options: a. Press Delete key b. Press Shift + Delete key c. Press Ctrl + Delete key d. Press Alt + Delete key

Ans:6 – b ,6 – b


.   Which of the following features allows you to view slides in a slide show without manually advancing each slide?
Options: a. Adding build effects b. Setting slide times c. Adding transitions d. All of these

Ans:4 – B ,4 – B


. Which is built directly on the hardware?
Options: a. Computer Environment b. Application Software c. Operating System d. Database System

Ans:0 – c ,0 – c


. The ability of a database to grow as the data tracking needs grow is its __________.
Options: a. scalability b. expandability c. maintainability d. platform-independence

Ans:8 – a ,8 – a


In comparison with static RAM memory, the dynamic RAM memory has
Options: lower bit density and higher power consumption,    higher bit density and higher power consumption,    lower bit density and lower power consumption,    higher bit density and lower power consumption

Ans:D,D


Which company offers the LISP machine considered to be "the most powerful symbolic processor available"?
Options: LMI,    Symbolics,    Xerox,    Texas Instruments

Ans:B ,B


A system design is said to be functionally modular if
Options: the system is able to handle all the function of the application,    each module performs a specific function and can be developed relatively independently by programmers,    the system makes extensive use of function. keys for maximum user assistance,    the system is developed using structured programming through COBOL or PASCAL

Ans:B ,B


The first mechanical calculating machine was made by
Options: William Oughtred,    Gottfried Leibnitz,    Blaise Pascal,    Charles Babbage

Ans:C ,C


Which of the following is correct regarding Aggregate functions?
Options: it takes a list of values and return a single values as result B. it takes a list of values and return a list of values as result C. it takes a single value and returns a list of values as result D. it takes a single value and returns a single value as result

Ans:– A ,


Identify which of the following are declarations 1 : extern int x; 2 : float square ( float x ) { ... } 3 : double pow(double, double);
Options: 1,    2,    1 and 3,    3

Ans:C ,C


. The computer code for the interchange of information between terminals is
Options: A) ASCII B) BCD C) EBCDIC D) All of above

Ans:A,A


Which is not true about surrogate keys?
Options: They are short.,    They are fixed.,    They have meaning to the user.,    They are numeric.

Ans:C ,C


Bus is
Options: one or more conductors that some as a common connection for a related group of devices,    a continuous frequency capable of being modulated or impressed with a second signal,    the condition when two or more stations attempt to use the same channel at the same time,    a collection of interconnected functional units that provides a data communications service among stations attached to the network

Ans:A ,A


Which access method is used for obtaining a record from a cassette tape?
Options: Direct,    Sequential,    Random,    All of the above

Ans:B,(Banswer


. The processing speed of first generation computers was
Options: A) milliseconds B) microseconds C) nanoseconds D) picoseconds

Ans:A,A


. How can you link a table with another so that a field in current table will display values in drop down box from another table while entering data:
Options: a. Query Wizard b. Look up Wizard c. Form Wizard d. Report Wizard

Ans:– b,– b


The first firm to mass-market a microcomputer as a personal computer was
Options: IBM,    Sperry Univac,    Radio Shack,    Data General Corporation

Ans:C ,C


What value will display if the formula = “$55.00″+5 is entered into a cell?
Options: $60 B. 60 C. “$55.00″+5 D. $60.00

Ans:– B ,


What will be the output if you format the cell containing 5436.8 as ‘#,##0.00′?
Options: a. 5430 b. 5436.8 c. 5436.80 d. 6.8

Ans:B,– b


. The Software which contains rows and columns is called ______
Options: a. Database b. Drawing c. Spreadsheet d. Word processing

Ans:– c,– c


What device separates a single network into two segments but lets the two segments appear as one to higher protocols?
Options: Switch,    Bridge,    Gateway,    Router

Ans:B ,B


The following are functions of a DBMS except ________ .
Options: creating and processing forms,    creating databases,    processing data,    administrating databases

Ans:A ,A


Which computer was considered the first electronic computer until 1973 when court invalidated the patent?
Options: A) ENIAC B) MARK I C) Z3 D) ABC

Ans:-A,-A


. When you insert an Excel file into a Word document, the data are
Options: a. Hyperlinked b. Placed in a word table c. Linked d. Embedded

Ans:– b,– b


One of the major benefits of using CAD in tool design is that:
Options: product design represents approximately one-half the engineering costs,    tool motions can be checked to see if there is interference between the tool and the object,    there is better coordination in the materials-handling area,    it simplifies the trial-and-error method

Ans:B ,B


. Anything you cut or copy on to the clipboard remains there until you
Options: a. Change it b. Clear c. Exit windows d. All of the above

Ans:3 – d ,3 – d

www.000webhost.com