A lock that allows concurrent transactions to access different rows of the same table is known as a


Options: Field-level lock B. Row-level lock C. Table-level lock D. Database-level lock

Ans:– A ,


Description: mcqquestions

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

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


What is the similarity between a structure, union and enumeration?
Options: All of them let you define new values,    All of them let you define new data types,    All of them let you define new pointers,    All of them let you define new structures

Ans:B ,B


What will be the output of the program ? #include<stdio.h> int main() { float arr[] = {12.4, 2.3, 4.5, 6.7}; printf("%d\n", sizeof(arr)/sizeof(arr[0])); return 0; }
Options: 5,    4,    6,    7

Ans:B ,B


The area of AI that investigates methods of facilitating communication between people and computers is:
Options: natural language processing,    symbolic processing,    decision support,    robotics

Ans:A ,A


An integrated circuit is
Options: A) A complicated circuit B) An integrating device C) Much costlier than a single transistor D) Fabricated on a tiny silicon chip

Ans:-D,-D


. Which of the following is machine independence program?
Options: A) High level language B) Low level language C) Assembly language D) Machine language

Ans:A,A


. Which command is used to list out deleted files in DOS?
Options: a. list b. Undelete/list c. Recover d. All of the above

Ans:3 – b ,3 – b


Which command is used to delete the directory and all its contents in one step?
Options: DEL *.*,    RD,    DELTREE,    CD

Ans:C ,C


How to create additional Guide Lines?
Options: by holding Ctrl key, click on existing Guide Line and drag B. by holding Alt key, click on existing Guide Line and drag C. by holding Ctrl + Alt key, click on existing Guide Line and drag D. Additional Guide Lines cannot be created

Ans:– A ,


Which layer 4 protocol is used for a Telnet connection?
Options: IP,    TCP,    TCP/IP,    UDP

Ans:B ,B


Which one of the following statements is true for the voltages in a series RL circuit?
Options: The total voltages is equal to the sum of the voltages across the resistance and inductance,    The voltage always has the same amplitude and phase for every part of the circuit,    The total voltage is less than the sum of the voltages across the resistance and inductance,    The total voltage lags the total current by less than 90

Ans:C ,C


Which of the following is not one of the stages in the evolution of distributed DBMS?
Options: Unit of work,    Remote unit of work,    Distributed unit of Work,    Distributed request

Ans:A ,A


The study project proposal
Options: estimates the effect the MIS will have on company profits,    estimate the costs of studying the feasibility of an MIS in detail,    both (a) and (b),    neither (a) nor (b)

Ans:C ,C


If both data and database administration exist in an organization, the database administrator is responsible for which of the following?
Options: Data modeling,    Database design,    Metadata,    All of the above.

Ans:B ,B


. In Power Point, this is a container for text or graphics.
Options: a. Slide master b. Table c. Placeholder d. Text box

Ans:6 – D ,6 – D


The difference between a high-technology and a medium-technology robot is the:
Options: speed of movement,    range of motion of the robot,    accuracy of the robot,    complexity of the task it can perform.

Ans:D ,D


Which computer has been designed to be as compact as possible?
Options: Mini,    Super computer,    Micro computer,    Mainframe

Ans:C,(Canswer


Where are silicon chips manufactured in India?
Options: Chandigarh,    Punjab,    UP.,    Tamil Nadu

Ans:A ,A


The first mechanical calculator was invented in
Options: 1958,    1647,    1658,    1972

Ans:B ,B


Which of the following is not true of a magnetic disk?
Options: It is expensive relative to magnetic tape,    It provides only sequential access to stored data,    Users can easily update records by writing over the old data,    It does not provide an automatic audit trail

Ans:B,B


The proper definition of a modern digital computer is
Options: an electronic automated machine that can solve problems involving words and numbers,    a more sophisticated and modified electronic pocket calculator,    any machine that can perform mathematical operations ',    a machine that works on binary code

Ans:A ,A


. Each model of a computer has a unique

Options: A) Assembly of a computer B) Machine language C) High level language D) All of the above

Ans:B,B


Reverse video is a technique of
Options: showing data with half brightness,    showing data upside down on the screen,    hiding confidential data on the screen,    emphasizing data by reversing the foreground and background

Ans:D ,D


What is the main difference between DDCMP and SDLG?
Options: DDCMP does not need special hardware to final the beginning of a message.,    DDCMP has a message header,    SDLC has a IP address,    SDLC does not use CRC

Ans:A ,A


