You issued the following statement in your SQL*Plus session:   SQLALTER SESSION ENABLE RESUMABLE TIMEOUT 600;   Which operation is neither suspended nor resumed using the Automatic Resumable Allocation feature in your database?()A、 creating a table in your schema and you exceed your allocated space quota on the tablespaceB、 executing a long query that involves a sort operation and the statement runs out of temporary spaceC、 loading data into tables by using the SQL*Loader and the number of extents in the table reaches the maximum limitD、 creating a table in a dictionary-managed tablespace with an explicit MAXEXTENTS setting which results in an out of space error

You issued the following statement in your SQL*Plus session:   SQL>ALTER SESSION ENABLE RESUMABLE TIMEOUT 600;   Which operation is neither suspended nor resumed using the Automatic Resumable Allocation feature in your database?()

  • A、 creating a table in your schema and you exceed your allocated space quota on the tablespace
  • B、 executing a long query that involves a sort operation and the statement runs out of temporary space
  • C、 loading data into tables by using the SQL*Loader and the number of extents in the table reaches the maximum limit
  • D、 creating a table in a dictionary-managed tablespace with an explicit MAXEXTENTS setting which results in an out of space error

相关考题:

You are requested to send us ______ to authenticate the cable L/C issued by your bank in the future.A.your specimen signatures bookB.your telegraphic test keyC.your tariffsD.your terms and conditions

You opened the encryption wallet and then issued the following command:Then you closed the wallet. Later, you issued the following command to create the EMPLOYEES table in the SECURESPACE tablespace and you use the NO SALT option for the EMPID column.What is the outcome?()A. It creates the table and encrypts the data in it.B. It generates an error because the wallet is closed.C. It creates the table but does not encrypt the data in it.D. It generates an error because the NO SALT option cannot be used with the ENCRYPT option.

As a duty engineer, as soon as your hear the fire emergency signal, you should ensure that theA.ring buoys are thrown overboardB.engines are stoppedC.fire pumps are startedD.life preservers have been issued to everyone

You have just issued the command commit confirmed and your network continues to be operational with no further changes required. You issue a commit and-quit. A short time later, users start complaining about network problems. Which commands (in order) need to be entered to resolve this issue?()A.AB.BC.CD.D

If,after examination by the Quarantine Officer,your vessel is found to have a specific deficiency,you may be issued ______.A.Bill of healthB.Free PratiqueC.Notice to ComplyD.Controlled Free Pratique

Your load line certificate expires on 27 May 2006.The vessel is surveyed on that date and is found satisfactory.You are sailing foreign the same day.Which statement is TRUE ________.A.A new certificate must be issued before you sailB.The existing certificate is endorsed as valid for a five year period commencing 27 May 2006C.The existing certificate is extended for a period of up to 150 daysD.The existing certificate is extended until the first foreign port of call where a new certificate will be issued by the local surveyor

You are signing on a deck officer,who will be designated as one of the GMDSS operators,before sailing foreign.Which statement is TRUE ________.A.He/she must have an STCW certificate endorsed as“Valid for Service on Vessels Operating in the GMDSS System”B.He/she must present either an FCC-issued license or a Coast Guard-issued licenseC.You must consult the“List of Qualifications”on the reverse of his/her FCC-issued licenseD.His/her Merchant Mariners Document must have an added endorsement as “Radio Electronics Officer”

We cant accept your complaint of poor qulity, ( ) you provide the certificate of inspection issued by CIQ.A. why B. unlessC. otherwise D. however

请根据下列材料写一篇150词左右的英语短文。 At present, a wide variety of credit cards issued by major banks and shopping malls are thriving in colleges and universities across the nation, with a multitude of college students making up a growing population of card holders. If you are a college student, will you also use the credit card?

You performed the RMAN database backup having a backupset key number 231 with the KEEP FOREVER option. After some days, you want to change the status of the database backup and you issued the following command: RMANCHANGE BACKUPSET 231 NOKEEP; What is the implication of this command?()A、The backup is deleted.B、The backup is marked unavailable.C、The backup overrides the backup retention policy.D、the backup becomes eligible for deletion according to the existing retention policy

