问题:多选题You are managing an Oracle Database 11g database with the following backup strategy: 1.On Sunday, an incremental level 0 tape backup is performed. 2.Monday through Saturday, acumulativeincremental level 1 tape backup is performed. Which two statements are true regarding the backups performed()AThe backup performed in step 1 backs up all blocks that have ever been in use in the database.BThe backup performed in step 2 copies all the blocks changed since the most recent level 0 backup.CThe backup performed in step 1 backs up all the blocks changed since the most recent level 1 backup.DThe backup performed in step 2 backs up all blocks that have changed since the most recent incremental backup at level 1.
Friday, January 12, 2024
问题:单选题To make audit information more productive, the DBA executes the following command before starting an auditoperation: 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 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
Sunday, November 19, 2023
问题:单选题Your database is configured in shared server mode. However, your senior DBA asks you to modify the value ofthe PRIVATE_SGA limit in the profile of the users. What could be the reason for this()A To limit the User Global Area (UGA) memory allocated to a session from the SGAB To limit the amount of memory to be used for the dispatcher queue of a session in SGAC To limit the amount of memory to be used for the request pool in System Global Area (SGA)D To control the amount of memory allocated in SGA for the local variables for each shared server process
Sunday, May 5, 2024
问题:单选题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.
Tuesday, May 7, 2024
问题:单选题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
Tuesday, November 7, 2023
问题:单选题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.
Thursday, September 22, 2022
问题:单选题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
Wednesday, July 5, 2023
问题:多选题You notice that the performance of the database has degraded because of frequent checkpoints. Which twoactions resolve the issue()ADisable automatic checkpoint tuning.BCheck the size of the redo log file size and increase the size if it is small.CSet the FAST_START_MTTR_TARGET parameter as per the advice given by the MTTR Advisor.DDecrease the number of redo log members if there are more than one redo log members available in eachredo log group.
Thursday, September 15, 2022
问题:多选题Which statements are true regarding the creation of an incident package file by using the EMWorkbench Support()AYou can add SQL test cases to the incident package.BYou can add or remove the trace files to the package.CYou cannot create an incremental incident package when the physical files are purged from the ADR.DYou can create the incremental incident package ZIP file for new or modified diagnostic information for the incident package already created.
Tuesday, October 10, 2023
问题:单选题These are points that describe the contents of different memory components: 1: Descriptive information or metadata about schema objects that are queried by using SQL statements 2: The run-time area for data manipulation language (DML) or data definition language (DDL) statements 3: Results of SQL queries and PL/SQL functions 4: Executable forms of SQL cursors, PL/SQL programs, and Java classes 5: The information necessary to reconstruct changes made to the database by a transaction Which of these will be stored in theShared Poolif the necessary configurations are done()A 1 and 2B 2 and 5C 1,3,and 4D 3,4,and 5E 1,2,3,and 4
问题:多选题Which two statements are true about Shared SQL Area and Private SQL Area()AShared SQL Area will be allocated in the shared pool.BShared SQL Area will be allocated when a session starts.CShared SQL Area will be allocated in the large pool always.DPrivate SQL Area will be allocated in the Program Global Area (PGA) always.EShared SQL Area and Private SQL Area will be allocated in the PGA or large pool.FThe number of Private SQL Area allocations is dependent on the OPEN_CURSORS parameter.
Saturday, October 15, 2022
问题:多选题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
Monday, February 12, 2024
问题:单选题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.
Tuesday, October 17, 2023
问题:单选题You execute the following command toauditdatabase activities: SQL>AUDITDROP ANY TABLE BY scott BY SESSION WHENEVER SUCCESSFUL; What is the effect of this command()A Oneauditrecord is created for every successful DROP TABLE command executed in the session ofSCOTT.B Oneauditrecord is generated for the session when SCOTT grants the DROP ANY TABLE privilege toother users.C One audit record is created for the whole session if user SCOTT successfully drops one or more tablesin his session.D One audit record is created for every session of any other user in which a table owned by SCOTT isdropped successfully.E One audit record is created for every successful DROP TABLE command executed by any user to droptables owned by SCOTT.
Monday, January 22, 2024
问题:多选题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
问题:单选题You want to access employee details contained in flat files as part of the EMPLOYEE table. You planto add a new column to the EMPLOYEE table to achieve this. Which data type would you use for the new column()A CLOBB BLOBC BFILED LONG RAW
Saturday, January 6, 2024
问题:单选题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
问题:多选题Your database instance is functional for the past one month. The Automatic Workload Repository(AWR) snapshot retention is set to 7 and the STATISTICS_LEVEL initialization parameter is set to TYPICAL. You receive a complaint about the poor performance of the database between 7 PM and 9 PM of theprevious day. Choose two actions any of which can be referred to first to diagnose the problem. ()AUse the Active Session History report.BUse the AWR Compare Periods report.CUse an ADDM analysis between 7 PM and 9 PM of the previous day.DUse the AWR Compare Period report between 7 PM and 9 PM of the previous day.
Thursday, January 18, 2024
问题:单选题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.