You opened the encryption wallet and then issued the following command: SQL>CREATE 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?()
第1题:
You want to take the backup of the USERS tablespace. It has a single data file of 900 MB. You have tape drives of 300 MB each. The SBT channel is configured for Recovery Manager (RMAN).To accomplish the backup, you issued the following RMAN command:RMAN> BACKUP SECTION SIZE 300M TABLESPACE users;Which two statements are true about the execution of the above command? ()(Choose two.)
A. The backup piece size will be limited to 300 MB
B. The RMAN uses multiplexing to perform backup
C. The operation is accomplished using the default channel available
D. The RMAN parallelizes the backup although the parallelism is not set for a channel
第2题:
You want to take the backup of the USERS tablespace. It has a single data file of 900 MB. You have tape drives of 300 MB each. The SBT channel is configured for Recovery Manager (RMAN). To accomplish the backup, you issued the following RMAN command: RMAN> BACKUP SECTION SIZE 300M TABLESPACE users; Which two statements are true about the execution of the above command? ()(Choose two.)
第3题:
You execute a command to resize a data file, sales.dbf, of size 200 MB in your database: ALTER DATABASE DATAFILE ’/remorse/sales.dbf’ RESIZE 150M; Which statement is true about this command()
第4题:
You want to drop the TBS1 tablespace from your database. You also want to delete the corresponding data files automatically, and not have to do it manually. What should you do?()
第5题:
You created an encrypted tablespace: You then closed the encryption wallet because you were advised that this is secure. Later in the day, you attempt to create the EMPLOYEES table in the SECURESPACE tablespace with the SALT option on the EMPLOYEE column. Which is true about the result?()
第6题:
You are managing an Oracle Database 11g database. You want to take a backup on tape drives of the USERS tablespace that has a single data file of 900 MB. You have tape drives of 300 MB each. To accomplish the backup, you issued the following RMAN command: RMAN> BACKUP SECTION SIZE 300M TABLESPACE users; Identify the appropriate configuration to accomplish faster and optimized backups using the above command.()
第7题:
You issue the following command in Oracle: CREATE TABLESPACE DAT_TBS DATAFILE "dat_tbs.dbf" SIZE 2M;. Later queries against the database reveal that the tablespace is located in the /u01/oradata/oracle directory. Which of the following choices identifies how Oracle likely determined what directory to place dat_tbs.dbf file in?()
第8题:
You are the administrator of a computer named Computer1 that runs Windows 7. Several users shareComputer1. The users plan to encrypt files on the computer. You need to ensure that you can access allencrypted files on the computer. What should you do first?()
第9题:
You need to include a disclaimer to all sent messages in your organization. Some of the users require message encryption.How do you make sure that disclaimer can be included in encrypted messages?()
第10题:
The SBT channel must be configured, with the default parallelism setting for the SBT device set to 1
The COMPATIBLE initialization parameter for the database instance must be set to at least 10.0
The SBT channel must be configured, with the parallelism setting for the SBT device set to 3
The SBT channel must be configured, with the MAXPIECESIZE set to 300 MB
第11题:
It creates the table successfully but does not encrypt any inserted data in the EMPNAME column because the wallet must be opened to encrypt columns with SALT.
It generates an error when creating the table because the wallet is closed.
It creates the table successfully, and encrypts any inserted data in the EMPNAME column because the wallet needs to be open only for tablespace creation.
It generates error when creating the table, because the salt option cannot be used with encrypted tablespaces.
第12题:
DB_CREATE_FILE_DEST
DB_CREATE_ONLINE_LOG_1
DB_CREATE_ONLINE_LOG_2
The directory is an operating system-specific default value in Oracle that can neigher be specified manually nor changed
第13题:
You have just issued the command user@router# save current.conf.Assuming the default settings, where in the file system is current.conf saved?()
第14题:
Examine the following RMAN command:RMAN> CONFIGURE ENCRYPTION FOR DATABASE ON;RMAN> BACKUP DATABASE PLUS ARCHIVELOG;Which prerequisite must be met before accomplishing the backup?()
第15题:
You want to take the backup of the USERS tablespace. It has a single data file of 900 MB. You have tape drives of 300 MB each. The SBT channel is configured for the RMAN. To accomplish the backup, you issued the following RMAN command: RMAN> BACKUP SECTION SIZE 300M TABLESPACE users; Which two statements are true regarding the execution of the above command?()
第16题:
You are creating a recovery catalog for use with RMAN. You have issued these commands: SQL> CREATE TABLESPACE rman_ts DATAFILE ’/DISK1/rman_ts01.dbf’ 2> SIZE 20M 3> DEFAULT STORAGE (initial 100K next 100K pctincrease 0); SQL> CREATE USER rman_db01 IDENTIFIED BY rman_db01 2> DEFAULT TABLESPACE rman_ts 3> QUOTA unlimited ON rman_ts; Which command should you issue next?()
第17题:
You have configured your database to use RMAN for backup and recovery. You must back up the datafile contained in the TS1 tablespace. The size of the datafile in the TS1 tablespace is 200 MB. You issue the following command from the RMAN prompt to perform a backup of the tablespace: RMAN> BACKUP TABLESPACE TS1 MAXSETSIZE 100M; Which statement is true about executing this command?()
第18题:
Your database is in ARCHIVELOG mode. On Friday evening, you perform an online database backup by using the BACKUP DATABASE command at the Recovery Manager (RMAN) prompt and close the database. On Monday, the System Administrator informs you about the failure of two hard disks. One of the lost disks contains two datafiles, HR1.DBF and HR2.DBF, both of which belong to a read/write tablespace named HR. The disk also contains a datafile, USERS.DBF, which belongs to a read/write tablespace named USERS. You need to restore and recover the database backup that was performed on Friday evening. After mounting the database, you issue the following RMAN commands: RMAN>RESTORE DATABASE; RMAN>RECOVER DATABASE; After successfully executing these RMAN commands, you issue the following statement using SQL*Plus: SQL>ALTER DATABASE OPEN; You receive the following errors when attempting to open the database: ORA-01157: cannot identify/lock data file 10 see DBWR trace file ORA-01110: data file 10: ’D:///USERS.DBF’ What is the cause of these errors?()
第19题:
The ORDERS table in the database of a company contains one million records. The table is stored in the DATA tablespace and the index created on the ORDERS table is stored in the index tablespace named INDEXES. On Monday, you failed to start the database because the datafiles of the INDEXES tablespace were missing. You dropped and recreated the INDEXES tablespace by issuing the following command: SQL>DROP TABLESPACE INDEXES INCLUDING CONTENTS; SQL> CREATE TABLESPACE INDEXES DATAFILE ’C:///ORACLE/ORADATA/ORA101t/INDEX01.DBF’ SIZE 50m; After that, you issued the following command to recreate the index: CREATE UNIQUE INDEX sales_index_pk ON sales (order_id) PCTFREE 10 INITRANS 2 MAXTRANS 255 TABLESPACE indexes STORAGE ( INITIAL 1m NEXT 1m PCTINCREASE 0 MINEXTENTS 1 MAXEXTENTS 8192 ) NOLOGGING PARALLEL( degree 4) Which two clauses are responsible for reducing the time for the recreation of the index?()
第20题:
You are planning to deploy two Windows Server 2008 R2 Hyper-V servers. You need to design the storage of VHD files for maximum security. What should you do?()
第21题:
The command must be issued in MOUNT state.
The command succeeds only if the data file is offline.
The command must be issued when the database is in the archivelog mode.
The command succeeds if no extent in the tablespace is currently allocated above the 150 MB boundary of the file.
第22题:
Provide a password for the encryption
Set up an Oracle wallet for the encryption
No setup is required as it is a default encryption method
Both Oracle wallet and password must be set up for the encryption
第23题:
The RMAN parallelizes the backup although the parallelism is not set for a channel.
The backup piece size will be limited to 300 MB.
The operation is accomplished using the default channel available.
Three channels for the tape drive must be configured by setting the parallelism to three.