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:


7.Terminals is
Options: (A)An input device which allows a user to communicate directly with a computer system. (B) An output device which allows a user to communicate directly with a computer system. (C) Both A & B (D) None of these 10

Ans:107. (C),107. (C)


If no multivalued attributes exist in a relation, then the relation is in what normal form?
Options: First normal form,    Second normal form,    Third normal form,    Fourth normal form

Ans:A ,A


In India, which one among the following formulates the fiscal policy?
Options: Planning Commission,    Ministry of Finance,    Finance Commission,    The Reserve Bank of India

Ans:B,B


Mina is the tribe of
Options: Tripura,    Sikkim,    Rajasthan,    Nagaland, Assam

Ans:C,C


. To hold row and column titles in places so that they do not scroll when you scroll a worksheet, click the
Options: a. Unfreeze panes command on the window menu b. Freeze panes command on the window menu c. Hold titles command on the edit menu d. Split command on the window menu

Ans:– b,– b


Which of the following is used for input and output both
Options: Graph plotter,    Teletype terminal,    Line printer,    All of the above

Ans:B ,B


In Bourne shell, which file sets the Unix environment for the user when the logs into his HOME directory.
Options: .exrc,    .profile,    lastlogin,    .mbox

Ans:B ,B


India’s fastest train is
Options: NA

Ans:Gatimaan Express,Gatimaan Express


Which one of the following is the largest tribal group of India as per Census 2011?
Options: NA

Ans:Bhils,Bhils


A PC with a 486DX2 processor runs internally at 50Mhz. What speed would its external logic be running?
Options: l0Mhz,    25Mhz,    50Mhz,    100 Mhz

Ans:B ,B


A default Frame Relay WAN is classified as what type of physical network?
Options: Point-to-point,    Broadcast multi-access,    Non-broadcast multi-access,    Non-broadcast multipoint

Ans:C ,C


An advantage of overlapped processing activities is:
Options: more effective use of the CPU,    increased processing activities for the entire system,    better coordination of I/O activities,    all the above

Ans:D ,D


where is hari roy mandir in hp
Options: kinnaur , lahul, kullu, chamba

Ans:chamba,chamba


Water is a good solvent of ionic salts because
Options: it has a high boiling point,    it has a high dipole moment,    it has a high specific heat,    it has no colour

Ans:B,B


What will be the output of the program in Turb C (under DOS)? #include<stdio.h> int main() { int arr[5], i=0; while(i<5) arr[i]=++i; for(i=0; i<5; i++) printf("%d, ", arr[i]); return 0; }
Options: 1, 2, 3, 4, 5,,    Garbage value, 1, 2, 3, 4,,    0, 1, 2, 3, 4,,    2, 3, 4, 5, 6,

Ans:B ,B


Which one of the following statements most accurately applies to the frequency of a waveform?
Options: The actual frequency of a sine waveform is 1.41 times the working frequency,    Unless specified otherwise, the frequency of a waveform is assumed to be 60 Hz,    The higher the amplitude of a waveform, the higher its frequency,    The longer the period of a waveform, the lower its frequency

Ans:A ,A


If you will be displaying or printing your document on another computer, you’ll want to make sure and select the _____________ option under the ‘Save’ tab.
Options: a. Embed Fonts b. Embed True Type Fonts c. Save True Type Fonts d. Save Fonts

Ans:– B,– B


Which algebra is widely used in DBMS?
Options: a. Relational algebra b. Arithmetic algebra c. Both d. None

Ans:– a ,


Is the following statement a declaration or definition? extern int i;
Options: Declaration,    Definition,    Function,    Error

Ans:A ,A


. Which of the following is best for quick copy operation?
Options: Copy and Paste B. Windows Clipboard C. Drag and Drop D. Auto Text

Ans: – C ,


A NOR gate recognizes only the input word whose bits are _____
Options: 0's and 1's,    1's,    0's,    0's or 1's

Ans:C ,C


Positive testing is
Options: running the system with line data by the actual user,    making sure that the new programs do in fact process certain transactions according to Specifications,    is checking the logic of one or more programs in the candidate system,    testing changes made in an existing or a new program

Ans:B ,B


The term used to refer to the checking of outputs of a computer, with the corresponding input documents, is called
Options: auditing around the computer,    auditing through the computer,    process control,    beta-test

Ans:A ,A


As compared to diskettes, the hard disks are
Options: more expensive,    more portable,    less rigid,    slowly accessed

Ans:A ,A


For connecting modem, a computer must be equipped with a port that conforms to the RS-232 standard of the Electronic Industries Association of America. What do the letters 'RS' stand for?
Options: Recognised standard,    Random sequence,    Recommended standard,    Registered source

Ans:C ,C


An input device that is able to interpret pencil marks on paper media is known as
Options: Magnetic disk,    Optical Mark Reader,    Card Puncher,    Magnetic tape

