Q1. Identify the two situations in which the alert log file is updated with details. (Choose two.)A. Running a query on a table returns "ORA-600: Internal Error"B. Inserting a value in a table returns "ORA-01722: Invalid Number"C. Creating a table returns "ORA-00955: name is already used by an existing object'D. Inserting a value in a table returns "ORA-00001: unique constraint…
Q1. You receive complaints from users regarding the high waiting time for their transactions. On investigation, you find that some users are not committing their transactions though they are not performing any activity for a long time. As a result, SQL statements need to wait for rowlevel locks.Which two actions could you take to prevent this locking problem in the…
Q1. You configured the Flash Recovery Area for your database. The database instance has been started in ARCHIVELOG mode and the LOG_ARCHIVE_DEST_1 parameter is not set.What will be the implications on the archiving and the location of archive redo log files?A. Archiving will be disabled because the destination for the redo log files is missingB. The database instance will shut…
Q1. User A executes the following command to drop a large table in your database:SQL> DROP TABLE trans;While the drop table operation is in progress; user B executes the following command on the same table;SQL> DELETE FROM trans WHERE tr_type='SL'Which statement is true regarding the DELETE command?A. It fails to delete the records because the records are locked in the…
Q1. Which statements listed below describe the data dictionary views?1. These are stored in the SYSTEM tablespace2. These are the based on the virtual tables3. These are owned by the SYS user4. These can be queried by a normal user only if O7_DICTIONARY_ACCESSIBLILITY parameter is set to TRUE5. The V$FIXED_TABLE view can be queried to list the names of these…
Q1. View the Exhibits and examine lock waits. Users HR and SH complain that their transactions on one of the application tables, EMP, are waiting for response.Which action would you take to release the lock and enable users HR and SH to continue with their transactions?07 (exhibit):A. Kill the session of the user SCOTT with session ID118.B. Issue manual checkpoint…
Q1. Examine the commands executed in the following sequence:Which statement is true about the above commands?A. The commands execute successfully.B. Command 6 produces an error because of circular role grant.C. Command 5 produces an error because a role cannot be granted to another role.D. Command 3 produces an error because the MGRROLE role already contains system privileges. The table created…
Q1. Your database is configured in shared server mode. However, your senior DBA asks you to modify the value of the PRIVATE_SGA limit in the profile of the users.What could be the reason for this?A. To limit the User Global Area (UGA) memory allocated to a session from the SGAB. To limit the amount of memory to be used for…
Q1. Examine the commands executed in the following sequence:Which statement is true about the above commands?A. The commands execute successfully.B. Command 6 produces an error because of circular role grant.C. Command 5 produces an error because a role cannot be granted to another role.D. Command 3 produces an error because the MGRROLE role already contains system privileges. The table created…
Q1. Your database instance is running with full workload after database creation. You have decided to use a fixedsize undo tablespace. You want to use the undo Advisor to estimate the capacity of the undo tablespace.Which two factors must you consider before using the Undo Advisor to estimate the capacity of the undo tablespace? (Choose two.)A. The retention period to…
Q1. You are in the middle of a transaction updating a very important table. The machine on which a database was running reboots because of power outage. This caused a database instance failure.Which statement is true in this situation?A. The online redo log files and archived redo log files are required to accomplish the recoveryB. The uncommitted transaction will be…
Q1. Some non-DBA users in your database have been granted ANY TABLE system privileges and they are able to access data dictionary base tables. You decide to restrict their access to data dictionary objects. Which method would you adopt to achieve this objective?A. Revoke the RESOURCE role from the users.B. Set the value of the OS_ROLES parameter to TRUE.C. Use…
Q1. Which two kinds of failures make the Data Recovery Advisor (DRA) generate a manual checklist? (Choose two.)A. Failure when no standby database is configuredB. Failure because a data file is renamed accidentallyC. Failure that requires no archive logs to be applied for recoveryD. Failure due to loss of connectivity-for example, an unplugged disk cableView AnswerAnswer: BDQ2. You are managing…
Q1. View the Exhibit and examine the setting for a table.Which statement is true about the PCTFREE setting for the table?A. It sets the minimum percentage of a data block to be reserved to contain chained rows from other blocks.B. It sets the minimum percentage of a data block to be reserved as free space before the server prevents inserts…
Q1. Which two statements describe good practices for an application developer to reduce locking conflicts in Oracle database? (Choose two.)A. Avoid coding unnecessary longrunning transactions.B. Allow the database to handle locks in default locking mode.C. Always explicitly code the locks as per the requirement of the application.D. Allow escalation of row locks to block locks if too many row locks…
Q1. Your database is open and the LISTENER listener is running. The new DBA of the system stops the listener by using the command: LSNRCTL> STOPWhat happens to the sessions that are presently connected to the database instance?A. The sessions are able to perform only queriesB. The sessions are not affected and continue to function normallyC. The sessions are terminated…
Q1. You perform differential incremental level 1 backups of your database on each working day and level 0 backup on Sunday to tape:Which two statements are true about differential incremental backups? (Choose two.)A. The backup performed on Sundays contains all the blocks that have ever been used in the databaseB. The backup performed on Sundays contains all the blocks that…
Q1. Your database instance is started using the server parameter file (SPFILE). You executed acommand to change the value of the LOG_BUFFER initialization parameter:ALTER SYSTEM SET LOG_BUFFER=32M SCOPE=BOTH;What would be the outcome of this command?A. The command succeeds only if Automatic Memory Management is not enabled.B. The command succeeds, but you need to restart the database for changes to take…
Q1. View the Exhibit and examine the user information.The user has been granted CONNECT and RESOURCE roles and no individual system privileges.The SL_REP user executes this command to create a table:SQL> CREATE TABLE orders (oid number(6),odate date,ccode number(4),oamt number(10,2)) TABLESPACE purchase_space;The PURCHASE_SPACE tablespace already exists in the database.Which statement describes the effect of the command?Exhibit:A. The command executes successfully and…