In the Oracle DBMS, primary and unique keys generally have indexes created automatically, but you might want to create an index on a foreign key as well. True False

SQL and Command Injection can be avoided by sanitizing input sometimes. True False

Please help me as this is in regards to Oracle 12 database Question 7  IN SELECT statement you always add SELECT , FROM and WHERE keywords because without WHERE condition you wouldn't know which data you search Question 7 options:   True   False Question 8  What will the following statement return after execution? SELECT employeenumber, lastname, email FROM products ORDER BY employeenumber DESC and email; Question 8 options:   The results are sorted first numerically and then alphabetically.   The results are sorted first numerically from high to low and then alphabetically.   The results are sorted first alphabetically and then numerically.   The query returns an error. Question 9  Which clause would you use in a SELECT statement to limit the display to those employees whose salary is greater than 5000? Question 9 options:   ORDER BY SALARY > 5000   GROUP BY SALARY > 5000   WITH SALARY > 5000   WHERE SALARY > 5000

What function does the data dictionary serve inside the DBLC procedure?

Observe the HOMETOWN REALESTATE database: SELLER SellerID SellerName RealtorID S111 Paul R1 S222 Carly R1 S333 Ana R2 $444 Charlotte R2 S555 Aidan R3 Có66 Eric R1 C777 Christina R1 REALTOR RealtorID RealtorName R1 Claire R2 Kate R3 Cliff R4 William If a DBMS enforces a DELETE RESTRICT option on the referential integrity constraint between SELLER and REALTOR in the HOMETOWN REALESTATE database, what will be the outcome after a user tries to delete the last record (R4, William) from REALTOR? O SELLER will have 7 records, REALTOR wilIl have 4 records O SELLER will have 6 records, REALTOR will have 3 records O SELLER will have 7 records, REALTOR will have 3 records O SELLER will have 6 records, REALTOR wilIl have 4 records O SELLER will have 3 records, REALTOR willI have 3 records

How important is the data dictionary in the whole DBLC procedure?

When you use a transaction, the database tables/views/other resources used in the transaction are locked until the transaction is either committed or rolled back in order to ensure all modifications are either ALL made, or none of them made. Usually databases also have options on the level of locking used such as no one can read or make changes to those resources when locked, or users can’t make changes to the resources but they can read data in the tables/views/read access to resources.  Pick a potential problem with database locks on tables/views/resources and one popular way database administrators and / or database users use to address that problem?

Why is it necessary to use a foreign key to ensure the database's integrity? Could you give an example of why this is so importa