网友您好, 请在下方输入框内输入要搜索的题目:

题目内容 (请给出正确答案)

You discover that your Recycle Bin contains two tables with the same name, MY_TABLE. You also have a table named MY_TABLE in your schema.You execute the following statement: FLASHBACK TABLE my_table TO BEFORE DROP RENAME TO my_table2; What will be the result of executing this statement?()

  • A、One of the tables is recovered from the Recycle Bin using a First In First Out (FIFO) approach.
  • B、One of the tables is recovered from the Recycle Bin using a Last In First Out (LIFO) approach.
  • C、Both the tables are recovered from the Recycle Bin with one table renamed to MY_TABLE2 and the other to a system-generated name.
  • D、None of the tables are recovered from the Recycle Bin, and the statement returns an error.

参考答案

更多 “ You discover that your Recycle Bin contains two tables with the same name, MY_TABLE. You also have a table named MY_TABLE in your schema.You execute the following statement: FLASHBACK TABLE my_table TO BEFORE DROP RENAME TO my_table2; What will be the result of executing this statement?()A、One of the tables is recovered from the Recycle Bin using a First In First Out (FIFO) approach.B、One of the tables is recovered from the Recycle Bin using a Last In First Out (LIFO) approach.C、Both the tables are recovered from the Recycle Bin with one table renamed to MY_TABLE2 and the other to a system-generated name.D、None of the tables are recovered from the Recycle Bin, and the statement returns an error.” 相关考题
考题 The questions will help you to discover whether the interviewee( 被接见者) has all the necessary abilities and qualities to match your____ picture of the ideal person for the job. A、mentalB、localC、stationD、asleep

考题 Examine the output of the query that you executed to list the objects in the recycle bin:You verified that no table named SALES_TAB exists in the schema. Then you executed the following command to purge the objects in the recycle bin:SQL PURGE TABLE sales_tab;What would be the outcome of this command?()A. All three tables in the recycle bin are purgedB. Only the table with the oldest DROPSCN is purgedC. The command returns an error because multiple entries with the same name exist in the recycle binD. Only the table with the latest DROPSCN is purged

考题 You discover audit log entries that report attempts to log on to your computer. You need to be notified of all logon attempts that occur on your computer.What should you do?() A.AB.BC.CD.D

考题 You enable the Windows Sidebar feature on your computer. You discover that you are unable to access the desktop icons that appear beneath the Windows Sidebar feature. You need to access these desktop icons.What are two possible ways to achieve this goal?()A.AB.BC.CD.DE.E

考题 You share your computer with other users. You install a new Microsoft add-on to view videos on the computer. You discover that this add-on conflicts with existing add-ons that other users frequently require.You need to ensure that you are able to view videos without affecting other users.What should you do?()A.AB.BC.CD.D

考题 You connect your computer to a wireless network. You discover that this new connection fails to show in the Connect to a network window.You need to view this connection in the Connect to a network window.What should you do?()A.AB.BC.CD.D

考题 You install a new hardware router that provides wireless network connectivity between your computer and the Internet. You connect to the router by using a wireless network adapter.Your computer is able to access the Internet but is unable to discover other computers in the local wireless network.You need to configure the wireless connection to allow your computer to discover other computers.What should you do?()A.AB.BC.CD.D

考题 You are working as a DBA at NetFx Corporation. You discover that the SCOTT schema is deleted by mistake. You decide to flash the database back to the time when the schema existed. Which view will you query to determine the estimated size of the flashback data that you require for your current target retention?()A、 V$FLASHBACK_DATABASE_LOGB、 V$FLASHBACK_DATABASE_STATC、 V$DATABASED、 V$UNDOSTAT

考题 As soon as you discover that you have lost an online redo log, if the database is still functioning, what should be your first action?()  A、 Shut down the databaseB、 Clear the online redo logC、 Back up the databaseD、 Checkpoint the databaseE、 Call Oracle support

考题 In which scenario will you perform a user-managed incomplete recovery?()A、 when a table is dropped and stored in the Recycle BinB、when a table is dropped and purged from the Recycle BinC、 when you are required to recover an existing table to its previous stateD、 when you are required to view all the versions of a row of an existing table between a specific time period

