Name the data type that should be used to store AccountCodes liko “A1001” of Customers -Technology

Name the data type that should be used to store AccountCodes liko “A1001” of Customers -Technology
by

1 Answer

Answer :

varchar data type should be used to store AccountCodes like ”A100111 of customers.
by

Related questions

Sanchita is working for a nationalized bank and is in the process of creating a table to store the details of customers of the bank. -Technology

Description : Sanchita is working for a nationalized bank and is in the process of creating a table to store the details of customers of the bank. -Technology

Last Answer : Primary key AccountNoCandidate key AccountNo and PAN NumberAlternate key PAN Number

Name the data type that should be used to store Student’s Admission numbers. -Technology

Description : Name the data type that should be used to store Student’s Admission numbers. -Technology

Last Answer : Data type should be Text.

For what, Memo data type is used? (a) To add table (b) To store objects created in other programs -Technology

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.

Memo data type allows you to store character type values in a table. -Technology

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.

Memo data type allows you to store only 255 characters in the table. -Technology

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.

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

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

How do I develop a system where my customers send all the order quantity and type through sms and I receive thier data real-time on my SAP or any portal ?

Description : How do I develop a system where my customers send all the order quantity and type through sms and I receive thier data real-time on my SAP or any portal ?

Last Answer : Slowly and carefully. 1) you need an SMS provider 2) you need a processor that will accept the incoming messages and parse them 3) you need to send these to your order processing software But there ... to depend on the software you are using, yur SMS provider, and how good your programmers are.

The director of a company uses a database to store data about job title. This is a part of the database given below: -Technology

Description : The director of a company uses a database to store data about job title. This is a part of the database given below: -Technology

Last Answer : 1. 62. 63. Secretary4. Finance department and their Payroll Numbers are A621 and M502.

Facilities offered by databases are (a) The ability to store a large amount of data in a structured format, -Technology

Description : Facilities offered by databases are (a) The ability to store a large amount of data in a structured format, -Technology

Last Answer : (a) Databases have the ability to store a large amount of data in structured format, easy update, sort query, production of reports.

Neha Mittal wants to store data of her montly expenditure for a period of two year and also wants -Technology

Description : Neha Mittal wants to store data of her montly expenditure for a period of two year and also wants -Technology

Last Answer : Microsoft Excel should be used because it cannot only be used for storing data but also be used to perform calculations and analysis of the data.

Tamanna needs to store and transport the data. She should use HTML or XML? -Technology

Description : Tamanna needs to store and transport the data. She should use HTML or XML? -Technology

Last Answer : She should use XML.

……….. allows customers to conduct financial transactions on a secure Website. -Technology

Description : ……….. allows customers to conduct financial transactions on a secure Website. -Technology

Last Answer : E-banking allows customers to conduct financial transactions on a secure Website.

Which of the following fields will not make a suitable primary key? (a) A customer’s account number -Technology

Description : Which of the following fields will not make a suitable primary key? (a) A customer’s account number -Technology

Last Answer : (b) From the given options, the data field can not be set as a primary key because it can’t be fixed for an object.

In a Bank’s database, there are two tables ‘Customer’ and ‘Transaction’ as shown below. Write a query to display customer’s name who has -Technology

Description : In a Bank’s database, there are two tables ‘Customer’ and ‘Transaction’ as shown below. Write a query to display customer’s name who has -Technology

Last Answer : (i) Select cust_name from customer c,transaction t where c.Acc_No=t.Acc_No and Transaction_Type= 'Debit';(ii)Select cust_name, t.* from customer c, transaction t where c.Acc_No=t.Acc_No;(iii) ... total amount of all type of transactions, it will only display the total of credit transactions only.

Write a query to display customer’s name who has withdrawn the money. -Technology

Description : Write a query to display customer’s name who has withdrawn the money. -Technology

Last Answer : Select cust_name from customer c,transaction t where c.Acc_No=t.Acc_No and Transaction_Type= 'Debit';

Write a query to display customer’s name along with their transaction details. -Technology

Description : Write a query to display customer’s name along with their transaction details. -Technology

Last Answer : Select cust_name, t.* from customer c, transaction t where c.Acc_No=t.Acc_No;

Write a query to display customer’s name who have not done any transaction yet. -Technology

