单选题You are part of the DBA team working for a multinational bank. The team is responsible for performing administrative tasks on the database server located at the home office. The database server at the home office has a production database and a test da

题目
单选题
You are part of the DBA team working for a multinational bank. The team is responsible for performing administrative tasks on the database server located at the home office. The database server at the home office has a production database and a test database named TESTDB. The test database is primarily used for testing database commands and configuration settings befor implementing these settings on the production database. The test database is also used for the development of database applications. You have been asked by the senior DBA to grant the SYSDBA privilege to a new team member， John， so that he can perform some administrative tasks， such as shutdown and startup operations， on TESTDB. You use the password file to configure remote authentication on the TESTDB database. You execute the following statement to grant the SYSDBA privilege to John：   SQL>GRANT SYSDBA TO john；   However， you receive the following error：   ORA-01996： GRANT failed： password file   ’c：/oracle/ora9i/dbs/testdb.pwd’ is full   Which action should you take to add the user john to the password file without removing any of the existing users？（）
A

 Create another password file and then re-execute the GRANT statement.

B

 Re-create the password file， specifying a larger number of allowed entries， and then re-execute the GRANT statement.

C

 Change the value of the REMOTE_LOGIN_PASSWORDFILE initialization parameter in theinitialization parameter file to NONE and then re-execute the GRANT statement.

D

 Change the value of the REMOTE_LOGIN_PASSWORDFILE initialization parameter in the initialization parameter file to SHARED and then re-execute the GRANT statement.

相似考题

1.You are managing the APPPROD database as a DBA which is not using the Oracle-managed files. You plan to duplicate this database in the same system with the name DUPDB.You want to create the same directory structure for duplicate database files as of the target database.You executed the following RMAN commands:What are the implications of this command?（）A. It creates database files for the duplicate database under the Oracle base with a different directory for the duplicate database.B. It overwrites data files of the target database because a different location for data files is not mentioned for the duplicate database.C. It creates database files for the duplicate database under the same Oracle home as that of the target database with the same directory structure.D. It creates database files for the duplicate database under the same Oracle home as that of the target but with a different directory for the duplicate database.

2.Which two prerequisites are needed for performing workload capture and replay？（）A、Close all sessions performing queries using database linksB、running the database in shared server modeC、The database on which the workload is replayed has to be a restore of the original database to a specific SCND、setting up the directory to capture the workload

3. 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

4.When a staging server is used as an environment for testing new data in a default WebSphere Commerce installation， which of the following are true about the staging server？（）A、The database has a subset of the tables in the production server database.B、The database has a copy of selected data from the production databaseC、The database logs changes for later propagation.D、The database is accessed as read-only to prevent data corruption.E、The database includes all user and order data for offline processing.

