出自:Oracle认证

You issue the following RMAN command to set a retention policy on a database: RMAN>CONFIGURE RETENTION POLICY TO REDUNDANCY 2; What will be the outcome of issuing this command?()
A:After two days, a backup will be marked obsolete
B:After two days, a backup will be deleted from the media
C:If the RMAN repository has records of two or more recent backups of a file, then older backups will be deleted from the media.
D:If the RMAN repository has records of two or more recent backups of a file, then older backups will be marked obsolete.
Which three table transformations can be done using online redefinition of tables?()
A:A
B:B
C:C
D:D
E:E
While planning to manage more than one database in your system, you perform the following activities:  1. Organize different categories of files into independent subdirectories.  2. Use consistent naming convention for database files.  3. Separate administrative information pertaining to each database.  Which option corresponds to the type of activities performed by you?()
A:Oracle Managed Files
B:Oracle Grid Architecture
C:Optimal Flexible Architecture
D:Oracle database architecture
Which two operations can be performed on an external table()
A:Create a view on the table.
B:Create an index on the table.
C:Create a synonym on the table.
D:Add a virtual column to the table.
E:Update the table using the UPDATE statement.
F:Delete rows in the table using the DELETE command
You work as a database administrator for Certkiller .com. You decided to manage client and server connections using Local Naming method in Certkiller .com. When you try to connect to the database you get the following error: ERROR:  ORA-12154:TNS:couldnot resolve service name  Which network configuration files would you look into to resolve this error?()
A:snmp.ora
B:names.ora
C:spfile.ora
D:sqlnet.ora
E:listener.ora
F:tnsnames.ora
Evaluate the CREATE TABLE statement:   CREATE TABLE products   (product_id NUMBER (6)  CONSTRAINT prod_id_pk PRIMARY KEY,  product_name VARCHAR2 (15));   Which statement is true regarding the PROD_ID_PK constraint?()
A: It would be created only if a unique index is manually created first.
B: It would be created and would use an automatically created unique index.
C: It would be created and would use an automatically created nonunique index.
D: It would be created and remains in a disabled state because no index is specified in the command.
Your business has departmental reports that are generated every day. Each department must use the same set of queries, but accesses 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
The TRANS_SUMMARY table contains product-wise transaction details that get updated with every transactionin the system. Each row has cumulative transaction details of a single product and every product is identified bya product code, which is the primary key.As part of the archival process, the company wants to transfer therows in the TRANS_SUMMARY table to the TRANS_SUMMARY_DUP table at the end of every quarter of theyear. Along with existing products, the company deals with many new products during every quarter. Whichmethod is best suited for this quarterly data transfer()
A:Using the MERGE command
B:Using the SQL*Loader utility
C:Using the correlated UPDATE command
D:Using the INSERT command to perform bulk operation
Why would you run the delete obsolete command?()  
A: To remove missing backup set pieces physically from disk
B: To remove metadata related to backup set pieces in the control file and the recovery catalog
C: To mark as deleted records in the control file and the recovery catalog associated with obsolete backup sets
D: To delete backup set pieces associated with backups that are no longer needed due to retention criteria
E: To remove old versions of RMAN backups
You executed the following code:   SQL> CREATE TABLE COUNTRY   (COUNTRY_ID CHAR(2) CONSTRAINT COUNTRY_ID_nn NOT NULL,   COUNTRY_NAME VARCHAR2(20),   CURRENCY_NAME VARCHAR2(20),   CONSTRAINT COUNTRY_ID_PK PRIMARY KEY (COUNTRY_ID))   ORGANIZATION INDEX;   In which tablespace will the mapping table be created?()
A: SYSTEM tablespace
B: SYSAUX tablespace
C: Undo tablespace
D: The tablespace of the Index Organized Table (IOT)
Which is the correct way to connect to both the target database and the recovery catalog from the RMAN command line?() Assume that the target database is called ORCL and that the recovery catalog database is called RCAT. Also assume that the recovery-catalog owner is called RCAT_OWN. Assume the environment is configured for the ORCL database. 
A: rman target=/ catalog=/@rcat
B: rman target=/ catalog=rcat_own/rcat_own
C: rman target=/ catalog=rcat_own/rcat_own@RCAT
D: rman target=sys/robert@orcl catalog=rcat_own/rcat_own@RCAT
E: You cannot connect to the target database and the recovery catalog at the same time.
Examine the following scenario: -Database is running in ARCHIVELOG mode. -Complete consistent backup is taken every Sunday. -On Tuesday the instance terminates abnormally because the disk on which control files are located gets corrupted -The disk having active online redo log files is also corrupted. -The hardware is repaired and the paths for online redo log files and control files are still valid. Which option would you use to perform the recovery of database till the point of failure?()
A:Restore the latest whole backup, perform complete recovery, and open the database normally
B:Restore the latest whole backup, perform incomplete recovery, and open the database with the RESETLOGS option
C:Restore the latest backups control file, perform complete recovery, and open the database with the RESETLOGS option
D:Restore the latest backup control file, perform incomplete recovery using backup control file, and open the database with the RESETLOG option
In order to find out how many database objects a user has created, which view would the DBA query in the Oracle data dictionary? ()
A:DBA_USERS 
B:DBA_OBJECTS 
C:DBA_TS_QUOTAS 
D:DBA_TAB_PRIVS 
You configured the Flash Recovery Area for your database. The database instance has been started inARCHIVELOG mode and the LOG_ARCHIVE_DEST_1 parameter is not set. What will be the implications onthe archiving and the location of archive redo log files()
A:Archiving will be disabled because the destination for the redo log files is missing.
B:The database instance will shut down and the error details will be logged in the alert log file.
C:Archiving will be enabled and the destination for the archived redo log file will be set to the Flash RecoveryArea implicitly.
D:Archiving will be enabled and the location for the archive redo log file will be created in the default location$ORACLE_HOME/log.
A customer has a development environment that uses the auto-deployment feature. The customer  claims the application is not redeployed even if the new version is copied to an application  subdirectory. Which two parameters of the configuration should you check?()
A:Check if archive file in the compressed version has a new REDEPLOY file.  
B:If server was started in the Development Mode. Auto-deployment is not supported in production  mode.  
C:If the application includes an EJB 3 module. Auto-deployment is not supported for EJBs.
D:You change JVM from HotSpot to JRockit. Auto-deployment is not supported in HotSpot auto  deployment.  
E:If the domain is a single-server domain. Auto-deployment is not supported in multiserver  domains.
You perform differential incremental level 1 backups of your database on each working day and level 0 backupon Sundays, to tape. Which two statements are true about differential incremental backups()
A:The backup performed on Sundays contains all the blocks that have ever been used in the database.
B:The backup performed on Sundays contains all the blocks that have changed since the last level 1 backup.
C:The backup performed on each working day contains all the blocks that have changed since the last level 0 backup.
D:The backup performed on Monday contains all the blocks that have changed since the level 0 backup, and every other working day contains all the blocks that have changed since the level 1 backup
You issued the following command:        SQL> DROP TABLE MYTABLE;        SQL> SHOW RECYCLEBIN  The following output is returned:        ORIGINAL NAME RECYCLEBIN NAME               OBJECT TYPE      DROP TIME        ------------- ------------------------------ --------------- --------------------        MYTABLE BIN$04LhcpndanfgMAAAAAANPw==$0     TABLE           2005-01-13:20:11:31  You want to drop the table, MYTABLE, from the Recycle Bin. Which two commands can you issue to accomplish the desired task?()
A: DROP TABLE MYTABLE PURGE;
B: PURGE RECYCLEBIN;
C: PURGE TABLE MYTABLE;
D: PURGE TABLE BIN$04LhcpndanfgMAAAAAANPw==$0;
Examine the following commands and their output: View the exhibit and examine the Flashback Version Query that was executed after the preceding commands. What could be the possible cause for the query not displaying any row?()
A:Flashback logging is not enabled for the database.
B:The changes made to the table are not committed.
C:Supplemental logging is not enabled for the database.
D:The database is not configured in ARCHIVELOG mode.
You disabled the Flashback Database feature by using the following command:  SQL> ALTER DATABASE FLASHBACK OFF;  What would be the effect of this command on the existing flashback logs?()
A:Flashback logs are not deleted.
B:Flashback logs are deleted automatically.
C:Flashback logs are deleted only if you are using Recovery Manager (RMAN).
D:Flashback logs are deleted only if you are using Oracle Managed Files (OMF).
E:Flashback logs are deleted only if you are using Automatic Storage Management (ASM).
Which two initialization parameters would you set to enable Automatic Shared Memory Management?()
A: set SHARED_POOL_SIZE to zero
B: set STATISTICS_LEVEL to BASIC
C: set SGA_TARGET to a non-zero value
D: set DB_CACHE_SIZE to a non-zero value
E: set STATISTICS_LEVEL to TYPICAL or ALL
Given: What is the result?()
A:Compilation fails.
B:An exception is thrown at runtime.
C:doStuff x = 6 main x = 6
D:doStuff x = 5 main x = 5
E:doStuff x = 5 main x = 6
The CALC function is used several times within the sales report. To simplify maintenance you want to store the function in one place and call it from within your PL/SQL trigger code. Which node would you use in object navigator to create a report level programme unit to store the function?()
A:Programme units. 
B:PL/SQL libraries. 
C:Database object. 
D:Built in packages.
You executed the following command in the Recovery Manager (RMAN): RMAN> REPORT NEED BACKUP days 3; What is the output of this command?()
A:A list of files that require a backup within 3 days
B:A list of files requiring more than 3 days of archivelogs to apply
C:A list of files that RMAN recommends be backed up only once in every three days, based on low volatility
D:A list of files for which a backup as already been performed in the last three days and which is required to be backed up again based on the high number of transactions performed on them
You issued the following command to analyze the SCOTT.EMP table for block corruption:   ANALYZE TABLE SCOTT.EMP VALIDATE STRUCTURE;  You received the following error:   ORA-01578: ORACLE data block corrupted  (file # %s, block # %s)   How will you resolve the block corruption problem?()
A: by using the DBMS_REPAIR package
B: by using the DB_BLOCK_CHECKING parameter
C: by using the DBVERIFY utility
D: will not be completely resolved until the hardware fault is corrected
In one of your online transaction processing (OLTP) applications, users are manipulating and querying a database table simultaneously. From the Segment Advisor, you find that one of the tables is highly fragmented and you want to shrink the table immediately without affecting the currently active queries.  Which option would you use with the ALTER TABLE command to achieve this objective?()
A:REBUILD
B:CASCADE
C:TRUNCATE
D:ROW MOVEMENT
E:SHRINK SPACE COMPACT
F:SHRINK SPACE CASCADE
当启动Oracle实例,如果不需要装置数据库,可以使用如下()命令。
A:STARTUP MOUNT
B:STARTUP NOMOUNT
C:START NOMOUNT
D:START MOUNT
View the Exhibit and examine the resource consumption details for the current plan in use by the database instance.Which two statements are true based on the output?()
A:An attempt to start a new session by the user belonging to DSS_QUERIES fails with an error
B:A user belonging to DSS_QUERIES can log in to a new session but the session will be queued
C:The CPU_WAIT_TIME column indicates the total time that sessions in the consumer group waited for the CPU due to resource management .
D:The CPU_WAIT_TIME column indicates the total time that sessions in the consumer group waited for the CPU due to resource management, I/O waits, and latch or enqueue contention
在Oracle中,表分区方式()建议分区数是2的幂(2、4、8等),以获得最平均的数据发布。
A:范围分区
B:列表分区
C:散列分区
D:复合分区
When you are performing media recover, and an archived log is lost or corrupt, which type of recover must you perform?()
A:Until SCN
B:Until time
C:Until cancel
D:Recover using backup control file.
What advantage would you get if you increase the length of time during which the undo information would be stored in the database?()
A:roll back of large transactions
B:roll forward to redo a transaction
C:data concurrency for large updates
D:read consistency for long-running transactions