. 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 ,






More Database Systems Related questions:


Point out the error in the program #include<stdio.h> int main() { int i; #if A printf("Enter any number:"); scanf("%d", &i); #elif B printf("The number is odd"); return 0; }
Options: Error: unexpected end of file because there is no matching #endif,    The number is odd,    Garbage values,    None of above

Ans:A ,A


Which language has been selected as the basis for the Japanese "fifth generation" computers.
Options: ALGOL,    COBOL,    PROLOG,    C

Ans:C ,C


. The Width of a processor’s data path is measured in bits. Which of the following are common data paths?
Options: A) 8 bits B) 12 bits C) 16 bits D) 32 bits

Ans:A,A


The auto calculate feature
Options: a. Can only add values in a range of cells b. Provides a quick way to view the result of an arithmetic operation on a range of cells c. Automatically creates formulas and adds them to a worksheet d. A and c

Ans:#8211; b,#8211; b


. When a key is pressed on the keyboard, which standard is used for converting the keystroke into the corresponding bits?

Options: A) ANSI B) ASCII C) EBCDIC D) ISO

Ans:A,A


Conversion of an octal number 738 to binary number is
Options: 1101112,    1111002,    1100102,    1110112

Ans:D ,D


Which of the following is not used for storage purposes with main frame computers?
Options: removable disks,    fixed disks,    mass storage systems,    diskettes

Ans:D ,D


The 2's complement of a binary no. is obtained by adding.....to its 1's complement.
Options: 0 ,    1,    10,    12

Ans:B,(Banswer


. If particular workbook have to open each time Excel started, where that workbook should be placed?
Options: AUTOEXEC Folder B. AUTOSTART Folder C. EXCELSTART Folder D. XLSTART Folder

Ans:– D ,


Inductive reactance is measured in units of:
Options: volts per second,    amperes per second,    Ohm,    henrys

Ans:C ,C


A vertically aligned set of tracks on a disk pack is known as
Options: Cluster,    Surface,    Cylinder,    Panel

Ans:C ,C


What should you do if you require pasting the same format in many places?
Options:  A) Click the Format painter and go on pasting in many places holding Alt Key, B) Double click the format painter then go on pasting in many places, C) Click the format painter then go on pasting to many places holding Ctrl Key, D) All of above,

Ans:-B,-B


A characteristic of a file server is which of the following?
Options: Manages file operations and is shared on a network.,    Manages file operations and is limited to one PC.,    Acts as a fat client and is shared on a network.,    Acts as a fat client and is limited to one PC.

Ans:A ,A


A high quality CAD system uses the following for printing drawing and graphs
Options: Dot matrix printer,    Digital plotter,    Line printer,    All of the above

Ans:B ,B


. MS Excel provides the default value for step in Fill Series dialog box
Options: a.  0 b.  1 c.  5 d.  10

Ans:– b,– b


. Which of the following syntax is correct regarding to SUM function in Excel?
Options: =SUM (A1, B1) B. =SUM (A1:B9) C. =SUM (A1:A9, B1:B9) D. All of the above

Ans:– D ,


. Before printing a datasheet, you can use ____ to determine whether to change the page orientation from portrait to vertical orientation.
Options: a. Design View b. Datasheet View c. Office View d. Print Preview

Ans:9 – d ,9 – d


hat is the shortcut key to display field codes?
Options: Alt + F9 B. Ctrl + F9 C. Shift + F9 D. Space + F9

Ans:– A ,


. Can you set 0.5 inch left indentation for a cell in Excel?
Options: a. Excel does not have indentation feature b. You can specify indentation only if you turn the rulers on c. Indentation can be set from Format Cells dialog box d. The indentation can be specified only when printing

Ans:– c,– c


A half byte is know is
Options: Data,    Bit,    Half byte,    Nibble

Ans:D ,D


The most popular language for interactive use is
Options: COBOL,    PASCAL,    BASIC,    FORTRAN

Ans:C ,C


. The database language that allows you to access or maintain data in a database
Options: a. Dcl b. Dml c. Ddl d. None of above

Ans:7 – a ,7 – a


What is the abbreviation used for a software package that permits the users to create, retrieve and maintain records in a database?
Options: DASD,    FMS,    EMMS,    DBMS

Ans:D ,D


Which of the following storage devices can store maximum amount of data?
Options:  Floppy Disk B.  Hard Disk C.  Compact Disk D.  Magneto Optic Disk

