-
You work as a database administrator for Certkiller .com. You enabled tracing while creating a listener to your database. What additional information is available to you when you enable tracing？（）
A . Information about each Oracle Net connection.
B . Information about each entry in theLinstener.orafile
C . Information about the changed done in the database
D . Information about the different listeners in your system
E . Information about all thenondatabasefiles required to operate the database
-
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.
-
A redo log file is corrupted while the database is open； as a consequence， database operations are stopped because archiving cannot continue. What would you do to solve the problem？（）
A . clear the redo log group
B . perform redo log file import
C . perform an incomplete recovery
D . perform a redo log recovery using Recovery Manager （RMAN）
E . shut down the database and open the database in the NOARCHIVELOG mode
-
You explicitly specified the tablespace usage threshold values while creating a tablespace. You need to revert to the database-wide default tablespace usage threshold values for the tablespace. Which PL/SQL package would you use?（）
A . DBMS_STATS
B . DBMS_ALERT
C . DBMS_SPACE
D . DBMS_MONITOR
E . DBMS_SERVER_ALERT
F . DBMS_SPACE_ADMIN
-
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.
-
What kind of information does a router running a link-state routing protocol need to create and maintain its topological database?（）
A . LSAs from other routers
B . Beacons received on point-to-point links
C . hello packets
D . Routing tables received from neighbors
E . SAP packets sent by other routers
F . TTL packets from exclusive router
-
A junior level Database Administrator erroneously deleted the database alert log while users were accessing the database. Which action should you take to recover the alert log？（）
A . Do nothing.
B . Restart the database.
C . Perform recovery on the database.
D . Restore the alert log from the last backup.
-
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 are creating a form that will access an Oracle8 database. On which three sources can you base a data block?（）
A . BFILE
B . REF column
C . Object table
D . Column object
E . INSTEAD-OF trigger
-
What are two benefits of installing Grid Infrastructure software for a stand-alone server before installing and creating an Oracle database?（）
A . Effectively implements role separation
B . Enables you to take advantage of Oracle Managed Files.
C . Automatically registers the database with Oracle Restart.
D . Helps you to easily upgrade the database from a prior release.
E . Enables the Installation of Grid Infrastructure files on block or raw devices.
-
Which option is best practice for creating a recovery catalog owner in the catalog database？（）
A . Granting UNLIMITED QUOTA on the SYSTEM tablespace to the owner
B . Allocating the SYSTEM tablespace as the default tablespace and granting the SYSDBA privilege to the user
C . Creating a new tablespace，allocating this as the default， and granting UNLIMITED QUOTA on this tablespace to the user
D . Allocating the SYSAUX tablespace as the default tablespace and granting UNLIMITED QUOTA on this tablespace to the user
-
You are performing a database recovery because a user’s schema is dropped. While performing the recovery， you use the UNTIL SEQUENCE clause. Which type of database recovery are you performing？（）
A . user managed complete recovery
B . user managed incomplete recovery
C . RMAN-based complete recovery
D . RMAN-based incomplete recovery
-
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.
-
Which option is best practice for creating a recovery catalog owner in the catalog database?（）
A . Granting UNLIMITED QUOTA on the SYSTEM tablespace to the owner
B . Allocating the SYSTEM tablespace as the default tablespace and granting the SYSDBA privilege to the user
C . Creating a new tablespace, allocating this as the default, and granting UNLIMITED QUOTA on this tablespace to the user
D . Allocating the SYSAUX tablespace as the default tablespace and granting UNLIMITED QUOTA on this tablespace to the user
-
When performing a database duplication， which duplicate database parameter would you set to ensure that the online redo logs are created in the correct location？（）
A . log_file_name_convert
B . convert_log_file_name
C . file_name_convert_log
D . redo_log_file_name_convert
E . logfile_convert_directory
-
Which two operations are NOT performed by the DUPLICATE command in Recovery Manager （RMAN） while duplicating a running database？（）
A . Creating the control file for the duplicate database
B . Restoring the target data files to the duplicate database
C . Performing complete recovery using all available backups
D . Generating a new， unique DBID for the duplicate database
E . Copying the online redo log files from the target database to the duplicate database
-
Which three pieces of information are to be mandatorily provided while creating a new listener using Enterprise Manager Database Control？（）
A . the port used by the listener
B . the protocol used by the listener
C . the server name where the listener runs
D . the log file and trace file destination for the listener
E . the database services to be registered with the listener
-
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 work as a database administrator for Supportcenter.cn. You enabled tracing while creating a listener to your database. What additional information is available to you when you enable tracing？（）
A . Information about each Oracle Net connection.
B . Information about each entry in theLinstener.orafile
C . Information about the changed done in the database
D . Information about the different listeners in your system
E . Information about all thenondatabasefiles required to operate the database
-
You created a database by using the Database Configuration Assistant. What must you do to access a user account in the sample schemas？（）https://assets.asklib.com/images/image2/2018080110052310043.jpg
A . A
B . B
C . C
D . D
-
You create a new pluggable database, HR_PDB, from the seed database. Which three tablespaces arecreated by default in HR_PDB?（）
A . SYSTEM
B . SYSAUX
C . EXAMPLE
D . UNDO
E . TEMP
F . USERS
-
【单选题】 While creating a “ cluster ” , you will often ___________. 【单选题】 While creating a “ cluster ” , you will often ___________.
-
You create a new Automatic Database Diagnostic Monitor （ADDM) task: instance_analysis_mode
You create a new Automatic Database Diagnostic Monitor (ADDM) task: instance_analysis_mode_task. To view the ADDM report, you use the following command:You want to suppress ADDM output relating to Segment Advisor actions on user SCOTT‘s segments.What would you do to achieve this？（）
<img src='https://img2.soutiyun.com/ask/uploadfile/2019-03-27/f856003f497492b5fcd1516f347bc3b8.jpg' />
A. Add a finding directive for the ADDM task.
B. Add a segment directive for the ADDM task.
C. Add a parameter directive for the ADDM task.
D. Disable the Segment Advisor from the Automatic Maintenance Task.
-
The database administrator of your company created a public synonym called HR for the HUMAN_RESOURCES table of the GENERAL schema, because many users frequently use this table. As a user of the database, you created a table called HR in your schema.What happens when you execute this query？（）
<img src='https://img2.soutiyun.com/shangxueba/ask/17133001-17136000/17135882/b1559080aa448ecf1a5fe7380a121c8c.jpg' />
A. You obtain the results retrieved from the public synonym HR created by the database administrator.
B. You obtain the results retrieved from the HR table that belongs to your schema.
C. You get an error message because you cannot retrieve from a table that has the same name as a public synonym.
D. You obtain the results retrieved from both the public synonym HR and the HR table that belongs to your schema, as a Cartesian product.
E. You obtain the results retrieved from both the public synonym HR and the HR table that belongs to your schema, as a FULL JOIN.
