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.…

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…

Which of these is true about undo tablespace? A. Undo tablespace is a temporary tablespace B. Undo tablespace has only one datafile C. Undotablespace has a datafile which is reused in cyclic manner

Your database is functional with a peak load for the last one hour. You want to preserve the performance statistics collected during this period to be used for comparison when you analyze the performance of the database in the future.…

View the Exhibit. You are creating an additional database by using the Database Configuration Assistant (DBCA). You opted to create a General Purpose database and during the database creation realize that the Block Size field is not enabled. What could…

Which two statements are true regarding the Oracle Data Pump export and import operations? (Choose two.) A. You cannot export data from a remote database. B. You can rename tables during an import operation. C. You can overwrite existing dump…

Which two statements are true about checkpointing? (Choose two.) A. The checkpoint frequency decreases with the smaller redo log file size. B. It ensures that all committed data is written to the data files during normal shutdown. C. The frequent…

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.…

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…

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…