Description : Write a query to display customer’s name who have not done any transaction yet. -Technology

Last Answer : Select cust_name from customer c,transaction t where c.Acc_No!=t.Acc_No;

To store object like image, you need to create a field in a table, having field type as …………. . -Technology

Description : To store object like image, you need to create a field in a table, having field type as …………. . -Technology

Last Answer : To store object like image, you need to create a field in a table, having field type as OLE Object.

…… memory is used to store large amount of information permanently. (a) RAM (b) ROM (c) Secondary (d) Primary -Technology

Description : …… memory is used to store large amount of information permanently. (a) RAM (b) ROM (c) Secondary (d) Primary -Technology

Last Answer : (c) Secondary memory is used to store large amount of information permanently.

Which folder is used as a convenient place to store important files and folders of a user? -Technology

Description : Which folder is used as a convenient place to store important files and folders of a user? -Technology

Last Answer : Documents is a folder that provides convenient place to store important files and folders.When a user saves a file, the file is automatically saved in Documents unless the user has chosen a different ... quickly, user can use Start menu or double click on the Documents icon placed on desktop.

Ram wants to create a text file to store name and roll number of his students. Suggest, which program he should use. -Technology

Description : Ram wants to create a text file to store name and roll number of his students. Suggest, which program he should use. -Technology

Last Answer : He can create a text file using Notepad or WordPad. Follow these steps to create a file using Notepad:(a) Step 1:Click Start.(b) Step 2:Choose All Programs -> Accessories -> Notepad.(c) Step 3: ... dialog box will appear.(g) Step 7:Give file name with extension.(h) Step 8: Click Save button.

A ………… is a hardware device on which you can store files and folders. -Technology

Description : A ………… is a hardware device on which you can store files and folders. -Technology

Last Answer : Adisk driveis a hardware device on which you can store files and folders.

Computer is a folder that provides you with a convenient place to store your important files and folders. -Technology

Description : Computer is a folder that provides you with a convenient place to store your important files and folders. -Technology

Last Answer : FalseComputer is an icon on desktop. It does not store files and folders, it simply helps you to display the folders contained on that drive.

It allows a visited website to store its own information about a user on the user’s computer. -Technology

Description : It allows a visited website to store its own information about a user on the user’s computer. -Technology

Last Answer : (iii) Cookies

Write Java code to assign the value 10 to variable x and store its square value in another variable y. -Technology

Description : Write Java code to assign the value 10 to variable x and store its square value in another variable y. -Technology

Last Answer : class Square{public static void main (String args [ ]){int x. y ; x = 10 : y = x * x ;

What would you do if you overheard a store employee making fun or talking bad of one of their customers behind his/her back?

Description : What would you do if you overheard a store employee making fun or talking bad of one of their customers behind his/her back?

Last Answer : I would note their names and tell the store manager.

Is a store owner legally obligated to serve all customers?

Description : Is a store owner legally obligated to serve all customers?

Last Answer : Does the business owner have a sign that says: We reserve the right to refuse service to anyone for any reason ? I don't mean to be smarmy, but I have seen these signs many times in my life ... our property. Once I had a manager who refused service to one of her ex-boyfriends for cheating on her.

A world-famous magician and his young assistant were observed walking slowly along in a department store when suddenly they both stopped walking and began to slowly rise from the floor. The two continued to rise majestically until they had reached a height of 20 feet. Numerous store customers and a security guard witnessed the event, but no one seemed shocked by what they had seen, and no report of the occurrence ever reached the news media. The secrets of magic are not supposed to be revealed, but how would you speculate the magician and his assistant accomplished this feat, and why didn’t the onlookers express amazement? -Riddles

Description : A world-famous magician and his young assistant were observed walking slowly along in a department store when suddenly they both stopped walking and began to slowly rise from the floor. The two ... and his assistant accomplished this feat, and why didn't the onlookers express amazement? -Riddles

Last Answer : The magician and his assistant were simply using an escalator to go up to the next floor in the department store.

What hosting is best used for doing business on the Internet ( I have my own small store and I want to increase the number of customers by expanding the geography of sales)?

Description : What hosting is best used for doing business on the Internet ( I have my own small store and I want to increase the number of customers by expanding the geography of sales)?

Last Answer : I am looking for ways to expand my business through modern technologies.

The customers, people from all walks of life, buy various merchandise at the discount store?

Description : The customers, people from all walks of life, buy various merchandise at the discount store?

Last Answer : people from all walks of life

Where could I find mobility scooters for customers to use in my store?

Description : Where could I find mobility scooters for customers to use in my store?

Last Answer : Shoprider makes these sorts of scooters for stores. You can buy them through their website http://shopridermobilityscooter.co.cc/. Mart Cart (http://www.martcart.com/) claims to have the number one ... also find them at http://www.dickensenterprises.com/amigo.html and http://www.amigoshopper.com/

. At the Melting Moments, an ice cream parlour, customers place their orders, watch their ice- cream sundaes being prepared, and then quickly eat the sundaes in the store before the ice cream melts. This is an example of a characteristic of services known as A. Inseparability B. Intangibility C. Heterogeneity D. Perishability E. Dependency

Description : . At the Melting Moments, an ice cream parlour, customers place their orders, watch their ice- cream sundaes being prepared, and then quickly eat the sundaes in the store before the ice cream ... known as A. Inseparability B. Intangibility C. Heterogeneity D. Perishability E. Dependency

Last Answer : D. Perishability

In the retail trade customer thresholds refer to the number of customers: A)required to make a profit. B)a store can hold comfortably at any one time C)a store can take for health and safety reasons.

