If every non-key attribute is functionally dependent on the primary key, the relation will be in


Options: First Normal Form B. Second Normal Form C. Third Normal Form D. Fourth Formal Form

Ans:– C ,


Description: mcqquestions

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

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


. By default we can save the file in
Options: a. Desktop b. Recycle bin c. My document d. My computer

Ans:7 – c ,7 – c


Changes to the data base are made only with
Options: proper departmental security codes,    proper individual passwords,    both (a) and (b),    neither (a) nor (b)

Ans:C ,C


  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 can be used to navigate documents?
Options: a. frames b. hyperlinks c. web toolbar d. all of the above

Ans: –  B , –  B


The simultaneous transmission of data to a number of stations is known as
Options: broadcast,    Band width,    Aloha,    Analog transmission

Ans:A ,A


Typewriter terminals can print computer-generated data at a rate of
Options: 10 characters per second,    120 characters per second,    120 characters per minute,    1200 characters per minute

Ans:B ,B


The ODBC core API consists of which of the following functions?
Options: Commit or rollback transactions only,    Connect to data sources with driver-specific information only,    Connect to data sources only,    Both 1 and 3 above are in the OBDC core API.

Ans:D ,D


Control Unit of a digital computer is often called the
Options: Clock,    Nerve center,    ICs,    All of the above

Ans:B ,B


You should never put floppy drives, hard drives, or even VCR tapes or cassette tapes on top of speakers (or near any other source of magnetism) because of:
Options: RFI,    EMI,    EXE,    FYI

Ans:B ,B


The graph of current gain versus collector current indicates that the current gain
Options: varies enormously,    is contant,    varies slightly,    equals the collector current divided by the base current

Ans:D ,D


Which is the layer of a computer system between the hardware and the user program
Options: Operating environment B. Operating system C. System environment D. None

Ans:– B ,


Data collection terminals gather data for use by the
Options: inventory subsystem,    cost subsystem,    production subsystem,    All of the above

Ans:D ,D


. Which is the menu command to recolor a picture on a slide
Options: a. Insert -> Picture -> Recolor b. Tools -> Picture -> Recolor c. Format -> Picture -> Recolor d. Edit -> Picture -> Recolor

Ans:4 – C ,4 – C


Internet-like networks within an enterprise.
Options: Intranets,    Switching alternating,    Inter organizational networks,    Extranets

Ans:A ,A


The name box
Options: a. Shows the location of the previously active cell b. Appears to the left of the formula bar c. Appears below the status bar d. Appears below the menu bar

Ans:#8211; b,#8211; b


The expert system developed at MIT to solve mathematical problems is known as:
Options: RAND,    ISIS,    MACSYMA,    MOLGEN

Ans:C ,C


When is the risk for electrostatic discharge the greatest?
Options: Day time,    High humidity,    Low humidity,    Night time

Ans:C ,C


. “Ctrl + Left Arrow” is used to
Options: Moves the cursor beginning of the Line B. Moves the cursor one word left C. Moves the cursor one paragraph up D. Moves the cursor one paragraph down

Ans:– B ,


Nils Nilsson headed a team at SRI that created a mobile robot named:
Options: Robitics,    Dedalus,    Shakey,    Vax

Ans:C ,C


A system program that combines the separately compiled modules of a program into a form suitable for execution
Options: assembler,    linking loader,    cross compiler,    load and go

Ans:B ,B


If the following program (myproc.c) is present in the directory "C:\TC" then what will be output of the program if run it from DOS shell? /* myproc.c */ #include<stdio.h> int main(int argc, char *argv[]) { printf("%s", argv[0]); return 0; }
Options: SAMPLE.C,    C:\TC\MYPROC.EXE,    C:\TC,    Error

Ans:B ,B


. What should be the extension to execute files?
Options: EXE B. BAT C. COM D. All of the above

Ans: – D ,


Which of the following program is not a utility?
Options: Debugger,    Editor,    Spooler,    All of the above

Ans:C ,C


Which of the following series of commands will restrict Telnet access to the router?
Options: Lab_A(config)#access-list 10 permit 172.16.1.1 Lab_A(config)#line con 0 Lab_A(config-line)#ip access-group 10 in,    Lab_A(config)#access-list 10 permit 172.16.1.1 Lab_A(config)#line vty 0 4 Lab_A(config-line)#access-class 10 out,    Lab_A(config)#access-list 10 permit 172.16.1.1 Lab_A(config)#line vty 0 4 Lab_A(config-line)#access-class 10 in,    Lab_A(config)#access-list 10 permit 172.16.1.1 Lab_A(config)#line vty 0 4 Lab_A(config-line)#ip access-group 10 in

Ans:C ,C


.    Which command should be used to display all files within the specified subordinate directory of the subdirectory?
Options: a.    Dir pathname b.    Dir pathnamepathname c.    Dir / ch d.    Dir pathnamefilename

