How many types of keys in Database Design?


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

Ans:– d ,


Description: mcqquestions

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

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


The binary equivalent of the Octal number 13.54 is
Options: 1011.1011,    1101.1110,    1001.1110,    All of the above

Ans:A ,A


Baseband is
Options: transmission of signals without modulation,    a signal all of whose energy is contained within a finite frequency range,    the simultaneous transmission of data to a number of stations,    All of the above

Ans:A ,A


The total capacitive reactance of a parallel capacitor circuit is:
Options: equal to the sum of the individual capacitive-reactance values,    equal to the sum of the individual capacitance values,    equal to the source voltage divided by total current,    less than the capacitance value of the smallest capacitor

Ans:C ,C


Which of the following digits are known as the terminal number of the Network User Address (NUA)?
Options: 5-7,    1-4,    8-12,    13-14

Ans:C ,C


After a table has been created, its structure can be modified using the SQL command:
Options: UPDATE TABLE [TableName].,    MODIFY TABLE [TableName].,    ALTER TABLE [TableName].,    CHANGE TABLE [TableName].

Ans:C ,C


In a _____ one module of the new information system is activates at a time.
Options: System Development Life Cycle,    CASE tool,    Phased Conversion,    Success factors

Ans:C ,C


Which of the following is graphics solution for Word Processors?
Options:  A) Clipart, B) WordArt, C) Drop Cap, D) All of above,

Ans:-A,-A


Which of the following is not one of the three ‘Mail Merge Helper’ steps?
Options: a. merge the two files b. create the main document c. set the mailing list parameters d. create the data source

Ans:– C,– C


Usually, it takes 10-bits to represent one character. How many characters can be transmitted at a speed of 1200 BPS?
Options: 10,    12,    120,    1200

Ans:C ,C


Which of the following IC was used in third generation of computers?
Options: A) SSI B) MSI C) LSI D) Both a and b

Ans:-D,-D


Which of the following is not a font style?
Options: a. Bold b. Italics c. Regular d. Superscript

Ans:– D,– D


Corporate modeling software can be used for
Options: cash planning,    operational budgeting,    capital budgeting,    All of the above

Ans:D ,D


. To center worksheet titles across a range of cell, you must
Options: a. Select the cells containing the title text and use the fill handle to center the text across a range of cells b. Select the cells containing the title text and click on Center button c. Select the cells in range containing the title text and use the Merge and Center tool d. Widen the column

Ans:– c,– c


Which of the following is true concerning personal computers?
Options: They decrease the demand for mainframe computers,    They have been most successful in the home,    The electronic spreadsheet has been a primary reason for their popularity,    Their future is not so bright owning to the improved cost-performance ratio of minis and mainframes

Ans:C ,C


If a switch receives a frame and the source MAC address is not in the MAC address table but the destination address is, what will the switch do with the frame?
Options: Discard it and send an error message back to the originating host,    Flood the network with the frame,    Add the source address and port to the MAC address table and forward the frame out the destination port,    Add the destination to the MAC address table and then forward the frame

Ans:C ,C


What is the use of Ping command?
Options: To test a device on the network is reachable B. To test a hard disk fault C. To test a bug in a Application D. To test a Pinter Quality

Ans:– A ,


For normal operation of the transistor, the collector diode has to be
Options: Forward-biased,    Reverse-biased,    Nonconducting,    Operating in the breakdown region

Ans:B ,B


Hardware _____ memory is seldom used in modern computers.
Options: ROM,    RAM,    LIFO,    PROM

Ans:C ,C


Which is considered a direct entry input device?
Options: Optical scanner,    Mouse,    Light pen,    Digitizer

Ans:E ,E


How many address lines are needed to address each memory locations in a 2048 x 4 memory chip?
Options: a. 10 b. 11 c. 8 d. 12 

Ans:3.b,3.b


Helping people keep track of things is the purpose of a(n) ________ .
Options: database,    table,    instance,    relationship

Ans:A ,A


Which command is used to sort the lines of data in a file in reverse order
Options: sort,    sh,    st,    sort -r

Ans:D ,D


Which of the following is NOT an Oracle-supported trigger?
Options: BEFORE,    DURING,    AFTER,    INSTEAD OF

Ans:B ,B


The OCR stand for?
Options: Outsized character reader,    Optical character recognition,    Operational character reader,    Only character reader

Ans:B ,B


Methods used to organise and physically store disk data are cylinder and
Options: Sector,    Surface,    Track,    Hib

Ans:A ,A


