网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
You are working as a Database Administrator. Despite having a password in the data dictionary as change_on_install， you always log on to the database MYNEWDB using operating system authentication. Your organization is planning to recruit two junior-level DBAs. You decide to enable remote authentication in your database so that the new DBAs can log on to the database from their workstations to carry out administrative tasks. To allow the new DBAs to perform the administrative tasks， you create a password file on the database server using the following command： ORAPWD file=d：/oracle/ora9i/orapwU01 password=admin entries=4 After creating the password file， you remove the operating system authentication and change the value of the REMOTE_LOGIN_PASSWORDFILE parameter to EXCLUSIVE. You also create a net service name as MYNEWDB that allows the new DBAs to connect to the database server from their workstations using this net service name. Which command must you use to connect to the database to start it？（）
A
CONNECT / AS SYSDBA
B
CONNECT sys/admin AS SYSDBA
C
CONNECT sys/admin@mynewdb AS SYSDBA
D
CONNECT sys/change_on_install AS SYSDBA
参考答案
参考解析
解析：
暂无解析
更多 “单选题You are working as a Database Administrator. Despite having a password in the data dictionary as change_on_install， you always log on to the database MYNEWDB using operating system authentication. Your organization is planning to recruit two junior-level DBAs. You decide to enable remote authentication in your database so that the new DBAs can log on to the database from their workstations to carry out administrative tasks. To allow the new DBAs to perform the administrative tasks， you create a password file on the database server using the following command： ORAPWD file=d：/oracle/ora9i/orapwU01 password=admin entries=4 After creating the password file， you remove the operating system authentication and change the value of the REMOTE_LOGIN_PASSWORDFILE parameter to EXCLUSIVE. You also create a net service name as MYNEWDB that allows the new DBAs to connect to the database server from their workstations using this net service name. Which command must you use to connect to the database to start it？（）A CONNECT / AS SYSDBAB CONNECT sys/admin AS SYSDBAC CONNECT sys/admin@mynewdb AS SYSDBAD CONNECT sys/change_on_install AS SYSDBA” 相关考题
考题
You are working on an Oracle Database 10g database. You enabled the Flashback Database feature. Which two statements regarding flashback logs are true？ （）A、 Flashback logs are not archived.B、 Flashback logs are maintained in redo log files.C、 Flashback logs are maintained in the Flash Recovery Area.D、 Flashback logs are used to maintain Flashback Database related errors.E、 Flashback logs need to be cleared manually after you disable Flashback Database.
考题
You are working on the APPDB database as a DB A. The database has a default Flashback Data Archive DFLA1 created on it. You issued the following command to drop the Flashback Archive FLA1： DROP FLASHBACK ARCHIVE fla1； What is the effect of this command？（）A、 The Flashback Archive FLA1 is dropped only if it is empty.B、 The tablespace having Flashback Archive is dropped.C、 The Flashback Archive FLA1 is dropped after moving the existing data in it to the default Flashback Archive.D、 The Flashback Data Archive and historical data are dropped.
考题
You are working on the 24X7 database with high transaction volume， to ensure faster instance recovery on your database you set the FAST_START_MTTR_TARGET initialization parameter to a very low value. What effect it will have on the database？（）A、The database performance would be enhanced.B、The redo log files would be get filled more frequently.C、The overall database performance would be degraded.D、The mean time to recover （MTTR） would be increased.
考题
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 are working on a database that must be functioning 24 hours a day， 7 days a week. The databaseis configured in ARCHIVELOG mode. Which two options do you have for performing user-managed backups（）A、You can perform consistent backups only.B、You can perform a complete database backup without shutting down the database instance.C、You can back up data files only when all data files have the same SCN recorded in the control file.D、You can back up only those data files whose headers are frozen by using ALTER TABLESPACE BEGINBACKUP or ALTER DATABASE BEGIN BACKUP commands.
考题
In which two cases would you perform only consistent backup？（）A、You are working on a database where downtime is not tolerated.B、You are working on a database where downtime can be tolerated.C、You are working on a database that operates in ARCHIVELOG mode.D、You are working on a database that operates in NOARCHIVELOG mode.E、You are working on a database where all the tablespaces are locally managed.F、You are working on a database where control files and redo log files are multiplexed.G、You are working on a database where control files and redo log files are not multiplexed.
考题
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？（）A、to enable operating system authentication for a remote clientB、to restrict the scope of administration to identical operating systemsC、to allow the start up and shut down of the database from a remote clientD、to enable the administration of the operating system from a remote clientE、to disable the administration of the operating system from a remote client
考题
You are working on an Oracle Database 10g database. Because of data loss， you decided to perform a Flashback Database operation using the following command： SQL FLASHBACK DATABASE TO TIMESTAMP（SYSDATE ？5/24）； Which two statements are true？ （）A、 SYSDATE should not be used with TIMESTAMP.B、 The database must have multiplexed redo log files.C、 The database must be in the MOUNT state to execute the command.D、 The database must be opened with the RESETLOGS option after the flashback operation.E、 The entire database needs to be restored from the most recent backup before the flashback operation.
考题
You are working on a database， where you have three redo log groups. When the database is down for a backup， an operating system （OS） user deletes all the redo log files in a group. What will happen when you open your database？（）A、 The instance starts， the database is mounted， but efforts to open the database fail， and an error about the missing redo log group is displayed.B、 Before the instance starts， you receive an error about the missing redo log files of a group.C、 The instance starts and the database opens with an error message written to the alert log file.D、 The instance starts and the database opens because two redo log groups still exist.E、 The instance starts and the database opens， but every attempt to write to redo log files fails with an error.
考题
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 as a network Exchange administrator at Company.com.The Company.com network currently consists of a single Active Directory forest containing a single domain named Company.com.The Company.com organization makes use of Microsoft Exchange Server 2010 as their messaging solution.During the course of the business week you receive instruction from Company.com to view the replication status of a mailbox database copy in the organization. What should you do？（）A、You should consider having the properties of the database copy viewed from the Exchange Management Console （EMC）.B、You should consider having the properties of the Mailbox server viewed from the Exchange Management Console （EMC）.C、You should consider having the Test-ServiceHealth cmdlet run from the Exchange Management Shell.D、You should consider having the Get-DatabaseAvailabilityGroup cmdlet run from the Exchange Management Shell.
考题
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 domain named Company.com.The Company.com organization makes use of Microsoft Exchange Server 2010 as their messaging solution.The Company.com organization currently makes use of a computer named -ex01 which hosts a mailbox database named kingdatabase which contains 25 user mailboxes.during the course of the business week you receive instruction from Company.com to create a new public folder database named kingpublic whilst ensuring you configure kingpublic as the default public folder database for each mailbox on -ex01.What should you do？（）A、you should consider having the properties of -ex01 modified.B、You should consider having the properties of KingPublic modified.C、You should consider having the properties of every mailbox modified.D、You should consider having the properties of KingDatabase modified.
考题
TestKing.com has employed you as their Exchange Administrator. The TestKing.com network contains an Exchange Server 2010 Organization. The Exchange organization contains multiple Hub TransportServers. On of the Hub Transport servers named TESTKING-EX01 is used by a line of business application that retries e-mail messages. The application is configured to only send e-mail messages to a single SMTPserver. You receive an instruction from the CIO to ensure that the application is able to retry e-mailmessages of TESTKING-EX01 tabs. What should you do？（）A、You should consider having failover clustering installed and configuring on the Hub Transport servers.B、You should consider having Windows network load balancing implementing on the Hub Transport servers.C、You should consider having log transactions implemented.D、You should consider having multiple MX records created for the Hub Transport servers in the internal DNS zone.
考题
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 domain named Company.com.The Company.com organization makes use of Microsoft Exchange Server 2010 as their messaging solution.During the course of the business week you receive instruction from Company.com to start planning the creation of ten mailbox databases on twenty Mailbox servers whilst ensuring that you create a naming convention for all Mailbox databases. What should you do？（）A、You should consider having a file name that is unique within the organization provided for each mailbox database file.B、You should consider having a file name that is unique within the Mailbox server provided for each mailbox database file.C、You should consider having a database name that is unique within the organization provided for each mailbox database file.D、You should consider having a database name that is unique within the Mailbox server provided for each mailbox database file.
考题
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 domain named Company.com.The Company.com organization makes use of Microsoft Exchange Server 2010 as their messaging solution.During the course of the business week you receive instruction from Company.com to ensure that deleted mailboxes are kept for 8 weeks on the Mailbox server.What should you do？（）A、You should consider having the properties of the Mailbox database modified.B、You should consider having the properties of the Mailbox server object modified.C、You should consider having a Retention Policy created.D、You should consider having a managed folder mailbox policy created.
考题
单选题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 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？（）A
to enable operating system authentication for a remote clientB
to restrict the scope of administration to identical operating systemsC
to allow the start up and shut down of the database from a remote clientD
to enable the administration of the operating system from a remote clientE
to disable the administration of the operating system from a remote client
考题
多选题You are working on an Oracle Database 10g database. You enabled the Flashback Database feature. Which two statements regarding flashback logs are true？ （）AFlashback logs are not archived.BFlashback logs are maintained in redo log files.CFlashback logs are maintained in the Flash Recovery Area.DFlashback logs are used to maintain Flashback Database related errors.EFlashback logs need to be cleared manually after you disable Flashback Database.
考题
多选题You are working on an Oracle Database 10g database. Because of data loss， you decided to perform a Flashback Database operation using the following command： SQL FLASHBACK DATABASE TO TIMESTAMP（SYSDATE 5/24）; Which two statements are true？ （）ASYSDATE should not be used with TIMESTAMP.BThe database must have multiplexed redo log files.CThe database must be in the MOUNT state to execute the command.DThe database must be opened with the RESETLOGS option after the flashback operation.EThe entire database needs to be restored from the most recent backup before the flashback operation.
考题
单选题You are working on the APPDB database as a DB A. The database has a default Flashback Data Archive DFLA1 created on it. You issued the following command to drop the Flashback Archive FLA1： DROP FLASHBACK ARCHIVE fla1； What is the effect of this command？（）A
The Flashback Archive FLA1 is dropped only if it is empty.B
The tablespace having Flashback Archive is dropped.C
The Flashback Archive FLA1 is dropped after moving the existing data in it to the default Flashback Archive.D
The Flashback Data Archive and historical data are dropped.
考题
单选题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 domain named Company.com.The Company.com organization makes use of Microsoft Exchange Server 2010 as their messaging solution.During the course of the business week you receive instruction from Company.com to start planning the creation of ten mailbox databases on twenty Mailbox servers whilst ensuring that you create a naming convention for all Mailbox databases. What should you do？（）A
You should consider having a file name that is unique within the organization provided for each mailbox database file.B
You should consider having a file name that is unique within the Mailbox server provided for each mailbox database file.C
You should consider having a database name that is unique within the organization provided for each mailbox database file.D
You should consider having a database name that is unique within the Mailbox server provided for each mailbox database file.
考题
单选题Which statement correctly describes the function of Oracle9i Cache Fusion feature？（）A
It provides each session with its own view of the database at a different point in the past. B
It enables you to execute scalable applications on a clustered database without having to partition the users or the database tables. C
It lets you dynamically reassign memory in your database buffer cache to different block buffer sizes. D
It allows you to add new sites to multimaster replication environment without quiescing the master definition site.
考题
单选题You are using recovery Manager (RMAN) with a recovery catalog to backup up your production database. The backups and the archived redo log files are copied to a tape drive on a daily basis. The database was open and transactions were recorded in the redo logs. Because of fire in the building you lost your servers having the production database and the recovery catalog database. The archive log files generated after the last backup are intact on one of the remote locations. While performing a disaster recovery of the production database what is the next step that you must perform after restoring the data files and applying archived redo logs?（）A
Open the database in NORMAL modeB
Open the database in read-only modeC
Open the database in RESTRICTED modeD
Open the database with the RESETLOGS option
考题
单选题You are working on a 24X7 database. You want to design a backup strategy for your database that uses user managed backups. You want to be able to perform all backups while the database remains online. Which statement about performing user-managed backups in a 24x7 environment is true?（）A
You must have change tracking enabled in your databaseB
Your database must be running in NOARCHIVELOG modeC
To back up a tablespace, it must be in backup modeD
To back up a tablespace, it must first be taken offline
考题
单选题You are working on the 24X7 database with high transaction volume， to ensure faster instance recovery on your database you set the FAST_START_MTTR_TARGET initialization parameter to a very low value. What effect it will have on the database？（）A
The database performance would be enhanced.B
The redo log files would be get filled more frequently.C
The overall database performance would be degraded.D
The mean time to recover （MTTR） would be increased.
考题
单选题You are working on a 24X7 database. You want to design a backup strategy for your database that uses user managed backups. You want to be able to perform all backups while the database remains online. Which statement about performing user-managed backups in a 24x7 environment is true？（）A
You must have change tracking enabled in your databaseB
Your database must be running in NOARCHIVELOG modeC
To back up a tablespace，it must be in backup modeD
To back up a tablespace，it must first be taken offline
考题
多选题In which two cases would you perform only consistent backup？（）AYou are working on a database where downtime is not tolerated.BYou are working on a database where downtime can be tolerated.CYou are working on a database that operates in ARCHIVELOG mode.DYou are working on a database that operates in NOARCHIVELOG mode.EYou are working on a database where all the tablespaces are locally managed.FYou are working on a database where control files and redo log files are multiplexed.GYou are working on a database where control files and redo log files are not multiplexed.
热门标签
最新试卷