Ans:B ,B


A billionth of a second is defined as a:
Options: millisecond,    microsecond,    nanosecond,    picoseconds

Ans:C,C


The ALU and control unit of most of the microcomputers are combined and manufacture on a single silicon chip. What is it called?
Options: a . monochip b . microprocessor c. ALU d . control unit 

Ans:7.b,7.b


The iron and steel industries of which of the following countries are almost fully dependent on imported raw materials?
Options: Britain,    Japan,    Poland,    Germany

Ans:B,B


The 2-input XOR gate has a high output only when the input bits are _____
Options: even,    different,    low,    high

Ans:B ,B


What keystroke will terminate setup mode?
Options: Ctrl+Z,    Ctrl+^,    Ctrl+C,    Ctrl+Shift+^

Ans:C ,C


A micro processor chip used in a PC system
Options: Performs the arithmetic-logic and control functions,    Is the only chip cound in most PC models,    Almost always operates on by-bits of data at a time,    Performs the primary storage function

Ans:A ,A


Normalization ________ data duplication.
Options: eliminates,    reduces,    increases,    maximizes

Ans:A ,A


Which of the following refers to the terms "residual error rate"?
Options: the number of bit errors per twenty four hours of continuous operation on an asynchronous line,    The probability that one or more errors will be undetected when an error detection scheme is used,    the probability that one or more errors will be detected when an error detection mechanism is used,    signal to noise ratio divided by the ratio of energy per bit to noise per hertz

Ans:B ,B


Which of the following is the correct order if calling functions in the below code? a = f1(23, 14) * f2(12/4) + f3();
Options: f1, f2, f3,    f3, f2, f1,    Order may vary from compiler to compiler,    None of above

Ans:C ,C


Which of the following registers hold the information before it goes to the decoder
Options: control register,    data register,    accumulator,    address register

Ans:B,B


If a computer's BIOS allows it, you can boot from a CD-ROM.
Options: True,    False,    ,    

Ans:A ,A


Diamond is an allotropic form of
Options: germanium,    carbon,    silicon,    sulphur

Ans:B,B


Binary numbers need more places for counting because
Options: They are always big numbers,    Any no. of 0's can be added in front of them,    Binary base is small,    0's and l's have to be properly spaced apart

Ans:C ,C


which is oldest chitrakala school in HP
Options: diyoli, kasauli, bashauli, kangra

Ans:bashauli,bashauli


If I create ‘Student’ field in ‘Fees’ table to store ‘student_id’ of ‘Students’ table, then this ‘Student’ field in ‘Fees’ table is called:
Options: a. Foreign key b. Native key c. Composite key d. Primary key

Ans:ndash; a,ndash; a


Stars which appear single to the naked eye but are double when seen through a telescope are
Options: novas and supernovas,    binaries,    asteroids,    quasars

Ans:B,B


465. bhaarat mein pahalee baar janaganana kab huee?
Options: NA

Ans: 1872, 1872


What will be the output of the program under DOS? #include<stdio.h> int main() { char huge *near *far *ptr1; char near *far *huge *ptr2; char far *huge *near *ptr3; printf("%d, %d, %d\n", sizeof(ptr1), sizeof(**ptr2), sizeof(ptr3)); return 0; }
Options: 4, 4, 4,    4, 2, 2,    2, 8, 4,    2, 4, 8

Ans:B ,B


4.In Microsoft PowerPoint what are lines, curve, freeform, and scribble
Options: (A)Emphasis effects that can be applied to animations (B) Types of custom motion paths (C) Predefined entrance and exit effects (D) All of the above

Ans:4. (B),4. (B)


0.Interoperability is
Options: (A)Ability of two or more systems, to exchange information and to use the information that has been exchanged. (B) Time taken to respond to an event. (C) Either the hazard not arises, if arise; it will not result in an accident. (D) None of these 22

Ans:220. (A),220. (A)


Large astronomical telescopes always use as objective
Options: lens,    mirror,    combinations of lenses,    None of the above

Ans:C,C


. The first digital computer built with IC chips was known as
Options: A) IBM 7090 B) Apple ? 1 C) IBM System / 360 D) VAX-10

Ans:C,C


. In which mode Windows starts with only the core drivers & services?
Options: Safe Mode B. Quick Mode       C. Normal Mode D. Repair Mode

Ans:– A ,


. What is the use of Referential Integrity in MS Access?
Options: a. It allow to enter a value in the foreign key field of a child table if that value exist in the primary key of the parent table b. It does not allow to enter a value in the foreign key field of a child table if that value exist in the primary key of the parent table c. It allow to enter a value in the Primary key field of a child table if that value exist in the Foreign key of the parent table d. None of above

Ans:– a,– a

www.000webhost.com