You need to replicate a table from a master to a slave. The master and slave copies of the table will have different number of columns. Which two conditions must be true?（）A、Each extra column in the copy with more columns must not have a default valueB、C

题目

You need to replicate a table from a master to a slave. The master and slave copies of the table will have different number of columns. Which two conditions must be true?（）

  • A、Each extra column in the copy with more columns must not have a default value
  • B、Columns that are common to both versions of the table must be defined in the same order on the master and the slave
  • C、The slave database cannot have more columns than the master. Only the master database can have more columns
  • D、Columns that are common to both versions of the table must come first in the table definition, before any additional columns are additional columns are defined on either server
  • E、The master database cannot have more columns than the slave. Only the slave deatbase can have more columns
相似考题

1.You need to replicate a table from a master to a slave. The master and slave copies of the table will have different number of columns.Which two conditions must be true?()A.Each extra column in the copy with more columns must not have a default valueB.Columns that are common to both versions of the table must be defined in the same order on the master and the slaveC.The slave database cannot have more columns than the master. Only the master database can have more columnsD.Columns that are common to both versions of the table must come first in the table definition, before any additional columns are additional columns are defined on either serverE.The master database cannot have more columns than the slave. Only the slave deatbase can have more columns

2.You are the administrator of a new multiprocessor SQL Server 2000 computer. You are migrating data from other database management systems to this server. You need to load data from two data files into a new table on the server. The table is empty and has no indexes.You want to complete the data load as quickly as possible. What should you do? (Each correct answer represents part of the solution. Choose all that apply.)A．Apply a bulk update lock to the table.B．Use separate client connections to load the files into the table simultaneously.C．Create a clustered index on the table.D．Specify the Full Recovery model for the database.E．Specify the Bulk-Logged Recovery model for the database.

3.You need to check the EMP_EAST partition in the EMPLOYEES table for physical corruptions. You also need to verify that the rows belong to the correct partition. Which option could you use？（）A、 LogMinerB、 The DBNEWID utilityC、 The DBVERIFY utilityD、 The ANALYZE commandE、 The RMAN REPORT commandF、 The RMAN CROSSCHECK command.G、 The RMAN BLOCKRECOVER command.

4.Examine the structure of the EMPLOYEES table:You need to update the records of employees 103 and 115. The UPDATE statement you specify should update the rows with the values specified below:Which UPDATE statement meets the requirements?（）A.B.C.D.E.

