Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
5 Cards in this Set
- Front
- Back
|
Question: 1 Examine the parameters foryour database instance: NAME TYPE VALUE undo_management string AUTOundo_retention integer 12 00undo_tablespace string UNDOTBS1You execute the following command:SQL> ALTER TABLESPACE undotbs1 RETENTION NOGUARANTEE;Whichstatement is true in this scenario? A. Undo data is written toflashback logs after 1200 seconds. B. Inactive undo data isretained for 1200 seconds even if subsequent transactions fail due to lack ofspace in the undo tablespace. C. You can perform a FlashbackDatabase operation only within the duration of 1200 seconds. D. An attempt is made to keepinactive undo for 1200 seconds but transactions may overwrite the undo beforethat time has elapsed. |
Answer: A Undo data is written to flashback logs after 1200 seconds. |
|
|
Question: 2 A user establishes aconnection to a database instance by using an Oracle Net connection. You wantto ensure the following:1. The user account must be locked after fiveunsuccessful login attempts.2. Data read per session must be limited for theuser.3- The user cannot have morethan three simultaneous sessions.4. The user must have amaximum of 10 minutes session idle time before being logged off automatically.Howwould you accomplish this? A. by granting a secure application role to the user B. by implementing Database Resource Manager C. by using Oracle Label Security options D. by assigning a profile to the user |
Answer: D by assigning a profile to the user |
|
|
Question: 3 As a user of the ORCLdatabase, you establish a database link to the remote HQ database such that allusers in the ORCL database may access tables only from the SCOTT schema in theHQ database. SCOTT’s password is TIGER. The service mane “HQ” is used toconnect to the remote HQ database.Whichcommand would you execute to create the database link? A. CREATE DATABASE LINK HQ USING 'HQ'; B.CREATE DATABASE LINK HQ CONNECT TOCXJRRENT_USER USING HQ' C. CREATE PUBLIC DATABASE LINK HQ CONNECT TO scottIDENTIFIED BY tiger USING 'HQ'; D. CREATE DATABASE LINK HQ CONNECT TO scott IDENTIFIED BY tiger USING 'HQ' |
Answer: B CREATE DATABASE LINK HQ CONNECT TO CXJRRENT_USER USING HQ' |
|
|
Question: 4 What happens if a maintenance window closes before ajob that collects optimizer statistics completes? A. The job is terminated andthe gathered statistics are not saved. B. The job is terminated butthe gathered statistics are not published. C. The job continues to rununtil all statistics are gathered. D. The job is terminated andstatistics for the remaining objects are collected the next time themaintenance window opens. |
Answer: D The job is terminated and statistics for the remaining objects are collected the next time the maintenance window opens. |
|
|
Question: 5 You plan to create a databaseby using the Database Configuration Assistant (DBCA), with the followingspecifications:Applications will connect tothe database via a middle tier.The number of concurrent userconnections will be high.The database will have mixedworkload, with the execution of complex BI queries scheduled at night.Which DBCA option must youchoose to create the database? A. a General Purpose database template with default memoryallocation B. a Data Warehouse databasetemplate, with the dedicated server mode option and AMM enabled C. a General Purpose database template, with the sharedserver mode option and Automatic Memory Management (AMM) enabled D. a default databaseconfiguratione? |
Answer: C a General Purpose database template, with the shared server mode option and Automatic Memory Management (AMM) enabled |
