Question

what determines the kind of data that can be stored in a column of a table?...

what determines the kind of data that can be stored in a column of a table?

a. the default value that is assigned to the column

b. tthe data type that is assigned to the column

c. the relationship between the column and the primary value of the key

d. whether the column can contain a null value

Homework Answers

Answer #1

Answer : Correct Option is Option(b) ie. the data type that is assigned to the column.

Explanation :

When a column in a table is defined, it is given a data type , that determines what kind of data it can store.

Hence,

Option(a) is Incorrect. Default value will not determine the kind of data that is assigned to the column.

Option(b) is Correct. The data type of the column will determine the kind of data that can be stored in column in table.

Option(c) is Incorrect. The relationship between the column and the primary value of the key will not determine the kind of data that a column will store in a table.

Option(d) is Incorrect. Whether column contain a null value , but it will not determine the kind of data that a column will store in a table.

Hence,

Option(b) is Correct. ie. the data type that is assigned to the column.

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
1. Suppose StudentID is the primary key of one table (e.g., the Students table) and the...
1. Suppose StudentID is the primary key of one table (e.g., the Students table) and the foreign key of another table (e.g., the Top10DesiredJobs table). If you can’t enforce the referential integrity relationship between these two tables, what might be the cause? Select one: a. The values of the primary key column are referenced by the values of the foreign key column. b. The foreign key contains duplicate data. c. The foreign key column contains values that do not exist...
Suppose TeacherID is the primary key of one table (e.g., the Teachers table) and the foreign...
Suppose TeacherID is the primary key of one table (e.g., the Teachers table) and the foreign key of another table (e.g., the TopPayingJobs table). If you can’t enforce the referential integrity relationship between these two tables, what might be the cause? a. The values of the primary key column are referenced by the values of the foreign key column. b. The foreign key contains duplicate data. c. The foreign key column contains values that do not exist in the primary...
1. Which of the following is NOT a type of data anomaly? a. Insertion b. Transformation...
1. Which of the following is NOT a type of data anomaly? a. Insertion b. Transformation c. Deletion d. Modification 2. Functional dependency has the following characteristics EXCEPT a. Attribute Y is functionally dependent upon attribute X, if the value of X uniquely determines the value of Y b. It's a constraint between two tables c. It's a constraint between two attributes (columns) d. Represented as Determinant(s) -> Dependent(s) 3. The definition of a partial dependency is a.One or more...
When a 1:M relationship exists between two tables, the ‘1’ side of the relationship is the...
When a 1:M relationship exists between two tables, the ‘1’ side of the relationship is the table where the common field is ________ Select one: a. the same data type as the ‘M’ side field b. the primary key c. unique within the table d. all of these e. none of these
Create 2 stored procedures: sp_AddNewUser and sp_AddNewRole. Use the ManyToMany script as your base table structures....
Create 2 stored procedures: sp_AddNewUser and sp_AddNewRole. Use the ManyToMany script as your base table structures. The stored procedure should accept the parameters needed to input the data for each table. NOTE: You do not need to input the UserID or RoleID. These are surrogate keys and the system automatically inserts them when you insert a row in the tables.   On execution, the stored procedure should check the database to see if the user exists, if so, return a message...
The following question is based on this table named Customer Column Name     Type              CustId          Integer P
The following question is based on this table named Customer Column Name     Type              CustId          Integer Primary Key, CustName        Varchar2(40), Balance         Number Gender          Varchar2(1) Write the Stored Function named GetCustDetails.       The function: Has one parameter named pCustName. Must return a text value Must search for a customer row that has a CustName value equal to pCustName If a match is found return the customer's name and balance in the following format: Customer Name: Fred   Gender M   Balance 20000 If a...
1.Consider the following (normalized) relational model (primary keys are underlined, foreign keys are in italics). EMPLOYEE(SSN,...
1.Consider the following (normalized) relational model (primary keys are underlined, foreign keys are in italics). EMPLOYEE(SSN, ENAME, EADDRESS, SEX, DATE_OF_BIRTH, SUPERVISOR, DNR) S U P E R V I S O R : foreign key refers to SSN in EMPLOYEE, NULL value allowed D N R : foreign key refers to DNR in DEPARTMENT, NULL value not allowed DEPARTMENT(DNR, DNAME, DLOCATION, MGNR) MGNR: foreign key refers to SSN in EMPLOYEE, NULL value not allowed PROJECT(PNR, PNAME, PDURATION, DNR) DNR: foreign...
This is for my Accounting Information System Assignment A data model which is created mainly for...
This is for my Accounting Information System Assignment A data model which is created mainly for business users and contain a minimum of technical details is referred to as ..........? A. A physical Model B. A logical Model C. A Conceptual Model D. An abbreviated Model An Attribute that is used as a linkage from records in one table to a record in another table i specified as the .........? A. Pointer Field B. Foreign Key C. Secondary Key D....
A scientist has new kind of tomatoes (type 2) and wants to see if it grows...
A scientist has new kind of tomatoes (type 2) and wants to see if it grows more reliably than a current kind (type 1). The scientist plants 49 tomatoes of each kind, later results that 43 of the type 1 have grown while 41 of the type 2 have grown. α = .05 (a) What are the null and alternative hypotheses? (b) What is the test statistic, with 2 decimal places? (c) What is the critical value or p value?...
What techniques can be used to analyse energy data? Examine the following table and determine the...
What techniques can be used to analyse energy data? Examine the following table and determine the relationship between production and energy. What techniques can be used to analyse energy data? Examine the following table and determine the relationship between production and energy. Period Driver Energy Weeks Tonnes kWh 1 150 140 726 2 80 103 223 3 60     90 764 4 50     87 567 5 170 146 600 6 180 154 773 7 120 121 575 8 40...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT