Which algebra is widely used in DBMS?


Options: a. Relational algebra b. Arithmetic algebra c. Both d. None

Ans:– a ,


Description: mcqquestions

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

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


Which of the following tools is not used for process descriptions?
Options: pseudocodes,    decision tables,    structured english,    data dictionaries

Ans:D ,D


The 34-pin connection on an I/O card is for?
Options: Floppy drive,    SCSI drive,    IDE drive,    Zip drive

Ans:A ,A


Declare the following statement? "An array of three pointers to chars".
Options: char *ptr[3]();,    char *ptr[3];,    char (*ptr[3])();,    char **ptr[3];

Ans:B ,B


What will be the output of the program? #include<stdio.h> #define FUN(arg) do\ {\ if(arg)\ printf("IndiaBIX...", "\n");\ }while(--i) int main() { int i=2; FUN(i<3); return 0; }
Options: IndiaBIX... IndiaBIX... IndiaBIX,    IndiaBIX... IndiaBIX...,    Error: cannot use control instructions in macro,    No output

Ans:B ,B


Which of the following is not considered a tool at the system Design phase?
Options: Data-Flow Diagram,    Decision Table,    Pie chart,    System Flowchart

Ans:C ,C


A 25-pin female connector on the back of your computer will typically be:
Options: Serial port 1,    A parallel port,    Docking,    COM2 port

Ans:B ,B


The Third Generation Computer was made with ________.
Options: Vacuum Tube B. Discrete Components C. IC D. Bio Chips

Ans:– C ,


The manager attempts to expedite, or speed up, the flow of
Options: machines,    manpower,    material,    All of the above

Ans:C ,C


The dialogue techniques for terminal use do not include
Options: questions and answers,    open-ended questions,    form fillings,    menu display

Ans:B ,B


Tracing, of any input record or process, performed on a system, back to its original source, is an
Options: audit trial,    report generation,    batch processing,    conversion

Ans:A ,A


What OSI layer handles logical address to logical name resolution?
Options: Transport,    Physical,    Presentation,    Data Link

Ans:A ,A


. Which of the following symbol sets would be most likely to contain a mathematical symbol such as a degree sign, greater than or equal to, or a Greek letter?
Options: a. Wingdings b. Wingdings 3 c. Webdings d. Symbol

Ans: – D , – D


Which is another name for functional language?
Options: Machine,    Application language,    Low-level language,    High-level language

Ans:B ,B


First-in-First-Out (FIFO) scheduling is
Options:  Non Preemptive Scheduling B.  Preemptive Scheduling C.  Fair Share Scheduling D.  Deadline Scheduling

Ans:– A ,


Which one of the following phrases best describes residual magnetism?
Options: Magnetism that remains in the core of an electromagnet after the current through the coil is turned off,    The force of attraction between the poles of a permanent and temporary magnetic field,    The amount of magnetic flux that is not confined to the core material of an electromagnet,    The circular magnetic field that surrounds a conductor carrying a current

Ans:A ,A


Which of the following statement is incorrect?
Options: The Addresses Resolution Protocol, ARP, allows a host to find the physical address of a target host on the same physical network, given only the target IP address.,    The sender's IP - to- physical address binding is included in every ARP broadcast; receivers update the IP-to-Physical address binding information in their cache before processing an ARP packet.,    ARP is a low-level protocol that hides the underlying network physical addressing, permitting us to assign IP-addresses of our choice to every machine.,    All of the above

Ans:D ,D


. What is defined by Handout Master?
Options: a. Slide Formatting b. Slide Transaction c. Layout of Handout d. Layout of Slide

Ans:6 – C ,6 – C


Bridge works in which layer of the OSI model?
Options: Appliation layer B. Transport layer                    C. Network layer D. Datalink layer

Ans:– D ,


In which way is a managerial information system (MIS) superior to electronic data processing (EDP)?
Options: It is batch oriented,    It is most cost effective,    It provides summary reports without details,    All of the above

Ans:C ,C


A random-access data storage device which gives rapid access to data is
Options: Magnetic tape,    Punched card,    Disk storage unit,    Buffer

Ans:C ,C


Which of the following is part of an administrative policy to secure a database?
Options: Authentication policies,    Limiting particular areas within a building to only authorized people,    Ensure appropriate responses rates are in external maintenance agreements,    All of the above.

Ans:D ,D


MIS is designed to provide information needed for effective decision making by?
Options: Consumers B. Workers C. Foremen D. Managers

Ans:– D ,


. Paste Special allows some operation while you paste to new cell. Which of the following operation is valid?
Options: a.  Square b.  Percentage c.  Goal Seek d.  Divide

Ans:– d,– d


_____ assist traditional auditors both in the review of computer controls and in the production of audit information through the use of computers.
Options: CDP,    CISA,    DPMA,    EDP auditor

Ans:D ,D