Ans:– B ,


The rise time of a pulse waveform is the time required for the voltage to rise:
Options: from zero to its rms value,    from zero to its peak value,    from 10% of the peak value to 70.7% of the peak value,    from 10% of the peak value to 90% of the peak value

Ans:D ,D


2. Which is the valid filename assign in MS-DOS?
Options: a. Ram*.txt b. Ram?.doc c. Ram_$.txt d. None of above

Ans:Correct Answer: c,Correct Answer: c


How many IRQs does a chain of USB devices require?
Options: 1,    2,    3,    4

Ans:A ,A


In a computer _____ is capable to store single binary bit.
Options: Capacitor B. Flip flop C. Register D. Inductor

Ans:– B ,


In SQL, the CREATE VIEW command is used
Options: to recompile view,    to define a view of one or more tables or views,    to recompile a table,    to create a trigger

Ans:B ,B


You have a class A network address 10.0.0.0 with 40 subnets, but are required to add 60 new subnets very soon. You would like to still allow for the largest possible number of host IDs per subnet. Which subnet mask should you assign?
Options: 255.240.0.0,    255.248.0.0,    255.252.0.0,    255.254.0.0

Ans:D ,D


. Which feature is used for monitoring all document changes?
Options: Edit Document B. Monitor Change C. Track Change D. Track all

Ans: – C ,


When operating above its resonant frequency, a series RLC circuit has the characteristics of a:
Options: series RL circuit,    series RC circuit,    series RLC circuit operated below its resonant frequency,    purely resistive circuit

Ans:A ,A


In MS-Word, for what does ruler help?
Options: to set tabs B. to set indents C. to change page margins D. All of the above

Ans:– D ,


. In databases, Locking level is also called as
Options: a. Granularity b. S lock c. X lock d. Dead lock

Ans:– a,– a


Memory unit is one part of
Options: Input device B. Control unit C. Output device D. Central Processing Unit

Ans:– D ,


. Which of the following is not true?
Options: A) Transistors are much smaller B) Transistors produce low heat C) Transistors were less reliable D) Transistors were used in radios and other electronic devices

Ans:C,C


. Press the ….button to have the window fill the entire screen
Options: a. Close b. Maximize c. Minimize d. none of the above

Ans:4 – c ,4 – c


An advantage of overlapped processing activities is:
Options: more effective use of the CPU,    increased processing activities for the entire system,    better coordination of I/O activities,    all the above

Ans:D ,D


If your router is facilitating a CSU/DSU, which of the following commands do you need to use to provide the router with a 64000bps serial link?
Options: RouterA(config)#bandwidth 64,    RouterA(config-if)#bandwidth 64000,    RouterA(config-if)#clock rate 64,    RouterA(config-if)#clock rate 64000

Ans:D ,D


Which are the most important features of Microsoft Windows program?
Options: Windows,    Pull-down menus,    Icons,    All of the above

Ans:D ,D


Which of the following protocol is/are defined in Transport layer?
Options: FTP B. TCP C. UDP D. B & C

Ans: – D ,


. Press ____ key while booting to display Advanced Boot Menu
Options: a. F5 b. F6 c. F8 d. Del

Ans:8 – c ,8 – c


Which of the following tasks is not suited for sequential processing by a computer?
Options: Preparing of mailing labels,    Processing payroll cheques,    Accounting for credit card purchases,    Inventory control

Ans:D ,D


Which option allows you to select line, curve, freeform or scribble tools?
Options: a. Create effect b. Insert motion path c. Draw custom path d. All of the above

Ans: – C , – C


. The default and maximum size of text field in access
Options: a. 50 and 255 characters b. 8 and 1 gb c. 266 characters & 64000 characters d. None of above

Ans:9 – a ,9 – a


The maximum combined length of the command-line arguments including the spaces between adjacent arguments is
Options: 128 characters,    256 characters,    67 characters,    It may vary from one operating system to another

Ans:D ,D


. Which one of the following key is used to refresh the active window?
Options: a. F7 b. F8 c. F9 d. F5

Ans:6 – d ,6 – d


Which of the following options will be used to display number of blocks used by a file?
Options: -c,    -i,    -d,    -s

Ans:D ,D


What are the three decisions making operations performed by the ALU of a computer?
Options: A) Grater than B) Less than C) Equal to D) All of the above

Ans:-D,-D


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

www.000webhost.com