-
You work as a database administrator for Certkiller .com. Your database is configured for automatic undo management. UNDO_RETENTION is set to 3 hours. You want to flash back a table that was created last year. How far back can the flashback query go？ （）
A . 3 hours
B . 6 months
C . until last year
D . until last commit
E . until the point when the undotablespacewas refreshed
F . until the database is shut down and the memory erased
-
You want to create an RMAN recovery catalog in the RC01 database to help you manage the databases named DB01 and DB02. You need to create a recovery catalog owner in which of your databases？（）
A . RCO1 only.
B . DB01 only.
C . DB02 only.
D . DB01 and DB02 only.
E . DB01，DB02，and RC01.
-
You created a department report and preview it in life preview. The font for the department name is too small and you want to enlarge it but do not want to change the font for any other fields. What is the easiest way to make this change?（）
A . Select the text to be enlarged in the life previewer and make the size change using the style bar.
B . Select the text to be enlarged in the layout mode and make the change.
C . Open the report wizard in the re-entrant mode and make the change.
D . Make the copy of the report, open the copy, make the changes and then delete the original report.&e
-
You have created a resource plan， DB_PLAN， using DBMS_RESOURCE_MANAGER.CREATE_SIMPLE_PLAN and you want to impose a restriction on utilization of resources by the database users. Which step must be performed before you can start using the resource plan？（）
A . assign users to consumer groups
B . set the resource plan for the instance
C . configure a simple resource plan and specify plan directives
D . configure a complex resource plan and specify plan directive
-
You want to use RMAN to create compressed backups.Which statement is true about the compression algorithms that RMAN can use?（）
A . The BZIP2 compression algorithm consumes more CPU resources than the ZLIB compression algorithm.
B . The ZLIB compression algorithm consumes more CPU resources than the BZIP2 compression algorithm.
C . The ZLIB compression algorithm provides maximum compression and produces smaller backups than the BZIP2 compression algorithm.
D . Only the BZIP2 compression algorithm can be used to make compressed backups to disk.
-
In your multitenant container database (CDB) with two pluggable database (PDBs). You want to create a new PDB by using SQL Developer. Which statement is true?（）
A . The CDB must be open.
B . The CDB must be in the mount stage.
C . The CDB must be in the nomount stage.
D . Alt existing PDBs must be closed.
-
You work as a database administrator for Supportcenter.cn. You want to create your database with the automatic undo management feature enable.Which two tasks must you perform to achieve this？（）
A . Set the UNDO_RETENTION parameter to AUTO.
B . Create an initial undo segment in undotablespace.
C . Set the UNDO_RETENTION parameter to 900 or more
D . Set the initialization parameter UNDO_MANAGEMENT to AUTO
E . Set the UNDO_MANAGEMENT parameter to the name of an undotablespace
-
You want to use RMAN to create compressed backups. Which statement is true about the compression algorithms that RMAN can use？（）
A . The BZIP2 compression algorithm consumes more CPU resources than the ZLIB compression algorithm.
B . The ZLIB compression algorithm consumes more CPU resources than the BZIP2 compression algorithm.
C . The ZLIB compression algorithm provides maximum compression and produces smaller backups than the BZIP2 compression algorithm.
D . Only the BZIP2 compression algorithm can be used to make compressed backups to disk.
-
You want to create a pie-style chart using the Chart Wizard. What must be you do to determine the fields available for use in this chart? （）
A . Select the block that contains the data to appear in the pie chart.
B . Select the table that contains the data to appear in the pie chart.
C . Select the view that contains the data to appear in the pie chart.
D . Nothing. The wizard will automatically create the pie chart based on the highlighted data.
-
You want to create the Recovery Manager （RMAN） Virtual Private Catalog （VPC） to maintain a separation of responsibilities along with a consolidation of RMAN repository. Which condition must be met before you create the VPC？（）
A . A base catalog exists
B . The recovery catalog is empty
C . The base recovery catalog must be dropped
D . A target database is registered in the recovery catalog
-
You have a domain that was created and configured with WebLogic 10.3.5. You want to upgrade the domain to use WebLogic 12c. Which Oracle tool must you use to upgrade your domain?（）
A . Oracle WebLogic Domain Upgrade tool
B . Smart Update
C . Smart Upgrade
D . No tool required, just install WebLogic 12c, update the domain to point to the new WebLogic installation and start your domain.
E . JDeveloper
-
You are creating a shared Internet connection on your Windows 2000 Professional computer. You want to enable other computers on the LAN to be able to access only HTTP and FTP sites on the Internet. What should you do?（）
A . Configure your shared Internet connection to disable LCP extensions.
B . Configure you shared Internet connection to disable on-demand dialing.
C . Create an Internet Connection Sharing application type for HTTP to use remote server port 25.
D . Create an Internet Connection Sharing application type for HTTP to use remote server port 80.
E . Create an Internet Connection Sharing application type for FTP to use remote server port 21.
F . Create an Internet Connection Sharing application type for FTP to use remote server port 72.
-
You are managing an Oracle Database 11g instance.You want to create a duplicate database for testing purpose. What are the prerequisites for performing the active database duplication?（）
A . The source database backup must be copied over the net for test database.
B . The source database must be run in ARCHIVELOG mode if the database is open.
C . The source database must be shut down cleanly if the database is in mounted state.
D . A net service name should be set up and a listener configured with the target as well as the source database.
-
You want to create a temporary table named OLD_INVENTORY in the OLD_INVENTORY database on the master server. This table is not to be replicated to the slave server. Which two changes would ensure that the temporary table does not propagate to the slave?（）
A . Use the – replicate-do-db, — replicate-do-table, or – replicate-wild-do-table option with the value equal to OLD_INVENTORY
B . Change the binlog_format option to ROW and restart mysqld before you create the OLD_INVENTORY table
C . Stop SQL_THREAD on the slave until you have finished using the OLD_INVENTORY temporary table
D . Set binlog_format=MIXED with the – replicate-ignore-temp-table option
E . Use the – replicate-ignore-table option with the value equal to OLD_INENTORY.OLD_INVENTORY and restart mysqld before creating the temporary table
-
You need to base a data block on the EMP table, but you do not want to give the users of the application access privileges on the table. Which type of data source would you use to create the data block?（）
A . table
B . transactional trigger
C . stored procedure
D . FROM clause query
-
You want to create the Recovery Manager (RMAN) Virtual Private Catalog (VPC) to maintain a separation of responsibilities along with a consolidation of RMAN repository. Which condition must be met before you create the VPC?（）
A . A base catalog exists
B . The recovery catalog is empty
C . The base recovery catalog must be dropped
D . A target database is registered in the recovery catalog
-
You want to create a template to be used as a standard for all company reports. What is the easiest way to do this?（）
A . Open an existing template file, rename it and modify the template objects.
B . Open the report wizard and create a new template.
C . Open the layout model and copy the paste items from the default templates provided in report builder.
D . Templates cannot be modified in release 2.
-
You want to create a temporary table while executing a procedure in a form. Which statement is true?（）
A . You cannot create a table form within Forms.
B . You must use the FORMS_DDL built-in to create the table.
C . You must use the DBMS_DYNAMIC_DDL package to create the table.
D . You can write the CREATE TABLE statement directly into the trigger.
-
You want to create a template to be used as a standard for all company reports, which are many different styles. How many different templates must you have if you plan to use multiple report styles?（）
A . Two
B . One
C . One per report style
D . One per report style + one more
-
You want to create a valid directory structure for your Java EE web application， and you want to put yourweb application into a WAR file called MyApp.war. Which two are true about the WAR file？（）
A . At deploy time， Java EE containers add a directory called META-INF directly into the MyApp directory.
B . At deploy time， Java EE containers add a file called MANIFEST.MF directly into the MyApp directory.
C . It can instruct your Java EE container to verify， at deploy time， whether you have properly configured your application’s classes.
D . At deploy time， Java EE containers add a directory call META-WAR directly into the MyApp directory.
-
You plan to collect the Automatic Workload Repository （AWR） data every Monday morning for a month. You want Oracle Database to automatically create a baseline every Monday and remove the old baseline. What is the correct action to achieve this？（）
A . Create and populate a SQL Tuning Set from the AWR on every Monday.
B . Change the RETENTION setting for the AWR snapshots to 7 days on Monday.
C . Create a repeating baseline template.
D . Insert a finding directive for future ADDM tasks.
-
When writing a subjective description, you will be selecting details purposefully and using language that creates the effect that you want the reader to experience.
-
You want to create the Recovery Manager （RMAN) Virtual Private Catalog （VPC) to maintain a
You want to create the Recovery Manager (RMAN) Virtual Private Catalog (VPC) to maintain a separation of responsibilities along with a consolidation of RMAN repository.Which condition must be met before you create the VPC？（）
A. A base catalog exists
B. The recovery catalog is empty
C. The base recovery catalog must be dropped
D. A target database is registered in the recovery catalog
-
You want to create a purchase order item for a non-valuated material.What must you do？ Please choose the correct answer.（)
A．A.Select an account assignment category
B．B.Set the indicator for non-valuated goods receipts
C．C.Set the Goods Receipt indicator
D．D.Set the Invoice Receipt indicator