When the values in one or more attributes being used as a foreign key must exist in another set of one or more attributes in another table, we have created a(n):
Options: transitive dependency.,    insertion anomaly.,    referential integrity constraint.,    normal form.

Ans:C ,C


. A computer which CPU speed around 100 million instruction per second and with the word length of around 64 bits is known as
Options: A) Super computer B) Mini computer C) Micro computer D) Macro computer

Ans:A,A


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

Ans:B,B


The analog computer measures dimensions and its circuits use the differential and integral equations of continuous variables. The digital computer counts units and its circuits use
Options: Logic gates,    Discrete switches,    Boolean algebra id) Bayes' theorem,    None of the above

Ans:C ,C


Which command is used to change directory to the name beginning with a 'p'?
Options: cd p,    cd p?,    cd p*,    cd [p]

Ans:C ,C


Which of the following statement is true.
Options: The LRU algorithm pages out pages that have been used recently,    Thrashing is a natural consequence of virtual memory systems.,    Seek analysis is used for analysing control-unit busy problems.,    All of the above

Ans:C ,C


The power source that drives the manipulator can be:
Options: pneumatic,    electric,    hydraulic,    All of the above

Ans:D ,D


Dot-matrix is a type of
Options: Tape,    Printer,    Disk,    Bus

Ans:B ,B


Which of the following is major activities of an operating system in regard to secondary-storage management?
Options: Free-space management B. Storage allocation C. Disk scheduling D. All of the above

Ans:– D ,


Which is built directly on the hardware?
Options: Computer Environment B. Application Software C. Operating System D. Database System

Ans:– C ,


A workstation has just been installed on an Ethernet LAN, but cannot communicate with the network. What should you check first?
Options: reinstall the network protocols,    reinstall the network interface card driver,    verify the ip configuration on the workstation,    verify the link status on the computer's network card

Ans:D ,D


What is the language used by most of the DBMSs for helping their users to access data?
Options: High level language,    Query language,    SQL,    4GL

Ans:B ,B


The equipment with which the computer talks to its users is called a
Options: word processor,    peripheral,    software,    diskette

Ans:B,B


. CPU speed of a personal computer is

Options: A) 32 KIPS B) 100 KIPS C) 1 MIPS D) None of these

Ans:B,B


Which layer 1 devices can be used to enlarge the area covered by a single LAN segment? Switch NIC Hub Repeater RJ45 transceiver
Options: 1 only,    1 and 3,    3 and 4,    5 only

Ans:C ,C


What will be the output of the program? #include<stdio.h> #include<stdarg.h> void dumplist(int, ...); int main() { dumplist(2, 4, 8); dumplist(3, 6, 9, 7); return 0; } void dumplist(int n, ...) { va_list p; int i; va_start(p, n); while(n-->0) { i = va_arg(p, int); printf("%d", i); } va_end(p); printf("\n"); }
Options: 2 4 3 6,    2 4 8 3, 6, 9, 7,    4 8 6 9 7,    1 1 1 1 1 1 1

Ans:C ,C


. Why ABC computer is called so?
Options: A) Because it was developed by Atanasoff and Berry B) Because it was thought to be the first computer so named with first alphabets of English C) Both of above are the reason to name the computer ABC D) None of above are true

Ans:A,A


Filename extensions help identify certain files. What filename extension identifies executable files?
Options: INF,    PRO,    EXE,    SYS

Ans:C ,C


Demodulation is the process of
Options: converting digital signals to analog signals,    converting analog signals to digital signals,    combining many low speed channels into one high speed channel,    dividing the high-speed signals into frequency bands

Ans:B ,B


. Microsoft Excel is a powerful………..
Options: a. Word processing package b. Spreadsheet package c. Communication S/W Package d. DBMS package

Ans:– b,– b


How many buses are connected as part of the 8085 microprocessor?
Options: 2,    3,    5,    8

Ans:B ,B


When we mention the prototype of a function?
Options: Defining,    Declaring,    Prototyping,    Calling

Ans:B ,B


A favourable reason for automation is to:
Options: decrease throughput,    raises assembly cost,    perform difficult operations,    increase number of operations

Ans:C ,C


From which menu you can insert Header and Footer?
Options:  A) Insert Menu, B) View Menu, C) Format menu, D) Tools Menu,

Ans:-B,-B


. How can you optimize performance of your computer?
Options: a. Delete unused files b. Defrag disk c. Scan for virus d. All of above

Ans:8 – d ,8 – d

www.000webhost.com