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
第1题:
A user sends you an email with the following error message: create table idtable(id number) * ERROR at line 1: ORA- 01110: data file 4: ,,/oracle01/oradata/orcl/users01.dbf ORA-27041: 01116: error in opening database file 4 ORA-unable to open file Linux Error: 2: No such file or directory Additional information: 3 You can choose from the following steps: a. Restore the missing database datafiles. b. Take the missing datafile offline. c. Shut down the database. d. Issue the recover tablespace USERS command. e. Issue the Startup Mount command to mount the database. f. Bring the USERS tablespace online. g. Issue the alter database open command. Which is the correct order of these steps in this case?()
第2题:
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?()
第3题:
A. The ‘/u01/app/oracle/oradata/orcl/users01.dbf‘ data file is recovered from the image copy
B. The ‘/u01/app/oracle/oradata/orcl/users01.dbf‘ data file is recovered from the last incremental backup
C. Image copies of the ‘/u01/app/oracle/oradata/orcl/users01.dbf‘ data file are updated with all changes up to incremental backup SCN. ‘/ u01/app/oracle/oradata/orcl/users01.dbf
D. Image copies of the ‘/u01/app/oracle/oradata/orcl/users01.dbf‘ data file are recovered using the above command if data file recovery fails
第4题:
View this parameter setting in your database: DB_CREATE_FILE_DEST=’D:// /oracle/product/10.2.0/oradata/oracle’ You created a tablespace by using this command: CREATE TABLESPACE USERS; Which two statements are true about the USERS tablespace?()
第5题:
You executed the following command: RMAN> RECOVER COPY OF DATAFILE '/u01/app/oracle/oradata/orcl/users01.dbf'; Which statement regarding the above command is correct?()
第6题:
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?()
第7题:
You executed the following command: RMAN> RECOVER COPY OF DATAFILE ’/u01/app/oracle/oradata/orcl/users01.dbf’; Which statement regarding the above command is correct?()
第8题:
A database is running in ARCHIVELOG mode and regular backups are performed. A user receives the following error message . Which is the recommended sequence of operations you need to perform for the query successfully?()
第9题:
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?()
第10题:
Examine the commands executed in a DBA session:SQL> CREATE BIGFILE TABLESPACE MRKT 2 DATAFILE ’/u01/app/oracle/oradata/orcl/mrkt.dbf’ size 10M LOGGING 3 EXTENT MANAGEMENT LOCALSEGMENT SPACE MANAGEMENT AUTO; Tablespace created. SQL> ALTER DATABASE DEFAULT TABLESPACE MRKT; Database altered. Which two statements are trueregarding the MRKT tablespace()