Description : Distinguish between Number and AutoNumber data type field. Give example of each. -Technology
Last Answer : Distinguishing between Number and AutoNumber dataNumberAutoNumberIt holds numeric values whichare used for calculations.It allows to store numbers thatare automatically generatedfor each record.The field ... for every newcustomer, this field willautomatically increase and willprovide a new number.
Description : The default data type for a field is (a) Number (b) AutoNumber -Technology
Last Answer : (d) The default data type for a field is Text.
Description : Define the AutoNumber data type in MS_ Access. -Technology
Last Answer : AutoNumber data type starts with a number for the first record and it automatically increases the number by a set of amount for each record.
Description : What is the use of AutoNumber type field used in MS_Access? -Technology
Description : When Memo data type is preferred over Text type for a field? -Technology
Last Answer : When the length of the field is more than 255 characters. Text data type is not capable to store the project description because its length cannot be more than 255 characters so, Memo data type is preferred over the Text data type.
Description : Which of the following is false? a) The more important the data, the greater the need for backing it up b) A backup is as useful as its associated restore strategy c) Storing the ... near to its original site is best strategy d) Automated backup and scheduling is preferred over manual operations
Last Answer : Storing the backup copy near to its original site is best strategy
Description : If the data type of a field is set to Text, what will be its number range? -Technology
Last Answer : Its range will be 0 to 255.
Description : What data type should you choose for a zipcode field in a table? (a) Text (b) Number -Technology
Last Answer : (b) Number data type should be chosen for a zip code field in a table.
Description : A Text data type cannot allow number entry. -Technology
Last Answer : False As, it can include both text as well as numbers.
Description : The digital signals to analog signals are carried out by ………., so that data can travel over telephone lines. -Technology
Last Answer : The digital signals to analog signals are carried out by MODEMso that data can travel over telephone lines.
Description : Which of the following charts is used for comparing the changes in data over a period of time? -Technology
Last Answer : (d) Line chart emphasizes on a rate of change rather than volume of change over time.
Description : What happens when you enter numbers in a Text data type field? -Technology
Last Answer : Numbers are accepted as a text value.
Description : Name the data type that should be used to store Student’s Admission numbers. -Technology
Last Answer : Data type should be Text.
Description : Write one example of data for which Memo data type is used. -Technology
Last Answer : To store resume of an employee in Employee table is an example of Memo data type.
Description : Write one example of each field, for which you would use 1. Text data type -Technology
Last Answer : 1. Text data type It allows to store text or combination of text and numbers as well as numbers that don't require calculations such as phone number. This data type allows maximum 255 characters ... Description will be of Memo data type, because the length of description of employee may be large.
Description : Which of the following is not a data type? (a) Picture/Graphic (b) Date/Time -Technology
Last Answer : (a) From the given options Date/Time, Text and Number are the data types.
Description : For what, Memo data type is used? (a) To add table (b) To store objects created in other programs -Technology
Last Answer : (c) As we know, Memo provides character upto 65536 so, it is used for long text entries.
Description : Single and double are the types of (a) Integer data type (b) Decimal numbers -Technology
Last Answer : (d) Date/Time will be the data type because it allows storing date and time format.
Description : Which data type helps you to handle input that is in boolean format? -Technology
Last Answer : (c) Yes/No will allow boolean value.
Description : For storing lengthy information in a field ………….. data type is used. -Technology
Last Answer : For storing lengthy information in a field Memodata type is used.
Description : In a Text type data field, we can enter a maximum of ………….. characters. -Technology
Last Answer : In a Text type data field, we can enter a maximum of 255characters.
Description : Memo data type allows you to store character type values in a table. -Technology
Last Answer : True Memo data type allows upto 65536 characters.
Description : Memo data type allows you to store only 255 characters in the table. -Technology
Last Answer : False Memo data type is used when character size is more than 255.
Description : ……. is a type of backup in which only the data that changed, since last backup is saved. -Technology
Last Answer : Differential backup is a type of backup in which only the data that changed since the last backup is saved.
Description : Suggest the suitable data type for Issue_Date column. -Technology
Last Answer : (i)Date(ii) alter table library modify name varchar(50);(iii) Bid column will always have a unique value which will help uniquely identify each record of Library table.(iv) Select name from library order by status desc;
Description : Help Ramesh in identifying any two columns for a table named student along with their suitable data type. -Technology
Last Answer : Column NameData TypeRollNoIntegerNameVarchar(20)
Description : While creating a table named “Employee”, Mr. Rishi got confused as which data type he should chose for the column “EName” out of char and varchar. -Technology
Last Answer : Varchar would be the suitable data type for EName column as char data type is a fixed length data type while varchar is a variable length data type.Any employee‟s name will be of variable length so it‟s advisable to choose varchar over char data type.
Description : Write the data type of variables that should be used to store : 1. Marks of students 2. Grades of students (Grade can be ‘A or ‘B’ or ‘C’) -Technology
Last Answer : (i) int data type(ii) char data type
Description : Name the data type that should be used to store AccountCodes liko “A1001” of Customers -Technology
Last Answer : varchar data type should be used to store AccountCodes like ”A100111 of customers.
Description : If the data entered in a cell is 546z then, Excel will treat it as a number because it starts with a digit. -Technology
Last Answer : False It will be treated as non-numeric data because it contains letters along with numbers.
Description : Write the code in python to read the contents of “number.csv” file consisting of data from a mysql table and print the data of the table -Technology
Last Answer : f = open('numbers.csv', 'r') with f:reader = csv.reader(f)for row in reader:for e in row:print(e)
Description : Why are drum-type armatures preferred over the Gramme ring armature in modern dc generators?
Last Answer : Drum-type armatures are more efficient, because flux lines are cut by both sides of each coil.
Description : Why NMOS technology is preferred more than PMOS technology?
Last Answer : N- channel transistors has greater switching speed when compared tp PMOS
Description : Which one of the following statements regarding preferred position in fine cut is false? a. Traditional customers want products located in the center of the circle. b. Low end customers want the ... . d. Performance customers prefer higher performance levels. e. Size customers want smaller size.
Last Answer : b. Low end customers want the newest technology at the cheapest price.
Description : Which types of LEDs are the preferred optical sources for short-distance, low-data-rate fiber optic systems?
Last Answer : SLEDs and ELEDs.
Description : Which light emitter is preferred for high-speed data in a fiber-optic system? ∙ A. incandescent ∙ B. LED ∙ C. neon ∙ D. laser
Last Answer : D. laser
Description : Which light emitter is preferred for high speed data in a fiber-optic system ∙ a. Incandescent ∙ b. LED ∙ c. Neon ∙ d. Laser
Last Answer : ∙ d. Laser
Description : ………………… is preferred method for enforcing data integrity A) Constraints B) Stored Procedure C) Triggers D) Cursors
Last Answer : A) Constraints
Description : ……………. is a preferred method for enforcing data integrity A) Constraints B) Stored procedure C) Triggers D) Cursors
Description : ………… refers to the amount of data that a signal or a circuit can carry. -Technology
Last Answer : Bandwidthrefers to the amount of data that a signal or a circuit can carry.
Description : Which of the following storage device can be used for storing large backup data? (a) Floppy disks (b) Hard disk (c) Magnetic tapes (d) None of these -Technology
Last Answer : "B) Hard Disk.
Description : Pen drive is also known as (a) Flash drive (b) Data stick (c) Thumb drive (d) All of the above -Technology
Last Answer : (d) A USB flash drive, data stick, thumb drive or pen drive is a portable drive that connects to a computer’s USB port.
Description : ……. is an electronic device that manipulates information or data according to the set of instructions called program. -Technology
Last Answer : Computeris an electronic device that manipulates information or data according to the set of instructions called program.
Description : ………. printers are based on electrophotography technology to print the data. -Technology
Last Answer : Laser printers are based on electrophotography technology to print the data.
Description : ………… memory is a special memory used for speeding up the transfer of data and instructions in CPU. -Technology
Last Answer : Cache memory is a special memory used for speeding up the transfer of data and instructions in CPU.
Description : A ……… is a thumb sized gadget that can be used to read, write or erase data as many times. -Technology
Last Answer : .A pen driveis a thumb sized gadget that can be used to read, write or erase data as many times.
Description : …….. is the meaningful content that is extracted from the data after processing. -Technology
Last Answer : Information is the meaningful content that is extracted from the data after processing.
Description : In CPU, control unit performs the actual processing on the data. -Technology
Last Answer : FalseIn CPU, control unit does not perform am actual processing instead it controls and guides the operations like a supervisor.
Description : In Random Access Memory if current will be interrupted, data will not lost. -Technology
Last Answer : FalseRandom Access Memory (RAM) is a volatile memory, if current is interrupted, data will lost.