出自:Oracle认证

You use the Memory Advisor to tune the memory structures of your database. What is the prerequisite to use the Memory Advisor？（）
A: The database must be in the ARCHIVELOG mode.
B: The automatic memory tuning must be enabled.
C: The change tracking feature must be enabled.
D: The automatic memory tuning must be disabled.
An existing master-slave setup is currently using a delayed replication of one hour. The master has crashed and the slave must be "rolled forward" to provide all the latest data. The SHOW SLAVE STATUS indicates the following values: RELAY_LOG_FILE =hostname-relay-bin.00004 RELAY_LOG_POS = 1383 Which command set would make the slave current?（）
A:Gtid_mode must be set to AUTO during point in time recoveries
B:Mysqlbinlog ignores arguments to – exclude-gtids-it means ignore all events with GTIDs
C:The server keeps track of which GTIDs have already been executed and skips those
D:Enforce_gtid_consistency is set to ON
User SCOTT wants to back out the transactions on the REGIONS table in his schema. As a DBA, whichcommands must you execute to enable SCOTT to flash back the transactions? （）(Choose four.)
A:ALTER DATABASE FLASHBACK ON;
B:GRANT SELECT any transaction TO scott;
C:GRANT EXECUTE ON dbms_flashback TO scott;
D:ALTER DATABASE ADD SUPPLEMENTAL LOG DATA;
E:ALTER TABLESPACE undots1 RETENTION GUARANTEE;
F:ALTER DATABASE ADD SUPPLEMENTAL LOG DATA (PRIMARY KEY) COLUMNS;
The CUSTOMERS table has these columns: The CUSTOMER_ID column is the primary key for the table.Which two statements find the number of customers? （）
A:SELECT TOTAL(*)   FROM customers;
B:SELECT COUNT(*)   FROM customers;
C:SELECT TOTAL(customer_id)   FROM customers;
D:SELECT COUNT(customer_id)   FROM customers;
E:SELECT COUNT(customers)   FROM customers;
F:SELECT TOTAL(customer_name)   FROM customers;
When performing a backup using Recovery Manager （RMAN）， which four types of files can be backed up with the RMAN BACKUPcommand？ （）
A: data file
B: password file
C: archivelog file
D: temporary file
E: online redo log file
F: the current control file
G: the tnsnames.ora file
H: current server parameter file
Evaluate the following command：   SQL>ALTER SYSTEM SET db_securefile = ’IGNORE’；   What is the impact of this setting on the usage of SecureFiles？（）
A: It forces BasicFiles to be created even if the SECUREFILE option is specified to create the LOB
B: It forces SecureFiles to be created even if the BASICFILE option is specified to create the LOB
C: It does not allow the creation of SecureFiles and generates an error if the SECUREFILE option is specified to create the LOB
D: It ignores the SECUREFILE option only if a Manual Segment Space Management tablespace is used and creates a BasicFile
Which are SRW package procedure or function could you use to create and then drop a temporary table in the sales report?（）
A:SRW.BREAK 
B:SRW.SET_ALTER 
C:SRW.REFERENCE 
D:SRW.DO_SQL 
E:SRW.RUN_REPORT
F:SRW.SET_FIELD
A customer has a Stock Watch application that publishes stock recommendations to different customers and programs. The stock recommendation message should be processed by only one of the JMS Servers in the cluster. Which JMS model should be used?（）
A:JMS Queue
B:Distributed JMS Queue
C:Uniform Distributed Topic
D:Partitioned Distributed Topic
Which two statements are true about standard database auditing（）
A:DDL statements can be audited.
B:Statements that refer to stand-alone procedure can be audited.
C:Operations by the users logged on as SYSDBA cannot be audited.
D:Only one audit record is ever created for a session per audited statement even though it is executedmore than once.
You are creating the CUST_PREMIUM data block in the AUTO_INSURANCE form. A new state law requires that premiums be lowered for drivers with a good driving history. Because this could potentially affect a large number of records, you want to base the data block on a stored procedure returning a table of records. Which statement supports this approach?（）
A:A table of records is efficient in terms of network traffic. 
B:A table of records improves developer productivity because the database administrator does not have to create a server side view. 
C:A table of records is efficient because the number of records fetched depends on the Array Fetch property value.
D:Your coding effort is simplified since DML operations are handles by setting form module properties.
Which two statements correctly describe the relation between a data file and the logical databasestructures（）
A:An extent cannot spread across data files.
B:A segment cannot spread across data files.
C:A data file can belong to only one tablespace.
D:A data file can have only one segment created in it.
E:A data block can spread across multiple data files as it can consist of multiple operating system （OS） blocks.
What is the end result of these commands if they are successful？（）   RMAN> show retention policy；  RMAN configuration parameters for database with db_unique_name  ORCL are： CONFIGURE RETENTION POLICY TO REDUNDANCY 1； # default Backup database tag=gold_copy plus archivelog tag=gold_copy delete input； Backup  database tag=silver_copy plus archivelog tag=silver_copy delete input；  
A: Attempting to restore silver_copy will fail.
B: Attempting to restore gold_copy will fail.
C: Both backups will be available for restore without question.
D: Attempting to restore gold_copy may or may not succeed.
E: You will not be able to restore either gold_copy or silver_copy.
You want to enable archiving on your database. Presently， the database is running inNOARCHIVELOG mode. Given below are the steps to accomplish the task in random order：  1：Shut down the instance.  2：Execute the ALTER DATABASE ARCHIVELOG command.  3：Start up the instance and mount the database.  4：Set the DB_RECOVERY_FILE_DEST initialization parameter to $ORACLE_HOME/dest_1. 5： Open the database.  Which is the correct sequence of steps for accomplishing the task（）
A:4，1，3，2，5
B:1，3，4，5，2
C:1，3，2，5；4 not required
D:4，1，5，2；3 not required
E:1，3，4，5；2 not required
You want to configure and schedule offline database backups to run automatically.  Which tool or utility wouldyou use to achieve this（）
A:The XML script
B:The PL/SQL script
C:The DBMS_SCHEDULER package
D:Enterprise Manager to schedule the backup
What view might you use to try to determine how long a particular backup will take?（）
A:V$SESSION_EVENT 
B:V$SESSION 
C:V$W0041ITS
D:V$WAITSTAT 
E:V$SESSION_LONGOPS 
Given： Which statement is true？（）
A:All of the assert statements are used appropriately.
B:Only the assert statement on line 12 is used appropriately.
C:Only the assert statement on line 15 is used appropriately.
D:Only the assert statements on lines 15 and 18 are used appropriately.
Evaluate this SQL statement: SELECT e.employee_id, (.15* e.salary) + (.5 * e.commission_pct) + (s.sales amount * (.35 * e.bonus)) AS CALC_VALUE FROM employees e, sales s WHERE e.employee_id = s.emp_id; What will happen if you remove all the parentheses from the calculation? （）
A:The value displayed in the CALC_VALUE column will be lower.
B:The value displayed in the CALC_VALUE column will be higher.
C:There will be no difference in the value displayed in the CALC_VALUE column.
D:An error will be reported.
You are maintaining your database in Oracle10g. You are required to view the list of files that have not been backed up for the last seven days. Which RMAN command will you use？（）
A: LIST command
B: CROSSCHECK command
C: REPORT command
D: SHOW command
Which two statements are true regarding hot patching？（）
A: It requires relinking of the Oracle binary.
B: It does not require database instance shutdown.
C: It can detect conflicts between two online patches.
D: It is available for installing all patches on all platforms. 
E: It works only in a single database instance environment.
You have taken a Logical Volume Manager (LVM) snapshot backup of a volume that contains the MySQL data directory. Why is it important to remove snapshots after completing a RAW backup in this way?（）
A:The snapshot size will continue to grow as changes to the volume are made
B:The snapshots take a significant amount of disk space as they are a duplicate copy of the data
C:The system can only support one snapshot per volume, and you need to remove it to be able to take your next backup
D:The system keeps a copy of changes in memory and can cause an out of memory event
The EMP table contains these columns: LAST NAME VARCHAR2(25) SALARY NUMBER(6,2) DEPARTMENT_ID NUMBER(6) You need to display the employees who have not been assigned to any department. You write the SELECT statement: SELECT LAST_NAME, SALARY, DEPARTMENT_ID FROM EMP WHERE DEPARMENT_ID = NULL; What is true about this SQL statement? （）
A:The SQL statement displays the desired results.
B:The column in the WHERE clause should be changed to display the desired results.
C:The operator in the WHERE clause should be changed to display the desired results.
D:The WHERE clause should be changed to use an outer join to display the desired results.
Which two statements are correct regarding the Oracle Flashback Drop feature？ （）
A: Recycle bin exists for the tables only in non-SYSTEM， locally managed tablespaces.
B: You can flash back a dropped table provided row movement has been enabled on the table.
C: If you drop an index before dropping its associated table， then the recovery of the index is not supported when you flash back the dropped table.
D: When you execute the DROP TABLESPACE？ INCLUDING CONTENTS command， the objects in the tablespace are places in the recycle bin.
E: When a dropped table is moved to the recycle bin， only the table is renamed to a system-generated name； its associated objects and constraints are not renamed.
F: If you drop a table that is protected by the recycle bin， then associated bitmap-joined indexes and materialized view logs are also stored in the recycle bin.
An online tablespace，TEST_TBS，is full and you realize that no server-managed tablespace threshold alerts were generated for the TEST_TBS tablespace.  What could be the reason，if the TEST_TBS tablespace does not include autoextensible data files？（）  
A: TEST_TBS is a small file tablespace.
B: TEST_TBS is a bigfile tablespace （BFT）.
C: TEST_TBS is the default temporary tablespace.
D: TEST_TBS is a dictionary-managed tablespace.
An application is using WebLogic JMS Store and Forward to forward messages from a local JMS queue a remote WebLogic JMS destination. You need to determine if the messages are being  sent from the local Weblogic Server. Where do you find information and metrics about Store and Forward components in the WebLogic Admin Console?（）
A:JMS Persistent Store
B:JMS Server  
C:JMS Distributed Destination
D:JMS Store and Forward  
E:Automatic Service Migration
The size of the largest datafile， data1.dbf， in your database is 30MB. You issued the following command：   RMAN>CONFIGURE MAXSETSIZE 10MB；     What will be the impact of the above setting？（）
A: While performing the backup of the datafile，data1.dbf，one backup set is created.
B: While performing the backup of the datafile，data1.dbf，two backup sets are created.
C: While performing the backup of the datafile，data1.dbf，three backup sets are created.
D: While performing the backup of the datafile，data1.dbf，the command for performing a backup of the datafile，data1.dbf，will fail.
One of the tablespaces is read/x7fonly in your database. The loss of all control files forced you to re/x7fcreate the control file.  Which operation do you need to perform after re/x7fcreating the control file and opening the database？（）
A:drop and re­create the read­only tablespaces
B:rename the read­only data files to their correct file names
C:change the tablespace status from read/write to read­only
D:re­create the read­only tablespace because it is automatically removed
You want to analyze a SQL Tuning Set （STS） using SQL Performance Analyzer in a test database. Which two statements are true regarding the activities performed during the test execution of SQLs in a SQL Tuning Set？（）
A: Every SQL statement in the STS is considered only once for execution.
B: The SQL statements in the STS are executed concurrently to produce the execution plan and execution statistics.
C: The execution plan and execution statistics are computed for each SQL statement in the STS. 
D: The effects of DDL and DML are considered to produce the execution plan and execution statistics.
以下不是oracle数据库特点的是（）。
A:高速数据传输
B:较高的数据独立性
C:较小的数据冗余
D:多用户数据共享
You are performing a block media recovery on the tools01.dbf data file in the SALES database using RMAN. Which two statements are correct in this scenario？（）
A: You must ensure that the SALES database is mounted or open.
B: You must restore a backup control file to perform a block media recovery.
C: You must take the tools01.dbf data file offline before you start a block media recovery.
D: You must put the database in NOARCHIVELOG mode to perform a block media recovery.
E: You can perform only a complete media recovery of individual blocks， point-in-time recovery of individual data blocks is not supported.
Which statement is true regarding virtual private catalogs？（）  
A: A virtual private catalog owner can create a local stored script， and have read/write access to a global stored script.
B: The virtual private catalog owner cannot create and modify the stored scripts.
C: The set of views and synonyms that make up the virtual private catalog is stored in the schema of the RMAN recovery catalog owner.
D: To perform most of the RMAN operations， the virtual catalog owner must have the SYSDBA or  SYSOPER privilege on the target database.
首页 <上一页 67 68 69 70 71 下一页> 尾页