出自:Oracle认证

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
Your business has departmental reports that are generated every day. Each department must use the same set of queries， but access a different subset of data in the tables， depending on which department generates the report. The format of the reports is being developed； currently， the format changes daily. How would you configure the database to ensure that each department generates its report （based on its target data） using the most recent report format every day？（）
A: By having each user run the report generation procedure at the scheduled time， supplying the necessary input variables.
B: By creating a program using DBMS_JOB that accepts one or more variables， and creating a job that calls this program using DBMS_JOB.
C: By having each user schedule a job using DBMS_JOB that accepts one or more input variables and calls a procedure that generates the report.
D: By having each user create a job using DBMS_SCHEDULER that includes all the information and commands necessary to generate the report.
E: By creating a program using DBMS_SCHEDULER that accepts one or more variables， and creating a job that calls this program using DBMS_SCHEDULER.
You have created a script in the recovery catalog called backup_database. Which of the following commands would successfully execute that script？（）  
A: run { open script backup_database； run script backup_database }
B: run { engage script backup_database； }
C: run { run script backup_database； }
D: Run { execute script backup_database； }
E: The name backup_database is an invalid name for an RMAN script. Trying to run it from RMAN would result in an error.
In Recovery Manager （RMAN）， you have set control file autobackup to ON by using the following command： CONFIGURE CONTROLFILE AUTOBACKUP ON； Which two events would cause the control file to be backed up automatically？ （）
A: A tablespace is taken offline.
B: The database instance is restarted.
C: A new data file is added to an existing tablespace.
D: A successful backup is recorded in the RMAN repository.
E: The RMAN connection is disconnected from the target database.
Compressed backups work with which of the following commands？（）
A: copy as backup
B: backup as copy
C: backup
D: copy
Examine the CREATE DISKGROUP command used to create a disk group：   SQL> CREATE DISKGROUP misc EXTERNAL REDUNDANCY  DISK ’ORCL： FRA3’ NAME misc1， ’ORCL： FRA4’ NAME misc2；   In which situation would you use this method of disk group creation？（）
A: When two-way disk mirroring is required for the allocation units
B: When three-way disk mirroring is required for the allocation units
C: When using hardware mirroring or RAID
D: When disk mirroring is required for the Automatic Storage Management （ASM） disks
Which two scenarios are NOT safe to replace a StringBuffer object with a StringBuilder object？（）
A:When using versions of Java technology earlier than 5.0.
B:When sharing a StringBuffer among multiple threads.
C:When using the java.io class StringBufferInputStream.
D:When you plan to reuse the StringBuffer to build more than one string.
When you create a backup control file， where is the resulting file written to？（）  
A: The database user dump destination directory
B: The database diagnostic destination directory
C: To $ORACLE_HOME/rdbms
D: To $ORACLE_HOME/admin
E: To the directory and filename you specify in the command
Identify three features of Multi-Org.（） (Choose three.)
A:The data can be logically partitioned.
B:Users can be assigned to specific organizations.
C:It defines organizations and the relationships between them.
D:Multiple installations of Oracle Application products are needed.
E:It enables at most two business units to use a single installation of Oracle Applications.
Examine the list of variables and their data types：  AME DATA Type  TS， TS1 TIMESTAMP  TSZ TIMESTAMP WITH TIME ZONE  TLZ TIMESTAMP WITH LOCAL TIME ZONE  IYM INTERVAL YEAR TO MONTH  IDS， IDSI INTERVAL YEAR To SECOND   Which three expressions using the new data and time data types are valid？（）
A:IDS* 2
B:TS + IYM
C:TS –TSI
D:IDS – TS
E:IDS + IYM
Examine the description of the EMPLOYEES table: Which statement produces the number of different departments that have employees with last name Smith?（）
A:SELECT COUNT(*) FROM employees WHERE last_name='Smith';
B:SELECT COUNT(dept_id) FROM employees WHERE last_name='Smith';
C:SELECT DISTINCT(COUNT(dept_id)) FROM employees WHERE last_name='Smith';
D:SELECT COUNT(DISTINCT dept_id) FROM employees WHERE last_name='Smith';
E:SELECT UNIQUE(dept_id) FROM employees WHERE last_name='Smith';
You are using an Automatic Storage Management （ASM） instance to manage the database files of your production database. After adding a new disk group to the ASM instance， you execute the following command：  ALTER DISKGROUP dg3 REBALANCE POWER 0； What would be the result of this command？（）
A:The rebalancing of the disk group would be stopped.
B:The rebalancing of the disk group would be completed as fast as possible.
C:The command would result in an error because the value of POWER cannot be 0.
D:The rebalancing of the disk group would be completed without affecting the disk group DG3.
E:The command would result in an error because the disk groups cannot be manually rebalanced.
Which new key architectural element introduced in WebLogic Server l2c should you take  advantage of when designing Disaster Recovery Centers with active - passive mode?（）
A:MAN Clusters, because they would allow you to synchronously replicate state in low latency networks 
B:WAN Clusters, because they would allow you to asynchronously replicate state in nonlow latency networks.  
C:Transaction Log in the database, because you could avoid synchronizing two replication technologies (database and file)  
D:Data Guard, because it is the most effective way to replicate a state across locations
E:GoldenGate, because it is the most effective way to replicate a state across locations
The multithreaded agent architecture for heterogeneous services is similar to the Oracle multithreaded server architecture. The principal difference is that it used threads instead of processes.  What are thee kinds of threads that it uses？（）
A:TCP
B:Task
C:Monitor
D:Dispatcher
E:Shared Server
F:Shutdown address
Which statement is true regarding the COALESCE function?（）
A:It can have a maximum of five expressions in a list 
B:It returns the highest NOT NULL value in the list for all rows 
C:It requires that all expressions in the list must be of the same data type 
D:It requires that at least one of the expressions in the list must have a NOT NULL value
While setting up an Oracle database for one of your critical applications， you want to ensure that the database is backed up at regular intervals without your intervention. What should you do to achieve the objective？（）
A:configure the database to run in ARCHIVELOG mode
B:configure the Flash Recovery Area to enable automatic database backup
C:schedule the database backup using DBMS_JOB package after creating the database
D:schedule the database backup using Recovery Manager （RMAN） commands after creating the database
E:schedule the database backup using Database Configuration Assistant （DBCA） while creating the database
You are using Recovery Manager （RMAN） with a recovery catalog to back up your production database. The backups and the archived redo log files are copied to a tape drive on a daily basis. Because of media failure， you lost your production database completely along with the recovery catalog database. You want to recover the target database and make it functional. You could consider performing the following steps to accomplish this task：   1） Restore an autobackup of the server parameter file.  2） Restore the control file.  3） Start the target database Instance.  4） Mount the database. 5） Restore the data files.  6） Open the database with the RESETLOGS option.  7） Recover the data files.  8） Set DBID for the target database   Which option illustrates the correct sequence that you must use？（）  
A: 8， 1， 3， 2， 4， 5， 7， 6
B: 1， 8， 3， 4， 2， 5， 7， 6
C: 1， 3， 4， 2， 8， 5， 6， 7
D: 1， 3， 2， 4， 6， 5， 7， 8
You work as a database administrator for Certkiller .com. On a Monday morning， you find the database instance aborted. After inspecting the alert log file， you execute the STARTUP command in SQL*Plus to bring the instance up. What statement is true？（）
A:PMON coordinates media recovery.
B:SMON coordinates instance recovery.
C:PMON coordinates instance recovery.
D:Undo Advisor would roll back all uncommitted transactions.
E:SQL*PLUS reports an error with the message asking you to perform instance recovery. 
You use—login-path to access a MySQL server on a Linux installation. Which statement is true about the – login-path option that is created by using mysql_config_editor?（）
A:All system users have access to the MySQL server via—login path local
B:login-path can be used only for MySQL servers running on a local machine
C:login-path allows you to provide login credentials without passing clear text passwords on the command line
D:When using – login-path to connect to a remote MySQL server, the remote server version must be 5.6 or later
以下对于SQL比较运算符ANY和ALL的说法正确的是（）
A:〈ANY 表示小于最小值
B:〉ANY 表示大于最大值
C:〈ALL 表示小于最大值
D:〉ALL 表示大于最小值
E:以上说法都不正确
Which statement is true regarding online redefinition for the migration of BasicFile LOBs to SecureFile LOBs?（）
A:It cannot be done in parallel.
B:It can be done at the table level or partition level.
C:It does not require additional storage because the operation is done online.
D:Local and global indexes are maintained automatically during the operation.
What is the correct order of steps to perform an online database backup？（）   a. alter database begin backup b. alter database end backup c. Back up the database datafiles d. Back up the archive log files e. alter system switch logfile
A:a， b， c， d， e
B:e， d， a， b， c
C:a， c， b， d， e
D:d， b， c， a， e
E:a， c， b， e， d
In your Certkiller .com production database， you find that the database users are able to create and read files with unstructured data， available in any location on the host machine from an application.  You want to restrict the database users to access files in a specific location on the host machine.  What could do to achieve this？（）
A:Modify the value for the UTL_FILE_DIR parameter in the parameter file
B:Grant read and write privilege on the operating system path to the database users
C:Modify the value for the LDAP_DIRECTORY_ACCESS parameter in the parameter file
D:Modify the value for the PLSQL_NATIVE_LIBRARY_DIR parameter in the parameter file
E:Create a directory object referring to the operating system path， and grant read and write privilege on the directory object to the database users
Given： Which code， inserted at line 16， correctly retrieves a local instance of a Point object？（）
A:Point p = Line.getPoint（）；
B:Line.Point p = Line.getPoint（）；
C:Point p = （new Line（））.getPoint（）；
D:Line.Point p = （new Line（））.getPoint（）；
Because of a logical corruption in your production database, you wanted to perform Tablespace Point in Time Recovery (TSPITR). But before you start the recovery, you queried the TS_PITR_OBJECTS_TO_BE_DROPPED view and realized that there are a large number of objects that would be dropped when you start the recovery by using this method. You want to preserve these objects. Which option must you use to perform TSPITR and preserve the object?（）
A:Perform Export before TSPITR and Import after TSPITR
B:Move objects to another schema that has the same tablespace assigned
C:Perform Incomplete Recovery before TSPITR with the Log Sequence Number (LSN)
D:Perform Incomplete Recovery before TSPITR with the System Change Number (SCN)
Which operations require undo data（）
A:Committing a transaction
B:Flashing back a transaction
C:Recovering a failed transaction
D:Running a read-consistent query
E:Changing a tablespace status from READ ONLY to READ WRITE
What command would you use to ensure that backup records in the control file are pointing to actual physical files on the backup media？（）  
A: crosscheck
B: list backup
C: confirm
D: resync
E: backup validate
You are maintaining subscriptions in an Oracle database. Which property of that subscription allowsyou to update it?（）
A:Phase
B:Status
C:Source Type
D:Rule Function
E:Customization Level
There was media failure and you need to check the data files for any block corruption. Which option would you use to create a report on any corruptions found within the database？（） 
A:the DBNEWID utility
B:the DBVERIFY utility
C:the ANALYZE command
D:the RMAN REPORT command
E:the RMAN CROSSCHECK command
F:the CHECK_OBJECT procedure of the DBMS_REPAIR package
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 SMDUpon  investigation， you find that SMD is a small file tablespace.  Which three action would allow the user to insert data（）
A:Add a data file to the SMD tablespace.
B:Add a data file to the temporary tablespace associated with the user HR.
C:Resize the data file associated with the SMD tablespace to make it larger.
D:Alter the data file associated with the SMD tablespace to grow automatically.
E:Change the segment space management for the SMD tablespace to automatic. n segments is managed through free lists.
首页 <上一页 47 48 49 50 51 下一页> 尾页