考题 Which two statements are correct regarding the Oracle Flashback Drop feature? ()A、 Recycle bin exists for the tables only in non-SYSTEM, locally managed tablespaces.B、 You can flash back a dropped table provided row movement has been enabled on the table.C、 If you drop an index before dropping its associated table, then the recovery of the index is not supported when you flash back the dropped table.D、 When you execute the DROP TABLESPACE? INCLUDING CONTENTS command, the objects in the tablespace are places in the recycle bin.E、 When a dropped table is moved to the recycle bin, only the table is renamed to a system-generated name; its associated objects and constraints are not renamed.F、 If you drop a table that is protected by the recycle bin, then associated bitmap-joined indexes and materialized view logs are also stored in the recycle bin.

考题 Your database is using shared server configuration. Which optional memory structure would you configure to store the User Global Area (UGA) information and improve the shared pool performance?()A、large poolB、streams poolC、keep buffer cacheD、recycle buffer cache

考题 You are maintaining your database in Oracle10g. On Tuesday at 8:00 A.M., while starting the database, you discover that all the control files are missing. The backup of the full database was performed on Sunday at 6:00 P.M. Which type of recovery will you perform?()A、 incomplete recoveryB、 complete recoveryC、 recovery using the Flashback Database featureD、 recovery using the export/import utility

考题 You discover audit log entries that report attempts to log on to your computer. You need to be notified of all logon attempts that occur on your computer.  What should you do?()A、Enable the Problem Reporting feature for all users.B、Configure a custom view to monitor failed logon events on your computer.C、Use the Computer Management console to connect to your computer from another computer and monitor the audit logs.D、In the Event Viewer window, attach a task to a failed logon event. Configure this task to send an e-mail message to your e-mail account.

考题 Your network contains a single Active Directory domain. The functional level of the forest is Windows  Server 2008 R2.   You need to enable the Active Directory Recycle Bin.   What should you use()A、the Dsmod toolB、the Enable-ADOptionalFeature cmdletC、the Ntdsutil toolD、the Set-ADDomainMode cmdlet

考题 After restarting your Windows 2000 Professional Computer, your Monitor shows a blank blue screen without text and your Computer will does respond to keyboard or mouse commands. You discover that an incorrect driver was just installed. How should you correct the problem? ()A、Use the "Last Known Good Configuration" to restart you system and correct the problem.B、There is nothing you can do. Reinstall the Operating System.C、Call the manufacturer to request a Windows 2000 compatible driver.D、Use the Emergency-Repair-Disk.

考题 You are maintaining a Microsoft ASP.NET Web Application that was created by using the Microsoft .NET Framework version 3.5.  You obtain the latest version of the project from the source control repository. You discover that an assembly reference is missing when you attempt to compile the project on your computer. You need to compile the project on your computer.  What should you do?()A、Add a reference path in the Property Pages of the project to the location of the missing assembly. B、Add a working directory in the Property Pages of the project to the location of the missing assembly. C、Change the output path in the Property Pages of the project to the location of the missing assembly. D、Delete the assembly reference. Add a reference to the missing assembly by browsing for it on your computer. 

考题 单选题You are working as a DBA at NetFx Corporation. You discover that the SCOTT schema is deleted by mistake. You decide to flash the database back to the time when the schema existed. Which view will you query to determine the estimated size of the flashback data that you require for your current target retention?()A  V$FLASHBACK_DATABASE_LOGB  V$FLASHBACK_DATABASE_STATC  V$DATABASED  V$UNDOSTAT

考题 单选题You discover that your Recycle Bin contains two tables with the same name, MY_TABLE. You also have a table named MY_TABLE in your schema. You execute the following statement:   FLASHBACK TABLE my_table TO BEFORE DROP RENAME TO my_table2;   What will be the result of executing this statement?()A  One of the tables is recovered from the Recycle Bin using a First In First Out (FIFO) approach.B  One of the tables is recovered from the Recycle Bin using a Last In First Out (LIFO) approach.C  Both the tables are recovered from the Recycle Bin with one table renamed to MY_TABLE2 and the other to a system-generated name.D  None of the tables are recovered from the Recycle Bin, and the statement returns an error.

考题 单选题Your x86-based server will not boot Solaris 10 OS. You discover that you need to restore your pboot and boot block on the / (root) slice located on disk c0d0. You first boot off of the CD-ROM or DVD into single user mode.  What commands should you run to restore the pboot and boot block on the slice?()A AB BC CD D

