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
Homework Answers
Add Answer to:
To drop a key column in an existing table (with existing data)
you must first remove...
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...
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...
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...
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
Most questions answered within 3 hours.
-
An infinite sheet of charge that has a surface charge density of
39 nC/m2 lies in...
asked 37 minutes ago -
After watching the lectures I am still having a hard time
understanding these equations.
1. The...
asked 1 hour ago -
Testing:
H0:μ=56.9
H1:μ<56.9
Your sample consists of 23 subjects, with a mean of 56.3 and
standard...
asked 1 hour ago -
straight wire, labeled as Wire A, lies horizontally on a
tabletop and is oriented to run...
asked 1 hour ago -
For a Chi-Squared Goodness of Fit Test about a uniform
distribution, complete the table.
Round to...
asked 2 hours ago -
Milk of magnesia is only slightly soluble in water. Kc for the
reaction Mg(OHs)(s)>Mg2+(a) + 2OH-1(aq)...
asked 2 hours ago -
Excel's HYPGEOM.DIST function can be used to compute _____.
a. both hypergeometric probabilities and cumulative
hypergeometric...
asked 2 hours ago -
The rocket used for the human lunar missions was the Saturn V
rocket. At liftoff the...
asked 2 hours ago -
1. The East Street Bagel Shop has a weekly demand for 3,500
bagels, which they make...
asked 2 hours ago -
paraphrasing each paragraph
“Where two or more persons knowingly act together unlawfully,
the act of each...
asked 2 hours ago -
The lateral line system in fish is contained which of the
following?
chemoreceptors
photoreceptors
mechanoreceptors
odor...
asked 2 hours ago -
Find the y-intercept of y =-5 x. The y-intercept of y equals
negative 5 x is______...
asked 2 hours ago