Which of the following option is use to retrieval of data? a. Stack b. Data Structure c. Linked list d. Query


Options: Every primary-key value must match a primary-key value in an associated table B. Every primary-key value must match a foreign-key value in an associated table C. Every foreign-key value must match a primary-key value in an associated table D. Every foreign-key value must match a foreign-key value in an associated table

Ans:– d ,






More Database Systems Related questions:


Point out the error in the program. #include<stdio.h> #define MAX 128 int main() { char mybuf[] = "India"; char yourbuf[] = "BIX"; char const *ptr = mybuf; *ptr = 'a'; ptr = yourbuf; return 0; }
Options: Error: cannot convert ptr const value,    Error: unknown pointer conversion,    No error,    None of above

Ans:A ,A


The situation when in a linked list START=NULL is
Options: a. underflow b. overflow c. housefull d. saturated  

Ans:a,a


A hard disk is divided into tracks which are further subdivided into:
Options: clusters,    sectors,    vectors,    heads

Ans:B ,B


What is the problem with an interface if you type show interface serial 0 and receive the following message? "Serial0 is administratively down, line protocol is down."
Options: The keepalives are different times.,    The administrator has the interface shut down.,    The administrator is pinging from the interface.,    No cable is attached.

Ans:B ,B


Resistance is measured in ?
Options: Volts,    Amps,    Watts,    Ohms

Ans:D ,D


The Management Information system (MIS) structure with one main computer system is called a
Options: hierarchical MIS structure,    distributed MIS structure,    centralized MIS structure,    decentralized MIS structure

Ans:C ,C


The earliest device that qualifies as a digital computer is
Options: EDSAC,    Abacus,    ENIAC,    EDVAC

Ans:B ,B


In this world of fast changing computer technology, one of the most important factor to be considered while purchasing a PC is, it should have a provision for
Options: high level integration,    self upgradability,    intelligent sensors,    faster data access

Ans:B ,B


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


. A function inside another function is called a ….. function.
Options: a. Nested b. Round c. Sum d. Text

Ans:– a,– a


  Which PowerPoint feature adds special effects to modify the appearance of the slides and the timing between each slide?
Options: Color Schemes B. Animation C. Transition Settings D. Handouts

Ans:– C ,


The three different application logic components are which of the following?
Options: Presentation, Client, and Storage,    Presentation, Client, and Processing,    Presentation, Processing, and Storage,    Presentation, Processing, and Network

Ans:C ,C


. Access file operations can be found by clicking the ____.
Options: a. Access Button b. Database Button c. Office Button d. Window Button

Ans:5 – c ,5 – c


. To install the new font
Options: a. Start -> setting -> control panel -> font b. Start -> setting -> control panel -> font -> install new font c. Start -> control panel -> font -> install new font d. Start -> setting -> font

Ans: b, b


Which command is used to list all the files with extension .lst?
Options: ls -l *.lst,    ls lst*,    ls *.*,    ls *[lst]

Ans:A ,A


______ shares characteristics with both hardware and software
Options: Operating system B. Software C. Data D. None

Ans:– A ,


. Which is not the function of “Edit, Clear” command?
Options: a. Delete contents b. Delete notes c. Delete cells d. Delete formats

Ans:– c,– c


. The __________ is the software tool to store or access data.
Options: a. table b. DBMS c. query d. report

Ans:6 – b ,6 – b


. The personnel who deals with the computer and its management put together are called
Options: A) Software B) Human ware C) Firmware D) Hardware

Ans:B,B


. Which of the following operating system does not implement the multitasking truly?
Options: a. Windows 98 b. Windows NT c. Windows XP d. MS DOS

Ans: d, d


Demodulation is a process of
Options: converting analog to digital signals,    converting digital to analog signals,    multiplexing various signals into one high speed line signals,    performing data description.

Ans:A ,A


Point out the error in the following program. #include<stdio.h> #include<stdarg.h> void varfun(int n, ...); int main() { varfun(3, 7, -11.2, 0.66); return 0; } void varfun(int n, ...) { float *ptr; int num; va_start(ptr, n); num = va_arg(ptr, int); printf("%d", num); }
Options: Error: too many parameters,    Error: invalid access to list member,    Error: ptr must be type of va_list,    No error

Ans:C ,C


Which of the following name does not relate to stacks?
Options: a. FIFO lists b. LIFO list c. Piles d. Push-down lists

Ans: a, a


Which of the following are advantages of using NAT? Translation introduces switching path delays. Conserves legally registered addresses. Causes loss of end-to-end IP traceability. Increases flexibility when connecting to the Internet. Certain applications will not function with NAT enabled. Reduces address overlap occurrence.
Options: 1, 3 and 4,    3, 5 and 6,    5 and 6,    2, 4 and 6

