A Relation is a


Options: Subset of a Cartesian product of a list of attributes B. Subset of a Cartesian product of a list of domains C. Subset of a Cartesian product of a list of tuple D. Subset of a Cartesian product of a list of relations

Ans:– B ,


Description: mcqquestions

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

Hits Today: 5914 | Level: Moderate


******************************************************

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

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




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




More Database Systems Related questions:


Which of the following files contains information related to password aging?
Options: Shadow,    password,    profile,    All the three

Ans:B ,B


How many hosts are attached to each of the local area networks at your site?
Options: 128,    254,    256,    64

Ans:B ,B


. Which one is notoperating system?
Options: a. P11 b. OS/2 c. Windows d. Unix

Ans: a, a


The complexity of the average case of an algorithm is
Options: a. Much more complicated to analyze than that of worst case b. Much more simpler to analyze than that of worst case c. Sometimes more complicated and some other times simpler than that of worst case d. None or above  

Ans:a,a


An IRQ allow interface cards to:
Options: Interrupt the CPU to request service,    Pass data to the CPU to be processed,    Pass data from one card to another,    Pass data to the computers memory

Ans:A ,A


In OSI network architecture, the dialogue control and token management are responsible of
Options: data link layer,    transport layer,    network layer,    session layer

Ans:D ,D


. What do you mean by dialog box?
Options: a. Interactive message box b. Group of options c. Set of controls d. All of the above

Ans:D,All of above


A device that prints one character at a ! time is kknown as
Options: Laser printer,    Line printer,    Character printer,    Dot-Matrix printer

Ans:C ,C


Transient data is which of the following?
Options: Data in which changes to existing records cause the previous version of the records to be eliminated,    Data in which changes to existing records do not cause the previous version of the records to be eliminated,    Data that are never altered or deleted once they have been added,    Data that are never deleted once they have been added

Ans:A ,A


. What is a compiler?
Options: A) 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,B


What frequency range is used for FM radio transmission?
Options: Very Low Frequency : 3 kHz to 30. kHz,    Low Frequency : 30 kHz to 300 kHz,    High Frequency : 3 MHz to 30 MHz,    Very High Frequency : 30 MHz to 300 MHz

Ans:D ,D


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

Ans:D ,D


A numeric error code check: A 17xx indicates a problem with:
Options: CMOS,    ROM BIOS,    DMA controller,    hard drive or controller

Ans:D ,D


Which of the following is the decimal and hexadecimal equivalents of the binary number 10011101?
Options: 155, 0x9B,    157, 0x9D,    159, 0x9F,    185, 0xB9

Ans:B ,B


Using the _____ switch causes FDISK to display the partition status of your hard disk without executing FDISK.
Options: /show,    /display,    /status,    /part

Ans:C ,C


. Which unit is known as nerve center of computer?
Options: A) ALU B) CU C) Memory D) Registers

Ans:B,B


Who developed a mechanical device in the 17th century that could add, subtract, multiply, divide and find square roots?
Options: Napier,    Babbage,    Pascal,    Leibnitz

Ans:D ,D


The files stored on a secondary stage device are composed of a hierarchy of data. What does a record in a file contain?
Options: Bits,    Characters,    Data field,    Schema

Ans:C ,C


Which scheduler selects which processes should be brought into the ready queue?
Options: Real-term B. Long-term C. Mid-term D. Short-term

Ans:– B ,


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

Ans:A ,A


The ALU of a computer normally contains a number of high speed storage elements called
Options: semiconductor memory,    registers,    hard disk,    magnetic disk

Ans:B,B


A subtype discriminator is which of the following?
Options: An attribute of the supertype whose values determine the subtype,    An attribute of the subtype whose values determine the supertype,    An attribute of the supertype whose values determine the supertype,    An attribute of the subtype whose values determine the subtype

Ans:A ,A


. In databases, Locking level is also called as
Options: a. Granularity b. S lock c. X lock d. Dead lock

Ans:– a,– a


The advent of personal computers:
Options: will make our lives more productive,    could cause us to lose some of our basic skills,    will take away some of the boring tasks that we have to perform,    All of the above

Ans:D ,D


. Which of the following is not input unit device?
Options: A) scanner B) camera C) plotter D) digitizer

Ans:C,C


. Which of the following is not an XT microprocessor?
Options: A) 8006 B) 8086 C) 8088 D) None of above

Ans:4-D,4-D


The model for a record management system might be
Options: a. handwritten list b. a Rolodex card file c. a business form d. all of above

Ans:d,All of above


