Which algebra is widely used in DBMS?


Options: a. Relational algebra b. Arithmetic algebra c. Both d. None

Ans:– a ,


Description: mcqquestions

Asked in: KCC-2018   |   JOA 556-2018  |  HRTC JTO-2017

Hits Today: 13319 | Level: Moderate




Got some suggestion about this question or to make this site better? Please leave your comments below.


Want to see where do you stand among other aspirants in "Computer" Category?

Click Here to take quick 5 mins MCQ test to find out.

More Database Systems Related questions:


While working with MS-DOS, which command is used to switch to the monochrome display from color display?
Options: MODE BLACK,    MODE B/W,    MODE MONO,    MODE CO40

Ans:C ,C


When a new trunk link is configured on an IOS-based switch, which VLANs are allowed over the link?
Options: By default, all VLANs are allowed on the trunk.,    No VLAN's are allowed, you must configure each VLAN by hand.,    Only configured VLAN's are allowed on the link.,    Only extended VLAN's are allowed by default.

Ans:A ,A


Program execution time would be minimum if the programs are written in
Options: Machine Language,    Assembly language,    High level language,    All of the above

Ans:A ,A


Which of the following is not a primary reason for the popularity of decision support systems?
Options: declining cost of computer hardware,    advent of data-base management systems,    increased number of programmers,    management trained in analytic techniques

Ans:C ,C


The model for a record management system might be
Options: handwritten list,    a Rolodex card file,    a business form,    All of the above

Ans:D ,D


A record management system
Options: a. can handle many files of information at a time b. can be used to extract information stored in a computer file c. always uses a list as its model d. both a and b 

Ans:.b,.b


. What is the AutoComplete feature of Excel?
Options: a. It automatically completes abbreviated words b. It completes text entries that match an existing entry in the same column c. It completes text and numeric entries that match an existing entry in the same column d. It completes text entries that match an existing entry in the same worksheet

Ans:– b,– b


What is the minimum number of operations required, for a microprocessor with 8 data pins, to read a 32-bit word?
Options: 1,    2,    4,    8

Ans:C ,C


Suppose a current source has an Ideal current of 10 mA and an internal resistance of 20 MW. For what values of load resistance will the current source appear stiff?
Options: 20 k Ohm or more,    200 k Ohm or less,    200 k Ohm or more,    20 km or less

Ans:B ,B


. In a computer _____ is capable to store single binary bit.
Options: A) Capacitor B) Flip flop C) Register D) Inductor

Ans:B,B


  Power Point presentation is a collection of ________
Options: Slides and Handouts B. Speaker’s notes C. Outlines D. All of the above

Ans:– D ,


Which of the following statements is incorrect?
Options: Multiplexers are designed to accept data from several I/O devices and transmit a unified stream of data on one communication line.,    HDLC is a standard synchronous communication protocol.,    RTS/CTS is the way the DTE indicates that it is ready to transmit data and the way the DCE indicates that it is ready to accept data.,    RTS/CTS is the way the terminal indicates ringing

Ans:D ,D


A typical modern computer uses
Options: LSI chips,    Vacuum tubes,    Valves,    All the above

Ans:A ,A


. All attachment fields display as a(n) ____ in Datasheet View.
Options: a. icon b. button c. thumb tack d. paperclip

Ans:3 – d ,3 – d


To create relationship between two tables
Options: a. drag the primary key of a table into foreign key of another table b. drag the foreign key of a table into the primary key of another table c. drag any field from parent table and drop on child table d. Any of above can be done to create relationship

Ans:ndash; a,ndash; a


The barcode which is used on all types of items, is read by a scanning device directly into the computer. What is the name of this scanning device?
Options: Laser scanner,    Wand,    OCR,    MICR

Ans:A ,A


A mechanism for arranging controlled access to a shared resource is
Options: Retrieving,    Sorting,    Balleting,    Lock-out

Ans:D ,D


A physical connection between the microprocessor memory and other parts of the microcomputer is known as
Options: A) Path B) Address bus C) Route D) All of the above

Ans:-B,-B


The following process determines the amount of memory present, the date/ time, and which communications ports and display adapters are installed in a microcomputer?
Options: Start-up utility test,    Power on Self Test,    Power up boot process,    Power on start up process

Ans:B ,B


The application layer of a network
Options: establishes, maintains, and terminates virtual circuits,    defines the user's port into the network,    consists of software being run on the computer connected to the network,    All of the above

Ans:C ,C


. When a thread waits indefinitely for some resource, but other threads are actually using it is called
Options: Starvation B. Demand Paging C. Segmentation D. None of them

Ans: – A ,


. To place something in the same position on every slide of presentation automatically, insert into
Options: a. Slide master b. Notes master c. Handout master d. None of the above

Ans:3 – A ,3 – A