Ans:D ,D


Error rate is
Options: an error-detecting code based on a summation operation performed on the bits to be checked.,    a check bit appended to an array of binary digits to make the sum of all the binary digits.,    a code in which each expression conforms to specific rules of construction, so that if certain errors occur in an expression, the resulting expression will not conform to the rules of construction and thus the presence of the errors is detected.,    the ratio of the number of data units in error to the total number of data units

Ans:D ,D


The SKETCHPAD system
Options: consisted of an cathode-ray oscilloscope driven by a Lincoln Tx2 computer where by graphical information was displayed on the screen.,    is used for interactive Graphics,    is expensive because it is sophisticated and make demands on the power and resources of the computer.,    All of the above

Ans:D ,D


Which of the following expresses correct order?
Options: a. Characters, Fields, Records, Tables, Files, Databases b. Characters, Fields, Records, Tables, Database, Files c. Databases, Tables, Files, Records, Field, Character d. Files, Databases, Tables, Records, Fields, Characters

Ans:ndash; a,ndash; a


A smart modem can dial, hang up and answer incoming calls automatically. Can you tell who provides the appropriate instruction to the modem for this purpose?
Options: Communications software,    Error detecting protocols,    Link access procedure (LAP),    Telecommunications

Ans:A ,A


An attribute is a(n):
Options: column of a table.,    two dimensional table.,    row of a table.,    key of a table.

Ans:A ,A


Cursor is a ____
Options: Pixel B. Thin blinking line C. Pointing device D. None of these

Ans:– B ,


Which of the following does not occur in phase - 4 of the system development life cycle (SDLC)
Options: conduct interviews,    train users,    acquire hardware and software,    test the new system

Ans:A ,A


What does the command o/r 0x2142 provide?
Options: It is used to restart the router.,    It is used to bypass the configuration in NVRAM.,    It is used to enter ROM Monitor mode.,    It is used to view the lost password.

Ans:B ,B


A group of magnetic tapes, videos or terminals usually under the control of one master is
Options: Cylinder,    Cluster,    Surface,    Track

Ans:B ,B


Contention is
Options: One or more conductors that serve 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:C ,C


When an input electrical signal A=10100 is applied to a NOT gate, its output signal is
Options: 01011,    10001,    10101,    00101

Ans:A ,A


What are inserted as cross-reference in Word?
Options: A. Placeholders B. Bookmarks C. Objects D. Word fields

Ans:D ,Word fields


Which one of the following equations most directly determines the amount of current flowing through a resistor when you know the value of the resistor and the voltage drop across it?
Options: E = PR,    E = I2R,    I = E/R,    I = ER

Ans:C ,C


What command is used to reset a MODEM when using the
Options: ATR,    ATZ,    DTR,    DCE

Ans:B ,B


A Database Management System (DBMS) is
Options: Collection of interrelated data B. Collection of programs to access data C. Collection of data describing one particular enterprise D. All of the above

Ans:– D ,


The Nolan _____ model identifies several phases that describe the development of information systems in organizations.
Options: stage,    plan,    decision,    master

Ans:A ,A


A fully functional computing device containing all the elements of a computer which is built around a MICROPROCESSOR is known as
Options: Machine-in-built computer,    Super computer,    Micro computer,    Mini computer

Ans:C ,C


Where one has to process all the data records in a file, the best tile organization is
Options: Indexed,    sequential,    direct access,    random access

Ans:B ,B


Which of the following contains a complete record of all activity that affected the contents of a database during a certain period of time?
Options: a. report writer b. query language c. data manipulation language d. transaction log

Ans:.d,.d


. Access time is
Options: A) seek time + latency time B) seek time C) seek time ? latency time D) latency time

Ans:A,A


Which of the following products implemented the CODASYL DBTG model?
Options: IDMS,    DB2,    dBase-II,    R:base

Ans:A ,A


Which output device is used for translating information from a computer into pictorial form on paper.
Options: Mouse,    Plotter,    Touch panel,    Card punch

Ans:B,(Banswer


Which of the following is a type of DBMS software?
Options: database manipulation language,    query language,    utilities,    report writer

Ans:A ,A


Which of the following is not an Input Device?
Options: A. Touch Screen B. Optical Scanners C. Touch Pad D. Mouse Pad

Ans:D,


. The box on the chart that contains the name of each individual record is called the ________.
Options: a. cell b. title c. axis d. legend

Ans:– d,– d


Which one of the following equations most directly determines the power dissipation of a resistance when you know the voltage drop and amount of resistance?
Options: P = I2R,    P = IE,    P = E2/R,    I = P/E

Ans:C ,C

www.000webhost.com