What will be the output of the program ? #include<stdio.h> int main() { static int arr[] = {0, 1, 2, 3, 4}; int *p[] = {arr, arr+1, arr+2, arr+3, arr+4}; int **ptr=p; ptr++; printf("%d, %d, %d\n", ptr-p, *ptr-arr, **ptr); *ptr++; printf("%d, %d, %d\n", ptr-p, *ptr-arr, **ptr); *++ptr; printf("%d, %d, %d\n", ptr-p, *ptr-arr, **ptr); ++*ptr; printf("%d, %d, %d\n", ptr-p, *ptr-arr, **ptr); return 0; }
Options: 0, 0, 0 1, 1, 1 2, 2, 2 3, 3, 3,    1, 1, 2 2, 2, 3 3, 3, 4 4, 4, 1,    1, 1, 1 2, 2, 2 3, 3, 3 3, 4, 4,    0, 1, 2 1, 2, 3 2, 3, 4 3, 4, 5

Ans:C ,C


You are editing an worksheet that you had previously saved. If you want to save the edited sheet without losing the original one, which command should you use?
Options: New B. Save As C. Edit D. Save

Ans:– B ,


. What is meant by a dedicated computer?
Options: A) Which is used by one person only B) Which is assigned one and only one task C) Which uses one kind of software D) Which is meant for application software

Ans:B,B


Read-only databases are ________ updated.
Options: always,    commonly,    seldom,    never

Ans:D ,D


. In MS Access, Text Data type may contain maximum character of
Options: a. 255 Character b. 256 Character c. 1064 Character d. No Limit

Ans:– a,– a


Which of the following FRUs would be considered both an input/output device?
Options: Video board,    SCSI host adapter,    System board CPU,    All of the above

Ans:B ,B


. A ________ is a unit of information in a ________
Options: a. record, field b. field, record c. data source, field d. record, data source

Ans:– b,– b


. Which command will you use to transfer a specific file from one disk to another disk?
Options: a. Time b. Diskcopy c. Copy d. Rename

Ans:7 – c ,7 – c


Match the device driver HIMEM.SYS to its operation
Options: Supports (ANSI) terminal emulation,    Manages the use of extended memory,    Uses expanded memory on an 80386 processor,    Supports code page switching

Ans:B ,B


The research and development department at your office has been experimenting with different technologies to help improve the performance of the network. One group has been examining the use of a broadband network versus a based band network. Select the correct statement about broadband and baseband.
Options: Broadband networks carry several channels on a single cable, whereas in a baseband network several cables carry one channel,    Baseband networks carry a single channel on a single cable, whereas broadband networks carry several channels on a single cable,    Baseband refers to local area networks, and broadband refers to wide area networks.,    Baseband operates at a standard bit rate, whereas broadband may operate at different rates as needed

Ans:B ,B


What is the power dissipation of a resistance that has 24 V dropped across it and 0.25 A flowing through it?
Options: 3 W,    6 W,    64 W,    122 W

Ans:B ,B


A device that can accept data hold them deliver them on demand at a later time is known as
Options: Buffer,    Memory,    CPU,    Register

Ans:B ,Memory


Which of the following protocols uses both TCP and UDP?
Options: FTP,    SMTP,    Telnet,    DNS

Ans:D ,D


Which of the following statements is true about symmetric multiprocessing?
Options: A single copy of the operating system resides in each processor.,    Useful for situations where data must remain in memory to process.,    Bottlenecks increase with uniprocessor systems because tasks are not shared.,    The problems of memory contention are unlikely.

Ans:B ,B


In SQL, the CREATE TABLE is used
Options: to create a table, defining its columns, integrity constrains, and storage allocation,    to add a column/integrity constraint to a table,    to redefine a column,    to change a table's storage characteristics

Ans:A ,A


Which of the following formulas is not entered correctly?
Options: a. =10+50 b. =B7*B1 c. =B7+14 d. 10+50

Ans:#8211; d,#8211; d


Conversion method in which users, being used to an old system, continue to use the old system, alongside the new system, is
Options: multi processing,    multitasking,    parallel run,    All of the above

Ans:C ,C


The two major categories of software are: application software and
Options: system software,    UNIX software,    high-level languages,    CAD software

Ans:A ,A


. 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


You can detect spelling and grammar errors by
Options:  A) Press Shift + F7, B) Press Ctrl + F7, C) Press Alt+ F7, D) Press F7, 

Ans:-D,-D


The earliest calculating devices are
Options: Abacus B. Clock C. Difference Engine D. None of these

Ans:– A ,


Structured design produces computer programs that are
Options: easily,    maintained,    easily understood,    both (a) and (b)

Ans:D ,D


Claude Shannon described the operation of electronic switching circuits with a system of mathematical logic called:
Options: LISP,    XLISP,    Boolean algebra,    neural networking

Ans:C ,C

www.000webhost.com