问题:单选题View the Exhibit to examine the output of the DBA_OUTSTANDING_ALERTS view. After 30 minutes, you executed the following command: SQL> SELECT reason,metric_value FROM dba_outstanding_alerts; REASON METRIC_VALUE ------------------------------------------------------------ ------------ Tablespace [TEST] is [28 percent]full 28.125 What could be the reason for the elimination of the other rows in the output()A An Automatic Workload Repository snapshot has been taken recently.B The non-threshold-based alerts are transferred to DBA_ALERT_HISTORY.C The threshold alerts conditions are cleared and the alerts are transferred to DBA_ALERT_HISTORY.D The threshold alerts related to database metrics are permanently stored in DBA_ALERT_HISTORY but not the threshold alerts related to instance metrics.
查看答案
问题:单选题In which situation would you use static database registration for a listener()A when multiple databases are to be registered with the listenerB when DBAs need to connect remotely to start up the database instanceC when users need to connect the database instance using the host naming methodD when the database instance that is to be registered with the listener is configured in shared server mode
问题:多选题Your database instance is running with full workload after database creation. You have decided to use a fixed-size undo tablespace. You want to use the Undo Advisor to estimate the capacity of the undo tablespace. Which two factors must you consider before using the Undo Advisor to estimate the capacity of the undotablespace()AThe retention period to support flashbackBThe expected length of the longest-running queryCThe number of undo tablespaces in the databaseDThe size of the Flash Recovery Area for the database instance
问题:多选题A database user SMITH tries to query the V$SESSION view and fails to access it as follows: SQL> connect smith/smith Connected. SQL> SELECT * FROM v$session; SELECT * FROM v$session * ERROR at line 1: ORA-00942: table or view does not exist Which are the two possible solutions to enable SMITH to query the data in V$SESSION()Agranting SELECT privilege to SMITH on V$SESSIONBgranting SELECT privilege to SMITH on V_$SESSIONCasking the user SMITH to run the catalog.sql scriptDgranting SELECT privilege to SMITH on V$FIXED_TABLESEsetting the O7_DICTIONARY_ACCESSIBILITY parameter to TRUEFcreating a view based on V$SESSION and granting SELECT privilege to SMITH on the view that was created
问题:单选题The instance abnormally terminates because of a power outage. Which statement is true about redo log filesduring instance recovery()A Inactive and current redo log files are required to accomplish recovery.B Online and archived redo log files are required to accomplish instance recovery.C All redo log entries after the last checkpoint are applied from redo log files to data files.D All redo log entries recorded in the current redo log file until the checkpoint position are applied to data files
问题:单选题Examine the command: SQL> DBMS_STATS.SET_TABLE_PREFS(’SH’, ’CUSTOMERS’, ’PUBLISH’, ’false’); Which statement describes the effect of the above command()A Automatic statistics collection is stopped for the CUSTOMERS table.B Statistics for the CUSTOMERS table are locked and cannot be overwritten.C Existing statistics for the CUSTOMERS table become unusable for the query optimizer.D Subsequently, statistics gathered on the CUSTOMERS table are stored as pending statistics.
问题:多选题You execute this command to drop the ITEM table, which has the primary key referred in the ORDERS table:SQL> DROP TABLE scott.item CASCADE CONSTRAINTS PURGE; Which two statements are true about theeffect of the command()ANo flashback is possible to bring back the ITEM table.BThe ORDERS table is dropped along with the ITEM table.CThe dependent referential integrity constraints in the ORDERS table are disabled.DThe dependent referential integrity constraints in the ORDERS table are removed.EThe table definition of the ITEM table and associated indexes are placed in the recycle bin
问题:单选题All the database users are presently connected to the database instance and working. The HR userhas opened three database sessions and executed the following command in one of his sessions: SQL> UPDATE persons SET ccode=’U031’ WHERE ccode=’U029’; 123 rows updated. SQL> DELETE FROM persons WHERE exp=’Y’; 3 rows deleted. The SYS user opens a new session after HR executed the above commands. Which sessions can seethe effect of the UPDATE and DELETE commands ()A all sessions of the HR user onlyB all sessions of the HR user and the SYS userC the session of the HR user that executed the commandsD all the sessions for which the database users have access privilege to the PERSONS table
问题:单选题Automatic Shared Memory Management is disabled for your database instance. You realize that there arecases of SQL statements performing poorly because of repeated parsing activity, resulting in degradation ofperformance. What would be your next step to improve performance()A Run the SQL Access AdvisorB Run the Memory Advisor for the sga.C Run the Memory Advisor for the pga.D Run the Memory Advisor for the shared pool.E Run the Memory Advisor for the buffer cache
问题:多选题You are managing an Oracle Database 11g database. The database is open, and you plan to perform Recovery Manager (RMAN) backups. Which three statements are true about these backups()AThe backups would be consistent.BThe backups would be inconsistent.CThe backups would be possible only if the database is running in ARCHIVELOG mode.DThe backups would be possible only if the database is running in NOARCHIVELOG mode.EThe backups need to be restored and the database has to be recovered in case of a media failure
问题:单选题Identify the memory component from which memory may be allocated for:() 1. Session memory for the shared server 2. Buffers for I/O slaves 3. Oracle Database Recovery Manager (RMAN) backup and restore operationsA Large PoolB Redo Log BufferC Database Buffer CacheD Program Global Area (PGA)
问题:单选题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 commandB Using the SQL*Loader utilityC Using the correlated UPDATE commandD Using the INSERT command to perform bulk operation
问题:单选题Your test database is configured to run in NOARCHIVELOG mode. One of the data files in the USERStablespace is lost due to a media failure. You notice that all the online redo logs have been overwritten since the last backup. What would you do to recover the data file()A Take the USERS tablespace offline and re-create the lost data file.B Shut down the instance, restore the data file from the last consistent backup, and restart the databaseinstance.C Shut down the instance, restore all the database files from the last consistent backup, and restart thedatabase instance.D Take the USERS tablespace offline, restore all the data files of the USERS tablespace from the lastconsistent backup, and make the tablespace online.
问题:单选题You are managing an Oracle Database 11g database with this backup strategy: - Every Sunday night, level 0 backup is performed. - On Monday night and subsequent days, level 1 incremental backup is performed. The backups are not cumulative incremental. Which statement about Monday’s backup is true()A The backup contains all the used blocks.B The backup contains all the used and unused blocks.C The backup contains blocks that have changed since the last level 0 backup.D The backup contains blocks that have changed since the last level 1 backup taken last week.
问题:单选题Examine the commands executed in the following sequence: 1:SQL> CREATE ROLE mgrrole; 2:SQL> GRANT create user,select any table,connect,resource TO mgrrole; 3:SQL> GRANT select,update ON sh.sales TO mgrrole; 4:SQL> CREATE ROLE ceo IDENTIFIED BY boss; 5:SQL> GRANT mgrrole,drop any table,create any directory TO ceo; 6:SQL> GRANT ceo TO mgrrole; Which statement is true about the above commands()A The commands execute successfully.B Command 6 produces an error because of circular role grant.C Command 5 produces an error because a role cannot be granted to another role.D Command 3 produces an error because the MGRROLE role already contains system privileges.E The table created by HR remains and HR still has the CREATE TABLE system privilege.F The table created by HR remains and HR can grant the CREATE TABLE system privilege to other users.
问题:单选题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,5B 1,3,4,5,2C 1,3,2,5;4 not requiredD 4,1,5,2;3 not requiredE 1,3,4,5;2 not required
问题:单选题To make audit information more productive, the DBA executes the following command before startingan audit operation: SQL> ALTER SYSTEM SET AUDIT_TRAIL=DB,EXTENDED SCOPE=SPFILE; Which statement is true regarding the audit record generated when auditing starts after restarting thedatabase()A It contains only the plan for the SQL statement executed by the user.B It contains the SQL text executed by the user and the bind variables used with it.C It contains the plan and statistics associated with the SQL statement executed by the user.D It contains the plan for the SQL statement executed by the user and the bind variables used with it.
问题:单选题You want to import schema objects of the HR user using Oracle Data Pump from the development database,DEVDB, to the production database, PRODDB. A database link devdb.us.oracle.com is created betweenPRODDB and DEVDB. You execute the following command on the PRODDB database server:$ impdp system/manager directory = DB_DATAdumpfile = schemas.datschemas = hr flashback_time = "TO_TIMESTAMP(’25-08-2007 14:35:00’, ’DD-MM-YYYY HH24:MI:SS’)"The command fails displaying the following error:ORA-39001: invalid argument valueORA-39000: bad dump file specification ORA-31640: unable to open dump file "/home/oracle/schema/schemas.dat" for read ORA-27037: unable toobtain file status What would you do to overcome the error()A Add the user, SYSTEM, to the schemas option.B Add the network_link = devdb.us.oracle.com option.C Change the dumpfile option to schema.dat@devdb.us.oracle.com.D Replace the schemas option with the network_link = devdb.us.oracle.comE Replace the dumpfile option with the network_link = devdb.us.oracle.com
问题:单选题You want to create a role to meet these requirements: 1:The role is to be protected from unauthorized usage. 2:The password of the role is not to be embedded in the application source code or stored in a table. Which method would you use to restrict enabling of such roles()A Create the role with global authentication.B Create the role with external authentication.C Create the role as a secure application role.D Create the role as a password-protected role.E Create a role and use Fine-Grained Access Control (FGAC) to secure the role.
问题:多选题Which three descriptions are correct about the effects of the TRUNCATE command on a table()AThe corresponding indexes for the table are also truncated.BDelete triggers on the table are fired during the execution of the TRUNCATE command.CThe child table is truncated when the TRUNCATE command is applied on the parent table.DThe high-water mark (HWM) is set to point to the first usable data block in the table segment.ENo undo or very little undo data is generated during the execution of the TRUNCATE command