问题:单选题Which of the following options enables a user to get authenticated though a single password instead of using multiple passwords?()A Wallet ManagerB RadiusC Oracle Internet DirectoryD None of the above...
查看答案
问题:多选题Media recovery can sometimes be stopped by the inability to read past a certain point in the redo stream. This is often referred to as “stuck recovery”. Before Oracle9i, the Database Administrator had few options to deal with stuck recovery. If the co...
问题:单选题You can control instance recover performance by setting parameters to define targets for()A The size of the redo buffer in SGA. B The instance that will perform recovery in Real Application Cluster database. C The number of blocks to be read during ins...
问题:单选题There is a problem with one of the disks used for your database and your system administrator informs you that the disk needs to be replaced. The replacement disk will not be available until tomorrow. There was only one data file on this disk; it belo...
问题:单选题Which server stack communication layer corresponds to the client application layer in a distributed environment?()A RDBMSB ApplicationC Oracle Net foundationD Network ProtocolE Presentation...
问题:单选题Which of the following files cannot be cataloged using the CATALOG command?()A Data filesB Control filesC Archived log filesD Files storing RMAN scripts...
问题:多选题Which three resource plan parameters are used to enable Automatic Consumer Group Switching to estimate job execution times automatically, and to perform a switch to a low priority consumer group before they are initiated?()ASWITCH_TIMEBSWITCH_GROUPCMAX...
问题:多选题Some data storage and transfer media have fixed-length physical records. When the data records are short, more then one can be stored in a single, physical record to use the storage space efficiently. Consider this data: 1119 Smith 1120 Yvonne 1121 ...
问题:多选题What are three benefits of performing data definition language (DDL) statements against a partitioned table with the UPDATE GLOBAL INDEXES clause?()AGlobal indexes are rebuilt automatically at the end of the DDL operation thereby avoiding problems with...
问题:多选题Which two file types must be included in a closed database backup taken with operating system commands?()Adata filesBcontrol fileCpassword fileDonline redo log filesEinitialization parameter file...
问题:单选题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 be...
问题:单选题Which of the following commands cannot use the functionality assosciated with theNLS_DATE_FORMAT variable?()A RESTOREB RECOVERC REPORTD BACKUP...
问题:单选题Which statement is true regarding RMAN components?()A Each target database requires its own recover catalog. B RMAN scripts can be stored in the recovery catalog or the target control file. C A channel is a stream of data to a device type and correspon...
问题:多选题Which four are true regarding the Workspace Manager in Oracle9i? ()AAutomatically versions all tables.BAutomatically installed with Oracle9i.CMerges changes with parent rows or discard changes.DProvides mechanism to identify and resolve conflicts.EAllo...
问题:单选题Examine the RMAN command: SWITCH DATAFILE ’/DISK3/user_data01.dbf’; Which command do you need to issue before you issue the above command, so that RMAN finds the file in the restored location of ’DISK2/user_data01.dbf’? ()A RESTORE DATAFILE ’/DISK2/use...
问题:多选题A web browser can connect directly to an Oracle server using which two?()AHTTPBIIOPCTCP/IPDNamed PipesETCP/IP with SSL...
问题:单选题The EMPLOYEES table is stored in the SAMPLE tablespace. The corresponding IPK_EMP index for the EMPLOYEES table’s primary key is stored in the INDX tablespace. Out of 12 partitions, only partition P1 of the SALES table is stored in the SAMPLE tablesp...
问题:To perform a database point-in-time recovery using RMAN, aft...