Oracle Oracle Database 1Z0-052 Questions & Answers

• Question 41:

  Your database is in shutdown state. What will happend if you issue next command: SQL> startup

  A. instance will started

  B. instance started and DB is mounted

  C. instance started, DB opened and finally mounted

  D. instance started, DB mounted and finally opened

  Correct Answer: D

• Question 42:

  Which two statements are true about standard database auditing? (Choose two.)

  A. DDL statements can be audited.

  B. Statements that refer to standalone procedure can be audited.

  C. Operations by the users logged on as SYSDBA cannot be audited.

  D. Only one audit record is ever created for a session per audited statement even though it is executed more than once.

  Correct Answer: AB

• Question 43:

  All the database users are presently connected to the database instance and working. The HR user has

  opened three database sessions and executed the following command in one of his sessions:

  SQL> UPDATE persons SET ccode='U031' WHERE ccode='U029';

  123 rows updated.

  SQL> DELETE FROM persons WHERE exp='Y';

  3 rows deleted.

  The SYS user opens a new session after HR executed the above commands.

  Which sessions can see the effect of the UPDATE and DELETE commands?

  A. All sessions of the HR user only

  B. All sessions of the HR user and the SYS user

  C. The session of the HR user that executed the commands

  D. All the sessions for which the database users have access privilege to the PERSONS table

  Correct Answer: C

• Question 44:

  View the Exhibit and examine the attributes of an undo tablespace. In an OLTP system, the user SCOTT has started a query on a large table in the peak transactional hour that performs bulk inserts. The query runs for more than 15 minutes and then SCOTT receives the following error:

  ORA-01555: snapshot too old

  What could be the reason for this error? Exhibit:

  

  A. The query is unable to get a read-consistent image.

  B. There is not enough space in Flash Recovery Area.

  C. There is not enough free space in the flashback archive.

  D. The query is unable to place data blocks in undo tablespace.

  Correct Answer: A

• Question 45:

  The user HR receives the following error while inserting data into the TTK table:

  ERROR at line 1:

  ORA-01653: unable to extend table HR.TTK by 128 in tablespace SMD

  Upon investigation, you find that SMD is a small file tablespace.

  Which three action would allow the user to insert data? (Choose three.)

  A. Add a data file to the SMD tablespace.

  B. Add a data file to the temporary tablespace associated with the user HR.

  C. Resize the data file associated with the SMD tablespace to make it larger.

  D. Alter the data file associated with the SMD tablespace to grow automatically.

  E. Change the segment space management for the SMD tablespace to automatic.

  Correct Answer: ACD

• Question 46:

  You have two database servers SEMP and SACCT. The database in the SEMP server maintains the employee information and the database in the SACCT server maintains the accounts payable information. The employees submit the expense reports to the accounts payable department. A user of the accounts payable database wants to extract the employee information from the database in the SEMP server for crossverification.

  Which schema object enables the user to access the information from the remote database?

  A. Cluster

  B. Database link

  C. Mapping table

  D. Materialized view

  Correct Answer: B

• Question 47:

  In a new installation of Oracle Database 11g, you perform these activities:

  1.

  Organize software and data on different subdirectories to avoid poor performance.

  2.

  Use consistent naming conventions for database files.

  3.

  Separate administrative information pertaining to the database in different directories. Which option corresponds to the type of activities you performed?

  A. Oracle Managed Files

  B. Oracle Grid Architecture

  C. Optimal Flexible Architecture

  D. Oracle database architecture

  E. Automatic Storage Management

  Correct Answer: C

• Question 48:

  You configured the Flash Recovery Area (FRA) for your database. The database instance is running in ARCHIVELOG mode. The default location for the archived redo log files is the Flash Recovery Area. Which two files are removed automatically if the space is required in the FRA as per the retention policy? (Choose two.)

  A. Flashback log files

  B. Backups that have become obsolete

  C. User managed backups of the data files and control files

  D. Archived redo log files that have multiple copies in a different archive location and not backed up

  Correct Answer: AB

• Question 49:

  User SCOTT executes the following command on the EMP table but has not issued COMMIT,

  ROLLBACK, or any data definition language (DDL) command:

  SQL> SELECT ename FROM emp

  2 WHERE job='CLERK' FOR UPDATE OF empno;

  SCOTT has opened another session to work with the database instance.

  Which three operations would wait when issued in SCOTT's second session? (Choose three.)

  A. LOCK TABLE emp IN SHARE MODE;

  B. LOCK TABLE emp IN EXCLUSIVE MODE;

  C. UPDATE emp SET sal=sal*1.2 WHERE job='MANAGER'

  D. INSERT INTO emp(empno,ename) VALUES (1289,'Harry');

  E. SELECT ename FROM emp WHERE job='CLERK' FOR UPDATE OF empno;

  Correct Answer: ABE

• Question 50:

  Which three statements are true about logical structures of the Oracle database? (Choose three.)

  A. Each segment contains one or more extents.

  B. Multiple tablespaces can share a single data file.

  C. A data block is the smallest unit of input/output (I/O) in data files.

  D. It is possible to have tablespaces of different block sizes in a database.

  E. Each data block in the database always corresponds to one operating system block.

  Correct Answer: ACD