A relation that has no partial dependencies is in which normal form

Options: First B. Second C. Third D. BCNF

Ans:– B ,

Description: mcqquestions

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

Hits Today: 8630 | 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 the correct order if calling functions in the below code? a = f1(23, 14) * f2(12/4) + f3();
Options: f1, f2, f3,    f3, f2, f1,    Order may vary from compiler to compiler,    None of above

Ans:C ,C

. Operating system is a ….
Options: a. System software b. Application software c. Presentation software d. Database software

Ans:7 – a ,7 – a

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

Ans:– A ,

A ________ is a program that performs some common action on database data and that is stored in the database.
Options: trigger,    stored procedure,    pseudofile,    None of the above is correct.

Ans:B ,B

  How can you stop a slide show?
Options: Press the right arrow B. Press Escape C. Press the left arrow D. Press the down arrow

Ans:– B ,

. A File which contains readymade styles that can be used for a presentation is called :
Options: a. AutoStyle b. Template c. Wizard d. Pre formatting

Ans:3 – B ,3 – B

Presentation designs regulate the formatting and layout for the slide and are commonly called
Options: a. Design plates b. Templates c. Placeholders d. Blueprints

Ans: – B , – B

In which of the following, each data item contains at most 2 points
Options: List structure,    LISP,    List sorting,    List head

Ans:B ,B

What should be first considered in choosing a plotter?
Options: The hardware you currently own,    The application for which it will be used,    The type of data you will input,    The cost

Ans:B ,B

The data communication support should include, but is not restricted to
Options: file transfer and transaction processing,    file and database access,    terminal support, electronic mail and voice grams.,    All of the above

Ans:D ,D

. How to create columns in Word 2010?
Options: Columns button on the Page Setup group in Page Layout ribbon B. Columns button on the Pages group in Insert ribbon C. Columns button on the Styles group in Home ribbon D. Columns button on the Show group in View ribbon

Ans:– A ,

Which of the following is (are) not a tool for Application Prototyping?
Options: Application generators,    third generation language,    screen generators,    report generators

Ans:B ,B

. To change the screen saver you can go from
Options: a. Control panel display b. Right click in desktop and properties c. Both of above d. None of these

Ans:0 – c ,0 – c

. How do you magnify your document?
Options: a. View, Zoom b. Format, Font c. Tools, Options d. Tools, Customize

Ans: –  A , –  A

_____ write computer programs that perform jobs specified by the user.
Options: Programmer,    Data entry operator,    System Analyst,    Computer operator

Ans:A ,A

Which of the following products was the first to implement true relational algebra in a PC DBMS?
Options: IDMS,    Oracle,    dBase-II,    R:base

Ans:D ,D

. The personnel who deals with the computer and its management put together are called
Options: A) Software B) Human ware C) Firmware D) Hardware


. Which control type do you use to create a calculated control?
Options: a. command button b. combo box c. text box d. list box

Ans:– c,– c

  Microsoft PowerPoint can insert objects from the following add-ins? A.  Equation Editor B.  Organization Chart C.  Photo Album D.  All of these

Ans: – D ,

Indexed-Sequential organization
Options: means storing records in contiguous blocks according to a key.,    Stores records sequentially but uses an index to locate records,    uses an index for each key type,    has records placed randomly throughout the file

Ans:B ,B

Which of the following is not a factor to consider when switching from small to large block size?
Options: The length of all of the fields in a table row.,    The number of columns,    Block contention,    Random row access speed

Ans:B ,B

Identify false statement
Options: a. You can find deleted files in recycle bin b. You can restore any files in recycle bin if you ever need c. You can increase free spaceof disk by sending files in recycle bin d. You can right click and choose Empty Recycle Bin to clean it at once


. The advantage of COM are its __ and __
Options: A) Compact size; speed readability B) Compact size, speed C) Readability; speed D) Low cost; readability


What does COUNTA () function do?
Options: counts cells having alphabets B. counts empty cells C. counts cells having number D. counts non-empty cells

Ans:– D ,

Credit checking is done in the
Options: order processing system,    quotation system,    order entry system,    any of the above

Ans:C ,C

