You query the ORDERS table and discover that order number 1101 is missing. One of your reports， generated at 5：00 A.M. on April 23， 2005 using Oracle Reports， includes this order number in the output. You have inserted 100 new orders into the ORDERS table

题目

You query the ORDERS table and discover that order number 1101 is missing. One of your reports， generated at 5：00 A.M. on April 23， 2005 using Oracle Reports， includes this order number in the output. You have inserted 100 new orders into the ORDERS table since generating this report. Which flashback technology would you use to recover order number 1101 into the ORDERS table without losing the 100 orders that you added after the report was generated？（）  

  • A、 Flashback Table
  • B、 Flashback Query
  • C、Flashback Version Query
  • D、 Flashback Transaction Query
相似考题

1.You have an SQL query that takes one minute to execute. You use the following code segment to execute theSQL query asynchronously.Dim ar As IAsyncResult = cmd.BeginExecuteReader()You need to execute a method named DoWork() that takes one second to run while the SQL query is executing.DoWork() must run as many times as possible while the SQL query is executing.Which code segment should you use?（）A.B.C.D.

2.Which MySQL utility program should you to process and sort the slow Query log based on query time or average query time?()A.MysqlaccessB.MysqldumpC.MysqlshowD.MysqlslowE.Mysqldumpslow

3.You want to use the Flashback Transaction Query feature to identify all the changes made to your database within a specific time period. What is a prerequisite for using the Flashback Transaction Query feature？（）A、 You must use automatic undo management in the database.B、 You must configure OMF in your database.C、 You must configure ASM for storing the datafiles.D、 You must multiplex the online redo log file.

4.You define a multiple－row subquery in the WHERE clause of an SQL query with a comparison operator "=". What happens when the main query is executed? ()A. The main query executes with the first value returned by the subquery.B. The main query executes with the last value returned by the subquery.C. The main query executes with all the values returned by the subquery.D. The main query fails because the multiple-row subquery cannot be used with the comparison operator.E. You cannot define a multiple-row subquery in the WHERE clause of a SQL query.

