Which SQL Query is use to remove a table and all its data from the database? a. Create Table b. Alter Table c. Drop Table d. None of these


Options: Every primary-key value must match a primary-key value in an associated table B. Every primary-key value must match a foreign-key value in an associated table C. Every foreign-key value must match a primary-key value in an associated table D. Every foreign-key value must match a foreign-key value in an associated table

Ans:– c ,






More Database Systems Related questions:


Customer data (name and address, shipping instructions, credit terms, etc.) is provided by the:
Options: manufacturing information system,    order entry subsystem,    billing subsystem,    marketing information system

Ans:C ,C


Conversion method in which users, being used to an old system, continue to use the old system, along with the new system, is
Options: Multiprocessing,    Multitasking,    Parallel run,    All of the above

Ans:C ,C


Which of following provides reliable communication?
Options: TCP B. IP C. UDP D. All of the above

Ans:– A ,


. In what respect computers are superior to human beings?

Options: A) Diligence B) Intelligence C) Both of above D) None of above

Ans:A,A


How may standard levels of interrupts are provided on the 8-bit ISA bus (XT-class computer)?
Options: 4,    8,    12,    16

Ans:B ,B


Features of XML include which of the following?
Options: The tags are used to describe the appearance of the content.,    Addresses the structuring and manipulation of the data involved.,    Governs the display of information in a Web browser.,    All of the above.

Ans:B ,B


Which of the following affects the extent to which you are involved with the system development life cycle in your company?
Options: your job description,    size of the organization,    your relevant experience,    All of the above

Ans:E ,E


What frequency range is used for FM radio transmission?
Options: Very Low Frequency : 3 kHz to 30. kHz,    Low Frequency : 30 kHz to 300 kHz,    High Frequency : 3 MHz to 30 MHz,    Very High Frequency : 30 MHz to 300 MHz

Ans:D ,D


When a group of computers is connected together in a small area without the help of telephone lines, it is called
Options: Remote communication network (RCN),    Local area network(LAN),    Wide area network (WAN),    Value added network (VAN)

Ans:B ,B


The details of all external symbols and relocation formation (relocation list or map) is provided to linker by
Options: Macro processor,    Translator,    Loader,    Editor

Ans:B ,B


Page-map table is
Options: A data file,    A directory,    Used for address translation,    All of the above

Ans:C ,C


Which of the following is not a disadvantage of wireless LAN?
Options: Slower data transmission,    higher error rate,    interference of transmissions from different computers,    All of the above

Ans:D ,D


. A character that represents one or more unknown character is
Options: a. Wildcard character b. All file name c. Extensions d. None of above

Ans:1 – a ,1 – a


The PowerPoint view that displays only text (title and bullets) is
Options: a. Slide show b. Slide sorter view c. Notes page view d. Outline view

Ans: – D , – D


. Which is the latest version of MS Windows?
Options: a. Windows 2007 b. Windows 8.1 c. Windows 2008 d.Windows 7

Ans: b, b


Who launched IBM's First PC in 1981?
Options: Dean Cline,    C.B. Rogers Jr.,    John F. Akers,    David Svenson

Ans:B ,B


External data is stored in the
Options: market forecast file,    forecast allocation file,    customer file,    All of the above

Ans:A ,A


Contention is
Options: One or more conductors that serve as a common connection for a related group of devices,    a continuous frequency capable of being modulated or impressed with a second signal,    the condition when two or more stations attempt to use the same channel at the same time,    a collection of interconnected functional units that provides a data communications service among stations attached to the network

Ans:C ,C


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

Ans:D ,D


. Except for the …… function, a formula with a logical function shows the word “TRUE” or “FALSE” as a result
Options: a. IF b. AND c. OR d. NOT

Ans:– a,– a


. Disk copy command in DOS is used to
Options: a. Copy a file b. Copy contents of one floppy disk to another c. Copy contents of CD-ROM to another d. All of the above

Ans:Correct Answer: b ,Correct Answer: b


When the collector current increases, what does the current gain do?
Options: decreases,    stays the same,    increases,    any of the above

Ans:C ,C


What is meant by the term RAM?
Options: Memory which can only be read,    Memory which can be both^read and written to,    Memory which is used for permanent storage,    Memory which can only be written to

Ans:B,B


