Which of the following in not a function of DBA?


Options: Network Maintenance B. Routine Maintenance C. Schema Definition D. Authorization for data access

Ans:– A ,


Description: mcqquestions

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

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


To install a second IDE drive into a computer, you must:
Options: Set the master-slave jumper to slave on the second drive,    Use the IDE configuration software to set the new drive as slave,    Verify that you define the new drive as D: in the CMOS setup,    Verify that you attach the drive to the connector at the end of the ribbon cable

Ans:A ,A


A section of code to which control is transferred when a processor is interrupted is known as
Options: M,    SVC,    IP,    MDR

Ans:A ,A


For you to create a swap partition by using fdisk, what must the partition's system ID type be?
Options: 83,    82,    5,    4

Ans:B ,B


. Computer operators
Options: A) writes computer programs for specific problems B) operate the device which input and output data from the computer C) normally require a college degree in computer science D) all of the above

Ans:B,B


. You can open the scenario Manager dialog box by choosing scenarios from the ….. menu.
Options: a. View b. Insert c. Format d. Tools

Ans:– d,– d


Block or buffer caches are used
Options: to improve disk performance,    to handle interrupts,    to increase the capacity of main memory,    to speed up main memory read operation

Ans:A ,A


Which of the following is true concerning a global transaction?
Options: The required data are at one local site and the distributed DBMS routes requests as necessary.,    The required data are located in at least one nonlocal site and the distributed DBMS routes requests as necessary.,    The required data are at one local site and the distributed DBMS passes the request to only the local DBMS.,    The required data are located in at least one nonlocal site and the distributed DBMS passes the request to only the local DBMS.

Ans:B ,B


In the following program how long will the for loop get executed? #include<stdio.h> int main() { int i=5; for(;scanf("%s", &i); printf("%d\n", i)); return 0; }
Options: The for loop would not get executed at all,    The for loop would get executed only once,    The for loop would get executed 5 times,    The for loop would get executed infinite times

Ans:D ,D


The calculation of expected outcomes in intended to help the manager
Options: identify problems,    identify solutions,    evaluate solutions,    All of the above

Ans:C ,C


Which output device is used for translating information from a computer into pictorial form on paper.
Options: Mouse,    Plotter,    Touch panel,    Card punch

Ans:B ,B


Point out the error in the program? #include<stdio.h> int main() { struct bits { float f:2; }bit; printf("%d\n", sizeof(bit)); return 0; }
Options: 4,    2,    Error: cannot set bit field for float,    Error: Invalid member access in structure

Ans:C ,C


The standard IRQ for the floppy drive is?
Options: 9,    6,    10,    All of the above

Ans:B ,B


A PC with a 486DX2 processor runs internally at 50Mhz. What speed would its external logic be running?
Options: l0Mhz,    25Mhz,    50Mhz,    100 Mhz

Ans:B ,B


What is the name of the visible silver rectangle which separates the take-up portion of the magnetic tape from the data recording portion?
Options: Load maker,    Load marker,    Tape separator,    Tape marker

Ans:B ,B


. Which command is used to copy system files?
Options: a. Sys b. Command c. MD d. Move

Ans:9 – a ,9 – a


In an SQL SELECT statement querying a single table, according to the SQL-92 standard the asterisk (*) means that:
Options: all columns of the table are to be returned.,    all records meeting the full criteria are to be returned.,    all records with even partial criteria met are to be returned.,    None of the above is correct.

Ans:A ,A


Which command loads a new version of the Cisco IOS into a router?
Options: copy flash ftp,    copy ftp flash,    copy flash tftp,    copy tftp flash

Ans:D ,D


Top-level managers are responsible for _____ plans and decisions.
Options: strategic,    structured,    simulation,    tactical

Ans:A ,A


Which of the following statements, is (are) not true for the lease option
Options: Lease charges are lower than rental charges for the same period and are also tax deductable.,    Lease may be written to show higher payments is early years to reflect the decline in value of the system,    Insurance, maintenance and other expenses are included in the rental charge,    All of the above

Ans:C ,C


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


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

Ans:D ,D


. You can open the consolidate dialog box byt choosing Consolidate from the ….. menu.
Options: a. Insert b. Format c. Tools d. Data

Ans:– d,– d


The effect applied to display when slides changes in slide show view is
Options: a. Slide Animation b. Custom Animation c. Custom Transition d. Slide Transition

