Question: in sql what data type is best to use for the attribute state, where state values consists of exactly 2 characters varchar ( 2 )

in sql what data type is best to use for the attribute state, where state values consists of exactly 2 characters varchar(2) char(2) text(2) text

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Q:

1. Consider the AIRLINE relational database schema and some sample data given in APPENDIX A. The schema describes a database for airline flight information. Each flight is identified by a...

Q:

Please Answer the following 1. Consider the AIRLINE relational database schema and some sample data given in APPENDIX A. The schema describes a database for airline flight information. Each flight is...

Q:

1411116 - Programming I Assignment #3 Due Date: November 30, 2016 Submission Instructions: Submit your assignment on the blackboard link, corresponding to your Section: Please follow the following...

Q:

INTRODUCTION The purpose of this assignment is to gain more SQL experience using Oracle. In particular, you will get practice creating tables, inserting data into tables, and performing updates and...

Q:

Briefly describe ASCII and Unicode and draw attention to any relationship between them. [3 marks] (b) Briefly explain what a Reader is in the context of reading characters from data. [3 marks] A...

Q:

Before starting with part 1, we will introduce two functions These two member functions are available in istream: setstate(); peek(); setstate() manually sets the status of the istream object to the...

Q:

Write an SQL statement to list ItemID and ItemDescription for all items that cost $1000 or more. Write an SQL statement to list ItemNumber and Description for all items that cost $1000 or more and...

Q:

TASK 1: MAKE UPDATES AND CORRECTIONS Based on Part 1 Comments-20 Points: 1. Update the data model: Make any required changes to your design based on the comments provided for Part 1 of the project....

Q:

Complete the following GC functions mmInit, mmAllocate, mmCollect, mmMark, mmAssoc. header file: cs3723p1.h #define TRUE 1 #define FALSE 0 #define MAX_KEY_SIZE 10 // Maximum size of a key for Hash...

Q:

#define _CRT_SECURE_NO_WARNINGS 1 #include #include #include #include #include "cs3723p1.h" #define MAX_TOKEN_SIZE 50 // largest token size for tokenizer #define MAX_BUFFER_SZ 100 // size of input...

Q:

In Table 17.3, suppose that the payoff if both firms enter is positive, 5 rather than 5, while the other payoffs remain the same. Now, what is the effect of a subsidy of 10 to Novartis?

Q:

The real options alternative allows for flexibility and the delay of the investment for 1 year. In this case, if we complete a pilot project we will be better able to evaluate ERP implementation...

Q:

9 : 0 3 7 5 6 ! 9 2 Return to Reading 1 6 5 1 7 2 % Corporations purchase and hold their own stock, known as treasury stock, for several reasons. Identify which of the following is not a reason that...

Q:

Select all that apply The amount of cash dividends a company can pay are limited by the amount of the company's q , . retained earnings preferred stock common stock cash

Q:

Explain how affirmative and negative majority votes can sometimes lead to inefficient allocations of resources to public goods. Is this problem likely to be greater under a benefits-received or under...

Q:

KEY QUESTION Place an M beside the items in the following list that describe a moral hazard problem and an A beside those that describe an adverse selection problem: a. A person with a terminal...

Q:

KEY QUESTION How does the problem of limited and bundled choice in the public sector relate to economic efficiency? Why are public bureaucracies alleged to be less efficient than private enterprises?