单选题You recently created a database and configured the SPFILE with the following parameter settings to ensure that Oracle automatically adjusts the memory for the Program Global Area （PGA）： SORT_AREA_SIZE = 150M HASH_AREA_SIZE = 150M BITMAP_MERGE_AREA_SIZE = 150M CREATE_BITMAP_AREA_SIZE = 150M WORKAREA_SIZE_POLICY = AUTO You have not included the PGA_AGGREGATE_TARGET initialization parameter in the SPFILE and the System Global Area （SGA） is currently sized at 4G. What is the total PGA memory allocated across all database server processes？（）A 10MB 400MC 600MD 800M
单选题
You recently created a database and configured the SPFILE with the following parameter settings to ensure that Oracle automatically adjusts the memory for the Program Global Area （PGA）： SORT_AREA_SIZE = 150M HASH_AREA_SIZE = 150M BITMAP_MERGE_AREA_SIZE = 150M CREATE_BITMAP_AREA_SIZE = 150M WORKAREA_SIZE_POLICY = AUTO You have not included the PGA_AGGREGATE_TARGET initialization parameter in the SPFILE and the System Global Area （SGA） is currently sized at 4G. What is the total PGA memory allocated across all database server processes？（）
A
10M
B
400M
C
600M
D
800M
参考解析
解析：
暂无解析
相关考题：
After you have restored and recovered a database to a new host by using a previously performed Recovery Manager (RMAN) backup, which is the best option you would consider for the new database?() A. Opening the database in RESTRICTED modeB. Opening the database with the RESETLOGS optionC. Setting a new DBID for the newly restored databaseD. Restoring the server parameter file (SPFILE) to the new host
In your database, the flash recovery area (FRA) is configured as the default for RMAN backups. You executed the following commands to configure the settings in RMAN:Which statement is true about the outcome?（）A. Only one channel is allocated and the backup is created in the flash recovery areaB. Only one channel is allocated and the backup is created in the destination specified for channelC. Two channels are allocated and backup sets are created in the destinations specified for channels 1 and 2D. Three channels are allocated and backup sets are created in the destinations specified for channels 1, 2, and FRA
You plan to use static database registration for a new listener when you create it.What could be the two reasons for this？（）A、More than one database is to be registered with the listener.B、The users will connect the database by using the host naming method.C、The Oracle Enterprise Manager is to be used to monitor an Oracle9i database.D、The database that is to be registered with the listener is configured in shared server mode.E、The listener is not configured on the default port of 1521 and the instance is not configured to register with a nondefault port.
You work as a database administrator for Supportcenter.cn. When you tried to connect to the database， you received the following error： ERROR： ORA-12541：TNS：no_listener You found that the listener is not running on the server， so you issued the following command in the Listener Control utility to start the listener. lsnrctlSTART What statement is true？（）A、It would attempt to start the default listenerB、It would start the most recently created listener.C、It would display an error with a message asking for the listener name to be specified.D、It would show you a list of listeners and prompts for the listener name that you want to start.
If you lost your entire database，including the database spfile，control files，online redo logs，and database datafiles，what kind of recovery would be required with RMAN？（） A、 Complete database recovery.B、 Incomplete database recovery.C、 Approximate database recovery.D、 Archived database recovery.E、 The database could not be recovered with RMAN.
You are managing an Oracle Database 11g database. You configured the database to run in ARCHIVELOGmode. Which two statements are true in this scenario（）A、You must shut down the database instance to perform the backups.B、You must configure the Flash Recovery Area （FRA） for the database.C、You can perform complete database backups without closing the database.D、All the previous closed database backups including control files become invalid after you configure thedatabase to ARCHIVELOG mode.
You recently created a database and configured the SPFILE with the following parameter settings to ensure that Oracle automatically adjusts the memory for the Program Global Area （PGA）： SORT_AREA_SIZE = 150M HASH_AREA_SIZE = 150M BITMAP_MERGE_AREA_SIZE = 150M CREATE_BITMAP_AREA_SIZE = 150M WORKAREA_SIZE_POLICY = AUTO You have not included the PGA_AGGREGATE_TARGET initialization parameter in the SPFILE and the System Global Area （SGA） is currently sized at 4G. What is the total PGA memory allocated across all database server processes？（） A、 10MB、 400MC、 600MD、 800M
Which statements regarding the server parameter file （SPFILE） are true（）A、An SPFILE is a binary file.B、An SPFILE cannot reside on a client.C、An SPFILE cannot contain static parameters.D、An SPFILE can store changes persistently across instance restarts.E、An SPFILE can be read by the database server， but it is not written to by the server.F、An SPFILE must be created manually， before creating a database， even if you use the DatabaseConfiguration Assistant （DBCA） to create the database
Your database is running in ARCHIVELOG mode,and the database is open. You execute an RMAN backup and specify the KEEP clause.Which components are backed up when this option is specified?（）A、only the control file, the current SPFILE, and data filesB、only the current SPFILE and data files if autobackup is disabledC、only the data files and the archived redo logsD、the control file, current SPFILE file, data files, and archived redo logs
You work as a network Exchange administrator at Company.com.The Company.com network currently consists of a single Active Directory forest containing a single site named KingSite1.The Company.com organization makes use of Microsoft Exchange Server 2010 as their messaging solution.Company.com has recently configured the mailbox server as members of a database availability group （DAG） with a public folder database. During the course of the business week you receive instruction from Company.com to create a new Active Directory site and install Exchange server in the site whilst ensuring the public folders are stored on servers in both sites. What should you do？（）A、You should consider having clustered continuous replication （CCR） configured on two servers in the new site.You should then have the replication settings for all public folder databases modified.B、You should consider having the standby continuous replication （SCR） configured on a server in the new site.You should then have the Enable-StorageGroupCopy cmdlet run from a server in the new site.C、You should consider having a public folder database created on a server in the new site.You should then have the replication settings for all public folders modified.D、You should consider having a public folder database created on a server in the new site.You should then have the set-DatabaseAvailabilityGroup cmdlet run from a server in the new site.
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 an internal application which uses Analysis Services and Reporting Services. You use the application on the basis of SQL Server 2008. According to the requirement of company security policy, the surface area for all the deployed components of SQL Server 2008 should be configured. You have to implement the security policy and devise a method to evaluate the security policy against other database servers. What should you do?（） A、You should create policies based on the appropriate facets. Apply the policies against a server group. The server group includes the database servers that need to be configured B、You should create a Transact-SQL script based on the sp_configure stored procedure. Use a configuration server to run the script against a server group that includes the database servers that need to be configured C、You should edit the RSReportServer.config configuration file. Distribute the file to all database servers that need to be configured D、You should analyze your database servers by using the SQL Server Best Practices Analyzer (BPA). Implement the recommendations of the BPA
多选题You plan to use static database registration for a new listener when you create it.What could be the two reasons for this？（）AMore than one database is to be registered with the listener.BThe users will connect the database by using the host naming method.CThe Oracle Enterprise Manager is to be used to monitor an Oracle9i database.DThe database that is to be registered with the listener is configured in shared server mode.EThe listener is not configured on the default port of 1521 and the instance is not configured to register with a nondefault port.
单选题You have created a baseline metric， DISK_IO_BL， for the disk I/O metrics in your PROD database and you have been getting notifications whenever the database performance degrades. You optimize the database I/O to gain the performance and you decide to remove the baseline metrics. Which method would you use to remove the DISK_IO_BL baseline metrics？（）AThe baseline， once created， cannot be removed.BDisable the baseline metrics in the Database Control Manage Metrics page.CThe baseline will be automatically removed once the database performance has been optimized.DDrop the baseline metrics by usingDBMS_WORKLOAD_REPOSITORY.DROP_BASELINE procedure.
单选题You work as a database administrator for Certkiller .com. When you tried to connect to the database， you received the following error： ERROR： ORA-12541：TNS：no_listener You found that the listener is not running on the server， so you issued the following command in the Listener Control utility to start the listener. lsnrctlSTART What statement is true？（）AIt would attempt to start the default listenerBIt would start the most recently created listener.CIt would display an error with a message asking for the listener name to be specified.DIt would show you a list of listeners and prompts for the listener name that you want to start.
单选题Your database is running in ARCHIVELOG mode,and the database is open. You execute an RMAN backup and specify the KEEP clause.Which components are backed up when this option is specified?（）Aonly the control file, the current SPFILE, and data filesBonly the current SPFILE and data files if autobackup is disabledConly the data files and the archived redo logsDthe control file, current SPFILE file, data files, and archived redo logs
单选题You recently created a database and configured the SPFILE with the following parameter settings to ensure that Oracle automatically adjusts the memory for the Program Global Area （PGA）： SORT_AREA_SIZE = 150M HASH_AREA_SIZE = 150M BITMAP_MERGE_AREA_SIZE = 150M CREATE_BITMAP_AREA_SIZE = 150M WORKAREA_SIZE_POLICY = AUTO You have not included the PGA_AGGREGATE_TARGET initialization parameter in the SPFILE and the System Global Area （SGA） is currently sized at 4G. What is the total PGA memory allocated across all database server processes？（）A 10MB 400MC 600MD 800M
单选题You work as a network Exchange administrator at Company.com.The Company.com network currently consists of a single Active Directory forest containing a single site named KingSite1.The Company.com organization makes use of Microsoft Exchange Server 2010 as their messaging solution.Company.com has recently configured the mailbox server as members of a database availability group （DAG） with a public folder database. During the course of the business week you receive instruction from Company.com to create a new Active Directory site and install Exchange server in the site whilst ensuring the public folders are stored on servers in both sites. What should you do？（）AYou should consider having clustered continuous replication （CCR） configured on two servers in the new site.You should then have the replication settings for all public folder databases modified.BYou should consider having the standby continuous replication （SCR） configured on a server in the new site.You should then have the Enable-StorageGroupCopy cmdlet run from a server in the new site.CYou should consider having a public folder database created on a server in the new site.You should then have the replication settings for all public folders modified.DYou should consider having a public folder database created on a server in the new site.You should then have the set-DatabaseAvailabilityGroup cmdlet run from a server in the new site.
单选题You are using RMAN to backup your ARCHIVELOG mode database. You have enabled control-file autobackups. Which files are not backed up during the RMAN backup?（）ADatabase Datafiles BDatabase Control Files COnline redo logsDArchived redo logs EThe database SPFILE FNone of the above, all these files are backed up.
单选题After you have restored and recovered a database to a new host by using a previously performed Recovery Manager （RMAN） backup， which is the best option you would consider for the new database？（）A Opening the database in RESTRICTED modeB Opening the database with the RESETLOGS optionC Setting a new DBID for the newly restored databaseD Restoring the server parameter file （SPFILE） to the new host
单选题You are managing an Oracle Database 10g database that uses Oracle Managed Files （OMF）. You enabled the block change tracking feature for the database. Which statement regarding the change tracking file is true？（）A One block change tracking file is created for each data file. By default， the file is created in DB_CREATE_FILE_DEST.B One block change tracking file is created for each data file. By default， the file is created in BACKGROUND_DUMP_DEST.C One block change tracking file is created for the database. By default， the file is created in DB_CREATE_FILE_DEST.D One block change tracking file is created for the database. By default， the file is created in BACKGROUND_DUMP_DEST.
单选题You are a Database Administrator with TXGlobal. You use a password file to establish remote connections to the HR database on the server located at the home office. Currently， two active remote sessions exist to this database. These sessions were established using the SYSDBA privilege from the remote machines. You accidentally deleted the password file. What will be the consequence of this action？（）A Both the sessions will be killed， and no new sessions will be created using the SYSDBA or SYSOPER privilege.B Both the sessions will remain active， but no new sessions will be created using the SYSDBA or SYSOPER privilege.CBoth the sessions will be killed， but new sessions will be created using the SYSDBA or SYSOPER privilege when the database restarts.D The database will crash， and no new sessions will be created using the SYSDBA or SYSOPER privilege when the database restarts.
单选题You work as a database administrator for Supportcenter.cn. Your database is configured for automatic undo management. UNDO_RETENTION is set to 3 hours. You want to flash back a table that was created last year. How far back can the flashback query go？（）A3 hoursB6 monthsCuntil last yearDuntil last commitEuntil the point when the undotablespacewas refreshedFuntil the database is shut down and the memory erased
单选题Your database is running in ARCHIVELOG mode， and the database is open. You execute an RMAN backup and specify the KEEP clause. Which components are backed up when this option is specified？（）A only the control file， the current SPFILE， and data filesB only the current SPFILE and data files if autobackup is disabledC only the data files and the archived redo logsD the control file，current SPFILE file，data files，and archived redo logs
单选题If you lost your entire database，including the database spfile，control files，online redo logs，and database datafiles，what kind of recovery would be required with RMAN？（）A Complete database recovery.B Incomplete database recovery.C Approximate database recovery.D Archived database recovery.E The database could not be recovered with RMAN.
单选题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 the administrator of a SQL Server 2005 computer， and the computer is called SQL1. There are two databases on the SQL1， and the two databases are respectively named Production and DW. A new database named Staging is created. When the data are moving from the Production database into the DW database， the Staging database is utilized temporarily to store and manipulate data. Since you are the database administrator， you are required to make sure the points listed below. First， the tables should not be removed from the Staging database. Second， any attempts to have tables migrated should be logged. Third， your solution should not impact on other databases. Which action should be performed to achieve the goal？（）ATo achieve the goal， a DML trigger on each table should be created to prevent deletion of data.BTo achieve the goal， a DDL trigger should be created， and that the ON DATABASE parameter is utilized by DDL trigger for the Staging database.CTo achieve the goal， an event notification should be created to fire when the TRUNCATE TABLE Transact-SQL statement is submitted to the Staging database.DTo achieve the goal， a DDL trigger should be created， and the ON ALL SERVER parameter is utilized by the DDL trigger.
单选题How can you make a shared server-side initialization parameter file available to all instances of a Real Application Clusters database？（）AInclude an SPFILE parameter in each instance-specified initialization file.BCreate an SPFILE copy on each client from which the instance will be started.CStore the SPFILE in a raw partition with a vendor-specifies location and name.DUse a single client to start the instances and create the SPFILE on this client.
多选题Which statements regarding the server parameter file （SPFILE） are true（）AAn SPFILE is a binary file.BAn SPFILE cannot reside on a client.CAn SPFILE cannot contain static parameters.DAn SPFILE can store changes persistently across instance restarts.EAn SPFILE can be read by the database server， but it is not written to by the server.FAn SPFILE must be created manually， before creating a database， even if you use the DatabaseConfiguration Assistant （DBCA） to create the database
单选题After you have restored and recovered a database to a new host by using a previously performed Recovery Manager (RMAN) backup, which is the best option you would consider for the new database?（）AOpening the database in RESTRICTED modeBOpening the database with the RESETLOGS optionCSetting a new DBID for the newly restored databaseDRestoring the server parameter file (SPFILE) to the new host