首页/ 题库 / [多选题]User SCOTTQ的答案

User SCOTT wants to back out the transactions on the REGIONS table in his schema. As a DBA, which commands must you execute to enable SCOTT to flash back the transactions?()

多选题
2022-01-05 13:28
A、 ALTER DATABASE FLASHBACK ON
B、 GRANT SELECT any transaction TO scott
C、 GRANT EXECUTE ON dbms_flashback TO scott
D、 ALTER DATABASE ADD SUPPLEMENTAL LOG DATA
E、 ALTER TABLESPACE undots1 RETENTION GUARANTEE
F、 ALTER DATABASE ADD SUPPLEMENTAL LOG DATA (PRIMARY KEY) COLUMNS
查看答案

正确答案
B| C| D| F

试题解析

标签: 1Z0-053
感兴趣题目
Your database is in NOARCHIVELOG mode. You start to do a backup, but your users complain that they dont want you to shut down the database to perform the backup. What options are available to you?()  
Jitter is an unwanted variation of one or more characteristics of a periodic signal in electronics and telecommunications and()refers to call issues that cause variations in timing or time of arrival. 
The CALC function is used several times within the sales report. To simplify maintenance you want to store the function in one place and call it from within your PL/SQL trigger code. Which node would you use in object navigator to create a report level programme unit to store the function?()
A customer wants to monitor energy consumption for all of their IBM systems. What part of the IBM Systems Director family supports this function?()
Which step is designed to prompt a user to press or say a single-digit number to perform a specific function? ()
You are the administrator of a Windows 2000 network. You use a user account named User1 to log on to a Windows 2000 Professional computer. Different students in a classroom use this Computer. User does not have administrative rights. However, you prefer to use this account for most of your daily activities, because it is not a security breach if you fail to log off. You want to schedule a task to run a command file named AddUsers.cmd that automatically adds six more student user accounts. What should you do?()

You deploy a new Exchange Server 2010 organization.You send a test message to an external recipient and immediately receive the following nondelivery report (NDR): Delivery has failed to these recipients or groups: [email protected] ([email protected]).
The recipient’s e-mail system isn’t accepting messages now.Please try resending this message later or contact the recipient directly.± You verify that you can succesfully send an e-mail message to [email protected] from an external e-mail system.You need to ensure that you can send e-mails to external recipients from within the Exchange organization.
What should you create?()

An application or user experiences poor performance, yet examination of the nfsstat -c output indicates no or very few timeouts and retransmits. This means that the client is receiving responses from the server as fast as it is asking for them. What is the first thing to be checked?()
A toy manufacturing customer wants to run Microsoft SQL Server. Which category is applicable for such a solution?()
A manufacturing customer has an existing SAN for their AIX servers and they want to add theirWindows servers with file level access to their existing storage pool. Which of the following is thelowest cost solution?()
The George Char Broiler Company wants to create its own locale file to accommodate a non-supported German language among its customers from Brunswick. This is the first locale file the company has tried to create. Which tag number will it assign to this locale?()
You work as a database administrator for Certkiller .com. You want to be notified when the number of disk I/O increases by 10% of what it was yesterday. You create a baseline metric for yesterday’s disk I/O performance. How do you use the baseline metrics to achieve your objective?()
相关题目
Do you want to pay _____ cash or _____ credit card.
Your network contains a server named Server1 that runs Windows Server 2003 Service Pack 2 (SP2).  You create a domain account named Admin1. You need to configure the security for Admin1 to meet the following requirements: Allow Admin1 to monitor events in the system event log and the application event logAllow Admin1 to create and view counter logs in Performance MonitorMinimize the user rights assigned to Admin1 To .which group should you add Admin1?()
A customer wants to install a pSeries system into an OEM rack.  What critical information is provided in the Site and Hardware Planning Information manual?()
You need to relocate the existing user and computer objects in your company to different organizational units. What are two possible ways to achieve this goal()
Which device is normally used to translate telephone numbers or names to IP addresses for call routing in an H.323 network? ()
If a parent organization is not specified when registering a user, which organization will the user be a member of?()
Which router or router combination is used to calculate the MPLS traffic engineering tunnel path?()
Which parameter or parameters are used to calculate OSPF cost in cisco routers?()
An employee named Drew is leaving your company. A new employee named Adam will replace him. Drew has a local user account on a Windows 2000 Professional computer, with rights and permissions to multiple files and folders on the computer. You want Adam to have the same rights and permissions. How will you achieve this with the least administrative efforts? ()
You are shrinking the SCOTT.EMP table by executing the ALTER TABLE SCOTT.EMP SHRINK SPACE CASCADE statement. What is a prerequisite for shrinking the SCOTT.EMP table?()
User SCOTT wants to back out the transactions on the REGIONS table in his schema. As a DBA, which commands must you execute to enable SCOTT to flash back the transactions?()
What will be the result of using the SQL> DROP USER SCOTT CASCADE; command?()
The SCOTT user has an index on the ITEM_DESC column of the ITEM table. As part of the year-ending task, SCOTT updates the ITEM_DESC column for most of the rows in the ITEM table. How does this change to the table affect the index?()
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?()
You are maintaining your database in ARCHIVELOG mode. An important table, SCOTT.EMPLOYEE, is dropped and purged from the Recycle Bin on Monday at 2:00 P.M. You do not use RMAN to perform backups. You performed the last full user-managed backup at 9:00 P.M. on Sunday.  How will you recover the dropped table, SCOTT.EMPLOYEE?()
A user on your network downloads a video card driver from the Internet. You are unsure of the source of the driver. You want to ensure that the user does not lose production time because of an incompatible driver. What should you do?()
You are the administrator of your company's network. You attempt to install a printer driver on a Windows 2000 computer for a user named Linda. You receive the following error message: “Error 11-Cannot install printer driver.” The driver was originally downloaded from the printer manufacturer’s Web site. You have successfully used the driver in the past on their Windows 2000 Professional computers. You want to configure Linda’s computer to check for driver integrity and to allow you to install this printer driver. What should you do? ()
You are the administrator of your company’s network. A user name Andrew has limited dexterity, which prevents him from using standard keyboard when completing his daily tasks. You configure Windows 2000 Professional to use sticky keys and screen keyboard options. You save the accessibility options to a shared folder on the local hard disk of Andrews’s computer. You want to configure the same options for another user Peter. You log on to Peter’s computer using his local user account and you access the folder over the network from Peter’s computer. You select the .acw file from the shared folder to set up Peter’s computer to use the accessibility option. You receive an error message as follows: " There was a problem running the file when running the accessibility wizard". What should you do to install the accessibility features on Peter’s computer?()
A user calls to report they are getting I/O errors on a file system. Which of the following tools should be used to isolate this problem?()
A remote user is trying to telnet to the production server. The session is getting a timeout error. Which command should the user issue to verify the network connection?()
广告位招租WX:84302438

免费的网站请分享给朋友吧