The powerful text editor called PC-Write can be used by anybody by paying a small fee. Such programs are called
Options: Software,    Shareware,    Firmware,    Mindware

Ans:B ,B


Which would you choose to move selected text from one place to another?
Options: Press Ctrl+S B. Click File, Save C. Click Tools, Options, Save D. Click File, Save As

Ans:C ,


7. …is the first program run on a computer when the computer boots up
Options: a. System software b. Operating system c. System operations d. None

Ans:Correct Answer: b,Correct Answer: b


. Which of the following is best for quick copy operation?
Options: Copy and Paste B. Windows Clipboard C. Drag and Drop D. Auto Text

Ans: – C ,


Quantitative techniques used to solve business problems are called
Options: operations management,    operations science,    operations research,    management operations

Ans:C ,C


What happens if you press Ctrl + Shift + F8?
Options:  A) It activates extended selection, B) It activates the rectangular selection, C) It selects the paragraph on which the insertion line is., D) None of above,

Ans:-B,-B


B7:B9 indicates:
Options: Cells B7 and cell B9 only. B. Cells B7 through B9. C. Cell B8 only. D. None of the above.

Ans:– B ,


Which of the following is true concerning QBE?
Options: An official standard has been defined for QBE.,    QBE cannot be used for client/server systems.,    QBE does not give the programmer a visual programming environment.,    Complete applications can be written using QBE.

Ans:D ,D


. Which statement is valid?

Options: A) 1KB = 1024 bytes B) 1 MB=2048 bytes C) 1 MB = 1000 kilobytes D) 1 KB = 1000 bytes

Ans:A,A


Which of the following is not of the merge process?
Options:  A) Sort the data source records, B) Format a main document, C) Edit a data source, D) Merge the two files to print or create a new document, 

Ans:-A,-A


. One computer that is not considered a portable computer is
Options: A) Minicomputer B) A laptop computer C) Tablet PC D) All of the above

Ans:A,A


A single packet on a data link is known as
Options: Path,    Frame,    Block,    Group

Ans:B ,B


. What should be the extension to execute files?
Options: EXE B. BAT C. COM D. All of the above

Ans: – D ,


In OLE DB, a service provider:
Options: does not own data only.,    transforms data through OLE DB interfaces only.,    is both a consumer and a provider of data only.,    All of the above are true of an OLE DB service provider.

Ans:D ,D


. Whenever you move a directory from one location to another
Options: a. All files inside the directory are moved b. All the subdirectory inside that directoryare moved c. The directory is moved the source file is not moved d. Both a and b

Ans: d, d


Conversion of an octal number 208 to its binary number is
Options: 100002,    101112,    101102,    111102

Ans:A ,A


. 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:7 – D ,7 – D


What command is used with file named 'letter' to remove the executable permission from the user and assign read permission to the group and others?
Options: chmod go + x, u - x letter,    chmod g - x, uo + r letter,    chmod go + r, u + x letter,    chmod u - x, go + r letter

Ans:D ,D


In SQL, which command is used to remove a stored function from the database?
Options: REMOVE FUNCTION,    DELETE FUNCTION,    DROP FUNCTION,    ERASE FUNCTION

Ans:C ,C


. Most of the first generation computers were
Options: A) Special purpose computers B) General purpose computers C) Both of above D) None of above

Ans:A,A


The tracks on a disk which can be accessed without repositioning the R/W heads is
Options: Surface,    Cylinder,    Cluster,    All of the above

Ans:B,(Banswer


.   The size of an organization chart object
Options: a. Is determined by the presentation design and cannot be changed b. Is determined by the presentation design but can be changed in PowerPoint c. Is dependent on the amount of text within the organization chart d. B and c

Ans:5 – D ,5 – D


What device protects against line deficiencies?
Options: Surge protector,    UPS,    Logic probe,    Capacitor

Ans:B ,B


. Which device is used as the standard pointing device in a Graphical User Environment?
Options: A) Keyboard B) Mouse C) Joystick D) Track ball

Ans:B,B


. Which is the highest form?
Options: A) Data B) Information C) Knowledge D) All of above

Ans:C,C


. The first cell in EXCEL worksheet is labeled as
Options: a. AA b. A1 c. Aa d. A0

Ans:– b,– b


. Tree structure displays the
Options: a. File only b. Directory only c. File and directory name d. None of above

Ans:2 – c ,2 – c

www.000webhost.com