You are employed as a DBA in an organization. You are informed that the record of EMP_NO 1000 is missing from the SCOTT.EMP table. You are required to identify the user who deleted the record， the SQL statement that will undo the deletion， and the transac

题目

You are employed as a DBA in an organization. You are informed that the record of EMP_NO 1000 is missing from the SCOTT.EMP table. You are required to identify the user who deleted the record， the SQL statement that will undo the deletion， and the transaction ID of the transaction that deleted the employee record. Which feature will you use to perform the tasks？（）

  • A、 Only the Flashback Table
  • B、 Both the Flashback Transaction Query and the Flashback Version Query
  • C、 Only the Flashback Drop
  • D、 Only the Flashback Version
相似考题

1.You are the database administrator for a retail company. The company owns 270 stores. Every month, each store submits approximately 2,000 sales records, which are loaded into a SQL Server 2000 database at the corporate headquarters.A Data Transformation Services (DTS) package transforms the sales records, as they are loaded. The package writes the transformed sales records to the Sales table, which has a column for integer primary key values. The IDENTITY property automatically assigns a key value to each transformed sales record.After loading this month's sales data, you discover that a portion of the data contains errors. You stop loading data, identify the problem records, and delete those records from the database.You want to reuse the key values that were assigned to the records that you deleted. You want to assign the deleted key values to the next sales records you load. You also want to disrupt users' work as little as possible.What should you do?A．Export all records from the Sales table to a temporary table. Truncate the Sales table, and then reload the records from the temporary table.B．Export all records from the Sales table to a text file. Drop the Sales table, and then reload the records from the text file.C．Use the DBCC CHECKIDENT statement to reseed the Sales table's IDENTITY property.D．Set the Sales table's IDENTITY_INSERT property to ON. Add new sales records that have the desired key values.

2. Your database is running in ARCHIVELOG mode. The SCOTT.EMP table belongs to the DATA1 tablespace. The junior DBA erroneously runs a script that executes the following statement：   SQL> DROP TABLE SCOTT.EMP PURGE；   After one hour， you are performing the user managed incomplete recovery. Which datafiles will you restore from the last full backup？（）A、 the datafiles associated with the SYSTEM tablespaceB、 the datafiles associated to the DATA1 tablespaceC、 the datafiles associated to the SYSTEM and DATA1 tablespacesD、 all the datafiles in the database

3. At 5：30 PM， a database administrator， William， is informed that an important record of employee no E0025 is missing from the SCOTT.EMPLOYEE table. At 4：30 P.M， the table contained the record of employee no E0025. William issues the following command to find the SQL statements that are used to undo the deletion：    SELECT operation， undo_sql， logon_user   FROM FLASHBACK_TRANSACTION_QUERY  WHERE xid=   HEXTORAW（’0100043E23456’）；   where ’0100043E23456’ is the transaction ID of the transaction that deleted the row. Before issuing the above statement， which task did William perform to identify the transaction ID of the transaction that deleted the row？（）A、 William used the Flashback Version Query feature.B、 William issued the CROSSCHECK command at the RMAN prompt.C、 William viewed the alert log file.D、 William used the Flashback Table feature.

4.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.

