Question

To drop a key column in an existing table (with existing data) you must first remove...

To drop a key column in an existing table (with existing data) you must first remove the constraints that apply to that key

True

False

0 0
Add a comment Improve this question Transcribed image text
Answer #1

True

Add a comment
Know the answer?
Add Answer to:
To drop a key column in an existing table (with existing data) you must first remove...
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. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • 7- The values of a Foreign Key column in a table can be referenced to any...

    7- The values of a Foreign Key column in a table can be referenced to any column in a second table (Primary key or non-primary key). TRUE FALSE) 8- Using WITH GRANT OPTION clause will result in granting the user the authority to pass ONLY his/her privileges to other users. TRUE FALSE ) 9. To change the characteristics of a column, use the ALTER TABLE command with a SET clause. TRUE FALSE) 10- When inserting new values into a table...

  • The employee is table, the best candidate for primary key is Select one: a. Department ID...

    The employee is table, the best candidate for primary key is Select one: a. Department ID b. Employee hiredate c. Employee ID d. Employee salary Question 2 A primary key can be composed of more than one attribute. Select one: True False Question 3 A foreign key allows you to join two tables. Select one: True False Question 4 Given two tables, department (dept_id, dept_location, dept_name) and EMPLOYEE(emp_id, emp_name, emp_dept_id, emp_name, emp_salary), which attribute (column) is the foreign key? Select...

  • 16. The primary key is selected from the: Group of answer choices composite keys. foreign keys....

    16. The primary key is selected from the: Group of answer choices composite keys. foreign keys. candidate keys. surrogate keys. 17. "Delete Table" statement is used to remove a table definition and all the data, indexes, triggers, constraints and permission specifications for that table. Group of answer choices True False 18. Which of the following commands always affect one row at a time when it runs? Group of answer choices Drop Insert Delete Update 19. Data stored as an image...

  • A foreign key value must exist in the table where it is a primary key. True?...

    A foreign key value must exist in the table where it is a primary key. True? False?

  • You are designing a table for employee data of a company. You have a requirement to...

    You are designing a table for employee data of a company. You have a requirement to identify if an employee is a United States citizen or not. You have designed a table called EMPLOYEE to store information related to each employee and you have a column called US CITIZEN INDICATOR to store if an employee is a US citizen or not. You only want to store values "Y" or "N" in this column. From the following options, what is the...

  • when you establish a relationship between a primary and foriegn key, the dbms can enforce integrity...

    when you establish a relationship between a primary and foriegn key, the dbms can enforce integrity constraints? true or false what database key links one table to another? what data base function allows you to define the data your database is storing?

  • rider_student Column Data Type Description student_id integer the primary key first_name varchar(25) student first name last_name...

    rider_student Column Data Type Description student_id integer the primary key first_name varchar(25) student first name last_name varchar(25) student last name major_id integer the ID of the student's major; a foreign key for the major_id in the rider_major table rider_major Column Data Type Description major_id integer the primary key major_name varchar(50) student first name major_description varchar(100) student last name Use the Tables above to answer the questions. Questions: 1. Write a SQL statement to add a student record to the rider_student...

  • If the following appeared in a CREATE TABLE statement FOREIGN KEY (PersonID) REFERENCES Persons(PersonID) true false...

    If the following appeared in a CREATE TABLE statement FOREIGN KEY (PersonID) REFERENCES Persons(PersonID) true false - The jable bong crealed must have a column named PeolD true false -The CREATE TABLEWill fail becaue2 tables can ut have a field with the named PersonlD true false -personlD in thi table must be UNIQUE true false- There must be a diftorent table named Pasons Deviousl reated Record Answer

  • To be in the third normal form, Hint: In order to in 3NF you must first...

    To be in the third normal form, Hint: In order to in 3NF you must first have attained 1NF and 2NF so all of the above is the correct answer. In the database design world the saying is that to be completely normalized the data be represented "by the key, the whole key, and nothing but the key so help me Codd". Ted Codd was the person behind the development of the relational theory back in the 1960s and 70s....

  • Lesson 10Create the DEPARTMENT tables based on the following: Column Name   ID      Name Data Type     Number...

    Lesson 10Create the DEPARTMENT tables based on the following: Column Name   ID      Name Data Type     Number Varchar2 Length        7      25 Populate the DEPARTMENT table with data from the DEPT table. Include only columns that you need. Create the EMPLOYEE table based on the following table chart: Column Name    ID      LAST_NAME     FIRST_NAME     DEPT_ID Data Type      Number Varchar2      Varchar2       Number Length         7       25            25             7 Modify the EMPLOYEE table to allow for longer employee last names. Confirm your modification. Confirm that both the...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT