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?（

题目

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
相似考题

1.You create a Web application for your company‘s intranet. You want to enable users to customize their versions of the intranet home page. You create sections of content as Web Parts. You need to ensure that users can customize content at any time.Which two code segments should you use?（）A.B.C.D.

2.You are the administrator of a SQL Server 2000 computer in your company's personnel department. Employee data is stored in a SQL Server 2000 database. A portion of the database schema is shown in the exhibit.You want to create a text file that lists these data columns in the following format title, FirstName, LastName, WorkPhone, PositionName, DepartmentName.You want to create the text file as quickly as possible. You do not expect to re-create this file, and you want to avoid creating new database objects if possible.What should you do?A．Use the bcp utility to export data from each table to a separate text file. Use format files to select the appropriate columns. Merge the data from each text file into a single text file.B．Create a view that joins data from all three tables include only the columns you want to appear in the text file. Use the bcp utility to export data from the view.C．Create a SELECT query that joins the data from the appropriate columns in the three tables. Add an INTO clause to the query to create a local temporary table. Use the bcp utility to export data from the local temporary table to a text file.D．Create a SELECT query that joins the data from the appropriate columns in the three tables. Add an INTO clause to the query to create a global temporary table. Use the bcp utility to export data from the global temporary table to a text file.

3.You are the administrator of a SQL Server 2000 computer. Your company uses the server to store service contract information for its customers.You are also the administrator of Oracle relational database management system (RDBMS) server.This server is used to store your company’s financial information. The financial information is updated frequently throughout the day.You need to create a series of reports that combine the service contract information and the financial information. These reports will be updated several times a day.You want to create reports on the SQL Server computer by using the minimum amount of disk space.What should you do?A．Set up SQL server replication to replicate the data from the oracle server to the SQL server computer.B．Set up the oracle server as a linked server. Create a view that joins the service contract information and the financial information.C．Set up data transformation services (DTS) package that imports and transforms the database from the oracle server to the SQL server computer. Use SQL server agent to execute the DTS package throughout the day as needed.D．Set up Microsoft ActiveX script. that connects to the oracle server and imports the financial information into SQL server temporary table. Create a view that joins the service contract information and the temporary table.

4.You are the administrator of a SQL Server 2000 computer. You are creating a data transformation services package. As the first step in this process, you need to load data from text files into a database table. These text files contain data on new stores that join your franchise. The text files list the data columns in the following format StoreID, StoreName, Address, City, State, PostalCode, ManagerID, StoreTypeID, FacilityID.The destination table is configured as shown in the exhibit.You want to load the data into the table as quickly as possible. What should you do?A．Use a Bulk Insert Task to read the data into a temporary table. Use an Execute SQL task to import the appropriate data into the destination table.B．Create and edit a format file to select the columns you want to import. Use a Bulk Insert Task, and then specify the format file to import the appropriate data into the destination table.C．Use a transform. data task to import the data. Use Microsoft ActiveX transformation scripts to write the appropriate data to the appropriate columns in the destination table.D．Create and edit a format file to select the columns you want to import. Use a transform. data task, and then specify the format file to import the appropriate data into the destination table.

