. Which of the following is true regarding Referential Integrity?


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: 10849 | 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:


Regarding a VDU, which statement is more correct?
Options: It is an output device,    It is an input device,    It is a peripheral device,    It is a hardware item

Ans:C ,C


. If 4/6 entered in a cell without applying any formats, Excel will treat this as
Options: Fraction B. Number C. Text D. Date

Ans:– D ,


. Which computers are used as servers for any medium sized organizations?
Options: A) Mainframe Computer B) Mini Computers C) Micro Computers D) Super Computers

Ans:B,B


Critical _____ factors are those that are vital if a manager is to make a full contribution to the achievement of an organization's goals.
Options: tactical,    success,    decision,    concise

Ans:B ,B


Pick the correct choice for the 8088 CPU.
Options: 16 bit word size, 8 bit data path,    8 bit word size, 8 bit data path,    16 bit word size, 16 bit data path,    4 bit word size, 8 bit data path

Ans:A ,A


. The date and time displays on
Options: a. Taskbar b. Status bar c. System tray d. Launch pad

Ans: c, c


. Which is a semi conductor memory?
Options: A) Dynamic B) Static C) Bubble D) Both a & b

Ans:D,D


A base register table
Options: is a term that refers to the control programs of an operating system,    is used to remember which of the general-purpose registers are currently available as base registers, and what base addresses they contain,    allows multiple programs to reside in separate areas of core at the same time,    allows the programmer to write base registers and displacements explicitly in the source program

Ans:B ,B


The database language that allows you to access or maintain data in a database
Options: a. DCL b. DML c. DDL d. None of above

Ans:ndash; b,ndash; b


Floppy disks which are made from flexible plastic material are also called?
Options: hard disks,    high-density disks,    diskettes,    templates

Ans:C ,C


Primary memory stores
Options: Data alone B. Programs alone C. Results alone D. All of these

Ans:– D ,


. Which of the following is not a part of the control panel?
Options: a. Date and time b. My documents c. Add or remove program d. Display

Ans:3 – b ,3 – b


What PPP protocol provides dynamic addressing, authentication, and multilink?
Options: NCP,    HDLC,    LCP,    X.25

Ans:C ,C


Which of the following is not true of SQL views?
Options: Oracle views cannot use the ORDER BY clause in view definitions.,    Oracle views are created using the standard SQL-92 CREATE VIEW command.,    Oracle views can by queried.,    The SQL-92 standard does not allow the use of the ORDER BY clause in view definitions.

Ans:A ,A


You can create a new presentation by completing all of the following except
Options: a. Clicking the new button on the standard toolbar b. Clicking file, new c. Clicking file open d. Pressing ctrl + N

Ans: – C , – C


A common boundary between two systems is called
Options: Interdiction,    Interface,    Surface,    None of the above

Ans:B ,B


Which of the following describes an industry-wide standard suite of protocols and algorithms that allows for secure data transmission over an IP-based network that functions at the layer 3 Network layer of the OSI model?
Options: HDLC,    Cable,    VPN,    IPSec

Ans:D ,D


What was the name of the first stored program electronic computer which was built in 1949 at Cambridge University in England?
Options: EDVAC,    EDSAC,    UNIVAC,    MARK-I

Ans:B ,B


An optional facilitates location program can be used to study
Options: factory location alternative,    warehouse location alternatives,    plant location alternatives,    All of the above

Ans:D ,D


Each time you turn the power switch on, which control files will the computer check?
Options: COMMAND.COM, IO.SYS,    COMMAND.COM, DATE.COM, TIME.COM,    C0MMAND.COM, IO.SYS, MSDOS.SYS,    CHKDSK.EXE

Ans:C ,C


. Which of the following is extension of notepad?
Options: a. .txt b. .bmp c. .ppt d. .xls

Ans:9 – a ,9 – a


A Transportation Problem in which the total supply available at the origins exactly satisfies the total demand required at the destinations is known as:
Options: Degenerate Solution,    Balanced Transportation Problem,    Unbalanced Transportation Problem,    All of the above

Ans:B ,B


. To insert a hyperlink in a slide
Options: a.  Choose Insert >> Hyperlink b.  Press Ctrl + K c.  Hyperlinks can’t be inserted in slides d.  Both a & b

Ans:0 – D ,0 – D


Each array declaration need not give, implicitly or explicitly, the information about
Options: a. the name of array b. the data type of array c. the first data from the set to be stored d. the index set of the array  

Ans:c,c