更多“单选题You are part of the DBA team working for a multinational bank. The team is responsible for performing administrative tasks on the database server located at the home office. The database server at the home office has a production database and a test da”相关问题

  • 第1题：

    You define an alert to be raised when the USERS tablespace usage has reached 80% of the total space. Which area would you refer to， in order to confirm that the alert has been raised due the event？（）

    • A、the alert.log file
    • B、the DBA_ALERTS view
    • C、the Database Control Home page
    • D、the Database Control performance page
    • E、the Database Control Maintenance page

    正确答案:C

  • 第2题：

    You are part of the DBA team working for a multinational bank. The team is responsible for performing administrative tasks on the database server located at the home office. The database server at the home office has a production database and a test database named TESTDB. The test database is primarily used for testing database commands and configuration settings befor implementing these settings on the production database. The test database is also used for the development of database applications. You have been asked by the senior DBA to grant the SYSDBA privilege to a new team member， John， so that he can perform some administrative tasks， such as shutdown and startup operations， on TESTDB. You use the password file to configure remote authentication on the TESTDB database. You execute the following statement to grant the SYSDBA privilege to John：   SQL>GRANT SYSDBA TO john；   However， you receive the following error：   ORA-01996： GRANT failed： password file   ’c：/oracle/ora9i/dbs/testdb.pwd’ is full   Which action should you take to add the user john to the password file without removing any of the existing users？（）

    • A、 Create another password file and then re-execute the GRANT statement.
    • B、 Re-create the password file， specifying a larger number of allowed entries， and then re-execute the GRANT statement.
    • C、 Change the value of the REMOTE_LOGIN_PASSWORDFILE initialization parameter in theinitialization parameter file to NONE and then re-execute the GRANT statement.
    • D、 Change the value of the REMOTE_LOGIN_PASSWORDFILE initialization parameter in the initialization parameter file to SHARED and then re-execute the GRANT statement.

    正确答案:B

  • 第3题：

    You want the user APP_DBA to administer the Oracle database from a remote machine. APP_DBA is granted the SYSDBA privilege to perform administrative tasks on the database. Which file is used by the Oracle database server to authenticate APP_DBA？（）

    • A、control file
    • B、password file
    • C、listener controller file
    • D、control file and password file

    正确答案:B

  • 第4题：

    You are a professional level SQL Sever 2008 Database Administrator in an international corporation named Wiikigo. You are experienced in managing databases in an enterprise-level organization, optimizing and sustaining the database life cycle. In the company, your job is to implement solutions on security, troubleshooting, deployment and optimization. A SQL Server 2008 instance of your company is managed by you. There is a team of database administrators in your company. SQL Server 2008 Integration Services (SSIS) packages are created on the test server in a shared project by a team of application developers. A fixed cache file is required by one of the packages. The company will deploy the packages to the production server on completion of development. The production server is available only to the database administrators.  Since you are the technical support, you need to confirm that the project can be deployed successfully to the production server by the application developers.    Which action will you perform to achieve the goal?（）

    • A、To achieve the goal, the Import and Export Wizard should be utilized to save packages.
    • B、To achieve the goal, a direct package configuration should be created for each package.
    • C、To achieve the goal, a deployment utility should be created for the SSIS project. 
    • D、To achieve the goal, an indirect package configuration should be created for all packages.

    正确答案:C

  • 第5题：

    Your company has a single Active Directory domain. You have 30 database servers that run Windows Server 2008 R2.   The computer accounts for the database servers are stored in an organizational unit （OU） named Data.   The user accounts for the database administrators are stored in an OU named Admin. The database administrators are members of a global group named D_Admins.   You must allow the database administrators to perform administrative tasks on the database servers. You must prevent the database administrators from performing administrative tasks on other servers. What should you do？（）

    • A、Deploy a Group Policy to the Data OU.
    • B、Deploy a Group Policy to the Admin OU.
    • C、Add D_Admins to the Domain Admins global group.
    • D、Add D_Admins to the Server Operators built-in local group.

    正确答案:A

  • 第6题：

    单选题
    You define an alert to be raised when the USERS tablespace usage has reached 80%of the total space. Which area would you refer to， in order to confirm that the alert has been raised due the event？（）
    A

    the alert.log file

    B

    the DBA_ALERTS view

    C

    the Database Control Home page

    D

    the Database Control performance page

    E

    the Database Control Maintenance page


    正确答案： A
    解析： 暂无解析

  • 第7题：

    单选题
    You are a professional level SQL Sever 2008 Database Administrator in an international corporation named Wiikigo. You are experienced in managing databases in an enterprise-level organization, optimizing and sustaining the database life cycle. In the company, your job is to implement solutions on security, troubleshooting, deployment and optimization. A SQL Server 2008 instance of your company is managed by you. There is a team of database administrators in your company. SQL Server 2008 Integration Services (SSIS) packages are created on the test server in a shared project by a team of application developers. A fixed cache file is required by one of the packages. The company will deploy the packages to the production server on completion of development. The production server is available only to the database administrators.  Since you are the technical support, you need to confirm that the project can be deployed successfully to the production server by the application developers.    Which action will you perform to achieve the goal?（）
    A

    To achieve the goal, the Import and Export Wizard should be utilized to save packages.

    B

    To achieve the goal, a direct package configuration should be created for each package.

    C

    To achieve the goal, a deployment utility should be created for the SSIS project. 

    D

    To achieve the goal, an indirect package configuration should be created for all packages.


    正确答案： B
    解析： 暂无解析

  • 第8题：

    多选题
    When a staging server is used as an environment for testing new data in a default WebSphere Commerce installation， which of the following are true about the staging server？（）
    A

    The database has a subset of the tables in the production server database.

    B

    The database has a copy of selected data from the production database

    C

    The database logs changes for later propagation.

    D

    The database is accessed as read-only to prevent data corruption.

    E

    The database includes all user and order data for offline processing.


    正确答案： A,C
    解析： 暂无解析

  • 第9题：

    单选题
    You are the administrator of a Microsoft Windows Server 2003 computer named Server1. SQL Server 2005 is installed on Server1 to host a database named MedDB. The MedDB database serves as the backend database for a new client/server application named MedDATA. Installation of the MedDATA application creates the database schema， application roles， and administrative accounts. It also sets all of the default permissions. You need to establish a permissions baseline for all objects in the MedDB database.  What should you do？（）
    A

    Use the SQL Server 2005 Management Studio to review the permissions of the default database objects.

    B

    Query the sys.server_permissions table on Server1.

    C

    Execute the sp_helplogins system stored procedure for each of the default users that the MedDATA application creates.

    D

    Query the sys.database_permissions and sys.database_principals tables in the MedDB database.


    正确答案： D
    解析： 暂无解析

  • 第10题：

    单选题
    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


    正确答案： A
    解析： 暂无解析

  • 第11题：

    单选题
    You want the user APP_DBA to administer the Oracle database from a remote machine. APP_DBA is granted the SYSDBA privilege to perform administrative tasks on the database. Which file is used by the Oracle database server to authenticate APP_DBA？（）
    A

    control file

    B

    password file

    C

    listener controller file

    D

    control file and password file


    正确答案： B
    解析： 暂无解析

  • 第12题：

    单选题
    You need to define an authentication system for the main office database administrators. The setup should require the minimum amount of administrative effort. The authentication environment must fulfill the company’s security requirements.What should you do？（）
    A

    Create a SQL Server login with Windows Authentication for each main office database administrator.Add all of these logins to the db_owner role in each database.

    B

    Create a SQL Server login with SQL Server Authentication for each main office database administrator.Add all of these logins to the sysadmin role.

    C

    Create a Windows global group named DBAdmins. Add each main office database administrator’s Windows user account to the Windows DBAdmins group.Create a SQL Server login with Windows Authentication for the group.Add the group to the serveradmin fixed server role.

    D

    Add each main office database administrator’s Windows user account to the Windows SQLManagersgroup.


    正确答案： C
    解析： 暂无解析

  • 第13题：

    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

    正确答案:D

  • 第14题：

    You work as a database administrator for Certkiller .com. 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？（）

    • A、Database Control
    • B、Management Server
    • C、Management Repository
    • D、Application Server Control
    • E、Oracle Management Agent

    正确答案:E

  • 第15题：

    You need to define an authentication system for the main office database administrators. The setup should require the minimum amount of administrative effort. The authentication environment must fulfill the company’s security requirements.What should you do？（）

    • A、Create a SQL Server login with Windows Authentication for each main office database administrator.Add all of these logins to the db_owner role in each database.
    • B、Create a SQL Server login with SQL Server Authentication for each main office database administrator.Add all of these logins to the sysadmin role.
    • C、Create a Windows global group named DBAdmins. Add each main office database administrator’s Windows user account to the Windows DBAdmins group.Create a SQL Server login with Windows Authentication for the group.Add the group to the serveradmin fixed server role.
    • D、Add each main office database administrator’s Windows user account to the Windows SQLManagersgroup.

    正确答案:D

  • 第16题：

    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 a database named Dworks in the instance. You are log shipping the Adventureworks database to a remote SQL Server 2008 instance. The primary SQL Server instance required a restart during the weekend. But you notice that log shipping has stopped working after the weekend. You have to check log shipping of the Adventureworks database and find out the problem. What should you do? （） 

    • A、You should use the EXTENDED_LOGICAL_CHECKS option to execute a DBCC CHECKDB statement on the AdventureWorks database by. 
    • B、You should identify whether the SQL Server Agent is started on the primary server. 
    • C、You should identify whether the AdventureWorks database uses the Simple recovery model. 
    • D、You should identify whether the SQL Server Volume Shadow Copy Service (VSS) Writer is started on the primary server

    正确答案:B

  • 第17题：

    You are the network administrator for TestKing. The network consists of a single Active Directory domain named testking.com. All domain controller run Windows Server 2003. employes three database administrators who administer seven databases servers that run Windows Server 2003. The database administrators occasionally restore a database server after a disaster. To restore a server, database administrators need the rights required to perform the following tasks: 1. Back up files and folders 2. Restore files and folders. 3. Restore the System State data. You need to assign the database administrators the rights that they require to perform the specified tasks. For security reasons, you must not assign the administrators more rights than they require to perform the tasks. What should you do?（）

    • A、Add the database administrators' user accounts to the Administrators group on each of the database servers.
    • B、Add the database administrators' user accounts to the Power Users group on each of the database servers.
    • C、Add the database administrators' user accounts to the Backup Operators group on each of the database servers.
    • D、Add the database administrators' user accounts to the Backup Operators group on one of the domain controllers.
    • E、Add the database administrators' user accounts to the Server Operators group on one of the domain controllers.

    正确答案:C

  • 第18题：

    单选题
    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？（）
    A

    Database Control

    B

    Management Server

    C

    Management Repository

    D

    Application Server Control

    E

    Oracle Management Agent


    正确答案： E
    解析： 暂无解析

  • 第19题：

    单选题
    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.

    C

    Both 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.


    正确答案： B
    解析： 暂无解析

  • 第20题：

    多选题
    Which two prerequisites are needed for performing workload capture and replay？（）
    A

    Close all sessions performing queries using database links

    B

    running the database in shared server mode

    C

    The database on which the workload is replayed has to be a restore of the original database to a specific SCN

    D

    setting up the directory to capture the workload


    正确答案： C,D
    解析： 暂无解析

  • 第21题：

    单选题
    Your company has a single Active Directory domain. You have 30 database servers that run Windows Server 2008 R2.   The computer accounts for the database servers are stored in an organizational unit （OU） named Data.   The user accounts for the database administrators are stored in an OU named Admin. The database administrators are members of a global group named D_Admins.   You must allow the database administrators to perform administrative tasks on the database servers. You must prevent the database administrators from performing administrative tasks on other servers. What should you do？（）
    A

    Deploy a Group Policy to the Data OU.

    B

    Deploy a Group Policy to the Admin OU.

    C

    Add D_Admins to the Domain Admins global group.

    D

    Add D_Admins to the Server Operators built-in local group.


    正确答案： B
    解析： 暂无解析

  • 第22题：

    单选题
    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. The server has a very large database named DB1. An application which is constantly available uses DB1. Now you get a report from users, in the report users complain that server has a poor performance. As the technical support, you have to improve the performance of the application by using the Database Engine Tuning Advisor. Besides this, you must make sure that the action of analyzing the workload will not affect the performance of the production server.So what should you do?（）
    A

    On the local server, enable the XP_MSVER stored procedure 

    B

    On the remote server, enable the XP_MSVER stored procedure. 

    C

    On the production server, use the dta.exe utility along with an XML input file. 

    D

    You should configure a test server that has a similar hardware configuration. Use the dta.exe utility on the test server along with an XML input file


    正确答案： D
    解析： 暂无解析

  • 第23题：

    单选题
    You are the network administrator for TestKing. The network consists of a single Active Directory domain named testking.com. All domain controller run Windows Server 2003. employes three database administrators who administer seven databases servers that run Windows Server 2003. The database administrators occasionally restore a database server after a disaster. To restore a server, database administrators need the rights required to perform the following tasks: 1. Back up files and folders 2. Restore files and folders. 3. Restore the System State data. You need to assign the database administrators the rights that they require to perform the specified tasks. For security reasons, you must not assign the administrators more rights than they require to perform the tasks. What should you do?（）
    A

    Add the database administrators' user accounts to the Administrators group on each of the database servers.

    B

    Add the database administrators' user accounts to the Power Users group on each of the database servers.

    C

    Add the database administrators' user accounts to the Backup Operators group on each of the database servers.

    D

    Add the database administrators' user accounts to the Backup Operators group on one of the domain controllers.

    E

    Add the database administrators' user accounts to the Server Operators group on one of the domain controllers.


    正确答案： B
    解析： 暂无解析

相关内容