Question
The value in the manager_id column of the EMPLOYEES table must match a value in the employee_id column in the EMPLOYEES table. A table must
The value in the manager_id column of the EMPLOYEES table must match a value in the employee_id column in the EMPLOYEES table.
A table must have at least one candidate key, as well as its primary key. True or False?
A table must have a primary key. True or False?
If a primary key is a set of columns then one column must be null. True or False?
Attributes become tables in a database. True or False?
In a physical data model, an attribute becomes a _____________.
The transformation from an ER diagram to a physical design involves changing terminology. Primary Unique Identifiers in the ER diagram become __________ and relationships become ____________.
The Oracle Database can implement a many to many relationship. You simply create two foreign keys between the two tables. True or False?
Many to many relationships are implemented via a structure called a: ________________
An "Arc Implementation" can be done just like any other Relationship - you simply add the required Foreign Keys. True or False?
What command will return data from the database to you?
The DESCRIBE command returns all rows from a table. True or False?
What command can be used to create a new row in a table in the database?
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started