You issue this SQL statement: ALTER DATABASE RENAME FILE ’/ORADATA/u02/user_data01.dbf’ TO ’/ORADATA/u04/user_data01.dbf’; What does this SQL statement do?()
相似题目
-
You issue the following command on the RMAN prompt. REPORT NEED BACKUP DAYS 5; Which statement is true about executing this command?()
-
On switch R1 you issue the "udld enable" global command. What does this command accomplish? ()
-
You want to flash back a test database by five hours.You issue this command:SQL > FLASHBACK DATABASE TO TIMESTAMP (SYSDATE - 5/24);Which two statements are true about this flashback scenario?()
-
You issue the following command on the RMAN prompt. REPORT NEED BACKUP DAYS 5; Which statement is true about executing this command?()
-
From SQL*Plus, you issue this SELECT statement: https://assets.asklib.com/images/image2/2018080116203977752.jpg You use this statement to retrieve data from a data table for()。
-
You issued the following statement: SQL>ALTER DATABASE ENABLE RESUMABLE TIMEOUT n; What will be the result of issuing the above statement?()
-
You issued the following statement: SQL> ALTER DATABASE BACKUP CONTROLFILE TO TRACE; What will be the result of issuing the statement?()
-
You issue this statement:ALTER DATABASE BACKUP CONTROLFILE TO TRACE; What does the statement generate?()
-
You need to troubleshoot an issue on the switched LAN. When you issue a command "show port3/1" on a switch, you observe the Giants column has a non-zero entry. What could cause this?()
-
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?()
-
The DBA issues this SQL command: https://assets.asklib.com/images/image2/2018080117142684706.jpg What privileges does the user Scott have at this point?()
-
When issuing the duplicate database command, you use the parameter DB_FILE_NAME_CONVERT. For what purpose do you use this parameter?()
-
The DBA issues this SQL command: CREATE USER scott IDENTIFIES by tiger; What privileges does the user Scott have at this point? ()
-
From SQL*Plus, you issue this SELECT statement: SELECT* FROM order; You use this statement to retrieve data from a data table for ().
-
In a test database, you issue the SELECT … INTO OUTFILE statement to create a file with your t1 table data. You then TRUNCATE this table to empty it.() Mysql> SELECT * INTO OUTFILE '/tmp/t1.sql' from t1; mysql> TRUNCATE t1;
-
You issued the following command on the temporary tablespace LMTEMP in your database: SQL>ALTER TABLESPACE lmtemp SHRINK SPACE KEEP 20M; Which requirement must be fulfilled for this command to succeed?()
-
You want to make sure that your database backup does not exceed 10 hours in length. What command would you issue that would meet this condition?()
-
You issue the following command: RMAN>CONFIGURE BACKUP OPTIMIZATION ON; What is the result of this command on your backups?()
-
In which scenario will you issue the following command?() SQL> RECOVER DATABASE UNTIL TIME ’2005-10-04 : 12:09:08’ USING BACKUP CONTROLFILE;
-
You issue the following RMAN command to set a retention policy on a database: RMAN>CONFIGURE RETENTION POLICY TO REDUNDANCY 2; What will be the outcome of issuing this command?()
-
You issued the following command to drop the PRODUCTS table: SQL> DROP TABLE products; What is the implication of this command?()
-
You issue the following RMAN command to set a retention policy on a database: RMAN>CONFIGURE RETENTION POLICY TO REDUNDANCY 2; What will be the outcome of issuing this command? ()
-
You issued the following command on the temporary tablespace LMTEMP in your database: SQL>ALTER TABLESPACE lmtemp SHRINK SPACE KEEP 20M; Which requirement must be fulfilled for this command to succeed?()
-
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?()