问题：多选题Which two statements are true regarding Oracle Data Pump（）AEXPDP and IMPDP are the client components of Oracle Data Pump.BDBMS_DATAPUMP PL/SQL packages can be used independently of the Data Pump clients.COracle Data Pump export and import operations can be performed only by users with the SYSDBA privilege.DOracle Data Pump imports can be done from the export files generated in the export utility of previous versions.EEXPDP and IMPDP use the procedures provided by DBMS_METADATA to execute export and import commands.
Friday, February 17, 2023
问题：多选题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（）AAdd a data file to the SMD tablespace.BAdd a data file to the temporary tablespace associated with the user HR.CResize the data file associated with the SMD tablespace to make it larger.DAlter the data file associated with the SMD tablespace to grow automatically.EChange the segment space management for the SMD tablespace to automatic. n segments is managed through free lists.
Thursday, December 19, 2024
问题：单选题The TRANS_SUMMARY table contains product-wise transaction details that get updated with everytransaction in the system. Each row has cumulative transaction details of a single product and everyproduct is identified by a product code， which is the primary key. As part of the archival process， the company wants to transfer the rows in the TRANS_SUMMARY tableto the TRANS_SUMMARY_DUP table at the end of every quarter of the year. Along with existing products，the company deals with many new products during every quarter. Which method 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
Monday, September 19, 2022
问题：单选题In your database instance， the STATISTICS_LEVEL initialization parameter is set to BASIC. What isthe impact of this setting（）A Optimizer statistics are collected automatically.B Only timed operating system （OS） statistics and plan execution statistics are collected.C The snapshots for the Automatic Workload Repository （AWR） are not generated automatically.D Snapshots cannot be collected manually by using the DBMS_WORKLOAD_REPOSITORY package.E The Oracle server dynamically generates the necessary statistics on tables as part of query optimization.
Saturday, March 18, 2023
问题：单选题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
问题：单选题Which statements listed below describe the data dictionary views（） 1） These are stored in the SYSTEM tablespace. 2） These are the based on the virtual tables. 3） These are owned by the SYS user. 4） These can be queried by a normal user only if O7_DICTIONARY_ACCESSIBILTY parameter is set to TRUE. 5） The V$FIXED_TABLE view can be queried to list the names of these views.A 1 and 3B 2， 3， and 5C 1， 2， and 3D 2， 3， 4， and 5
Wednesday, June 12, 2024
问题：多选题Which two files in the database can be configured for automatic backups by using the autobackupfeature in Recovery Manager （RMAN）（）Adata filesBcontrol filesCparameter fileDonline redo log filesEserver parameter file
Tuesday, October 10, 2023
问题：单选题The HR user creates a stand-alone procedure as follows and grants the EXECUTE privilege on theprocedure to many database users： CREATE OR REPLACE PROCEDURE create_dept （ v_deptno NUMBER， v_dname VARCHAR2， v_mgr NUMBER， v_loc NUMBER） BEGIN INSERT INTO hr.departments VALUES （v_deptno， v_dname， v_mgr， v_loc）； END； The users having permission to execute the procedure are able to insert records into the DEPARTMENTStable even though they do not have the INSERT privilege on the table. You want only those users whohave privileges on the DEPARTMENTS table to be able to execute the procedure successfully. What would you suggest to the PL/SQL developers to achieve this（）A Create the procedure with definer’s right.B Create the procedure with invoker’s right.C Grant the EXECUTE privilege with GRANT OPTION on the procedure to selected users.D Create the procedure as part of a PL/SQL package and grant the EXECUTE privilege on the package to selected users
Sunday, July 14, 2024
问题：单选题Which task would you perform before you run Oracle Universal Installer （OUI） in silent or suppressedmode for an installation（）A Run the root.sh script.B Create the oraInst.loc file.C Create the tnsnames.ora file.D Run the oraintRoot.sh script.
Monday, July 1, 2024
问题：多选题Which statements are true about logical structures of the Oracle database（）AEach segment contains one or more extents.BMultiple tablespaces can share a single data fileCA data block is the smallest unit of input/output （I/O） in data files.DIt is possible to have tablespaces of different block sizes in a database.EEach data block in the database always corresponds to one operating system block
Sunday, September 18, 2022
问题：多选题Which statements are true regarding the Oracle Data Pump export and import operations（）AYou cannot export data from a remote database.BYou can rename tables during an import operation.CYou can overwrite existing dump files during an export operation.DYou can compress the data during export but not the metadata because it is not supported
Monday, November 11, 2024
问题：单选题Which naming method uses the tnsnames.ora file to store the connect descriptor used by the client whileconnecting to the database instance from a remote machine（）A Host naming methodB Local naming methodC External naming methodD Directory naming method
Saturday, September 17, 2022
问题：多选题You plan to move data from a flat file to a table in your database. You decide to use SQL*Loader direct pathload method to perform this task. The table in which you plan to load data is an important table having variousintegrity constraints defined on it. Which constraints will remain enabled by default during this operation（）ACHECKBUNIQUECNOT NULLDPRIMARY KEYEFOREIGN KEY
Thursday, March 30, 2023
问题：单选题You have issued a SHUTDOWN ABORT command to bring down your database instance. Consider the stepsthat will be performed later when you open the database： 1. SGA is allocated. 2. Control file is read. 3. Redo log files are read. 4. Instance recovery is started. 5. Background processes are started. 6. Data files are checked for consistency. 7. Server parameter file or the initialization parameter file is read. Which option has the correct order in which these steps occur（）A 7， 1， 5， 2， 3， 6， 4B 1， 2， 3，7， 5， 6， 4C 7， 1， 4， 5， 2， 3， 6D 1， 7， 5， 4， 2， 3， 6
Friday, December 20, 2024
问题：单选题Which statement is true about the Manageability Monitor （MMON） background proces（）A It transfers statistics from memory to disk at regular intervals.B It coordinates the rebalance activity for disk groups when ASM is used.C It communicates with the Automatic Storage Management （ASM） instance on behalf of the databaseinstance.D It performs dynamic memory management when Automatic Shared Memory Management is enabledfor the database instance.
Wednesday, November 20, 2024
问题：多选题Which statements regarding the server parameter file （SPFILE） are true（）AAn SPFILE is a binary file.BAn SPFILE cannot reside on a client.CAn SPFILE cannot contain static parameters.DAn SPFILE can store changes persistently across instance restarts.EAn SPFILE can be read by the database server， but it is not written to by the server.FAn SPFILE must be created manually， before creating a database， even if you use the DatabaseConfiguration Assistant （DBCA） to create the database
Wednesday, July 5, 2023
问题：多选题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（）AThe backup performed on Sundays contains all the blocks that have ever been used in the database.BThe backup performed on Sundays contains all the blocks that have changed since the last level 1 backup.CThe backup performed on each working day contains all the blocks that have changed since the last level 0 backup.DThe 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 are managing an Oracle Database 11g database. You configured the database to run in ARCHIVELOGmode. Which two statements are true in this scenario（）AYou must shut down the database instance to perform the backups.BYou must configure the Flash Recovery Area （FRA） for the database.CYou can perform complete database backups without closing the database.DAll the previous closed database backups including control files become invalid after you configure thedatabase to ARCHIVELOG mode.
Monday, October 7, 2024
问题：单选题You have two database servers SEMP and SACCT. The database in the SEMP server maintains the employeeinformation and the database in the SACCT server maintains the accounts payable information. The employeessubmit the expense reports to the accounts payable department. A user of the accounts payable databasewants to extract the employee information from the database in the SEMP server for cross-verification. Whichschema object enables the user to access the information from the remote database（）A ClusterB Database linkC Mapping tableD Materialized view
Friday, January 12, 2024
问题：多选题Which operations require undo data（）ACommitting a transactionBFlashing back a transactionCRecovering a failed transactionDRunning a read-consistent queryEChanging a tablespace status from READ ONLY to READ WRITE
