Which SQL Query is use to remove a table and all its data from the database? a. Create Table b. Alter Table c. Drop Table d. None of these

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:– c ,

Description: mcqquestions

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

Hits Today: 11100 | 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:

. Which of the following is not a video file extension?
Options: a. .avi b. .wav c. .mpeg d. .mov

Ans:1 – b ,1 – b

What will be the output of the program? #include<stdio.h> #define str(x) #x #define Xstr(x) str(x) #define oper multiply int main() { char *opername = Xstr(oper); printf("%s\n", opername); return 0; }
Options: Error: in macro substitution,    Error: invalid reference 'x' in macro,    print 'multiply',    No output

Ans:C ,C

33. The spike
Options: a. Allows you to combine text from several documents and tehn insert all the text into one document at onwe time b. Allows you to edit auto text entries c. Allows you to format uto text entries d. All of above

Ans:– A ,– A

. Pick the one that is used for logical operations or comparisons such as less than equal to or greater than.
Options: A) Arithmetic and Logic Unit B) Control Unit C) Both of above D) None of above


When creating a pool of global addresses, which of the following can be used instead of the netmask command?
Options: / (slash notation),    prefix-length,    no mask,    block-size

Ans:B ,B

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

Ans:A ,A

By default a real number is treated as a
Options: float,    double,    long double,    far double

Ans:B ,B

Without using the mouse or the arrow keys, what is the fastest way of getting to cell A1 in a spreadsheet?
Options: a. Press Ctrl +Home b. Press Home c. Press Shift + Home d. Press Alt + Home

Ans:#8211; a,#8211; a

A transitive dependency is which of the following?
Options: A functional dependency between two or more key attributes.,    A functional dependency between two or more nonkey attributes.,    A relation that is in first normal form.,    A relation that is in second normal form.

Ans:B ,B

A communications medium that uses pulses of laser light in glass fibers. Select the best fit for answer:
Options: Fiber optic cables,    Cellular phone systems,    Telecommunications processors,    Telecommunications software

Ans:A ,A

. WAN stands for
Options: A) Wap Area Network B) Wide Area Network C) Wide Array Net D) Wireless Area Network


Thorough planning must take place when setting up an 802.3 network. A maximum number of segments can separate any two nodes on the network. What is the maximum number of segments allowed between two nodes?
Options: Five,    Two,    Four,    Six

Ans:A ,A

Which device does the general population associate most with automation?
Options: Flexible manufacturing,    Robots,    Numerical control machine,    Computer graphics workstation

Ans:B ,B

. Merge cells option can be applied from
Options: a. Format Cells dialog box Alignment Tab b. Formatting toolbar c. Both of above d. None of above

Ans:– a,– a

The ALU of a central processing unit does the essential maths work for the computer. What does the control unit do?
Options: Communicates its results,    Activates the output device,    Monitors the flow of information,    Control the printer

Ans:C ,C

. In a datasheet, what does each column represent?
Options: a. Record b. Field c. Database d. Table

Ans:– b,– b

Difficult of MIS implementation is affected by
Options: employee attitude,    the firm's objectives,    the firm's existing MIS,    All of the above

Ans:D ,D

The management information system (MIS) structure with one main computer system is called a
Options: a. hierarchical MIS structure b. distributed MIS structure c. centralized MIS structure d. decentralized MIS structure

Ans:C,centralized MIS structure

If a piece of data is stored in two places in the database, then 
Options: a . storage space is wasted b . changing the data in one spot will cause data inconsistency c . in can be more easily accessed d . both and b


As a general rule.
Options: MIS performance criteria determine management information needs, and these needs determine the objectives of the firm.,    the firm's objective determine management information needs, and these needs determine MIS performance criteria,    management information needs determine MIS performance criteria, and these criteria determine the firm's objectives,    the firm's objectives determine MIS performance criteria, and these criteria determine manage¬ment information needs.

Ans:B ,B

. A(n) _______________ query makes changes to or moves records in a dynaset, in a single operation.
Options: a. select b. summary c. parameter d. action

Ans:3 – d ,3 – d

The central processor of a modern digital computer consists of
Options: control unit,    primary memory,    control unit and primary memory,    All of the above

Ans:C ,C

Which one of the following statements most accurately reflects the nature of ac power?
Options: The current in an ac circuit flows in one direction, but changes value periodically,    The current in an ac circuit flows in one direction at a steady level,    The current in an ac circuit changes direction periodically,    The current in an ac circuit flows in two directions at the same time

Ans:C ,C

The signal to noise ratio for a voice grade line is 30.1 dB (decibels) or a power ratio of 1023:1. The maximum achievable data rate on this line whose spectrum ranges from 300 Hz to 4300 Hz is
Options: 6200 bps,    9600 bps,    34000 bps,    31000 bps