How can you define a field so that when entering data for that field it will display ****** instead of actual typed text
Options: a. Input mask b. Validation Rule c. Indexed d. IME Mode

Ans:ndash; a,ndash; a


Which gate sends on a pulse when it receives one at either or both of its terminals.
Options: NOR,    NOT,    OR,    NAND

Ans:C ,C


  Which is the shortcut key to jump to the first slide of the presentation? A.  Home B.  Alt + Home C.  Ctrl + Home D.  Shift + Home
Options:

Ans:– C ,


A computer program that converts assembly language to machine language is
Options: Compiler,    Interpreter,    Assembler,    Comparator

Ans:C,(Canswer


Which symbol is used to separate more than one command in the same command line?
Options: $,    #,    :,    ;

Ans:D ,D


. To make a selection of slides on our presentation, use a different design template from the other slides, what do you do?
Options: a. Select the slides thumbnails in that section, and apply a different color scheme b. Select the slide thumbnails in that section and apply a different design template c. Select one of the slide in the section you want to change, customize the fonts and colors, and use the format painter tool to apply those styles to the other slides in the section d. All of above

Ans:9 – B ,9 – B


If the number of bits in a virtual address of a program is 16 and the page size is 0.5 K bytes, the number of pages in the virtual address space is
Options: 16,    32,    64,    128

Ans:D ,D


Which one of the following is the first second-generation computer?
Options: IBM 7090,    IBM 801,    IBM 7070,    IBM 650

Ans:A ,A


Codes which do not require to be frequently updated also promote user efficiency due to
Options: Simplicity,    Sortability,    Stability,    Expansibility

Ans:C ,C


The Santa Clara Valley, California is popularly known as Silicon Valley of America because
Options: huge deposits of silicon are found there,    many silicon chip manufacturing firms are located there,    Santa Claus visits it every Christmas,    it is full of large grain sand

Ans:B ,B


Thrashing
Options: is a natural consequence of virtual memory systems,    can always be avoided by swapping,    always occurs on large computers,    can be caused by poor paging algorithms

Ans:D ,D


A systems theory of organization sees the firm as a
Options: network of resource flows,    system transforming inputs into outputs,    physical system managed by a manager using a conceptual system,    All of the above

Ans:D ,D


The number of free electrons and holes in intrinsic semiconductor increases when the temperature
Options: Decreases,    Increases,    Stays the same,    0oC

Ans:B ,B


If a firm wanted to transmit data from 1,000 punched cards to a remote computer, they would use a(n)
Options: POS terminal,    data collection terminal,    batch processing terminal,    intelligent terminal

Ans:C ,C


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

Ans:A ,A


A microporgram is sequencer perform the operation  
Options: a . read b . write c . execute d . read and execute

Ans:D,Read and Execute


The ascending order of a data hirerchy is:
Options: a. bit-byte-record-field-file-database b. byte-bit-field-record-file-database c. bit-byte-field-record-file-database d. bit-byte-file-record-field-database

Ans:c ,c


. Which icon would you access in the printer window to install a printer drive?
Options: a. Add printer wizard b. Setup c. Install d. None of above

Ans:0 – a ,0 – a


Which is a device that changes information into digital form?
Options: Modem,    Digitizer,    Mouse,    Light pen

Ans:B ,B


What two methods are available to build electronic continuous control?
Options: Analog and mechanical,    Pneumatic and analog,    Analog and digital,    All of the above

Ans:C ,C


. In Windows,start button is used to
Options: a. Run applications b. Device setting c. Turn off the system d. All of above

Ans: d, d


Status indicators are located on the
Options: a. Vertical scroll bar b. Horizontal scroll bar c. Formula bar d. Standard toolbar

Ans:#8211; c,#8211; c


Which of the following is true concerning a procedure?
Options: You do not create them with SQL.,    They do not need to have a unique name.,    They include procedural and SQL statements.,    They are the same thing as a function.

Ans:C ,C


Data scrubbing is which of the following?
Options: A process to reject data from the data warehouse and to create the necessary indexes,    A process to load the data in the data warehouse and to create the necessary indexes,    A process to upgrade the quality of data after it is moved into a data warehouse,    A process to upgrade the quality of data before it is moved into a data warehouse

Ans:D ,D


. Which menu bar selection would you access to openfile?
Options: a. Option b. Help c. View d. None of above

Ans: d, d


In an Entity-Relationship Diagram “Ellipses” represents
Options: Attributes B. Weak entity set C. Relationship sets D. Multi-valued attributes

Ans:– A ,

www.000webhost.com