考题 单选题On Monday, you dropped the DEPT table from your schema and then you re-created the DEPT table in your schema. On Wednesday, you have a requirement to restore the DEPT table from the recycle bin. Which statement is correct?()A  You cannot restore the DEPT table by using the Oracle Flashback Drop feature because a table with the name DEPT already exists in your schema.B  You can restore the DEPT table by using the Oracle Flashback Drop feature, provided you use the RENAME TO clause.C  You cannot restore the DEPT table by using the Oracle Flashback Drop feature because the contents of the recycle bin are purged every 12 hours by default.D  You can restore the DEPT table by using the Oracle Flashback Drop feature and a system-generated name will be assigned to the restored table.

考题 单选题Your network contains a single Active Directory domain. The functional level of the forest is  Windows Server 2008 R2.   You need to enable the Active Directory Recycle Bin.     What should you use()A the Dsmod toolB the Enable-ADOptionalFeature cmdletC the Ntdsutil toolD the Set-ADDomainMode cmdlet

考题 单选题You discover that your Recycle Bin contains two tables with the same name, MY_TABLE. You also have a table named MY_TABLE in your schema.You execute the following statement: FLASHBACK TABLE my_table TO BEFORE DROP RENAME TO my_table2; What will be the result of executing this statement?()A One of the tables is recovered from the Recycle Bin using a First In First Out (FIFO) approach.B One of the tables is recovered from the Recycle Bin using a Last In First Out (LIFO) approach.C Both the tables are recovered from the Recycle Bin with one table renamed to MY_TABLE2 and the other to a system-generated name.D None of the tables are recovered from the Recycle Bin, and the statement returns an error.

考题 单选题After restarting your Windows 2000 Professional Computer, your Monitor shows a blank blue screen without text and your Computer will does respond to keyboard or mouse commands. You discover that an incorrect driver was just installed. How should you correct the problem? ()A Use the Last Known Good Configuration to restart you system and correct the problem.B There is nothing you can do. Reinstall the Operating System.C Call the manufacturer to request a Windows 2000 compatible driver.D Use the Emergency-Repair-Disk.

考题 单选题On Monday, you dropped the DEPT table from your schema and then you re/x7fcreated the DEPT table in your schema. On Wednesday, you have a requirement to restore the DEPT table from the recycle bin. Which statement is correct?()A You can restore the DEPT table by using the Oracle Flashback Drop feature, provided you use the RENAME TO clause.B You can restore the DEPT table by using the Oracle Flashback Drop feature and a system­generated name will be assigned to the restored table.C You cannot restore the DEPT table by using the Oracle Flashback Drop feature because a table withthe name DEPT already exists in your schema.D You cannot restore the DEPT table by using the Oracle Flashback Drop feature because the contents of the recycle bin are purged every 12 hours by default.

考题 单选题You install a new hardware router that provides wireless network connectivity between your computer and the Internet. You connect to the router by using a wireless network adapter. Your computer is able to access the Internet but is unable to discover other computers in the local wireless network.  You need to configure the wireless connection to allow your computer to discover other computers.  What should you do?()A Configure the network category of your wireless network connection to Private.B Configure the network category of your wireless network connection to Public.C Configure the TCP/IP packet filtering on the wireless network connection.D Configure the wireless network connection with the appropriate authentication to the router.

考题 单选题A user reports that their computer suddenly will not boot. When the technician arrives, they discover that the user is very worried they will not be able to complete a research paper theyve been working on which is due by the end of the day. Which of the following is an appropriate response to the users concerns? ()A A Trojan may have infected the OS or worked its way into the MBR. What did you download recently that caused the problem?B I understand your concern, and will try to have your computer working again as quickly as possible so that you can finish your report.C If the paper was so important to you, you should have created a backup copy so you could finish it on another computer.D I do not understand why you are upset. I am sure your professor will understand and you will be able to turn in the paper tomorrow.

考题 单选题As soon as you discover that you have lost an online redo log, if the database is still functioning, what should be your first action?()A  Shut down the databaseB  Clear the online redo logC  Back up the databaseD  Checkpoint the databaseE  Call Oracle support