When you boot a PC and don't hear any beep, this could suggest which of the following?
Options: The monitor is turned off,    Keyboard not plugged in,    Normal PC boot,    Bad or disconnected speaker

Ans:D ,D

What script is run for setting bash global defaults for all users?
Options: /etc/.profile,    /etc/.bashrc,    /etc/.log,    /etc/profile

Ans:D ,D

The subsystem appearing in each of the functional information systems is the
Options: internal accounting subsystem,    environmental intelligence subsystem,    information processor subsystem,    system analysis subsystem

Ans:A ,A

The _____ is a short horizontal line indicating the conclusion of a document.
Options: a. insertion point b. end mark c. status indicator d. scroll box

Ans:– B,– B

A menu-driven operating system is one which allows you to pick up from the menu of choices it displays on the screen. What is the name given to the images which are used in such image oriented menus?
Options: Icon,    Figure,    Symbol,    option

Ans:A ,A

. In Access 2007, to set a table to open as a document tab, you need to go to the ____.
Options: a. Microsoft Office button b. Navigation Pane c. Quick Access toolbar d. Database Tools command tab

Ans:5 – a ,5 – a

What does 240 translate to in binary?
Options: 11110000,    00011110,    00001111,    11100000

Ans:A ,A

In the DOS memory model, the HIGH Memory Area (HMA). is the _____ memory.
Options: Last 64k of conventional,    Last 64k of extended,    First 64k above conventional,    First 64k of extended

Ans:D ,D

. Microsoft Access is a
Options: a. Rdbms b. Oodbms c. Ordbms d. Network database model

Ans:5 – a ,5 – a

Excel files have a default extension of
Options: a. Xls b. Xlw c. Wk1 d. 123

Ans:#8211; a,#8211; a

. The most commonly used standard data code to represent alphabetical, numerical and punctuation characters used in electronic data processing system is called
Options: A) ASCII B) EBCDIC C) BCD D) All of above


A channel for communicating across a boundary between two or more sub¬systems is known as
Options: interface,    actigram,    walk through,    data path

Ans:B ,B

. Which of the following is not electro-mechanical computer?
Options: A) Mark I B) ABC C) Zuse D) UNIVAC


A system program which helps the execution of user programs is known as
Options: System software,    Application program,    Batch operating system,    Utilities

Ans:C ,C

.   To import text from a word document that uses headings into a PowerPoint presentation:
Options: a. This cannot be done in PowerPoint b. Click Insert, Slides from Outline c. Click Import, Word Document Headings d. Click File, New, Presentation from Word Headings

Ans:2 – B ,2 – B

A self check digit is useful in detecting
Options: transcription errors only,    transposition errors only,    Random errors only,    All of the above

Ans:D ,D

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


. Where can you define the permanent path for DOS?
Options: a. Io.sys b. Config.sys c. Autoexec.sys d. Command . com

Ans:6 – c ,6 – c

What is the benefit of the Networking?
Options: File Sharing B. Easier access to Resources C. Easier Backups D. All of the Above

Ans:– D ,

Which of the following allows dirty reads, nonrepeatable reads and phantom reads to occur?
Options: Read committed,    Read uncommitted,    Repeatable read,    Serializable

Ans:B ,B

What is the size of the reserved memory area?
Options: 64 kb,    384 kb,    640 kb,    1024 kb

Ans:B ,B

. A small part of taskbar that has icons of background running applications is
Options: a. Start button b. Quick launch c. Task bar d. System tray

Ans: d, d

  To print the PowerPoint presentation, press
Options: Ctrl + T B. Ctrl + E C. Ctrl + S D. Ctrl + P

Ans:– D ,

Sales persons and other employees of the company who spend much of their time away from their offices but keep in touch with their company's microcomputers or main frame computers over telephone lines are called
Options: field workers,    telecommuters,    teleprocessors,    company directors

Ans:B ,B

Suppose that you have a customer who has a central HQ and six branch offices. They anticipate adding six more branches in the near future. They wish to implement a WAN technology that will allow the branches to economically connect to HQ and you have no free ports on the HQ router. Which of the following would you recommend?
Options: PPP,    HDLC,    Frame Relay,    ISDN

Ans:C ,C