Ans:.b,Correct Answer: b. Dir pathnamepathname


.    Which command creates a directory or subdirectory?
Options: a.    Dir b.    Mkdir c.    Md d.    Both b and c

Ans:.a,Correct Answer: d. Both b and c


What router command allows you to determine whether an IP access list is enabled on a particular interface?
Options: show ip port,    show access-lists,    show ip interface,    show access-lists interface

Ans:C ,C


. Which technology is more reliable?
Options: A) Mechanical B) Electro-Mechanical C) Electronic D) For reliability it does not matter. So all of above are reliable

Ans:3-C,3-C


Main storage is also called
Options: A. Accumulator B. Control Unit C. Register Unit D. Memory

Ans:D,


If both inputs of an S-R NAND latch are LOW, what will happen to the output?
Options: The output would become unpredictable.,    The output will toggle.,    The output will reset.,    No change will occur in the output.

Ans:A ,A


. __________ is the clear leader for personal databases.
Options: a. Microsoft Access b. Microsoft FoxPro c. Borland dBase d. MySQL

Ans:5 – a ,5 – a


To return the remainder after a number is divided by a divisor in EXCEL we use the function?
Options: ROUND ( ) B. FACT ( ) C. MOD ( ) D. DIV ( )

Ans:– C ,


How many DMA channels are there in an AT class PC?
Options: 3,    4,    7,    8

Ans:D ,D


Computer instructions written with the use of English words instead of binary machine code is called
Options: Mnemonics,    Symbolic code,    Gray code,    Op-code

Ans:B,B


Which of the following is the valid host range for the subnet on which the IP address 192.168.168.188 255.255.255.192 resides?
Options: 192.168.168.129-190,    192.168.168.129-191,    192.168.168.128-190,    192.168.168.128-192

Ans:A ,A


What is Unicode?
Options: Standard Font B. Software C. Character Encoding System D. Keyboard Layout

Ans:– C ,


What types of installations require a special boot disk?
Options: NFS,    FTP,    PCMCIA,    All of the above

Ans:D ,D


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

Ans:D ,D


. The term ‘computer’ is derived from
Options: A) Greek language B) Sanskrit language C) Latin language D) German language

Ans:8-C,8-C


Which protocol is used to send a destination network unknown message back to originating hosts?
Options: TCP,    ARP,    ICMP,    BootP

Ans:C ,C


The major responsibilities of the data-base administrator are all of the following except:
Options: analyzing application systems,    advising programmers,    designing data base,    developing data dictionaries

Ans:A ,A


The most common binary code in use today is the 8 bit ASCII code. What do the letters ASCII stand for?
Options: American Standard Code for International Interchange,    American Standard Code for Information Interchange,    American Standard Code for Intelligence Interchange,    American Scientific Code for Information Interchange

Ans:B,B


Which of the following is a correlated subquery?
Options: Uses the result of an inner query to determine the processing of an outer query.,    Uses the result of an outer query to determine the processing of an inner query.,    Uses the result of an inner query to determine the processing of an inner query.,    Uses the result of an outer query to determine the processing of an outer query.

Ans:B ,B


The designer of a form includes
Options: filed designators,    prompts,    data,    both (a) and (b)

Ans:D ,D


. In Normal view, this tab displays the content of each slide.
Options: a. Slides b. View c. Sort d. Outline

Ans:0 – D ,0 – D


Communication between computers using standard telephone service
Options: Requires a change to an anolog signal,    Is most efficient,    Produces little noise and few disturbances,    All of the above

Ans:A ,A


The time lag, between the keying of the last character on the keyboard input and the appearance of the first output character on the screen, is known as
Options: Key,    System review,    response time,    batch Processing

Ans:C ,C


Point out the correct statement will let you access the elements of the array using 'p' in the following program? #include<stdio.h> #include<stdlib.h> int main() { int i, j; int(*p)[3]; p = (int(*)[3])malloc(3*sizeof(*p)); return 0; }
Options: for(i=0; i<3; i++) { for(j=0; j<3; j++) printf("%d", p[i+j]); } ,    for(i=0; i<3; i++) printf("%d", p[i]); ,    for(i=0; i<3; i++) { for(j=0; j<3; j++) printf("%d", p[i][j]); } ,    for(j=0; j<3; j++) printf("%d", p[i][j]);

Ans:C ,C


A multiple-form file management system
Options: lets you define different forms for different operations,    lets you create a look-up form with an associated read-only password to prevent access by unauthorized users,    both (a) and (b),    allow you to entry data in all the forms

Ans:C ,C


Which technique enables the designer to mold and shape, rather than construct on object using a series of lines?
Options: Solid modeling,    Wire-frame modeling,    Surface modeling,    FEM (Finite Element Modeling)

Ans:A ,A

www.000webhost.com