RMAN would use the current operating system location to place the backup.
RMAN would use the control file of the target database to maintain the backup.
RMAN would use the recovery catalog of the target database to maintain the backup.
RMAN would use the control file of the target database to maintain the backup metadata.
RMAN would use the recovery catalog of the target database to maintain the backup metadata.
第1题:
You work as a database administrator for Supportcenter.cn. One of the database users accidentally deleted all the rows of a critical table and committed the delete at 1:30 p.m. You senior database administrator, SupportCenter, asks you to retrieve the lost data. Which two actions would you use to ensure that there is no impact on other connected users while retrieving the deleted rows?()
第2题:
You observe that in your PROD database, customer information is being modified by some unauthorized users. You want to keep track of all of the transactions happening on the table using PL/SQL. Which type of PL/SQL subprogram or construct would you use to accomplish this task?()
第3题:
You work as a database administrator for Supportcenter.cn. You have been asked to use a centralized administrative tool to administer your database servers and application servers. In order to achieve the objective, which component would you configure on each database server?()
第4题:
set the SESSIONS to 1 in the parameter file
grant SINGLE SESSION privilege to all of the users
set the SESSIONS_PER_USER to 1 in the users’ profile
grant RESTRICTED SESSION privilege to all of the database users
create a role with SINGLE SESSION privilege and assign the role to the users
第5题:
You are a professional level SQL Server 2005 database administrator in an international corporation named Wiikigo. You are experienced in implementing high-availability solutions, monitoring the database server, and design deployment. In the company, you major job is the deployment, maintenance and support of Microsoft SQL Server 2005. You work as a database administrator for your company. You utilize the SP:Recompile event class to run SQL Server Profiler. You find that a great amount of recompiles occurring. The possible causes of the large number of recompiles should be identified. From the flowing four options, which one is the most possible cause of the problem?()
第6题:
You have been recently hired as a database administrator. Your senior manager asks you to study the production database server and submit a report on the settings done by the previous DBA. While observing the server settings, you find that the following parameter has been set in the parameter file of the database: REMOTE_OS_AUTHENT = TRUE What could have been the reason to set this parameter as TRUE?()
第7题:
You work as a senior administrator at ABC.com. The ABC.com network consists of a single domain named ABC.com. All servers on the ABC.com network have Windows Server 2012 R2 installed, and all workstations have Windows 8 installed. You are running a training exercise for junior administrators.You are currently discussing the Always Offline Mode. Which of the following is TRUE with regards to the Always Offline Mode?()
第8题:
The database users are connecting to the PROD database from different applications, thereby degrading the database performance. The senior database administrator suspects the large number of concurrent connections to be the reason for low performance and asks you to restrict the number concurrent connections per database user to one. Which action would you take to achieve this objective?()
第9题:
to enable operating system authentication for a remote client
to restrict the scope of administration to identical operating systems
to allow the start up and shut down of the database from a remote client
to enable the administration of the operating system from a remote client
to disable the administration of the operating system from a remote client
第10题:
For the database, you should turn on the TRUSTWORTHY database option
For the database, the PAGE_VERIFY database option should be set to CHECKSUM
For the database, the database compatibility level option should be set to 10
For the model database, the PAGE_VERIFY database option should be set to TORN_PAGE_DETECTION.