更多“You query the ”相关问题

  • 第1题：

    You are maintaining your OLTP database in Oracle10g. You are performing the Flashback Transaction Query to find the undo SQL statements that can be used to undo the changes made to the database in the specific time period. Which pseudocolumn will you use to perform the Flashback Transaction Query？（）

    • A、 VERSIONS_STARTSCN
    • B、 VERSIONS_STARTTIME
    • C、 VERSIONS_XID
    • D、 VERSIONS_OPERATION

    正确答案:C

  • 第2题：

    You define a multiple-row subquery in the WHERE clause of an SQL query with a comparison operator "=".What happens when the main query is executed?（）

    • A、The main query executes with the first value returned by the subquery.
    • B、The main query executes with the last value returned by the subquery.
    • C、The main query executes with all the values returned by the subquery.
    • D、The main query fails because the multiple-row subquery cannot be used with the comparison operator.
    • E、You cannot define a multiple-row subquery in the WHERE clause of a SQL query.

    正确答案:D

  • 第3题：

    Which MySQL utility program should you to process and sort the slow Query log based on query time or average query time?（）

    • A、Mysqlaccess
    • B、Mysqldump
    • C、Mysqlshow
    • D、Mysqlslow
    • E、Mysqldumpslow

    正确答案:E

  • 第4题：

    You have a DNS server named Server1 that runs Windows Server 2003 Service Pack 2 （SP2）. You create a primary zone on Server1 for contoso.com.You run the DNS simple query test and recursive query test. The simple query test completes successfully， but the recursive query test fails.You need to ensure that the recursive query test can complete successfully.  What should you do on Server1？（）

    • A、Clear the cache.
    • B、Disable recursion.
    • C、Enable access to the Internet.
    • D、Configure a reverse lookup zone.

    正确答案:C

  • 第5题：

    You are the network administrator for The network consists of a single Active Directory domain named The functional level of the domain is Windows Server 2003. Some user accounts have expiring passwords and some do not. You need to identify all user accounts that do not have expiring passwords. You need to modify the password property to allow the passwords on these accounts to expire. You must complete this task by using the minimum amount of administrative effort. First, you create a saved query to obtain a list of all user accounts that do not have expiring passwords. What should you do next?（）

    • A、Export the query results to a comma-delimited file. Use a CSVDE script to modify the password property of each user account.
    • B、From the Results pane of the query, select all user accounts and modify their password properties simultaneously.
    • C、Export the query results to a comma-delimited file. Use an LDIFDE script to modify the password property of each user account.
    • D、From the Results pane of the query, select each user account and modify the password property, one by one.

    正确答案:B

  • 第6题：

    单选题
    You want to use the Flashback Transaction Query feature to identify all the changes made to your database within a specific time period. What is a prerequisite for using the Flashback Transaction Query feature？（）
    A

     You must use automatic undo management in the database.

    B

     You must configure OMF in your database.

    C

     You must configure ASM for storing the datafiles.

    D

     You must multiplex the online redo log file.


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

  • 第7题：

    单选题
    Which MySQL utility program should you to process and sort the slow Query log based on query time or average query time?（）
    A

    Mysqlaccess

    B

    Mysqldump

    C

    Mysqlshow

    D

    Mysqlslow

    E

    Mysqldumpslow


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

  • 第8题：

    单选题
    You remotely monitor several domain controllers.   You run winrm.exe quickconfig on each domain controller.   You need to create a WMI script query to retrieve information from the bios of each domain controller.   Which format should you use to write the query（）
    A

    XrML

    B

    XML

    C

    WQL

    D

    HTML


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

  • 第9题：

    单选题
    Your network contains an Active Directory domain. The domain contains four domain controllers.  You modify the Active Directory schema.  You need to verify that all the domain controllers received the schema modification.     Which command should you run（）
    A

    dcdiag.exe /a

    B

    netdom.exe query fsmo

    C

    repadmin.exe /showrepl *

    D

    sc.exe query ntds


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

  • 第10题：

    单选题
    You need to resolve the blocking issue that is affecting the performance of the CRM system. What should you do?（）
    A

    Replace the named query with an SQL view.

    B

    Set the transaction isolation level to serializable in the named query.

    C

    Set the source database to use snapshot isolation.

    D

    Set the transaction isolation level to repeatable read in the named query.


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

  • 第11题：

    单选题
    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
    解析： 暂无解析

  • 第12题：

    单选题
    You are required to flashback your database. You want to find the amount of flashback data generated since the database was opened. Which task will you perform to obtain the required information？（）
    A

     Query the V$FLASHBACK_DATABASE_LOG view.

    B

     Query the V$FLASHBACK_DATABASE_STAT view.

    C

     Check the value of the DB_FLASHBACK_RETENTION_TARGET initialization parameter.

    D

     Query the V$RECOVERY_FILE_DEST view.


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

  • 第13题：

    You are required to flashback your database. You want to find the amount of flashback data generated since the database was opened. Which task will you perform to obtain the required information？（）

    • A、 Query the V$FLASHBACK_DATABASE_LOG view.
    • B、 Query the V$FLASHBACK_DATABASE_STAT view.
    • C、 Check the value of the DB_FLASHBACK_RETENTION_TARGET initialization parameter.
    • D、 Query the V$RECOVERY_FILE_DEST view.

    正确答案:B

  • 第14题：

    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 Version Query only.
    • D、 Flashback Database and Flashback Transaction Query.
    • E、 Flashback Version Query and Flashback Transaction Query.

    正确答案:E

  • 第15题：

    You are a database administrator for your company. The company uses a vendor company’s application that is based on a proprietary database. You query data from the application database and import the data into a SQL Server 2005 database. The application vendor provides you with a new OLE DB driver to be used when querying the application database. Company policy prohibits connections between the SQL Server database and the application database， except when querying this data. You need to provide a way to query data from the application database. What should you？（）

    • A、Configure a Linked Server connection to the application database.
    • B、Write a query that uses an OPENDATASOURCE command.
    • C、Write a query that uses an OPENQUERY command.
    • D、Configure a Remote Server connection to the application database.

    正确答案:B

  • 第16题：

    You are the DNS administrator for Adventure Works. Adventure Works is an Internet service provider （ISP） that hosts Web sites for many companies.  Each Adventure Works DNS server hosts multiple DNS zones for customers. Several Adventure Works administrators are allowed to add DNS zones. You want to produce a weekly report that will list all the zones that are hosted on each DNS server.  What should you do？（）

    • A、Use the dnslint utility to query each DNS server.
    • B、Use the dnscmd utility to query each DNS server.
    • C、Use the nslookup utility to query each DNS server.
    • D、Use the adsiedit utility to query Active Directory for a list of DNS zones.

    正确答案:B

  • 第17题：

    单选题
    You are maintaining your OLTP database in Oracle10g. You are performing the Flashback Transaction Query to find the undo SQL statements that can be used to undo the changes made to the database in the specific time period. Which pseudocolumn will you use to perform the Flashback Transaction Query？（）
    A

     VERSIONS_STARTSCN

    B

     VERSIONS_STARTTIME

    C

     VERSIONS_XID

    D

     VERSIONS_OPERATION


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

  • 第18题：

    单选题
    You need to create a data block for DML operations in the NEW_EMPLOYEE form module. Which data source can you use for this block?（）
    A

    REF cursor query. 

    B

    Stored function. 

    C

    From clause query. 

    D

    Transactional trigger.


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

  • 第19题：

    单选题
    You created a tabular report for the sales department to display each customer and the sales person assign to the customer. The data is sorted by customer using the order by clause in this query. This is department manager asks you to alter the report so that data is sorted by sales person rather than by customer. What is the best way to make the needed change?（）
    A

    Recreate the query and default the layout. 

    B

    Alter the query, default the layout and redo the boiler plates. 

    C

    Query and manually change the layout to save the boiler plate. 

    D

    Alter the query and make no further change.


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

  • 第20题：

    单选题
    You are creating an online catalog application that will display product information on the company Web site. The product data is stored in a SQL Server 2005 database. The data is stored as relational data but must be passed to the application as an XML document by using FOR XML. You test your application and notice that not all of the items matching your query appear in the XML document. Only those products that have values for all elements in the schema appear.   You need to modify your Transact-SQL statement so that all products matching your query appear in the XML document. What should you do？（）
    A

    Add an XML index to the table that contains the product data.

    B

    Add the XSINIL argument to the ELEMENTS directive in the query.

    C

    Add a HAVING clause to the query.

    D

    Add the replace value of clause to the query.


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

  • 第21题：

    单选题
    You have many users complaining about slow inserts into a large table. While investigating the reason， you find that the number of indexes on the table is high. You want to find out which indexes are not being used.  Which method would you follow to achieve this？（）
    A

    enable index monitoring and query the DBA_OBJECTS view

    B

    enable index monitoring and query the DBA_INDEXES view

    C

    enable index monitoring and query the V$OBJECT_USAGE view

    D

    enable index monitoring and view the DBA_INDEXTYPE_COMMENTS view


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

  • 第22题：

    单选题
    View the Exhibits. You performed operations on the DEPT4 table as shown in the Exhibit. When you perform the FlashbackVersions Query， you find that the first two updates are not listed. What could be the reason？（）
    A

    The row movement is not enabled on the table.

    B

    The first two updates were not explicitly committed.

    C

    The Flashback Versions Query lists only the most recent update.

    D

    The Flashback Versions Query stops producing rows after it encounters a time in the past when the  table structure was changed.


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

  • 第23题：

    单选题
    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 Version Query only.

    D

     Flashback Database and Flashback Transaction Query.

    E

     Flashback Version Query and Flashback Transaction Query.


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

相关内容