. Model 5100 was ______ in 1957.
Options: A) The first PC built by IBM B) The first PC built by Apple C) The first PC built by Motorola D) The first PC built by Intel

Ans:A,A


What will be the output of the program ? #include<stdio.h> int main() { enum days {MON=-1, TUE, WED=6, THU, FRI, SAT}; printf("%d, %d, %d, %d, %d, %d\n", MON, TUE, WED, THU, FRI, SAT); return 0; }
Options: -1, 0, 1, 2, 3, 4,    -1, 2, 6, 3, 4, 5,    -1, 0, 6, 2, 3, 4,    -1, 0, 6, 7, 8, 9

Ans:D ,D


Which of the following is the allocation method of a disk space?
Options: Contiguous allocation B. Linked allocation C. Indexed allocation D. All of the Above

Ans:– D ,


What is the IP Address range of APIPA?
Options: 169.254.0.1 to 169.254.0.254 B. 169.254.0.1 to 169.254.0.255 C. 169.254.0.1 to 169.254.255.254 D. 169.254.0.1 to 169.254.255.255

Ans:– C ,


In a document what is the maximum number of columns that can be inserted in MS Word Table?
Options:  A) 35, B) 15, C) 63, D) 65, 

Ans:-C,-C


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 type of join is needed when you wish to return rows that do have matching values?
Options: Equi-join,    Natural join,    Outer join,    All of the above.

Ans:D ,D


What action will correct patchy, faint, uneven or intermittent print on a dot matrix printer?
Options: Replacing the ribbon,    Replacing the timing belt,    Adjusting the paper feed tension,    Adjusting the tractor feed tension

Ans:A ,A


The major function of the language system is:
Options: to perform various processing tasks,    to provide artificial-intelligence capabilities to the DSS,    to provide data to the DSS,    to enable the users to interact with the DSS

Ans:D ,D


Which of the structure is correct? 1 : struct book { char name[10]; float price; int pages; }; 2 : struct aa { char name[10]; float price; int pages; } 3 : struct aa { char name[10]; float price; int pages; }
Options: 1,    2,    3,    All of above

Ans:A ,A


The register which keeps track of the execution of a program and which contains the memory address of the instruction currently being executed is known as
Options: Index register,    Memory address register,    Program counter,    Instruction register

Ans:C ,C


The complete picture of data stored in database is known as
Options: Record,    Schema,    System flowchart,    DBMS

Ans:B,(Banswer


.   To maintain the perspective (height and width ratio) of an object when resizing, you need to
Options: a. Press and hold the shift key while dragging a corner sizing handle b. Press and hold the alt + ctrl keys while dragging a middle handle c. Drag a corner sizing handle d. A and c

Ans:7 – A ,7 – A


Object modules generated by assemblers that contain unresolved external references are resolved for two or more object modules by a/an
Options: operating system,    loader,    linker,    compiler

Ans:C ,C


Data are sent over pin _____ of the EIA-232 interface.
Options: 2,    3,    4,    All of the above

Ans:A ,A


An entity type is which of the following?
Options: A major category of data about people, place, and things,    The various departments of an organization,    The application software,    The business processes the support the mission of an organization

Ans:A ,A


Where can system and mail logs be found in Ret Hat Linux?
Options: /var/log,    /etc/log,    /mail,    All of the above

Ans:A ,A


Which of the following devices would be classified as a robot by the Robot Institute of America?
Options: Automobile,    Pick-and-place manipulator,    Artificial hand,    All of the above

Ans:B ,B


. In MS Access, Field Value may contain
Options: a. Text b. Date & Time c. Picture d. All of the Above

Ans:– d,– d


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 ,


You are installing an IDE hard drive that will be your boot drive. Which is the correct order of steps that need to be followed?
Options: A. jumper properly, auto-detect(or configure manually) in CMOS, low level format, high level format, partition B. jumper properly, auto-detect(or configure manually) in CMOS, partition, high level format with / s switch C. jumper properly, partition, auto-detect(or configure manually in CMOS, high level format with /s switch D. jumper properly, auto-detect in CMOS, regular format

Ans:B ,jumper properly, auto-detect(or configure manually) in CMOS, partition, high level format with / s s


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 TCP/IP internet protocol a diskless machine uses to obtain its IP address from a server?
Options: RDP,    RARP,    RIP,    X.25

Ans:B ,B


Which of the following is a phase of a compilation process
Options: Lexical analysis,    Code generation,    Both of the above,    Static analysis

Ans:C ,C


Which of the following is an essential file of a MS-DOS boot disk?
Options: COMMAND.COM B. START.COM C. TREE.COM D. VER.COM

Ans: A ,COMMAND.COM


A customer has just installed a new cd-rw. the system was working fine before the installation, but now the cdrom does not work, what should you suggest that the customer do?
Options: flash or upgrade the BIOS,    check the CONFIG.SYS,    add cdrw in the device manager,    check the jumper setting on the cd-rw

Ans:D ,D

www.000webhost.com