【多选题】A warehouse fact table in your Oracle 12c Database is range-partitioned by month and accessed frequently with queries that span multiple partitions The table has a local prefixed, range partitioned in...
A.
Using a partial local Index on the warehouse fact table month column with indexing disabled to the table partitions that return most of their rows to the queries.
B.
Using a partial local Index on the warehouse fact table month column with indexing disabled for the table partitions that return a few rows to the queries.
C.
Using a partitioned view that does a UNION ALL query on the partitions of the warehouse fact table, which retains the existing local partitioned column.
D.
Converting the partitioned table to a partitioned view that does a UNION ALL query on the monthly tables, which retains the existing local partitioned column
E.
Using a partial global index on the warehouse fact table month column with indexing disabling for the table partitions that return most of their rows to the queries.
F.
Using a partial global index on the warehouse fact table month column with indexing disabled for the table partitions that return a few rows to the queries.
【多选题】You want to create a temporary table named OLD_INVENTORY in the OLD_INVENTORY database on the master server. This table is not to be replicated to the slave server. Which two changes would ensure that...
A.
Use the – replicate-do-db, — replicate-do-table, or – replicate-wild-do-table option with the value equal to OLD_INVENTORY
B.
Change the binlog_format option to ROW and restart mysqld before you create the OLD_INVENTORY table
C.
Stop SQL_THREAD on the slave until you have finished using the OLD_INVENTORY temporary table
D.
Set binlog_format=MIXED with the – replicate-ignore-temp-table option
E.
Use the – replicate-ignore-table option with the value equal to OLD_INENTORY.OLD_INVENTORY and restart mysqld before creating the temporary table
【简答题】Seating a Walk-in Guest 接待未预订客人 J=Jane (Hostess ) S=Stephen Nobel (Guest) J: Good afternoon. Welcome to our hotel. Do you have a 1 ? S: No. I’m 2 we haven’t. Is it 3 for us to have lunch here?...