Which two operations wait when executed in hr s

This preview shows page 100 - 102 out of 152 pages.

Which two operations wait when executed in HR ’s second session? (Choose two.) A. LOCK TABLE employees IN EXCLUSIVE MODE; B. INSERT INTO employees(empno,ename) VALUES (1289, ‘Dick’); C. SELECT job FROM employees WHERE job=’CLERK’ FOR UPDATE OF empno; D. SELECT empno,ename FROM employees WHERE job=’CLERK’; E. INSERT INTO employees(empno,ename,job) VALUES (2001,’Harry’,’CLERK); Correct Answer: AC Section: (none) Explanation Explanation/Reference: QUESTION 193 In your Oracle 12c database, you plan to execute the command: SQL> CREATE TABLESPACE tbs1 DATAFILE ‘/u02/oracle/data/tbs01.dbf’ SIZE 50M; The u02 file system has 1 GB of free space available. What is the outcome? A. It creates a locally managed tablespace with manual segment space management enabled. B. It raises an error because extent management is not specified. C. It creates a locally managed tablespace with automatic segment space management enabled. D. It creates a dictionary-managed tablespace with manual segment space management enabled. Correct Answer: C Section: (none) Explanation Explanation/Reference: References: QUESTION 194 In your database, USERS is the default permanent tablespace. Examine the commands and their outcome: You plan to execute the commands: Which two statements are true? (Choose two.)
Image of page 100
A. The MYTAB table is created in the SYSTEM tablespace but no rows can be inserted into the table by USER02 . B. The MYTAB table is created in the SYSTEM tablespace and rows can be inserted into the table by USER02 . C. The MYTAB table is created in the USERS tablespace but no rows can be inserted into the table by USER02. D. The CREATE TABLE statement generates an error because the SYSDBA privilege does not provide any space quota on the SYSTEM tablespace by default. E. The MYTAB table is owned by the SYS user. Correct Answer: BE Section: (none) Explanation Explanation/Reference: QUESTION 195 You use multiple temporary tables frequently in your database. Which two are benefits of configuring temporary undo? (Choose two.) A. Performance improves because less redo is written to the redo log. B. Temporary undo reduces the amount of undo stored in undo tablespaces. C. Performance improves because data manipulation language (DML) operations performed on temporary tables do not use the buffer cache. D. Performance improves because no redo and undo are generated for the temporary tables. Correct Answer: AB Section: (none) Explanation Explanation/Reference: QUESTION 196 Which three statements are true about the Pre-Upgrade Information Tool? (Choose three.) A. It generates a script to recompile invalid objects post-upgrade. B. The preupgrade_fixups.sql script is created to list and describe issues in the source database. C. A log file, preupgrade.log , is created that contains the output of the Pre-Upgrade Information tool.
Image of page 101
Image of page 102

You've reached the end of your free preview.

Want to read all 152 pages?

  • Fall '19
  • Oracle Database

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern

Stuck? We have tutors online 24/7 who can help you get unstuck.
A+ icon
Ask Expert Tutors You can ask You can ask You can ask (will expire )
Answers in as fast as 15 minutes
A+ icon
Ask Expert Tutors