Ans:D ,D

An instruction that transfers program control to one or more possible paths is known as
Options: Utility program,    System software,    Broadband channel,    Application program

Ans:C ,C

Which of the following is not an output device of a computer?
Options: Printer,    keyboard,    VDU,    CRT screen

Ans:B ,B

Who invented the modem?
Options: Wang Laboratories Ltd.,    AT & T Information Systems, USA,    Apple Computers Inc.,    Digital Equipment Corpn.

Ans:B ,B

. LSI, VLSI & ULSI chips were used in which generation?

Options: A) First B) Second C) Third D) Fourth


Who is called a supervisor of computer activity? A)  Memory B)  Operating System C)  I/O Devices D)  Control Unit

Ans:– B ,

Which of the following is the largest and most powerful computer manufacture in the world
Options: IBM,    Intel,    Novel,    Microsoft

Ans:A ,A

How many digits of the Network User Address are known as the DNIC (Data Network Identification Code)?
Options: first three,    first four,    first five,    first seven

Ans:B ,B

The instruction register
Options: is a hardware memory device which denotes the location of the current instruction being executed.,    is a group of electrical circuits (hardware), that performs the intent of instructions fetched from memory.,    contains the address of the memory location that is to be read from or stored into.,    contains a copy of the designated memory location specified by the MAR after a "read" or the new contents of the memory prior to a "write".

Ans:B ,B

Bringing a page into memory only when it is needed, this mechanism is called
Options:  Deadlock B.  Page Fault C.  Dormant Paging D.  Demand Paging

Ans:– D ,

Which of following is/are the advantage(s) of modular programming?
Options: The program is much easier to change,    Modules can be reused in other programs,    Easy debugging,    Easy to compile

Ans:A ,A

The following is true about 2-out of-5 code:
Options: it is weighted code,    it is unweighted code,    it has odd parity,    All of the above

Ans:B ,B

Which of the following is a read only memory storage device?
Options:  Floppy Disk B.  CD-ROM      C.  Hard Disk D.  None of these

Ans:– B ,

On executing the below program what will be the contents of 'target.txt' file if the source file contains a line "To err is human"? #include<stdio.h> int main() { int i, fss; char ch, source[20] = "source.txt", target[20]="target.txt", t; FILE *fs, *ft; fs = fopen(source, "r"); ft = fopen(target, "w"); while(1) { ch=getc(fs); if(ch==EOF) break; else { fseek(fs, 4L, SEEK_CUR); fputc(ch, ft); } } return 0; }
Options: r n,    Trh,    err,    None of above

Ans:B ,B

The slowest transmission speeds are those of
Options: twisted-pair wire,    coaxial cable,    fiber-optic cable,    microwaves

Ans:A ,A

Which of the following storage and retrieval methods would be well suited to your processing requirements if you only need to retrieve records one at a time and there is no fixed pattern to the requests for data and records?
Options: indexed sectors,    sequential,    direct,    indexed direct

Ans:D ,D

  Which option in PowerPoint allows you to create a package of your presentation for showing to another computer?
Options: Save As B. Save and Go C. Pack and Go D. Web and Go

Ans:– C ,

What is the type of Oracle backup in which all uncommitted changes have been removed from the datafiles?
Options: Full backup,    Consistent backup,    Inconsistent backup,    Differential backup

Ans:B ,B

What will be the output of the program in 16 bit platform (Turbo C under DOS)? #include<stdio.h> int main() { extern int i; i = 20; printf("%d\n", sizeof(i)); return 0; }
Options: 2,    4,    vary from compiler,    Linker Error : Undefined symbol 'i'

Ans:D ,D

Which is NOT typically a Field Replaceable Unit?
Options: System ROM,    Power supply,    System chasis,    Video controller

Ans:C ,C

. Which program would you use to create copies of important information stored on your fixed disk drive?
Options: a. Scan disk b. Copy disk c. Back up d. None of above

Ans:3 – c ,3 – c

What is the maximum number of lines you can set for a drop cap?
Options:  A) 3, B) 10, C) 15, D) 20,


When determining the efficiency of algorithm the time factor is measured by
Options: A)Counting microseconds b.Counting the number of key operations c.Counting the number of statements d.Counting the kilobytes of algorithm


Which option will be used with disk free command to include the total amount of disk space in the file system?
Options: -t,    -tt,    -4,    -i

Ans:A ,A

The MODE command of MS-DOS is used to
Options: display information about several types of devices installed in your computer,    provide various types of control over your printers,    make changes of the current display,    All of the above

Ans:D ,D

.  Which language is used to create macros in Excel?
Options: a. Visual Basic b. C c. Visual C++ d. Java

Ans:– a,– a

. The operating speed of third generation computer was
Options: A) Milliseconds B) Microseconds C) Nanoseconds D) Picoseconds