. A command to remove a relation from an SQL database


Options: Delete table <table name> B. Drop table <table name> C. Erase table <table name> D. Alter table <table name>

Ans: – B ,


Description: mcqquestions






More Database Systems Related questions:


The average time necessary for the correct sector of a disk to arrive at the read write head is _____
Options: Down time,    Seek time,    Rotational delay,    Access time

Ans:C,(Canswer


The data base be prepared until
Options: the computer has been selected,    the MIS staff has been acquired and organized,    the preparation of physical facilities,    All of the above

Ans:A ,A


Which of the following is not an advantage of decentralized processing over centralized processing?
Options: reduced data communication costs,    improved system reliability,    increased employee productivity,    increased computer system control

Ans:D ,D


. When you add fields in ____, a Field List pane displays.
Options: a. Design View b. Layout View c. Print Preview d. Report View

Ans:0 – b ,0 – b


Which of the following describe the DHCP Discover message? It uses FF:FF:FF:FF:FF:FF as a layer 2 broadcast. It uses UDP as the Transport layer protocol. It uses TCP as the Transport layer protocol. It does not use a layer 2 destination address.
Options: 1 only,    1 and 2,    3 and 4,    4 only

Ans:B ,B


. By default, on which page the header or the footer is printed?
Options: a. on first page b. on alternate page c. on every page d. none of the above

Ans:–  C,–  C


2. ….is the layer of a computer system between the hardware and the user program
Options: a. Operating environment b. Operating system c. System environment d. None

Ans:Correct Answer: b,Correct Answer: b


15. Which command in DOS is used to display the version of MSDOS?
Options: a. VERSION b. VERIFY c. VER d. VERSN

Ans:Correct Answer: c ,Correct Answer: c


Which best describes a fragmented hard drive:
Options: The platters are bad,    Data files are corrupted,    Clusters of data are damaged,    Files are not stored in consecutive clusters

Ans:D ,D


Who invented Java?
Options: Netscape,    Microsoft,    Sun,    None of the above is correct.

Ans:C ,C


14.4 modem should transmit _____ bits per second
Options: 14,400-15,000,    140-150,    1400-1500,    140,000-150,000

Ans:A ,A


Which of the following is not a level of data abstraction?
Options: Physical Level B. Critical Level       C. Logical Level D. View Level

Ans:– B ,


In LISP, the function returns t if <object> is a CONS cell and nil otherwise:
Options: (cons <object>),    (consp <object>),    (eq <object>),    (cous = <object>)

Ans:B ,B


. You can automatically adjust the size of text in a cell if they do not fit in width by
Options: a. Double clicking on the right border of column header b. From Format choose Columns and then Autofit Selection c. From Format Cells dialog box mark Shrink to fit check box d. All of above

Ans:– c,– c


In the instruction, 500 SUBA # 50 the command field is:
Options: 500,    # 50000,    SUBA,    (b) and (c)

Ans:C ,C


What is an SQL virtual table that is constructed from other tables?
Options: Just another table,    A view,    A relation,    Query results

Ans:B ,B


The bars in a bar chart are represented by the
Options: rectangles in a network diagram,    arrows in a network diagram,    triangles in a network diagram,    All of the above

Ans:B ,B


Baseband is
Options: transmission of signals without modulation,    a signal all of whose energy is contained within a finite frequency range,    the simultaneous transmission of data to a number of stations,    All of the above

Ans:A ,A


Which of the following memory unit that processor can access more rapidly
Options:  Main Memory B.  Virtual Memory C.  Cache memory D.  Read Only Memory

Ans:– C ,


. What does the VLOOKUP function do?
Options: a. Looks up text that contain ‘v’ b. Checks whether text is the same in one cell as in the next c. Finds related records d. All of above

Ans:– c,– c


A hierarchical chart that divides a large program into modules, in which greater details is designed in successively lower programming levels, is called a
Options: Scheme,    sub-schema,    Structure,    All of the above

Ans:C ,C


Which of the following is the user programmed semiconductor memory?
Options: SRAM,    DRAM,    EPROM,    All of the above

Ans:C,C


What is the size of Network bits & Host bits of Class A of IP address?
Options: Network bits 7, Host bits 24 B. Network bits 8, Host bits 24 C. Network bits 7, Host bits 23 D. Network bits 8, Host bits 23

Ans:– A ,


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 ,


The analysis and design of application systems are the responsibility of a _____
Options: Computer Operator,    Programmer,    System Analyst,    Data entry operator

Ans:C ,C


. The __________ field is used to hold a yes or no answer.
Options: a. object b. number c. text d. logical

Ans:9 – d ,9 – d


Data collection terminals
Options: track the flow of materials from one production area to another,    record employee attendance,    record start and stop of production steps,    All of the above

Ans:D ,D


The main function(s) of computer in CAD is/are
Options: To serve as an extension to the memory of the designer,    To enhance the analytical and logical power of the designer,    To relieve the designer from routine repetitious tasks.,    All of the above

Ans:D ,D


. Any files deleted in Windows goes into
Options: a. Trash can b. Recycle bin c. Deleted Files d. None of above

Ans:2 – b ,2 – b


To be successful in implementing DSS, organizations should have the following characteristics except:
Options: a well-controlled data-processing system,    willingness to commit dollars and personnel to the project.,    education and training by the organization,    powerful central computer groups to initiate and manage system projects

Ans:D ,D


Which command is used to select distinct subject (SUB) from the table (BOOK)?
Options: SELECT ALL FROM BOOK,    SELECT DISTINCT SUB FROM BOOK,    SELECT SUB FROM BOOK,    All of the above

Ans:B ,B


Columns dialog box can be opened from
Options:  A) Format menu Columns submenu, B) Double click on column space in ruler, C) Press Alt + O + C, D) All of above, 

