问题：单选题SQL*Loader reads a set of records from a file， generates INSERT commands， and passes them to the Oracle kernel. Oracle then finds places for those records in free blocks in the table and updates any associated indexes. Which SQL*Loader mode is used in this scenario？（）A direct-path loadB conventional path load
Thursday, August 22, 2024
问题：多选题Examine the code： CREATE ROLE readonly IDENTIFIES USING app.chk_readwrite ； CREATE ROLE readwrite IDENTIFIED USING app.chk_readwrite ； CREATE OR REPLACE PROCEDURE app.chk_readwrite AUTHID CURRENT_USER IS ipchk STRING（30）； BEGIN IF sys_context（‘USERENV’，’ISDBA’）=’TRUE’ THEN DBMS_SESSION.SET_ROLE‘READWRITE’） ； ELSE DBMS_SESSION.SET_ROLE（‘READONLY’） ； END； / Which three statements correctly describe the Secure Application role definition？（）ANo user or application has to remember or hide a password.BIt prevents everyone except a true DBA session from acquiring the READWRITE role.Capp.chk_readwrite is called whenever a user tries to access rows protected by the READONLY or READWRITE label.Dapp.chk_readwrite is called by users or applications when they want to enable the READONLY or READWRITE role.
Saturday, October 5, 2024
问题：单选题Management has decided that the database must be available 24 hours a day， 7 days a week. Given this requirement， which type of backup is required？（）A user-managed backups.B partial database backups.C consistent database backups.D inconsistent database backups.
Saturday, November 9, 2024
问题：单选题When performing an incomplete recover of the whole database， which data files must you restore？ （）A Only the damaged or lost data files.B All of the data files of the database.C Only the data files belonging to the SYSTEM tablespace.D The data files belonging to the SYSTEM tablespace and the damaged or lost data files.
Thursday, June 20, 2024
问题：多选题You notice that your RMAN script used to copy the datafiles， control files， and archived redo log files is performing very slowly. Which two changes might you want to include in your RMAN script to speed up the COPY commands？（）ANOCHECKSUMBMAXCORRUPTCCHECK LOGICALDBACKUP INCREMENTALECONFIGURE DEVICE TYPE ... PARALLELISM
Wednesday, July 3, 2024
问题：单选题Click the Exhibit button and examine the diagram， which illustrates the components performing tasks within an Oracle Shared Sever environment. Which task is being performed by component 4？（）A The PMON process registers the request in the response queue.B A shared sever places the process request in the response queue.C A request within the request queue is processed by an idle shared server process.D A dispatcher assigns a request from the request queue to and idle shared server process.
问题：单选题As A DBA， which of the following methods can you use to make a backup of your table？（）A Recover Manager （RMAN） utilityB Import utilityC Export utilityD O/S backup command
Sunday, December 15, 2024
问题：单选题What is true regarding direct-load insert？（）A A direct-load insert can be invoked by suing the APPEND hint.B Inserting using the NOLOGGING option is the default for direct-load inserts.C All data loaded using direct-load insert is loaded below the high-water mark.D An object that is modifies using parallel direct-load can be queried within the same Transaction.
问题：单选题RMAN enables you to open the target database when it is already mounted. Which command must you execute at the RMAN prompt to open the database？（）A ’SQL ALTER DATABASE OPEN’；B SQL ALTER DATABASE ’OPEN’；C OPEN DATABASE；D DATABASE OPEN
问题：多选题A web browser can connect directly to an Oracle server using which two？（）AHTTPBIIOPCTCP/IPDNamed PipesETCP/IP with SSL
Friday, July 12, 2024
问题：单选题You want to create an RMAN recovery catalog in the RC01 database to help you manage the databases named DB01 and DB02. You need to create a recovery catalog owner in which of your databases？（）A RCO1 only.B DB01 only.C DB02 only.D DB01 and DB02 only.E DB01，DB02，and RC01.
Wednesday, December 11, 2024
问题：多选题Oracle9i provides a database package called dbms_redefinition to perform an online rebuild of a table. Which two steps are you recommended to do prior to issuing thedbms_redefinition_start_redef table procedure call？（）AGrand privileges on the interim table.BInvoke the dbms_redefinition.can_redef_table procedure.CInvoke the dbms_redefinition.sync_interim_table procedure.DCreate any triggers， indexes， or constraints on the interim table.ECreate an empty interim table with all the desired characteristics.
Thursday, September 7, 2023
问题：单选题Which Oracle background process frees SGA resources that were allocated to a user process that failed？（）A PMONB SMONC CKPTD LGWRE ARCn
问题：单选题Which files must be synchronized in order for a database to start？（）A temp filesB online data filesC offline data filesD read only data files
Wednesday, October 11, 2023
问题：单选题You are configuring the listener on your server. Which listener.ora parameter contains the information needed to detect session requests from different client types？（）A ADDRESS_LISTB SID_NAMEC LISTENERD SERVICE_LIST
问题：单选题Which of the following environment variables specifies a non-default location for the listener configuration file？（）A LSN_ADMINB TNS_ADMINC ADMIN_TNSD TSN_ADMIN
Thursday, August 17, 2023
问题：单选题Which dynamic performance view displays the information about the files associated with the locally managed temporary tablespaces in Oracle9i？（）A V$DATAFILEB V$TEMPFILEC V$DBFILED V$DATAFILE_HEADER
问题：多选题Which two are characteristics of user-managed backup and recovery operations？（）ARecovery is initiated using SQL*Plus.BDatabase files are backed up using SQL commands.CDatabase files are backed up with Recovery Manager.DDatabase files are restored using Recovery Manager.EDatabase files are backed up using operating system commands.
问题：多选题Which two statements are true regarding the use of UTF-16 encoding？ （）AEnables easier loading of multinational data.BUses a fixed-width Multibyte encoding sequence.CAsian characters are represented in three characters.DUsed a variable-width Multibyte encoding sequence.EEuropean characters are represented on one or two bytes.
问题：单选题You issue this statement：ALTER DATABASE BACKUP CONTROLFILE TO TRACE； What does the statement generate？（）A A text copy of the control file.B A binary copy of the control file.C A file containing a SQL statement which will re-create the database.D A file containing a SQL statement which will re-create the control file.
