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 one place 28.          Which of the following statements is a valid reason for using a view?      Mark for Review (1) Points                 Views allow access to the data because the view displays all of the columns from the table.                 Views are used when you only want to restrict DML operations using a WITH CHECK OPTION.                 Views are not valid unless you have more than one user.

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 should use a WHERE clause. (*)                 You must use the HAVING clause with the GROUP BY clause.                 You can use a column alias in a GROUP BY clause. Section 10                 (Answer all questions in this section) 45.          Which of the following be

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             True             False (*) 12.       If Oracle crashes, your changes are automatically rolled back. True or False? Mark for Review (1) Points             True (*)             False 13.       Which SQL statement is used to remove all the changes made by an uncommitted

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 system privileges granted to roles)             user_sys_privs (lists system privileges granted to the user) (*)             role_tab_privs (lists table privileges granted to roles)             user_tab_privs_recd (lists object privileges granted to the user) 4.         What system privilege must be held in order to login to an Oracle database?  Mark for Review (1) Points             CREATE LOGI