Ans:-D,-D


All calculations are performed and all comparisons are made in _____ unit.
Options: control unit,    aritmetic-logic unit,    central processing unit,    primary storage unit

Ans:B ,B


Binary search algorithm can not be applied to
Options: a. sorted linked list b. sorted binary trees c. sorted linear array d. pointer array  

Ans:a,a


If digital data rate of 9600 bps is encoded using 8-level phase shift keying (PSK) method, the modulation rate is
Options: 1200 bands,    3200 bands,    4800 bands,    9600 bands

Ans:B ,B


Natural language processing is divided into the two subfields of:
Options: symbolic and numeric,    time and motion,    algorithmic and heuristic,    understanding and generation

Ans:D ,D


. A search value can be an exact value or it can be
Options: a. Logical operator b. Relationship c. Wild card character d. Comparison operation

Ans:8 – c ,8 – c


Coding and testing are done In a
Options: top-down manner,    bottom-up manner,    ad hoc manner,    cross sectional manner

Ans:A ,A


Which of the following professions has not been affected by personal computers?
Options: medical,    clerical,    accounting,    None of the above

Ans:D,None of the above


. An operating system is a program or a group of programs that
Options: a. Helps in checking the spelling of Word b. Maintain the relationship in Database c. Manages the resources of the Computer d. Performs the calculations of cells in Excel

Ans:2 – c ,2 – c


What is the shortcut key to “Insert Hyperlink ” in a document?
Options: Ctrl + H B. Ctrl + L C. Ctrl + K D. None of above

Ans:– C ,


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

Ans:– C ,


. Which command will be used to display only the file name and extensions in wide format?
Options: a. Dir/b b. Dir A: c. Dir/s d. Dir/w

Ans:8 – d ,8 – d


What command will permit SMTP mail to only host 1.1.1.1?
Options: access-list 10 permit smtp host 1.1.1.1,    access-list 110 permit ip smtp host 1.1.1.1,    access-list 10 permit tcp any host 1.1.1.1 eq smtp,    access-list 110 permit tcp any host 1.1.1.1 eq smtp

Ans:D ,D


Which of the following function is more appropriate for reading in a multi-word string?
Options: printf();,    scanf();,    gets();,    puts();

Ans:C ,C


Which of the following device cannot be shared in Network?
Options: CD Drive B. Printer C. Mouse D. Hard Disk

Ans:– C ,


Which command is used with vi editor to move cursor forward to first occurrence of character 'ch' in the current line?
Options: tch,    fch,    rch,    ech

Ans:B ,B


. The secondary storage devices can only store data but they cannot perform
Options: A) Arithmetic Operation B) Logic operation C) Fetch operations D) Either of the above

Ans:0-D,0-D


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


Which of the following term is used in connection with the organisation of files in ALGOL 68
Options: Blow,    Machine,    Biquinary,    Book

Ans:D ,D

www.000webhost.com