Vision sensors:
Options: will remain very costly,    can not improve much in the next decade,    will more closely match the capabilities of the human eye,    All of the above

Ans:C ,C


Which language is used in the areas of pattern recognition, artificial intelligence & for simulation of games.
Options: APL,    FORTH,    LISP,    CORAL

Ans:C ,C


. Where can you change automatic or manual calculation mode in Excel?
Options: a.  Double CAL indicator on status bar b.  Go to Tools >> Options >> Calculation and mark the corresponding radio button c.  Both of above d.  None of above

Ans:– b,– b


The complexity of the average case of an algorithm is
Options: a. Much more complicated to analyze than that of worst case b. Much more simpler to analyze than that of worst case c. Sometimes more complicated and some other times simpler than that of worst case d. None or above  

Ans:a,a


. Which of the following command is used to switch between the window programs?
Options: a. Alt+Tab b. Alt+F4 c. Ctrl+Tab d. None of the above

Ans:5 – a ,5 – a


Which command is used to link the files?
Options: lk,    ln,    cp,    tar

Ans:B ,B


. When was the company named IBM?
Options: A) 1914 B) 1924 C) 1975 D) None of above

Ans:7-B,7-B


From which tag descriptive list starts
Options: ,B,C
,D


Ans:D,



. Which of the following is not a valid size of a Floppy Disk?
Options: A) 8? B) 5 ¼? C) 3 ½? D) 5 ½?

Ans:D,D


System prototyping helps the designer in
Options: making the programmers understand how the system will function.,    communicating to the user, quickly, how the system, when developed, will look like and get a feedback.,    giving a demo of the software, to the system manager to whom he reports,    both (a) and (b)

Ans:B ,B


Which of the following data structure is linear data structure?
Options: a. Trees b. Graphs c. Arrays d. None of above  

Ans:c,c


A _____ is a brief message to an operator that describes what data are to be entered.
Options: prompt,    passwords,    MIS,    Tactical

Ans:A ,A


. Outlook express lets you
Options: a. Mail communication b. Internet c. Connects to ISP d. All of above

Ans:4 – a ,4 – a


Size of the primary memory of a PC ranges between
Options: 2KB to 8KB B. 64KB & 256KB C. 256KB & 640KB D. None of these

Ans:– C ,


. The ribbon in Word 2007 consists of a series of
Options: a. Gates b. Smaller ribbons c. Tabs d. Icons

Ans: – C , – C


The word processing task associated with changing the appearance of a document is
Options: A) Editing B) Writing C) Formatting D) All of above

Ans:-C,-C


Which of the following isn't used in the storage phase of a computer-based information system?
Options: Magnetic,    Keyboard,    Diskette,    Hard disk

Ans:B ,B


A packet switching network that was sponsored by the Commission of the EEC and became operational in 1979 is
Options: LAN,    Broadband network,    Star network,    Euronet

Ans:D ,D


Where can you change the vertical alignment?
Options:  A) Formatting toolbar, B) Paragraph dialog box, C) Page Setup dialog box, D) Standard toolbar,

Ans:-C,-C


Which simplifies the process of formatting text if the same formatting is required in more than one location
Options: Auto Text B. Format Painter C. Font dialog box D. None of the above

Ans:– B ,


Backup and recovery procedures are primarily implemented to
Options: handle the contingency when a file gets corrupted,    to provide data redundancy,    to show different versions of data and programs,    All of the above

Ans:A ,A


An oval represents which of the following in an ERD?
Options: Attribute,    Entity,    Optional One,    Relationship

Ans:A ,A


In LISP, the atom that stands for "False" is
Options: t,    nil,    y,    time

Ans:B ,B


A keyboard locks up intermittently even when replaced with a new keyboard. What is the LEAST likely cause of the problem?
Options: A second bad keyboard,    The keyboard controller chip,    The keyboard connector,    The motherboard

Ans:A ,A


Which of the following is not user defined data type? 1 : struct book { char name[10]; float price; int pages; }; 2 : long int l = 2.35; 3 : enum day {Sun, Mon, Tue, Wed};
Options: 1,    2,    3,    Both 1 and 2

Ans:B ,B


ASCII stands for
Options: American standard code for information interchange,    All purpose scientific code for information interchange,    American security code for information interchange,    American Scientific code for information interchange

Ans:A,(Aanswer


EDP auditors can be used in the
Options: implementation phase of MIS development,    planning phase of MIS development,    analysis and design phase of MIS development,    All of the above

Ans:D ,D

www.000webhost.com