How much should an organisation spend for information can be determined by some type of a:
Options: cost analysis,    benefit analysis,    cost-benefit analysis,    any of the above

Ans:C ,C


Which part of the system allows the user to interact with the compiler? (a) Memory
Options: Translator,    Communications processor,    Interpreter,    None of the above

Ans:D ,D


. If you want all of the white cats grouped together in the database, you need to sort by ________.
Options: a. Color, then Gender b. Pet Type, then Color c. Pet Type, then Gender d. Color, then Pet Name

Ans:– b,– b


Each data item in a record may be a group item composed of sub-items; those items which are indecomposable are called
Options: a. elementary items b. atoms c. scalars d. all of above

Ans: d, d


Which is used to store firmware.
Options: RAM,    ROM,    PROM,    EPROM

Ans:B ,B


Which of the following indicates the minimum number of entities that must be involved in a relationship?
Options: Minimum cardinality,    Maximum cardinality,    ERD,    Greater Entity Count (GEC)

Ans:A ,A


From what location are the 1st computer instructions available on boot up?
Options: ROM BIOS,    CPU,    boot.ini,    CONFIG.SYS

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


. To access properties of an object, the mouse technique to use is __________.
Options: a. dragging b. dropping c. right-clicking d. shift-clicking

Ans:6 – c ,6 – c


A byte is comprised of:
Options: One bit,    Four bits,    Eight bits,    Sixteen bits

Ans:C ,C


Which one of the following statements is true for the voltage in a parallel RL circuit?
Options: The voltage always has the same amplitude and phase for every part of the circuit,    The total voltage is equal to the sum of the voltages across the resistance and inductance,    The total voltage lags the total current by less than 90,    The total voltages is less than the sum of the voltages across the resistance and inductance

Ans:A ,A


Which of the following typically uses a keyboard for input?
Options: desktop terminal,    point-of-sale terminal,    financial transaction terminal,    All of the above

Ans:D,All of the above


. The __________ is used to access one record at a time.
Options: a. query b. filter c. form d. report

Ans:4 – c ,4 – c


What is x in the following program? #include<stdio.h> int main() { typedef char (*(*arrfptr[3])())[10]; arrfptr x; return 0; }
Options: x is a pointer,    x is an array of three pointer,    x is an array of three function pointers,    Error in x declaration

Ans:C ,C


A benefit of the three-tier architecture is which of the following?
Options: New modules can be built to support specific business needs,    Performance improves for compiled SQL statements,    Results in a thinner client and database server,    All of the above.

Ans:A ,A


What is the name of the visible silver rectangle which separates the take-up portion of the magnetic tape from the data recording portion?
Options: Load maker,    Load marker,    Tape separator,    Tape marker

Ans:B ,B


Which of the following is the first computer to use Stored Program Concept?
Options: A) UNIVAC B) ENIAC C) EDSAC D) None of above

Ans:-C,-C


The characteristics of the computer system capable of thinking, reasoning and learning is known is
Options: machine intelligence,    human intelligence,    artificial intelligence,    virtual intelligence

Ans:C ,C


How does a parallel port communicate information to a peripheral device?
Options: one bit at a time,    8 bytes at a time,    one byte at a time,    16,555 bytes at a time

Ans:C ,C


The average time necessary for the correct sector of a disk to arrive at the read write head is _____
Options: Down time,    Seek time,    Rotational delay,    Access time

Ans:C ,C


. To drag a selected range of data to another worksheet in the same workbook, use the
Options: a. Tab key b. Alt key c. Shift key d. Ctrl key

Ans:– d,– d


The saturation point is approximately the same as
Options: cutoff point,    lower end of the load line,    upper end of the load line,    infinity

Ans:C ,C


In data transmission, the bit coding scheme used to represent a byte is typically:
Options: EBCDIC,    ASCII,    SNA,    Hexadecimal

Ans:B ,B


An expert system differs from a database program in that only an expert system:
Options: contains declarative knowledge,    contains procedural knowledge,    features the retrieval of stored information,    expects users to draw their own conclusions

Ans:B ,B


. The Name box on to the left of formula bar
Options: a.  shows the name of workbook currently working on b.  shows the name of worksheet currently working on c.  shows the name of cell or range currently working on d.  None of above

Ans:– c,– c


Which one of the following properties of a magnetic circuit can be directly compared to voltage in an electrical circuit?
Options: Flux density,    Number of lines of force,    Magnetomotive force,    Reluctance

Ans:C ,C


A transaction for which all committed changes are permanent is called:
Options: atomic.,    consistent.,    isolated.,    durable.

Ans:D ,D


The word 'linear' in linear programming is used to describe:
Options: relationship among two or more variables in a straight line,    relationship among two or more variable which are directly proportional,    relationship among two or more variables is linear,    all of the above

Ans:B ,B

www.000webhost.com