Ans: – D , – D


Which of the following is true about ColdFusion Markup Language (CFML)?
Options: It is stored in .asp files.,    It is executed on the client.,    It does not use tags.,    It allows for coding of custom tags in an HTML file.

Ans:D ,D


. Which of the following statement is true
Options: a. Reports can be used to retrieve data from tables and calculate b. Queries can be printed in well formatted manner and presented as the information c. Queries can include calculated fields that do not exist in table d. Reports and forms are similar but forms are use to print but reports to display on screen only

Ans:7 – c ,7 – c


A Compiler is ____
Options:  a combination of computer hardware B.  a program which translates from one high-level language to another C.  a program which translates from one high-level to a machine level language D.  None of these

Ans:– C ,


Which of the following hardware component is the most important to the operation of database management system?
Options: a . high resolution video display b . printer c . high speed, large capacity disk d . plotter

Ans:.c,.c


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

Ans:B,(Banswer


. Which of the following bypasses the print dialog box when printing individual slides or an entire presentation?
Options: a. File, Print Preview b. The print button c. File, print d. Ctrl + P

Ans:8 – B ,8 – B


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

Ans:– A ,


. What is the date when Babbage conceived Analytical engine
Options: A) 1642 B) 1837 C) 1880 D) 1850

Ans:0-B,0-B


Which of the following isn't a type of computer facility?
Options: decentralized,    centralized,    de-distributed,    distributed

Ans:C ,C


A relationship should be specified how in the ODL?
Options: One direction starting with the first class,    One direction starting with the second class,    Neither direction.,    Both directions.

Ans:D ,D


Which of the following statements best describes the batch method of input?
Options: Data is processed as soon as it is input,    Data is input at the time it is collected,    Data is collected in the form of source documents, placed into groups, and then input to the computer,    Source documents aren't used

Ans:C ,C


. Which of the following is not a class based on size?
Options: A) Mainframe Computer B) Micro Computer C) Mini Computer D) Digital Computer

Ans:D,D


1 Microfarad is the same as:
Options: 1 millionth of a picofarad,    1000 millifarads,    1 million picofarads,    1 million farads

Ans:C ,C


.  A ____ is a major database object used to display information in a printable page format.
Options: a. form b. query c. report d. table

Ans:6 – c ,6 – c


What is the name of the device that converts computer output into a form that can be transmitted over a telephone line?
Options: Teleport,    Modem,    Multiplexer,    Concentrator

Ans:B ,B


Advantages of data base system is (are)
Options: storage space duplication is eliminated,    all applications share centralized files,    data are stored once in the data base and are easily accessible when needed,    All of the above

Ans:D ,D


The relational model uses some unfamiliar terminology. A tuple is equivalent to a:
Options: record,    field,    file,    data base

Ans:A ,A


The term scheme means
Options: the relationship service bureau,    a map of overall structure of a database.,    a parent with no owners,    two dimensional table

Ans:B ,B


Where as a computer mouse moves over the table surface, the trackball is
Options: A) Stationary B) Difficult to move C) Dragged D) Moved in small steps

Ans:-A,-A


Compression of digital data for efficient storage is
Options: Buffer,    CPU,    Packing,    Field

Ans:C,(Canswer


. What is to be use to add text in Slide?
Options: a. Text Box b. Note Box c. Text Layer d. Comment Box

Ans:1 – A ,1 – A


The following method/s are used in Transportation Models of Operations Research:
Options: VogeFs Approximation Method,    North West Corner Method,    Least Cost Method,    All of the above

Ans:D ,D


Time during which a job is processed by the computer is
Options: Delay time,    Real time,    Execution time,    Down time

Ans:C,C


A __ name must be unique within a database
Options: a. Table b. Field c. Record d. Character

Ans:ndash; a,ndash; a


A co-processor
Options: a. Is relatively easy to support in software b. Causes all processor to function equally c. Works with any application d. Is quite common in modern computer

Ans:a,a


What command is used to copy a file?
Options: tar,    cpio,    cp,    copy

Ans:C ,C


The term Incomplete for a UML has the same meaning as which of the following for an EER diagram?
Options: Overlapping rule,    Disjoint rule,    Total specialization rule,    Partial specialization rule

Ans:D ,D

www.000webhost.com