The transformation from an ER diagram to a physical design involves changing ter
ID: 3726986 • Letter: T
Question
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?
The SQL statement ALTER TABLE EMPLOYEES DELETE COLUMN SALARY is a valid statement. True or False?
Systems are always just rolled out as soon as the programming phase is finished. No further work is required once the development is finished. True or False?
System Documentation is developed right at the end once the system has gone live and users have been using it for a little while. You are more likely to get it correct that way. True or False?
Which SQL statement will return an error?
When you use the SELECT clause to list one or two columns only from a table and no WHERE clause, which SQL capability is used?
Which statement best describes how arithmetic expressions are handled? (4) Division and multiplication operations are handled before subtraction and addition operations.
Explanation / Answer
1).primary keys, foreign keys
2).False
3).intersection table
It indicates being two one-tomany relationships that the hidden DBMS is outlined to manage.
4).False
5).SELECT
It also indicates the name of stored procedure (or) a query to obtain all rows in a table by using the asrick symblo i.e *
Example : SELECT *FROM TABLE
6).False
It simply gives the column definitions for a given table.
7).INSERT
which you can enter a new row in a table or existing table.
8).False
To delete salary column follow the syntax as below
ALTER SALARY FROM EMPLOEE.EMPLOYEESALARY WHRE ID=1002;
DELETE SALARY FROM EMPLOYEE.EMPLOYEESALARY WHERE ID=1003;
9).False
10).False
12).Projection only capability is used.
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.