更多“You are employed as a DBA in an organization. You are informed that the record of EMP_NO 1000 is missing from the SCOTT.EMP table. You are required to identify the user who deleted the record， the SQL statement that will undo the deletion， and the transac”相关问题

  • 第1题：

    In which scenario will you use the Flashback Transaction Query feature？（）

    • A、 when you want to restore an important table that is dropped from the Recycle Bin
    • B、 when you want to obtain the SQL statements to undo the deletion of some important records from a table by a transaction
    • C、when you want to restore a dropped user’s schema
    • D、 when a row of a table is updated many times within a specific time period and you want all the versions of the row in the specified time period

    正确答案:B

  • 第2题：

    You created the DEPT table by using the following command：   CREATE TABLE scott.dept   （deptno NUMBER（3），   dname VARCHAR2（15），   loc VARCHAR2（15） ）   STORAGE （INITIAL 100K NEXT 50K  MAXEXTENTS 10 PCTINCREASE 5  FREELIST GROUPS 6 FREELISTS 4）；You are required to shrink the DEPT table. While performing the shrink operation， you want to ensure that the recovered space is returned to the tablespace in which the DEPT table is stored. You do not want to shrink the indexes created on the DEPT table. What will you do to shrink the SCOTT.EMP table？（）

    • A、 Issue the ALTER TABLE SCOTT.DEPT SHRINK SPACE COMPACT； statement.
    • B、 Issue the ALTER TABLE SCOTT.DEPT SHRINK SPACE； statement.
    • C、 Issue the ALTER TABLE SCOTT.DEPT SHRINK SPACE CASCADE； statement.
    • D、 You cannot shrink the SCOTT.EMP table.

    正确答案:D

  • 第3题：

    You are maintaining your database in Oracle10g. You want to store the information about the backup of the database in the control file. You issue the following statement：    SQL>ALTER SYSTEM SET CONTROL_FILE_RECORD_KEEP_TIME=400；    What is the outcome of this statement？ （）

    • A、 The statement will not execute successfully.
    • B、 The statement will execute successfully， and the backups metadata will be maintained in the control file for 400 days
    • C、 The statement will execute successfully， and the backups metadata will be maintained in the recovery catalog for 400 days.
    • D、 Backups will be deleted from the media after 400 days.

    正确答案:A

  • 第4题：

    You need to make structural changes to the cube. You also need to ensure that appropriate aggregations are created after the changes are made. What should you do?（）

    • A、Record a weeks user activity by using SQL Profiler. Apply structural changes. Replay the activity and then run the Usage Based Optimization Wizard.
    • B、Apply structural changes. Run the Database Engine Tuning Advisor.
    • C、Apply structural changes. Run the Usage Based Optimization Wizard.
    • D、Record a weeks user activity by using SQL Profiler. Apply structural changes. Run the Database Engine Tuning Advisor.

    正确答案:A

  • 第5题：

    Your company uses a SQL Server 2005 database. Customer data from your trading partners is imported into the Customers table every night. You need to ensure that the customer record is updated if it already exists in the Customers table. If the record does not exist, the data needs to be inserted into the Customers table. What should you do?（）

    • A、 Create a FOR trigger. 
    • B、 Create an INSTEAD OF trigger. 
    • C、 Create an AFTER trigger. 
    • D、 Create a DDL trigger.

    正确答案:B

  • 第6题：

    You need to record package and task outcome in the ETLAudit table. Which components of SSIS should you use?（）

    • A、Custom event handlers
    • B、Data flow error output
    • C、SSIS log provider for SQL Server
    • D、Execute SQL tasks with failure precedence constraints

    正确答案:A

  • 第7题：

    You have an Exchange Server 2010 organization.The organization is authoritative for the domain contoso.com.You create a federated trust.You need to ensure that federated partners can automatically locate the Client Access servers in the organization. What should you create from an external DNS server？（）

    • A、an A record for autodiscover.contoso.com
    • B、an A record for FederatedSharing.contoso.com
    • C、an SRV record for _autodiscover._TCP._msdcs.contoso.com
    • D、an SRV record for _FederatedSharing._UDP._msdcs.contoso.com

    正确答案:A

  • 第8题：

    单选题
    You are maintaining your database in Oracle10g. You want to store the information about the backup of the database in the control file. You issue the following statement：    SQL>ALTER SYSTEM SET CONTROL_FILE_RECORD_KEEP_TIME=400；    What is the outcome of this statement？ （）
    A

     The statement will not execute successfully.

    B

     The statement will execute successfully， and the backups metadata will be maintained in the control file for 400 days

    C

     The statement will execute successfully， and the backups metadata will be maintained in the recovery catalog for 400 days.

    D

     Backups will be deleted from the media after 400 days.


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

  • 第9题：

    单选题
    Your company uses a SQL Server 2005 database. Customer data from your trading partners is imported into the Customers table every night. You need to ensure that the customer record is updated if it already exists in the Customers table. If the record does not exist, the data needs to be inserted into the Customers table. What should you do?（）
    A

     Create a FOR trigger. 

    B

     Create an INSTEAD OF trigger. 

    C

     Create an AFTER trigger. 

    D

     Create a DDL trigger.


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

  • 第10题：

    单选题
    You created the DEPT table by using the following command：   CREATE TABLE scott.dept   （deptno NUMBER（3），   dname VARCHAR2（15），   loc VARCHAR2（15） ）   STORAGE （INITIAL 100K NEXT 50K  MAXEXTENTS 10 PCTINCREASE 5  FREELIST GROUPS 6 FREELISTS 4）；You are required to shrink the DEPT table. While performing the shrink operation， you want to ensure that the recovered space is returned to the tablespace in which the DEPT table is stored. You do not want to shrink the indexes created on the DEPT table. What will you do to shrink the SCOTT.EMP table？（）
    A

     Issue the ALTER TABLE SCOTT.DEPT SHRINK SPACE COMPACT； statement.

    B

     Issue the ALTER TABLE SCOTT.DEPT SHRINK SPACE； statement.

    C

     Issue the ALTER TABLE SCOTT.DEPT SHRINK SPACE CASCADE； statement.

    D

     You cannot shrink the SCOTT.EMP table.


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

  • 第11题：

    多选题
    From SQL*Plus, you issue this SELECT statement: SELECT* FROM order; You use this statement to retrieve data from a data table for （）.
    A

    Updating

    B

    Viewing

    C

    Deleting

    D

    Inserting

    E

    Truncating


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

  • 第12题：

    单选题
    At 5：30 PM， a database administrator， William， is informed that an important record of employee no E0025 is missing from the SCOTT.EMPLOYEE table. At 4：30 P.M， the table contained the record of employee no E0025. William issues the following command to find the SQL statements that are used to undo the deletion：    SELECT operation， undo_sql， logon_user   FROM FLASHBACK_TRANSACTION_QUERY  WHERE xid=   HEXTORAW（’0100043E23456’）；   where ’0100043E23456’ is the transaction ID of the transaction that deleted the row. Before issuing the above statement， which task did William perform to identify the transaction ID of the transaction that deleted the row？（）
    A

     William used the Flashback Version Query feature.

    B

     William issued the CROSSCHECK command at the RMAN prompt.

    C

     William viewed the alert log file.

    D

     William used the Flashback Table feature.


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

  • 第13题：

    From SQL*Plus, you issue this SELECT statement: SELECT* FROM order; You use this statement to retrieve data from a data table for （）.

    • A、Updating
    • B、Viewing
    • C、Deleting
    • D、Inserting
    • E、Truncating

    正确答案:B,D

  • 第14题：

    At design time, you create a query record group for the LOV associated with the HOTEL text item in a form module for the Travel Planner Application. When is the record group populated?（）

    • A、When the user navigates to the HOTEL item. 
    • B、When the form module successfully compiles. 
    • C、After Form Builder validates the SELECT statement and dismisses the New Record Group dialog box. 
    • D、When the user enters data in the HOTEL item, and the Validate from List property for the HOTEL item is set to YES. 

    正确答案:D

  • 第15题：

    You work as the enterprise exchange administrator at Xxx .Xxx is using Microsoft Exchange Server 2010 as their messaging solution.You have received instructions from the CIO to enable Autodiscover for Internet users by creating a resource record in DNS.What actions must you take？（）

    • A、You must set up recipient filtering.
    • B、You must set up a Host （A）.
    • C、You must use a TXT record.
    • D、You must use a Pointer （PTR） record.
    • E、You must use a Mail exchange （MX） record.

    正确答案:B

  • 第16题：

    You work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a database named Dworks in the instance. You are log shipping the Adventureworks database to a remote SQL Server 2008 instance. The primary SQL Server instance required a restart during the weekend. But you notice that log shipping has stopped working after the weekend. You have to check log shipping of the Adventureworks database and find out the problem. What should you do? （） 

    • A、You should use the EXTENDED_LOGICAL_CHECKS option to execute a DBCC CHECKDB statement on the AdventureWorks database by. 
    • B、You should identify whether the SQL Server Agent is started on the primary server. 
    • C、You should identify whether the AdventureWorks database uses the Simple recovery model. 
    • D、You should identify whether the SQL Server Volume Shadow Copy Service (VSS) Writer is started on the primary server

    正确答案:B

  • 第17题：

    You have an Exchange Server 2010 organization.You need to create a resource record in DNS to support Autodiscover from the Internet.What type of resource record should you create？（）

    • A、Host（A）
    • B、Text（TXT）
    • C、Pointer（PTR）
    • D、Mail exchange（MX）

    正确答案:A

  • 第18题：

    You work as the enterprise exchange administrator at Company.com.The Company.com network consists of a single Active Directory domain named Company.com.Company.com has an Exchange Server 2010 organization.You have received instructions from the CIO to support Autodiscover from the Internet by creating a resource record in DNS.What should you do？（）

    • A、You should consider creating a Host （A） resource record.
    • B、You should consider creating a Text （TXT） resource record.
    • C、You should consider creating a Pointer （PTR） resource record.
    • D、You should consider creating a Mail exchange （MX） resource record.

    正确答案:A

  • 第19题：

    单选题
    In which scenario will you use the Flashback Transaction Query feature？（）
    A

     when you want to restore an important table that is dropped from the Recycle Bin

    B

     when you want to obtain the SQL statements to undo the deletion of some important records from a table by a transaction

    C

    when you want to restore a dropped user’s schema

    D

     when a row of a table is updated many times within a specific time period and you want all the versions of the row in the specified time period


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

  • 第20题：

    单选题
    You are employed as a DBA in an organization. You are informed that the record of EMP_NO 1000 is missing from the SCOTT.EMP table. You are required to identify the user who deleted the record， the SQL statement that will undo the deletion， and the transaction ID of the transaction that deleted the employee record. Which feature will you use to perform the tasks？（）
    A

     Only the Flashback Table

    B

     Both the Flashback Transaction Query and the Flashback Version Query

    C

     Only the Flashback Drop

    D

     Only the Flashback Version


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

  • 第21题：

    单选题
    At design time, you create a query record group for the LOV associated with the HOTEL text item in a form module for the Travel Planner Application. When is the record group deleted?（）
    A

    When the user navigates to the HOTEL item. 

    B

    When the form module successfully compiles. 

    C

    After Form Builder validates the SELECT statement and dismisses the New Record Group dialog box. 

    D

    When the user enters data in the HOTEL item, and the Validate from List property for the HOTEL item is set to YES.


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

  • 第22题：

    单选题
    You are performing the shrink operation on the SCOTT.EMP table. You want to perform the same operation on all dependent objects of the SCOTT.EMP table. What is NOT a prerequisite for the operation？（）
    A

     You must enable the row movement on the SCOTT.EMP table.

    B

     You must define the tablespace of the SCOTT.EMP table for automatic segment space management.

    C

     You must use the CASCADE clause in the ALTER TABLE SHRINK SPACE statement.

    D

     You must use the COMPACT clause in the ALTER TABLE SHRINK SPACE statement.


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

  • 第23题：

    单选题
    Your database is running in ARCHIVELOG mode. The SCOTT.EMP table belongs to the DATA1 tablespace. The junior DBA erroneously runs a script that executes the following statement：   SQL> DROP TABLE SCOTT.EMP PURGE；   After one hour， you are performing the user managed incomplete recovery. Which datafiles will you restore from the last full backup？（）
    A

     the datafiles associated with the SYSTEM tablespace

    B

     the datafiles associated to the DATA1 tablespace

    C

     the datafiles associated to the SYSTEM and DATA1 tablespaces

    D

     all the datafiles in the database


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

相关内容