Blog Gue

1.          The table that contains the Primary Key in a Foreign Key Constraint is known as:                Mark for Review (1) Points                 Child Table                 Mother and Father Table                 Parent Table (*)                 Detail Table Section 15                 (Answer all questions in this section) 2.          What is one advantage of using views?  Mark for Review (1) Points                 To provide restricted data access (*)                 To provide data dependence                 To be able to store the same data in more than o...

1. Evaluate this SELECT statement: SELECT MIN(hire_date), department_id FROM employees GROUP BY department_id; Which values are displayed?  Mark for Review (1) Points                 The latest hire date in the EMPLOYEES table                 The earliest hire date in the EMPLOYEES table                 The earliest hire date in each department (*)                 The hire dates in the EMPLOYEES table that contain NULL values 44.          Which statement about the GROUP BY clause is true?    Mark for Review (1) Points                 By default, rows are not sorted when a GROUP BY clause is used.                 To exclude rows before dividing them into groups using the GROUP BY clause, you s...

1.     If a database crashes, all uncommitted changes are automatically rolled back. True or False? Mark for Review (1) Points             True (*)             False 10.       A transaction makes several successive changes to a table. If required, you want to be able to rollback the later changes while keeping the earlier changes. What must you include in your code to do this?       Mark for Review (1) Points             An update statement             A savepoint (*)             A database link             An object privilege             A sequence 11.       You need not worry about controlling your transactions. Oracle does it all for you. True or False?    Mark for Review (1) Points    ...

1.         The following table shows some of the output from one of the data dictionary views. Which view is being queried? USERNAME    PRIVILEGE     ADMIN_OPTION USCA_ORACLE_SQL01_S08            CREATE          VIEW NO USCA_ORACLE_SQL01_S08            CREATE          TABLE NO USCA_ORACLE_SQL01_S08            CREATE          SYNONYM NO USCA_ORACLE_SQL01_S08            CREATE          TRIGGER NO USCA_ORACLE_SQL01_S08            CREATE          SEQUENCE NO USCA_ORACLE_SQL01_S08            CREATE          DATABASE NO  Mark for Review (1) Points             role_sys_privs (lists s...