Description : In the retail trade customer thresholds refer to the number of customers: A)required to make a profit. B)a store can hold comfortably at any one time C)a store can take for health and safety reasons.

Last Answer : A)required to make a profit.

Location is extremely important to a retailer because: A)suppliers charge more to service stores in certain trading areas. B)a desirable location appeals to consumers' emotions and encourages them to buy. C)location is the major determinant of store image. D)location determines the trading area from which the store must draw its customers. E)convenient location is an essential customer service.

Description : Location is extremely important to a retailer because: A)suppliers charge more to service stores in certain trading areas. B)a desirable location appeals to consumers' emotions and encourages them ... which the store must draw its customers. E)convenient location is an essential customer service.

Last Answer : D)location determines the trading area from which the store must draw its customers.

How will you make customers feel welcome in our store?

Description : How will you make customers feel welcome in our store?

Last Answer : Sub: Free Retail interview questions and answers Interview questions: How will you make customers feel welcome in our store? Answer tips/answer samples: In a retail store, there are many customers in ... attitude is the key to make the customers feel warm and welcomed when coming to your store.

Why do customers shop at this store?

Description : Why do customers shop at this store?

Last Answer : Sub: Free Retail interview questions and answers Interview questions: Why do customers shop at this store? Answer tips/answer samples: The common question you may encounter if you are applying ... a quality product at a reasonable margin with the dynamic and passionate help of the salesman.

What happens when you enter numbers in a Text data type field? -Technology

Description : What happens when you enter numbers in a Text data type field? -Technology

Last Answer : Numbers are accepted as a text value.

Write one example of data for which Memo data type is used. -Technology

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.

Define the AutoNumber data type in MS_ Access. -Technology

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.

If the data type of a field is set to Text, what will be its number range? -Technology

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.

When Memo data type is preferred over Text type for a field? -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.

When is AutoNumber data type preferred over Number data type? -Technology

Description : When is AutoNumber data type preferred over Number data type? -Technology

Last Answer : When you want to increment the number automatically as you add or delete the records. AutoNumber data type is preferred. Also, if the table does not have a primary key, then AutoNumber uniquely identifies the record.

Write one example of each field, for which you would use 1. Text data type -Technology

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.

Distinguish between Number and AutoNumber data type field. Give example of each. -Technology

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.

Which of the following is not a data type? (a) Picture/Graphic (b) Date/Time -Technology

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.

What data type should you choose for a zipcode field in a table? (a) Text (b) Number -Technology

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.

The default data type for a field is (a) Number (b) AutoNumber -Technology

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.

Single and double are the types of (a) Integer data type (b) Decimal numbers -Technology

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.

Which data type helps you to handle input that is in boolean format? -Technology

Description : Which data type helps you to handle input that is in boolean format? -Technology

Last Answer : (c) Yes/No will allow boolean value.

For storing lengthy information in a field ………….. data type is used. -Technology

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.