Which three route filtering statements are true?()A、After the router ospf 10 and passive - interface s0/0 commands have been issued , the s0/0 interface will not send any OSPF updates, but will receive routing updates on that interfaceB、When you use the passive - interface command with RIPv2, multicasts are sent out the specified interfaceC、After the router rip and passive -interface s0/0 commands have been issued, the s0/0 interface will not send any RIP updates, but will receive routing updates on that interfaceD、When you use the passive - interface command with EIGRP, hel lo messages are not sent out the specified interfaceE、After the router eigrp 10 and passive - interface s0/0 commands have been issued, the s0/0 interface will not send any EIGRP updates, but will receive routing updates on that interfaceF、When you use the passive - interface command with OSPF, hello messages are not sent out the specified interface

You work as a database administrator for Supportcenter.cn. When you tried to connect to the database, you received the following error:   ERROR:   ORA-12541:TNS:no_listener   You found that the listener is not running on the server, so you issued the following command in the Listener Control utility to start the listener.   lsnrctlSTART   What statement is true?()A、It would attempt to start the default listenerB、It would start the most recently created listener.C、It would display an error with a message asking for the listener name to be specified.D、It would show you a list of listeners and prompts for the listener name that you want to start.

You just issued the following statement: ALTER TABLE SALES DROP COLUMN PROFIT. Which of the following choices identifies when the column will actually be removed from Oracle?()A、Immediately following statement execution B、After the ALTER TABLE DROP UNUSED COLUMNS command is issued C、After the ALTER TABLE SET UNUSED COLUMN command is issued D、After the ALTER TABLE MODIFY command is issued

The database is running in the ARCHIVELOG mode. It has three redo log groups with one member each. Oneof the redo log groups has become corrupted. You have issued the following command during the recovery of a damaged redo log file:ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 3; Which action should you perform immediately after using this command?()A、You should perform a log switchB、You should make a backup of the databaseC、You should switch the database to the NONARCHIVELOG modeD、You should shut down the database instance and perform a complete database recovery

You issued the following statement to monitor the usage of the index:        SQL ALTER INDEX SCOTT.EMP_IDX MONITORING USAGE;   Which view will you query to ensure that the index is being monitored?()  A、 INDEX_STATSB、 DBA_INDEXESC、 DBA_IND_COLUMNSD、 V$OBJECT_USAGE

You have an Exchange Server 2010 organization.Users on the network use HTTPS to connect to Outlook Web App (OWA).The Client Access server uses a certificate issued by an internal certification authority (CA).You plan to deploy an e-mail encryption solution for all users. You need to ensure that users can send and receive encrypted e-mail messages by using S/MIME from OWA.What should you do?()A、Issue a certificate to each userB、Instruct all OWA users to import a root CA certificateC、Modify the authentication settings of the OWA virtual directoryD、Configure the Client Access Server to use a certificate issued by a third-party CA

单选题You work as a database administrator for Certkiller .com. When you tried to connect to the database, you received the following error: ERROR:  ORA-12541:TNS:no_listener  You found that the listener is not running on the server, so you issued the following command in the Listener Control utility to start the listener.  lsnrctlSTART  What statement is true?()AIt would attempt to start the default listenerBIt would start the most recently created listener.CIt would display an error with a message asking for the listener name to be specified.DIt would show you a list of listeners and prompts for the listener name that you want to start.

单选题As soon as you hear the fire and emergency signal, you should ensure that the ().Aring buoys are thrown overboardBengines are stoppedCfire pumps are startedDlife preservers have been issued to everyone

多选题Examine the following command used to perform incremental level 0 backup: RMAN BACKUP INCREMENTAL LEVEL 0 DATABASE; To enable the block change tracking, after the incremental level 0 backup you issued the following command: SQL ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE '/mydir/ rman_change_track.f'; To perform incremental level 1 cumulative backup, you issued the following command: RMAN BACKUP INCREMENTAL LEVEL 1 CUMULATIVE DATABASE; Which two statements are true in the above situation?()AThe block change tracking data will be used only from the next incremental 0 backup.BThe incremental backup will use change tracking data for accomplishing the backup.CThe incremental backup will not use change tracking data for accomplishing the backup.DThe block track file will scan all the blocks and create bitmap for all the blocks backed up in the level 0 backup.

