What does the NOW() function return?


Options: It returns the serial number of the current date and time B. It returns the serial number of the current date C. It returns the serial number of the current time D. None of the above

Ans:– D ,


Description: it will show date ,not the serial no. of anythying

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

Hits Today: 5459 | Level: Moderate




Got some suggestion about this question or to make this site better? Please leave your comments below.


Want to see where do you stand among other aspirants in "Computer" Category?

Click Here to take quick 5 mins MCQ test to find out.

More MS-Excel Related questions:


What are the types of linkages?
Options: Internal and External,    External, Internal and None,    External and None,    Internal

Ans:B ,B


. How to fit long texts in a single cell with multiple lines?
Options: Start typing in the cell and press the Enter key to start another line B. Use the Wrap Text option in the Format -> Alignment menu C. Use the Shrink to Fit option in the Format -> Cells -> Alignment menu D. All of above

Ans:– B ,


What will be the output of the program? #include<stdio.h> int main() { int i; char c; for(i=1; i<=5; i++) { scanf("%c", &c); /* given input is 'b' */ ungetc(c, stdout); printf("%c", c); ungetc(c, stdin); } return 0; }
Options: bbbb,    bbbbb,    b,    Error in ungetc statement.

Ans:C ,C


Using ODL, you can define which of the following?
Options: Attribute,    Structure,    Operation,    All of the above.

Ans:D ,D


Which one of the following equations most directly determines the power dissipation of a resistance when you know the voltage drop and amount of resistance?
Options: P = I2R,    P = IE,    P = E2/R,    I = P/E

Ans:C ,C


Changing oil in an automobile is an example of
Options: preventative maintenance,    scheduled maintenance,    both (a) and (b),    neither (a) nor (b)

Ans:C ,C


Two dimensional arrays are also called
Options: a. tables arrays b. matrix arrays c. both of above d. none of above

Ans:- c,- c


To conserve battery power on your laptop computer. What DOS v6.x command should you use?
Options: Powermon.exe,    Power.exe,    Idel.com,    Pw.sys

Ans:B ,B


After typing header text, how can you quickly enter footer text?
Options:  A) Press PageDown key and type the text for footer, B) Click on Switch between Heder & Footer then type the text, C) Both of above, D) None of above,

Ans:C,Both of above


A(n) ____ device is any device that provides information which is sent to the CPU.
Options: input,    output,    CPU,    memory

Ans:A ,A


    In MS-Dos 6.22, which part identifies the product uniquely  
Options: a.    MS b.    DOS c.    Ms-DOS d.    6.22

Ans:.b,Correct Answer: d. 6.22


ESD potential decreases with the use of:
Options: De-ionizing fans,    A wrist strap,    Rubber gloves with matching cap,    A static meter

Ans:B ,B


Which of the following is not a common configuration used in a DDP system?
Options: star,    ring,    tree,    realtime

Ans:D ,D


Which of the following is not the Section Break Option?
Options: a. Next Page b. Previous Page c. Odd Page d. Even Page

Ans:–  B,–  B


0. What is a file extension of Templates in Microsoft Word?
Options: .Dtep B. .Dott C. .Dotx D. .Doct

Ans: – C ,


. Bit map terminal
Options: A) support display containing multiple window B) require considerable amount of video RAM C) requires tremendous amount of copying and hence low performance D) all of above

Ans:D,D


Which of the following commands is used to display the directory attributes rather than its contents?
Options: ls -l -d,    ls -l,    ls -x,    ls -F

Ans:A ,A


Which one of the following equations most directly leads to the resistance of an ordinary household light bulb, assuming that you know the power and voltage rating?
Options: R = E2/P,    P = PR,    P = E2/R,    I = P/E

Ans:A ,A


The magnetic disks and drums are like recirculating shift registers because
Options: they have about the same storage capacity,    their storage is non volatile,    their access times are about the same,    stored data is available for reading over and over again in the same order.

Ans:D ,D


hat is the use of Document Map?
Options: to quickly format the document B. to quickly print required page C. to quickly navigate the document D. to quickly correct spelling mistakes

Ans:– C ,


What is the main difference between a mainframe and a super computer?
Options: A) Super computer is much larger than mainframe computers B) Super computers are much smaller than mainframe computers C) Supercomputers are focused to execute few programs as fast as possible while mainframe uses its power to execute as many programs concurrently D) Supercomputers are focused to execute as many programs as possible while mainframe uses its power to execute few programs as fast as possible.

Ans:C,C


If there are multiple recycle bin for a hard disk
Options: a. you can setdifferent size for each recycle bin b. you can choose which recycle bin to use to store your deleted files c. You can make any one of them default recycle bin d. None of above

Ans:a,a


Which of the following statements correct about the below program? #include<stdio.h> int main() { union a { int i; char ch[2]; }; union a u1 = {512}; union a u2 = {0, 2}; return 0; } 1: u2 CANNOT be initialized as shown. 2: u1 can be initialized as shown. 3: To initialize char ch[] of u2 '.' operator should be used. 4: The code causes an error 'Declaration syntax error'
Options: 1, 2,    2, 3,    1, 2, 3,    1, 3, 4