更多“You want to create a temporary ”相关问题

  • 第1题：

    In which three cases would you use the USING clause?（）

    • A、You want to create a nonequijoin.
    • B、The tables to be joined have multiple NULL columns.
    • C、The tables to be joined have columns of the same name and different data types.
    • D、The tables to be joined have columns with the same name and compatible data types.
    • E、You want to use a NATURAL join, but you want to restrict the number of columns in the join condition.

    正确答案:C,D,E

  • 第2题：

    You lost a temporary file that belongs to the default temporary tablespace in your database. From the options provided， which approach would you take to solve the problem？ （）

    • A、flash back the database
    • B、import the temporary tablespace from the last export
    • C、restore all the data files and temporary files from the last full database backup and perform a recovery
    • D、not perform a recovery， but create a new temporary tablespace， make it the default temporary tablespace and then drop the old tablespace

    正确答案:D

  • 第3题：

    You want to create a new optimized database for your transactional production environment to be used by a financial application. While creating the database， you want the Oracle software to take care of all basic settings to optimize the database performance. Which method would you use to achieve this objective？（）

    • A、Use the CREATE DATABASE .. command to create the database with Oracle-managed files. 
    • B、Use the Database Configuration Assistant (DBCA) to create the database with Oracle-managed files. 
    • C、Use Enterprise Manager to create a new database with the Online Transaction Processing (OLTP) option. 
    • D、Use Database Configuration Assistant (DBCA) to create the database with Transaction Processing template. 
    • E、Use the CREATE DATABASE .. command to create the database with Automatic Storage Management (ASM) file system.

    正确答案:D

  • 第4题：

    You want to create a shortcut to a folder named Project on a network share. You want this shortcut to be available when you are not connected to the network. You attempt to configure the shortcut to be available offline. However， you do not see any option， which will let you do so. What should you do？（）

    • A、Use Windows Explorer to enable caching for the Project folder.
    • B、Use Windows Explorer to configure the Project folder on the network share with the full  control permission for your user account.
    • C、Connect to the network before trying to make the shortcut available offline
    • D、Create shortcuts to each file in the Project folder and make the shortcuts to the files available  offline. 

    正确答案:A

  • 第5题：

    You have just added three new hard disks to your Windows 2000 Professional computer. You want to configure all of the disks as two drives. You want the two drives to be as equal in size as possible. You want to configure the non-system drive for the best optimal performance.  What should you do?（）

    • A、Extend the system volume onto disk1. Create a single, stripe volume from disk2 and disk3.
    • B、Extend the system volume onto disk2. Create a single, stripe volume from disk1 and disk2
    • C、Extend the system volume onto disk1. Create a single, spanned volume from disk2 and disk3. 
    • D、Extend the system volume onto disk1. Create a single, spanned volume from disk1 and disk2.
    • E、Create a single, stripe volume from disk1, disk2, and disk3. 
    • F、Create a single spanned volume from disk1, disk2, and disk3. 

    正确答案:A

  • 第6题：

    You are the administrator of a Windows 2000 domain. You develop a graphics software application for users in the Graphics organizational unit （OU）. You want to create a custom installation for three users named Carlos， Carmen， and Maria， who are members of the Graphics OU. You want these three users to be able to access additional text， filters， and other graphics options for the software. What should you do？ （）

    • A、 Create the Graphic Users OU in the domain. Add a custom .msi file to the Graphics OU
    • B、 Create the Graphic Users OU in the domain. Add a custom .mst file to the Graphics OU
    • C、 Create the Advanced Software OU within the Graphics OU, and add Carlos, Carmen, and  Maria.Create an .msi file, including changes, and apply the modifications to the Advanced Software OU
    • D、 Create the Advanced Software OU within the Graphics OU, and add Carlos. Carmen, and Maria. Create an: mst file, including changes, and apply the modifications to the Advanced Software OU

    正确答案:D

  • 第7题：

    You work with a SQL Server 2005 database that provides banking information for customers. You want customers to see banking reports that combine data that is retrieved from the database with real-time investment information that comes from a Web service provided by a third party. The investment information must be current when the reports are executed. You need to create the appropriate objects that support the reports. What should you do？（）

    • A、Publish the data in the database as an XML Web service by using the FOR XML AUTO clause.
    • B、Create a table to store the banking information for each customer. Create a trigger that fires when data is inserted into the table that joins with the data coming from the Web service.
    • C、Create a Transact-SQL stored procedure that uses a temporary table to store the banking information for each customer. Update the table with the values from the Web service.
    • D、Have a developer in TestKing.com create an assembly that calls the remote Web service.Create a CLR function by using the assembly. Call the CLR function and combine the results with banking information in the database.

    正确答案:D

  • 第8题：

    单选题
    While creating a database using Database Configuration Assistant tool， you created a database default temporary tablespace. Which activity would cause the default temporary tablespace of the database to be used？（）
    A

    the CREATE TABLE .. command

    B

    sorting of the SYSTEM tablespace’s data

    C

    sorting of data required by recursive SQL statements

    D

    the CREATE TABLE .. ORGANIZATION EXTERNAL .. command

    E

    sorting of data if the users have not been allocated temporary tablespace explicitly

    F

    sorting of data if the users have been allocated temporary tablespace explicitly


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

  • 第9题：

    单选题
    You are developing a tax report for the payroll application. You created a before parameter form report trigger to create three temporary tables to store text that are need while the report is executed. Which report trigger would you use to delete these temporary tables?（）
    A

    Before parameter form. 

    B

    After parameter form. 

    C

    Before report. 

    D

    After report.


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

  • 第10题：

    问答题
    Practice 6　　● Your department needs to employ some temporary staff.　　● Write an email to the Human Resources Manager:　　● saying how many staff you need and giving the date you want them to start　　● explaining why you need them　　● stating what skills they should have　　● Write 40—50 words.

    正确答案： 【参考范文】
    To: Human resource manager
    From: J. Darcy
    Subject: Temporary staff needed
    Dear Sir,
    As you know, the number of orders will increase a great deal as it always does before the Spring Festival and we are short of hands for packaging. Seven people are needed before the end of this weekend there will be no special requirements for skills.
    Thanks.
    Best regards
    解析： 暂无解析

  • 第11题：

    单选题
    You are the network administrator for Company. You have been assigned the task to create and deploy a standard Windows 2000 Professional image to all 2,500 client computers that today are installed with Windows 98. You log on to a client computer called Company by using a local administrative account called SetupUser and install three Windows 2000 professional compatible software packages on Company. You create an image using third party software. You deploy the image to a test client computer and join the client computer to a domain. You want to create shortcuts on all users' desktops for the software packages you installed. You also want users to have the option to delete the icons.  Which profile must you edit?（）
    A

    The SetupUser profile

    B

    The Default User profile

    C

    The Administrator profile

    D

    The System profile

    E

    The All Users profile


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

  • 第12题：

    单选题
    You have three temporary tablespace groups named G1, G2, and G3 in your database. You are creating a new temporary tablespace as follows: CREATE TEMPORARY TABLESPACE TEMP1 TEMPFILE /u1/data/temp1.dbf SIZE 10M TABLESPACE GROUP ;Which statement regarding the above command is correct?（）
    A

    It will create the tablespace TEMP1 in group G1

    B

    It will create the tablespace TEMP1 in group G3 

    C

    It will not add the tablespace TEMP1 to any group

    D

    It will create the tablespace TEMP1 in the default group

    E

    It will throw an error with message 'specified group is not available

    F

    It will create a new group with a system-generated name and add the tablespace TEMP1 to it.


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

  • 第13题：

    What are two reasons to create synonyms?（）

    • A、You have too many tables.
    • B、Your tables are too long.
    • C、Your tables have difficult names.
    • D、You want to work on your own tables.
    • E、You want to use another schema's tables.
    • F、You have too many columns in your tables.

    正确答案:B,C

  • 第14题：

    You completed the development of a new application and want to create a new domain in a new environment for functional testing. You want to have the same settings for your new domain as your old domain, with the option of changing the configuration in the new target environment. Which two actions should you execute?（）

    • A、Use the introspect () command in WLST to gather the configuration information from the  original domain.
    • B、Use pack/unpack to transfer the domain from one machine to another.
    • C、Create a domain template from the original domain using the Domain Template Builder and use  the Configuration Wizard to create a new domain from the template.
    • D、Use the Admin Console of the original domain to create a domain template from the original  domain and use the Configuration Wizard to create a new domain from the template.

    正确答案:C

  • 第15题：

    While setting up the database for your production environment， you want to create a user with following requirements.   1.The objects created by the user must be stored in a tablespace， TBS1， if the  TABLESPACE option is not defined during the object creation.   2.The user should be able to use 10MB of space in the tablespace TBS1.   3.The user must change the password immediately after logging in for the first time.   Which three options of the CREATE USER command would you use to achieve this objective？（）

    • A、profile
    • B、account lock
    • C、account unlock
    • D、password expire
    • E、quota 10MB on TBS1
    • F、password never expire
    • G、default tablespace TBS1
    • H、quota unlimited on TBS1
    • I、temporary tablespace TEMP
    • J、temporary tablespace SYSTEM

    正确答案:D,E,G

  • 第16题：

    You are a network administrator of your network. You want to install Windows 2000 professional on 100 computers from a central location. You want to copy a customized application with theinstallation process to all the 100 computers.  What should you do to copy that application during the installation process to the computers.（）

    • A、 It cannot be done.
    • B、 Copy the application to the temp folder of the distribution server.
    • C、 Create a folder named $OEM$ as a sub folder in the distribution folder of  source files.
    • D、 Create a folder named $COPYDIR$ as a sub folder in the distribution folder of source files.

    正确答案:C

  • 第17题：

    You are designing a Windows Azure application that will use a worker role. The worker role will create temporary files.  You need to recommend an approach for creating the temporary files that minimizes storage transactions.  What should you recommend？（）

    • A、 Create the files on a Windows Azure Drive.
    • B、 Create the files in Windows Azure local storage.
    • C、 Create the files in Windows Azure Storage page blobs.
    • D、 Create the files in Windows Azure Storage block blobs.

    正确答案:B

  • 第18题：

    You work as an IT support specialist. Your job responsibilities include managing server storage. You aredesigning storage for a new application server. The application makes heavy use of temporary storage， andyou want to allocate three 20-GB disk drives to that storage. If excellent read and write performance is ahigh priority，and you also want to use as much available space as possible，which of the following volumetypes should you create？（）

    • A、Simple volume
    • B、Spanned volume
    • C、Mirrored volume
    • D、Striped volume
    • E、RAID-5 volume

    正确答案:D

  • 第19题：

    You are creating a view to join the Customers and Orders tables in a SQL Server 2005 database. You need to ensure that the view cannot be affected by modifications to underlying table schemas. You want to accomplish this goal by using the least possible amount of overhead. What should you do?（）

    • A、Create CHECK constraints on the tables. 
    • B、Create a DDL trigger to roll back any changes to the tables if the changes affect the columns in the view. 
    • C、Create the view, specifying the WITH SCHEMABINDING option. 
    • D、Create the view, specifying the WITH CHECK option. 

    正确答案:C

  • 第20题：

    单选题
    You are the administrator of a Windows 2000 domain. You develop a graphics software application for users in the Graphics organizational unit （OU）. You want to create a custom installation for three users named Carlos， Carmen， and Maria， who are members of the Graphics OU. You want these three users to be able to access additional text， filters， and other graphics options for the software. What should you do？ （）
    A

     Create the Graphic Users OU in the domain. Add a custom .msi file to the Graphics OU

    B

     Create the Graphic Users OU in the domain. Add a custom .mst file to the Graphics OU

    C

     Create the Advanced Software OU within the Graphics OU, and add Carlos, Carmen, and  Maria.Create an .msi file, including changes, and apply the modifications to the Advanced Software OU

    D

     Create the Advanced Software OU within the Graphics OU, and add Carlos. Carmen, and Maria. Create an: mst file, including changes, and apply the modifications to the Advanced Software OU


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

  • 第21题：

    单选题
    You want to create a temporary table while executing a procedure in a form. Which statement is true?（）
    A

    You cannot create a table form within Forms. 

    B

    You must use the FORMS_DDL built-in to create the table. 

    C

    You must use the DBMS_DYNAMIC_DDL package to create the table. 

    D

    You can write the CREATE TABLE statement directly into the trigger.


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

  • 第22题：

    单选题
    You are designing a Windows Azure application that will use a worker role. The worker role will create temporary files.  You need to recommend an approach for creating the temporary files that minimizes storage transactions.  What should you recommend？（）
    A

     Create the files on a Windows Azure Drive.

    B

     Create the files in Windows Azure local storage.

    C

     Create the files in Windows Azure Storage page blobs.

    D

     Create the files in Windows Azure Storage block blobs.


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

  • 第23题：

    单选题
    You have three temporary tablespace groups named G1, G2, and G3 in your database. You are creating a new temporary tablespace as follows: CREATE TEMPORARY TABLESPACE TEMP1 TEMPFILE '/u1/data/temp1.dbf' SIZE 10M TABLESPACE GROUP ''; Which statement regarding the above command is correct?（）
    A

    It will create the tablespace TEMP1 in group G1.

    B

    It will create the tablespace TEMP1 in group G3.

    C

    It will not add the tablespace TEMP1 to any group.

    D

    It will create the tablespace TEMP1 in the default group.


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

相关内容