How many types of keys in Database Design?


Options: a. Candidate key b. Primary key c. Foreign key d. All of these

Ans:– d ,






More Database Systems Related questions:


What will be the output of the program if the array begins at 65472 and each integer occupies 2 bytes? #include<stdio.h> int main() { int a[3][4] = {1, 2, 3, 4, 4, 3, 2, 1, 7, 8, 9, 0}; printf("%u, %u\n", a+1, &a+1); return 0; }
Options: 65474, 65476,    65480, 65496,    65480, 65488,    65474, 65488

Ans:B ,B


. A user wishes to remove a spreadsheet from a workbook. Which is the correct sequence of events that will do this?
Options: a. Go to File-Save As – Save As Type – Excel worksheet b. Right click on the spreadsheet tab and select DELETE c. Right click on the spreadsheet and select Insert – Entire Column d. None of above

Ans:– b,– b


In a step-down transformer, which is larger?
Options: Primary voltage,    Secondary voltage,    Neither,    Impossible to say

Ans:A ,A


How is ink transferred to paper in common ink jet printers?
Options: Boiling ink,    Crystal,    Motorized pump,    Screens deflect ink on the paper into the proper positions

Ans:B ,B


Shimmer, Sparkle text, Blinking Background etc. are known as
Options:  A) font styles, B) font effects, C) word art, D) text effects, 

Ans:-D,-D


Which part interprets program instructions and initiate control operations.
Options: Input,    Storage unit,    Logic unit,    Control unit

Ans:D ,D


Which of the following statements in correct?
Options: most analysts agree on the structure and organization of MIS.,    operational planning reports are a primary informational tool for middle management.,    an MIS focuses on managing information generated with a computer system,    the cross reference of data items is an integral feature of the simple structure used in database organization.

Ans:C ,C


What will be the output of the program? #include<stdio.h> #define FUN(arg) do\ {\ if(arg)\ printf("IndiaBIX...", "\n");\ }while(--i) int main() { int i=2; FUN(i<3); return 0; }
Options: IndiaBIX... IndiaBIX... IndiaBIX,    IndiaBIX... IndiaBIX...,    Error: cannot use control instructions in macro,    No output

Ans:B ,B


A digital device that processes data is known as
Options: Data processor,    Data entry,    DBMS,    Database

Ans:A ,A


Which of the following are unique characteristics of half-duplex Ethernet when compared to full-duplex Ethernet? Half-duplex Ethernet operates in a shared collision domain. Half-duplex Ethernet operates in a private collision domain. Half-duplex Ethernet has higher effective throughput. Half-duplex Ethernet has lower effective throughput.
Options: 2 only,    1,2 and 3,    1 and 4,    4 only

Ans:C ,C


A Decision table
Options: represents the information flow,    documents rules, that select one or more actions, based on one or more conditions, from a set of possible conditions.,    gets an accurate picture of the system,    shows the decision paths

Ans:B ,B


Relations are:
Options: two-dimensional tables.,    three-dimensional tables.,    four-dimensional tables.,    five-dimensional tables.

Ans:A ,A


In the language of the computer profession, one thousand position of main storage is represented with the letter
Options: K,    L,    M,    C

Ans:A ,A


. ASCII and EBCDIC are the popular character coding systems. What does ASCII stand for?
Options: A) American Stable Code for International Interchange B) American Standard Case for Institutional Interchange C) American Standard Code for Information Interchange D) American Standard Code for Interchange Information

Ans:C,C


What is a compiler?
Options:  A compiler does a conversion line by line as the program is run B.  A compiler converts the whole of a higher level program code into machine code in one step C.  A compiler is a general purpose language providing very efficient execution D.  None of the above

Ans:– B ,


. Which is an example of a formula?
Options: a. =A1+A2 b. =add(A1:A2) c. A1+A2 d. SUM(A1:A2)

Ans:– a,– a


Which option in File pull-down menu is used to close a file in MSWord?
Options: New B. Quit C. Close D. Exit

Ans:– C ,


What Is a process variable?
Options: A manipulated variable,    A controlled variable,    A process parameter that changes value,    All of the above

Ans:D ,D


. On the works cited page, list works by each author’s last name and _____ the title of the work.
Options: a. italicize or underline b. boldface or italicize c. underline or boldface d. enlarge or underline

Ans: – A , – A


In MS-DOS 5.0, which is the number that acts as a code to uniquely identify the software product?
Options: MS,    DOS,    MS DOS,    5.0

Ans:D ,D


.   To maintain the perspective (height and width ratio) of an object when resizing, you need to
Options: a. Press and hold the shift key while dragging a corner sizing handle b. Press and hold the alt + ctrl keys while dragging a middle handle c. Drag a corner sizing handle d. A and c

Ans:7 – A ,7 – A