单选题You are signing on a deck officer,who will be designated as one of the GMDSS operators,before sailing foreign.Which statement is TRUE().AHe/she must have an STCW certificate endorsed as“Valid for Service on Vessels Operating in the GMDSS System”BHe/she must present either an FCC-issued license or a Coast Guard-issued licenseCYou must consult the“List of Qualifications”on the reverse of his/her FCC-issued licenseDHis/her Merchant Mariners Document must have an added endorsement as “Radio Electronics Officer”

多选题You performed an incremental level 0 backup of a database: RMAN BACKUP INCREMENTAL LEVEL 0 DATABASE; To enable block change tracking after the incremental level 0 backup, you issued this command: SQL ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE ‘ /mydir/rman_change_track.f’; To perform an incremental level 1 cumulative backup, you issued this command: RMAN BACKUP INCREMENTAL LEVEL 1 CUMULATIVE DATABASE; Which three statements are true?()ABackup change tracking will sometimes reduce I/O performed during cumulative incremental backups.BThe change tracking file must always be backed up when you perform a full database backup.CBlock change tracking will always reduce I/O performed during cumulative incremental backups.DMore than one database block may be read by an incremental backup for a change made to a single block.EThe incremental level 1 backup that immediately follows the enabling of block change tracking will not read the change tracking file to discover changed blocks.

多选题Identify three valid methods of opening, pluggable databases (PDBs).()AALTER PLUGGABLE DATABASE OPEN ALL ISSUED from the rootBALTER PLUGGABLE DATABASE OPEN ALL ISSUED from a pdbCALTER PLUGGABLE DATABASE PDB OPEN issued from the seedDALTER DATABASE PDB OPEN issued from the rootEALTER DATABASE OPEN issued from that pdbFALTER PLUGGABLE DATABASE PDB OPEN issued from another pdbGALTER PLUGGABLE DATABASE OPEN issued from that pdb

单选题You issued the following commands to configure setting in RMAN; Then you issued the following command to take the backup: RMAN BACKUP DATABASE PLUS ARCHIVELOG; Which statement is true about the execution of the above command?()A The backup will terminate because the FORMAT clause was not configured for the channelB It backs up two copies of data files to tape and disk, and two copies of archived log file on tapeC It backs up the data files and archived log files to disk, making two copies of each data file and archived log fileD It backs up the data files and archived log files to tape, making two copies of each data file and archived log file

单选题You opened the encryption wallet and then issued the following command:   SQLCREATE TABLESPACE securespace DATAFILE ’/home/user/oradata/secure01.dbf’ SIZE 150M  ENCRYPTION USING ’3DES168’ DEFAULT STORAGE(ENCRYPT);   Then you closed the wallet. Later, you issued the following command to create theEMPLOYEES table in the SECURESPACE tablespace and you use the NO SALT option for the EMPID column.  What is the outcome?()A It creates the table and encrypts the data in it.B It generates an error because the wallet is closed.C It creates the table but does not encrypt the data in it.D It generates an error because the NO SALT option cannot be used with the ENCRYPT option.

单选题If,after examination by the Quarantine Officer,your vessel is found to have a specific deficiency,you may be issued().ABill of healthBFree PratiqueCNotice to ComplyDControlled Free Pratique

单选题You issued the following statement to monitor the usage of the index:        SQL ALTER INDEX SCOTT.EMP_IDX MONITORING USAGE;   Which view will you query to ensure that the index is being monitored?()A INDEX_STATSB DBA_INDEXESC DBA_IND_COLUMNSD V$OBJECT_USAGE

单选题Your network contains an Active Directory forest. The functional level of the forest is Windows Server 2008 R2.You plan to deploy DirectAccess.You need to configure the DNS servers on your network to support DirectAccess.What should you do?()AModify the GlobalQueryBlockList registry key and restart the DNS Server service.BModify the EnableGlobalNamesSupport registry key and restart the DNS Server service.CCreate a trust anchor that uses a certificate issued by an internal certification authority (CA).DCreate a trust anchor that uses a certificate issued by a publicly trusted certification authority (CA).

单选题The database is running in the ARCHIVELOG mode. It has three redo log groups with one member each. One of the redo log groups has become corrupted. You have issued the following command during the recovery of a damaged redo log file:   ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 3;   Which action should you perform immediately after using this command?()A You should perform a log switchB You should make a backup of the databaseC You should switch the database to the NONARCHIVELOG modeD You should shut down the database instance and perform a complete database recovery