Ans:C ,C


Each answer below shows example data from a table. Which answer is an example of the general-purpose remarks column problem?
Options: Three columns have the values 534-2435, 534-7867, and 546-2356 in the same row.,    Three rows have the values Brown Small Chair, Small Chair Brown, and Small Brown Chair in the same column.,    Three rows have the values Brown, NULL, and Blue in the same column.,    One row has the value "He is interested in a Silver Porsche from the years 1978-1988" in a column.

Ans:D ,D


The characteristics of strategic decisions include all of the following except:
Options: they are structured,    they are future oriented,    they have a high level of uncertainty,    they are concerned with long-range plans

Ans:A ,A


A microprocessor is:
Options: controlled by a program,    an integrated circuit,    relatively inexpensive,    All of the above

Ans:D ,D


A word processor would most likely be used to do
Options:  A) Keep an account of money spent, B) Do a computer search in media center, C) Maintain an inventory, D) Type a biography,

Ans:-D,-D


. Which of the following line spacing is invalid?
Options: a. Single b. Double c. Triple d. Multiple

Ans: – C , – C


1024 bytes represent a
Options: Megabyte,    Gigabyte,    Kilobyte,    None of the above

Ans:C,C


Which of these controller types is the most accurate?
Options: Proportional plus integral,    Proportional,    Proportional plus derivative,    Three mode

Ans:D ,D


The data appearing first in the left portion of punched card is
Options: descriptive data,    coded data,    quantitative data,    All of the above

Ans:B ,B


. Getting data from a cell located in a different sheet is called….
Options: a. Accessing b. Referencing c. Updating d. Functioning

Ans:– b,– b


Which of the following file types has the least life
Options: Master file,    Program file,    Transaction file,    Work file

Ans:D ,D


To find out how much memory is available, you could type _____
Options: EMM,    MEM,    CHKDSK,    MEMMAKER

Ans:B ,B


. The Basic Input Output System (BIOS) resides in
Options: a. RAM b. ROM c. The CPU d. Memory Cache

Ans: b, b


. What is the method of handling deadlocks?
Options: a. Use a protocol to ensure that the system will never enter a deadlock state. b. Allow the system to enter the deadlock state and then recover. c. Pretend that deadlocks never occur in the system. d. All of the Above

Ans:5 – d ,5 – d


Which bus is bidirectional?
Options: data bus,    control bus,    address bus,    multiplexed bus

Ans:A ,A


The technique, for sharing the time of a computer among several jobs. Which switches jobs so rapidly such that each job appears to have the computer to itself:
Options: time sharing,    time out,    time domain,    FIFO

Ans:A ,A


3. What is the maximum number of lines you can set for lines to drop box?
Options: a. 3 b. 5 c. 10 d. 15

Ans:#8211; C ,#8211; C


While working with MS-DOS, which command is used to undelete a bunch of files with extension DOC that you have just deleted?
Options: UNDELETE,    UNDELETE *.DOC,    UNDELETE/ALL,    UNDELETE/LIST

Ans:B ,B


What project is currently developing X server support?
Options: XFree86 Project, Inc.,    RHAD Labs,    GNOME Project,    All of the above

Ans:A ,A


Suppose the zener diode has a breakdown voltage of 10 V and zener resistance of 8.5 W, what is the additional voltage when the current is 20 mA?
Options: 0.17 V,    10.17 V,    20 V,    18.8 V

Ans:A ,A


Compilers and interpreters are themselves
Options: High-level language,    Codes,    Programs,    Mnemonics

Ans:C ,C


Which DOS command would allow you to redirect a printer?
Options: Type,    Capture,    Mode,    Print

Ans:C ,C


Which of the following is not a requirement of structured design?
Options: It should be made up of a hierarchy of modules,    It should use many GOTO statements,    The code should be executed in a top-to-bottom fashion within each module,    Each module should be as independent as possible of all other modules, except its parent

Ans:B ,B


A table that displays data redundancies yields ____________ anomalies
Options: Insertion B. Deletion C. Update D. All of the above

Ans:– D ,


Which of the following devices could be part of a sensor?
Options: thermometer,    brake,    relay,    clutch.

Ans:A ,A


A Dumb terminal has
Options: Processor and Keyboard B. Processor and Hard Disk C. Keyboard and Hard Disk D. Keyboard and Screen

Ans:– D ,


. What is a light pen?

Options: A) Mechanical Input device B) Optical input device C) Electronic input device D) Optical output device

Ans:B,B


A supertype/subtype hierarchy has which of the following features?
Options: Subtypes at the lower lever in the hierarchy inherit attributes only from their immediate supertype.,    Attributes are assigned at the highest logical level.,    Subtypes at the higher lever in the hierarchy inherit attributes only from their immediate subtype.,    Attributes are assigned at the lowest logical level.

Ans:B ,B

www.000webhost.com