You are using the control file to maintain information about the database backups that are being performed by Recovery Manager (RMAN).Identify two scenarios is which you must have a recovery catalog. ()(Choose two.) To store the backup information of multiple database。 To restrict the amount of space that is used by the backups。 To maintain a backup for a certain time is set by the CONTROL_FILE_RECORD_KEEP_TIME parameter.。 To list the data files that were in a target database at a given time by using the AT option of REPORT SCHEMA command.。
高温菌和中温菌在低温环境中的代谢能力为什么减弱?
How many individual archive-log destination directories are supported by Oracle Database11g?() 7 。 1 。 10 。 11 。 21。
Identify two situations in which the block header grows in a data block. () when row directories need more row entries。 when there is row migration in the data block。 when there is an increase in the PCTFREE value for the data block。 when more transaction slots are required than are initially configured。
Examine the description of the CUSTOMERS table: CUSTOMER_ID NUMBER(4) NOT NULL CUSTOMER_NAME VARCHAR2(100) NOT NULL STREET_ADDRESS VARCHAR2(150) CITY_ADDRESS VARCHAR2(50) STATE_ADDRESS VARCHAR2(50) PROVINCE_ADDRESS VARCHAR2(50) COUNTRY_ADDRESS VARCHAR2(50) POSTAL_CODE VARCHAR2(12) CUSTOMER_PHONE VARCHAR2(20) The CUSTOMER_ID column is the primary key for the table. Which statement returns the city address and the number of customers in the cities Los Angeles or San Francisco?() SELECT city_address, COUNT(*) FROM customers WHERE city _ address IN ('Los Angeles','San Fransisco');。 SELECT city_address, COUNT (*) FROM customers WHERE city address IN ( 'Los Angeles', 'San Fransisco') GROUP BY city_address;。 SELECT city_address, COUNT(customer_id) FROM customers WHERE city_address IN ( 'Los Angeles', 'San Fransisco') GROUP BY city_address, customer_ id;。 SELECT city_address, COUNT (customer_id) FROM customers GROUP BY city_ address IN ('Los Angeles','San Fransisco')。
Your Oracle Database 10g is online when you execute the following statement:
SQL>ALTER TABLESPACE MY_TABLESPACE FLASHBACK OFF;
What is the result of executing this statement if the Flashback Database feature is already enabled in the database?()