A 4 KHz noise less channel with one sample ever 125 per sec is used to transmit digital signals. If Delta modulation is selected, then how many bits per second are actually sent?
Options: 32 kbps,    8 kbps,    128 kbps,    64 kbps.

Ans:B ,B


. Suppose you wanted to create an AutoCorrect entry that would type the words ‘We regret to inform you that your submission has been declined’ Of the following choices, which would be the best name you could assign to this entry?
Options: a. regret b. subdecl c. We regret to inform you that your submission has been declined d. 11

Ans: – B , – B


What will be the output of the program? #include<stdio.h> int main() { const int i=0; printf("%d\n", i++); return 0; }
Options: 10,    11,    No output,    Error: ++needs a value

Ans:D ,D


The function of a database is ...
Options: a. to check all input data b. to check all spelling c. to collect and organize input data d. to output data

Ans:. c ,. c


The total number of messages handled by a computerized telephone system on a daily basis is an example of:
Options: Frequency,    Updating,    Volume,    All of the above

Ans:C ,C


Ideally, the chairman of the MIS committee should be the
Options: vice-president of manufacturing,    vice-president of marketing,    vice-president of finance,    All of the above

Ans:E ,E


.   Which key deletes text before, or the left of, the insertion point?
Options: a. Backspace b. Page up c. Delete d. Page down

Ans:9 – A ,9 – A


Batch processing is appropriate if
Options: a . large computer system is available b . only a small computer system is avilbale c . only a few transactions are involved D . none of the above

Ans:D,none of the above


.  To assign a macro to an event, users need to open the form in Design View.
Options: a.            event b.            property c.           title d.           macro

Ans:– a,– a


The microprocessor of a computer cannot operate on any information if that information is not in its.
Options: secondary storage,    main storage,    ALU,    logic unit

Ans:B ,B


. In maximum, how many sheets can be set as default while creating new workbook? 
Options: a. 254 b. 255 c. 256 d. No Limit

Ans:– b,– b


In the Binary numbering system, a (1) represents a jumper being shorted and a (0) represents a jumper being open. On a three-bit jumper block on a SCSI drive, how would an ID of logical 3 be set?
Options: 100,    010,    011,    . 101

Ans:C ,C


Data are sent over pin _____ of the EIA-232 interface.
Options: 2,    3,    4,    All of the above

Ans:A ,A


Actuarial accounting systems are associated with the _____ industry.
Options: insurance,    reliable,    consistent,    exhaustive

Ans:A ,A


Which tab in Font dialog box contains options to apply font effects?
Options:  A) Font tab, B) Character Spacing, C) Text Effects, D) Standard Toolbar,

Ans:-A,-A


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

Ans:D ,D


A memory that is capable of determining whether a given datum is contained in one of its addresses is
Options: ROM,    PROM,    CAM,    RAM

Ans:C ,C


High-level languages:
Options: are "procedure-oriented",    are very difficult to use,    cannot be used with automatic systems.,    require knowledge of the computer design

Ans:A ,A


You are about to install a second IDE hard drive in a PC that has only one IDE adapter. Your first hard drive will still be the boot drive. How should the second drive be configured?
Options: as a master,    as a secondary,    as a slave,    as a primary

Ans:C ,C


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

Ans:D ,D


Texas Instruments Incorporated produces a low-cost LISP machine called:
Options: The Computer-Based Consultant,    The Explorer,    Smalltalk,    The Personal Consultant

Ans:B ,B


Which statement(s) about IPv6 addresses are true? Leading zeros are required. Two colons (::) are used to represent successive hexadecimal fields of zeros. Two colons (::) are used to separate fields. A single interface will have multiple IPv6 addresses of different types.
Options: 1 and 3,    2 and 4,    1, 3 and 4,    All of the above

Ans:B ,B


A hand-held device which reads marks or characters on paper by detecting photo-sensitivity is known as
Options: Light pen,    Optical-wand,    Plotter,    All of the above

Ans:B ,B


Most of the time, modification anomalies are serious enough that tables should be normalized into:
Options: 1NF.,    2NF.,    3NF.,    BCNF.

Ans:D ,D


In wildcard specification ? is used as replacement for
Options: a. one character b. two character c. three character d. none of the above

Ans:8 a.,8 a.


Conversion of hexadecimal number 1D7F16 to a decimal number is
Options: 755110,    877110,    555710,    778110

Ans:A,A


. The first general purpose electronic digital computer in the world was
Options: A) UNIVAC B) EDVAC C) ENIAC D) All of above

Ans:C,C


Which switching technology reduces the size of a broadcast domain?
Options: ISL,    802.1Q,    VLANs,    STP

Ans:C ,C


What are the data transmission channels available for carrying data from one location to another?
Options: Narrowband,    Voiceband,    Broadband,    All of the above

Ans:D ,D

www.000webhost.com