更多“You need to replicate a table f”相关问题

  • 第1题：

    ou need to create a data block for query operations in the RETIRED_EMPLOYEES form module. Which three data sources can you use for this block?（）

    • A、vector 
    • B、database view 
    • C、database table 
    • D、transactional trigger 
    • E、PL/SQL table of records 
    • F、multi-dimensional array

    正确答案:B,C,D

  • 第2题：

    Evaluate the SQL statement: TRUNCATE TABLE DEPT;Which three are true about the SQL statement? （）

    • A、It releases the storage space used by the table.
    • B、It does not release the storage space used by the table.
    • C、You can roll back the deletion of rows after the statement executes.
    • D、You can NOT roll back the deletion of rows after the statement executes.
    • E、An attempt to use DESCRIBE on the DEPT table after the TRUNCATE statement executes will display an error.
    • F、You must be the owner of the table or have DELETE ANY TABLE system privileges to truncate the DEPT table.

    正确答案:A,D,F

  • 第3题：

    Evaluate the SQL statement:TRUNCATE TABLE DEPT;Which three are true about the SQL statement? （）

    • A、It releases the storage space used by the table.
    • B、It does not release the storage space used by the table.
    • C、You can roll back the deletion of rows after the statement executes.
    • D、You can NOT roll back the deletion of rows after the statement executes.
    • E、An attempt to use DESCRIBE on the DEPT table after the TRUNCATE statement executes will display an error.
    • F、You must be the owner of the table or have DELETE ANY TABLE system privileges to truncate the DEPT table

    正确答案:A,D,F

  • 第4题：

    An application uses Windows Azure Table storage. The application uses five tables.  One table used by the application is approaching the limit for storage requests per second.  You need to recommend an approach for avoiding data access throttling.  What should you recommend？（）

    • A、 Use a single partition key for the table.
    • B、 Compress data before storing it in the table.
    • C、 Create additional partition keys for the table.
    • D、 Continually remove unnecessary data from the table.

    正确答案:C

  • 第5题：

    You need to resolve the double counting of transactions issue in the existing reports. What should you do?（）

    • A、Apply a many-to-many relationship between the Transaction measure group and the Person dimension in the WoodgroveSSAS database.
    • B、Apply a Conditional Split transformation in the Transaction data in the SSIS package.
    • C、Delete the AccountHolder table in the WoodgroveDW database.
    • D、Apply a foreign key relationship between the Person table and the Transaction table in the WoodgroveDW database.

    正确答案:A

  • 第6题：

    多选题
    You need to replicate a table from a master to a slave. The master and slave copies of the table will have different number of columns. Which two conditions must be true?（）
    A

    Each extra column in the copy with more columns must not have a default value

    B

    Columns that are common to both versions of the table must be defined in the same order on the master and the slave

    C

    The slave database cannot have more columns than the master. Only the master database can have more columns

    D

    Columns that are common to both versions of the table must come first in the table definition, before any additional columns are additional columns are defined on either server

    E

    The master database cannot have more columns than the slave. Only the slave deatbase can have more columns


    正确答案： B,C
    解析： 暂无解析

  • 第7题：

    多选题
    You administer a SQL Server 2008 instance. You deploy a new database named Engineering. The Engineering database manages large documents that will be revised occasionally. You need to design a table structure that allows fast read access. You also need to minimize storage space requirements.  Which two actions should you perform?（）
    A

    Use NTFS file system compression on the volume.

    B

    Use row-level compression on the document table.

    C

    Use varbinary(MAX) data type with FILESTREAM storage.

    D

    Enable row-level compression on all columns that use the vardecimal() data type.


    正确答案： A,C
    解析： 暂无解析

  • 第8题：

    单选题
    You are configuring the data source for an Oracle database. You will need to specify a test table for WebLogic to test the status of the database. Which option should you choose?（）
    A

    a table name which has 100s of records

    B

    a table name which has 10s of records

    C

    a table name which has empty records

    D

    a table name which has 1000s of records

    E

    never use a table name


    正确答案： D
    解析： 暂无解析

  • 第9题：

    单选题
    You are working in an online transaction processing (OLTP) environment. You use the FLASHBACKTABLE command to flash back the CUSTOMERS table. Before executing the FLASHBACK TABLE command, the system change number (SCN) was 663571. After flashing back the CUSTOMERS table, you realize that the table is not in the correct state. Now, you need to reverse the effects of the FLASHBACK TABLE command. Which is the fastest and the most efficient option to reverse the effects of the FLASHBACK TABLE command?（）
    A

    Restore the backup control file and open the database with RESETLOGS option.

    B

    Perform point-in-time recovery because flashback cannot be performed again on this table

    C

    Execute the FLASHBACK DATABASE statement to retrieve the CUSTOMERS table as it was at SCN 663571

    D

    Execute another FLASHBACK TABLE statement to retrieve the CUSTOMERS table as it was at SCN 663571


    正确答案： A
    解析： 暂无解析

  • 第10题：

    单选题
    You need to check the EMP_EAST partition in the EMPLOYEES table for physical corruptions. You also need to verify that the rows belong to the correct partition. Which option could you use？（）
    A

     LogMiner

    B

     The DBNEWID utility

    C

     The DBVERIFY utility

    D

     The ANALYZE command

    E

     The RMAN REPORT command

    F

     The RMAN CROSSCHECK command.

    G

     The RMAN BLOCKRECOVER command.


    正确答案： D
    解析： 暂无解析

  • 第11题：

    多选题
    You need to design a connection agreement for Active Directory Connector to synchronize directory information with the subsidiary location. Which two actions should you perform？（）
    A

    Configure a one-way connection agreement that replicates from the subsidiary’s Exchange 5.5 organization to Active Directory

    B

    Configure a one-way connection agreement that replicates from Active Directory to the subsidiary’s Exchange 5.5 organization

    C

    Configure two one-way connection agreements that replicate between the subsidiary’s Exchange 5.5 organization and Active Directory

    D

    Configure the connection agreement to replicate all objects

    E

    Configure the connection agreement to replicate only mailboxes

    F

    Configure the connection agreement to save deletions in an LDAP Data Interchange Format file


    正确答案： D,B
    解析： 暂无解析

  • 第12题：

    单选题
    By mistake， you ran the batch job （for updating the BILL_DETAILS table） twice. You are not sure which rows in the BILL_DETAILS table were affected. You need to identify：  a） a list of changes made along with the transaction identifier of each change  b） the necessary SQL statements to undo the erroneous changes  Which option would you choose？（）
    A

    RMAN only

    B

    Flashback Table only

    C

    Flashback Versions Query only

    D

    Flashback Database and Flashback Transaction Query

    E

    Flashback Versions Query and Flashback Transaction Query


    正确答案： D
    解析： 暂无解析

  • 第13题：

    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 the temporary table does not propagate to the slave?（）

    • 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

    正确答案:B,E

  • 第14题：

    You have a range-partitioned table in your database. Each partition in the table contains the sales data for a quarter.  The partition related to the current quarter is modified frequently and other partitions undergo fewer data manipulations. The preferences for the table are set to their default values. You collect statistics for the table using the following command in regular intervals： SQL> EXECUTE  DBMS_STATS.GATHER_TABLE_STATS（’SH’，’SALES’，GRANULARITY=>’GLOBAL’）；   You need statistics to be collected more quickly.  What can you do to achieve this？（）

    • A、 Set DYNAMIC_SAMPLING to level 4
    • B、 Set the STATISTICS_LEVEL parameter to BASIC
    • C、 Set the INCREMENTAL value to TRUE for the partition table
    • D、 Increase the value of STALE_PERCENT for the partition table

    正确答案:C

  • 第15题：

    The EMPLOYEES table is stored in the USERS tablespace. You need to check if the EMPLOYEES table is affected by the block corruption found in the USERS tablespace. Which option would you use？（） 

    • A、the DBNEWID utility
    • B、the ANALYZE command
    • C、the RMAN LIST command
    • D、the RMAN REPORT command
    • E、the RMAN CROSSCHECK command
    • F、the RMAN BLOCKRECOVER command

    正确答案:B

  • 第16题：

    You are transferring records from one database to another. You need to decide whether you can use the SqlBulkCopy class to transfer the records. What should you do? （）

    • A、Ensure that the source database is Microsoft SQL Server.
    • B、Ensure that the destination database is Microsoft SQL Server.
    • C、Ensure that the column names in the source table match the column names in the destination table.
    • D、Ensure that the bulk copy program (bcp) utility is installed on the destination server.

    正确答案:B

  • 第17题：

    You need to design a connection agreement for Active Directory Connector to synchronize directory information with the subsidiary location. Which two actions should you perform？（）

    • A、Configure a one-way connection agreement that replicates from the subsidiary’s Exchange 5.5 organization to Active Directory
    • B、Configure a one-way connection agreement that replicates from Active Directory to the subsidiary’s Exchange 5.5 organization
    • C、Configure two one-way connection agreements that replicate between the subsidiary’s Exchange 5.5 organization and Active Directory
    • D、Configure the connection agreement to replicate all objects
    • E、Configure the connection agreement to replicate only mailboxes
    • F、Configure the connection agreement to save deletions in an LDAP Data Interchange Format file

    正确答案:A,E

  • 第18题：

    单选题
    The EMPLOYEES table is stored in the USERS tablespace. You need to check if the EMPLOYEES table is affected by the block corruption found in the USERS tablespace. Which option would you use？（）
    A

    the DBNEWID utility

    B

    the ANALYZE command

    C

    the RMAN LIST command

    D

    the RMAN REPORT command

    E

    the RMAN CROSSCHECK command

    F

    the RMAN BLOCKRECOVER command


    正确答案： B
    解析： 暂无解析

  • 第19题：

    单选题
    You need to base a data block on the EMP table, but you do not want to give the users of the application access privileges on the table. Which type of data source would you use to create the data block?（）
    A

    table 

    B

    transactional trigger 

    C

    stored procedure 

    D

    FROM clause query


    正确答案： B
    解析： 暂无解析

  • 第20题：

    单选题
    You are working in an online transaction processing （OLTP） environment. You used the FLASHBACK TABLE command to flash back the CUSTOMERS table. Before executing the FLASHBACK TABLE command， the System Change Number （SCN） was 663571. After flashing back the CUSTOMERS table， you realize that the table is not in the correct state and the resultant changes are not what you had desired. So， you need to reverse the effects of the FLASHBACK TABLE command while ensuring that：  a） No other user data in the database is affected.  b） The operation takes the minimum possible time.  Which option would you choose？（）
    A

    use the ROLLBACK command with SCN 663571

    B

    perform Flashback Transaction Query with SCN 663571

    C

    execute the FLASHBACK DATABASE statement to retrieve the CUSTOMERS table as it was at SCN 663571

    D

    execute another FLASHBACK TABLE statement to retrieve the CUSTOMERS table as it was at SCN 663571


    正确答案： B
    解析： 暂无解析

  • 第21题：

    单选题
    Before a Flashback Table operation, you execute the following command: ALTER TABLE employees ENABLE ROW MOVEMENT; Why would you need this to be executed?（）
    A

    Because row IDs may change during the flashback operation

    B

    Because the object number changes after the flashback operation

    C

    Because the rows are retrieved from the recycle bin during the flashback operation

    D

    Because the table is moved forward and back to a temporary during the flashback operation


    正确答案： D
    解析： 暂无解析

  • 第22题：

    单选题
    You are working in an online transaction processing （OLTP） environment. You used the FLASHBACK TABLE command to flash back the CUSTOMERS table. Before executing the FLASHBACK TABLE command， the System Change Number （SCN） was 663571. After flashing back the CUSTOMERS table， you realize that the table is not in the correct state and the resultant changes are not what you had desired. So， you need to reverse the effects of the FLASHBACK TABLE command while ensuring that：  a） No other user data in the database is affected.  b） The operation takes the minimum possible time.  Which option would you choose？（）
    A

     Use ROLLBACK command with SCN 663571.

    B

     Perform Flashback Transaction Query with SCN 663571.

    C

     Execute the FLASHBACK DATABASE statement to retrieve the CUSTOMERS table as it was at SCN 663571.

    D

     Execute another FLASHBACK TABLE statement to retrieve the CUSTOMERS table as it was at SCN 663571.


    正确答案： D
    解析： 暂无解析

  • 第23题：

    单选题
    Before a Flashback Table operation，you execute the following command：   ALTER TABLE employees ENABLE ROW MOVEMENT；   Why would you need this to be executed？（）
    A

     Because row IDs may change during the flashback operation

    B

     Because the object number changes after the flashback operation

    C

     Because the rows are retrieved from the recycle bin during the flashback operation

    D

     Because the table is moved forward and back to a temporary during the flashback opertion


    正确答案： C
    解析： 暂无解析

相关内容