网友您好, 请在下方输入框内输入要搜索的题目:

题目内容 (请给出正确答案)
单选题
In your Certkiller .com database server the parameter PLSQL_CODE_TYPE has been set to NATIVE. Which object would be achieved by the setting?()
A

The source PL/SQL code will be stored in native machine code.

B

The source PL/SQL code will be stored in interpreted byte code.

C

The compiled PL/SQL code will be stored in native machine code.

D

The compiled PL/SQL code will be stored in interpreted byte code.


参考答案

参考解析
解析: 暂无解析
更多 “单选题In your Certkiller .com database server the parameter PLSQL_CODE_TYPE has been set to NATIVE. Which object would be achieved by the setting?()A The source PL/SQL code will be stored in native machine code.B The source PL/SQL code will be stored in interpreted byte code.C The compiled PL/SQL code will be stored in native machine code.D The compiled PL/SQL code will be stored in interpreted byte code.” 相关考题
考题 Your boss at Certkiller .com wants you to clarify Oracle 10g. Which statement regarding the contents of the V$PARAMETER view is true?()A、Displays only the list of default valuesB、Displays only the list of all basic parametersC、Displays the currently in effect parameter valuesD、Displays only the list of all advanced parametersE、Displays the list of all the parameter files of a databaseF、Displays the current contents of the server parameter file.

考题 Your PROD database has been started using the server parameter file. In your PROD database you are using RMAN for backup and recovery operations. You issue the following commands from the RMAN prompt:     RMAN CONFIGURE CONTROLFILE AUTOBACKUP OFF;   RMAN BACKUP DATABASE;   Which files from the database will be backed up as a result of this BACKUP command?()A、 control fileB、 all datafilesC、 password fileD、 online redo log fileE、 archive redo log fileF、 server parameter fileG、 only the SYSTEM datafile

考题 In your Certkiller .com database server the parameter PLSQL_CODE_TYPE has been set to NATIVE. Which object would be achieved by the setting?()A、The source PL/SQL code will be stored in native machine code.B、The source PL/SQL code will be stored in interpreted byte code.C、The compiled PL/SQL code will be stored in native machine code.D、The compiled PL/SQL code will be stored in interpreted byte code.

考题 You work as a database administrator for Certkiller .com. Your database is in NOARCHIVELOG mode and you want to perform a backup. Which type of backup would be appropriate in this case? ()A、Hot backupB、Online backupC、consistent backupD、incremental backupE、inconsistent backup

考题 You work as a database administrator for Certkiller .com. In your database server, the parameter PLSQL_OPTIMIZE_LEVEL has been set to 2. What would this setting achieve?()A、It degrades the run time and compiler performance.B、It provides better run time and compiler performance.C、It provides better optimization of the statement during parse time.D、It forces the rule based optimizer to be used for statement optimization.E、It provides better run time performance but slightly degraded compiler performance. F、It provides better run time performance but slightly degraded run time performance.

考题 You work as a database administrator for Certkiller .com. Your database is in the MOUNT state and you execute the following command to open it ALTER DATABASE OPEN; What two actions are performed as a result of this command?()A、All control files are openedB、All redo files are openedC、The password file is openedD、The parameter file is openedE、All online data files are opened

考题 You work as a database administrator for Certkiller .com. In your organization, you have four databases, Certkiller DB01, Certkiller DB02, Certkiller DB03, and Certkiller DB04, which are located in Berlin, Frankfurt,Rammstein, and Munich respectively, and which were created using Database Configuration Assistant (DBCA).  You want to perform administrative tasks on these databases that include startup and shutdown, taking regular backups, and so on, fromFrankfurtusing Oracle tools. Which Oracle file would you enable to perform this task?()A、Control fileB、Password fileC、Parameter fileD、Online redo log fileE、Listener controller fileF、Server parameter file

考题 Your boss at Certkiller .com wants you to clarify Oracle 10g. Which condition in your database forces you to perform only consistent backups?()A、The database is in mount state.B、One of the tablespaces is offline.C、One of the tablespaces is read only.D、The database operates in ARCHIEVELOG mode.E、The database operates in NOARCHIEVELOG mode.

考题 You work as a database administrator for Certkiller .com. You decided to manage client and server connections using Local Naming method in Certkiller .com. When you try to connect to the database you get the following error: ERROR:  ORA-12154:TNS:couldnot resolve service name  Which network configuration files would you look into to resolve this error?()A、snmp.oraB、names.oraC、spfile.oraD、sqlnet.oraE、listener.oraF、tnsnames.ora

考题 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 ControlB、Management ServerC、Management RepositoryD、Application Server ControlE、Oracle Management Agent

考题 You work as a database administrator for Certkiller .com. You started the instance using theinit.orafile. You have two control files and three redo log groups in your database. You decided to protect the database against failures by adding one more control file. Which file is the appropriate way to perform this task?()A、Shut down the instance, copy the control file to the third location and open the database.B、Abort the instance, copy the control file to the third location, modify the CONTROL_FILES parameter in theinit.orafile and open the database.C、Copy the control file to the third location, modify the CONTROL_FILES parameter in theinit.orafile, restart the instance and open the database.D、Shut down the instance, copy the control file to the third location, modify the CONTROL_FILES parameter in theinit.orafile and open the database.E、Shut down the instance, startup in the mount state, copy the control file to the third location, modify the CONTROL_FILES parameter ininit.oraand open the database.

考题 多选题You work as a database administrator for Certkiller .com. You want to create your database with the automatic undo management feature enable.Which two tasks must you perform to achieve this?()ASet the UNDO_RETENTION parameter to AUTO.BCreate an initial undo segment in undotablespace.CSet the UNDO_RETENTION parameter to 900 or moreDSet the initialization parameter UNDO_MANAGEMENT to AUTOESet the UNDO_MANAGEMENT parameter to the name of an undotablespace

考题 多选题You work as a database administrator for Certkiller .com. You want to administer your database servers,which are running on different host machines,using the Web-enabled grid control interface. You have configured the agent on the host machines. You have started the Oracle Database 10g Grid Control utility on your machine. Which two additional components would you configure to achieve this objective?()AApplication Server ControlBOracle Management ServiceCOracle Enterprise Manager RepositoryDOracle Enterprise Manager Database Control

考题 单选题You work as a database administrator for Certkiller .com. In your Oracle database10g installation you have set ORACLE_BASE to /u01/app/oracle.  Which objective will be achieved by this setting?()A The Oracle kernel will be placed in this location.B The Oracle software will be placed in this location.C The server parameter file (SPFILE) will be placed in this location.D The database files will be placed in this location, if not specified explicitly.E The location will be considered for the base of Oracle Managed Files (OMF).F The location will be considered for the base of Optimal Flexible Architecture (OFA).

考题 单选题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 ControlB Management ServerC Management RepositoryD Application Server ControlE Oracle Management Agent

考题 多选题You work as a database administrator for Certkiller .com. You decided to manage client and server connections using Local Naming method in Certkiller .com. When you try to connect to the database you get the following error: ERROR:  ORA-12154:TNS:couldnot resolve service name  Which network configuration files would you look into to resolve this error?()Asnmp.oraBnames.oraCspfile.oraDsqlnet.oraElistener.oraFtnsnames.ora

考题 单选题You work as a database administrator for Certkiller .com. You are using three database, Certkiller DB01, Certkiller DB02, and Certkiller DB03, on different host machines in your development environment. The database serverconfiguration, such as IP address and listener port number, change frequently due to development requirements, and you havethe task of notifying the developers of the changes. Which connection method would you use to overcome this overhead?()A Host namingB Local namingC Easy ConnectD External namingE directory naming

考题 单选题You work as a database administrator at Certkiller .com. Your production database uses an Automatic Storage Management (ASM) instance to manage its files. You want to add a new disk group to the ASM instance to manage the increased data load. What action would you perform to include the new disk group in the ASM instance without causing any impact on the currently connected users?()A  mount the new disk group in the ASM instanceB  restart the ASM instance and the production database instanceC  register the new disk groups in the production database instanceD  restart the ASM instance without restarting the production database instanceE  include the new disk group in the ASM_DISKSTRING parameter in the parameter file and restart the ASM instance

考题 单选题You work as a database administrator for Certkiller .com. In your production  database, the size of Database Buffer Cache needs to be increased immediately for the current as well as future instances of the database. The Oracle instance has been configured to accommodate any changes in the size of the memory structures. At this is production database, you want to accomplish this task with no impact on the user’s connections.  Which activity must you have completed before accomplishing this task?()A You must have started the database instance in restricted mode.B You must have started the database instance inNORMALmode.C You must have started the database instance with server parameter file.D You must have started the database instance but must not have mounted.E You must have started the database instance but must not have opened.

考题 单选题Your boss at Certkiller .com wants you to clarify Oracle 10g. Which statement regarding the contents of the V$PARAMETER view is true?()A Displays only the list of default valuesB Displays only the list of all basic parametersC Displays the currently in effect parameter valuesD Displays only the list of all advanced parametersE Displays the list of all the parameter files of a databaseF Displays the current contents of the server parameter file.

考题 单选题In your Certkiller .com production database, you find that the database users are able to create and read files with unstructured data, available in any location on the host machine from an application.  You want to restrict the database users to access files in a specific location on the host machine.  What could do to achieve this?()A Modify the value for the UTL_FILE_DIR parameter in the parameter fileB Grant read and write privilege on the operating system path to the database usersC Modify the value for the LDAP_DIRECTORY_ACCESS parameter in the parameter fileD Modify the value for the PLSQL_NATIVE_LIBRARY_DIR parameter in the parameter fileE Create a directory object referring to the operating system path, and grant read and write privilege on the directory object to the database users

考题 单选题You work as a database administrator for Certkiller .com. You started the instance using theinit.orafile. You have two control files and three redo log groups in your database. You decided to protect the database against failures by adding one more control file. Which file is the appropriate way to perform this task?()A Shut down the instance, copy the control file to the third location and open the database.B Abort the instance, copy the control file to the third location, modify the CONTROL_FILES parameter in theinit.orafile and open the database.C Copy the control file to the third location, modify the CONTROL_FILES parameter in theinit.orafile, restart the instance and open the database.D Shut down the instance, copy the control file to the third location, modify the CONTROL_FILES parameter in theinit.orafile and open the database.E Shut down the instance, startup in the mount state, copy the control file to the third location, modify the CONTROL_FILES parameter ininit.oraand open the database.

考题 单选题You work as a database administrator for Certkiller .com. In your database server, the parameter PLSQL_OPTIMIZE_LEVEL has been set to 2. What would this setting achieve?()A It degrades the run time and compiler performance.B It provides better run time and compiler performance.C It provides better optimization of the statement during parse time.D It forces the rule based optimizer to be used for statement optimization.E It provides better run time performance but slightly degraded compiler performance. F It provides better run time performance but slightly degraded run time performance.

考题 单选题You work as a database administrator for Certkiller .com. In your organization, you have four databases, Certkiller DB01, Certkiller DB02, Certkiller DB03, and Certkiller DB04, which are located in Berlin, Frankfurt,Rammstein, and Munich respectively, and which were created using Database Configuration Assistant (DBCA).  You want to perform administrative tasks on these databases that include startup and shutdown, taking regular backups, and so on, fromFrankfurtusing Oracle tools. Which Oracle file would you enable to perform this task?()A Control fileB Password fileC Parameter fileD Online redo log fileE Listener controller fileF Server parameter file

考题 单选题You work as a database administrator for Certkiller .com. Your database is in NOARCHIVELOG mode and you want to perform a backup. Which type of backup would be appropriate in this case? ()A Hot backupB Online backupC consistent backupD incremental backupE inconsistent backup

考题 单选题Your boss at Certkiller .com wants you to clarify Oracle 10g. Which condition in your database forces you to perform only consistent backups?()A The database is in mount state.B One of the tablespaces is offline.C One of the tablespaces is read only.D The database operates in ARCHIEVELOG mode.E The database operates in NOARCHIEVELOG mode.

考题 多选题Your PROD database has been started using the server parameter file. In your PROD database you are using RMAN for backup and recovery operations. You issue the following commands from the RMAN prompt:     RMAN CONFIGURE CONTROLFILE AUTOBACKUP OFF;   RMAN BACKUP DATABASE;   Which files from the database will be backed up as a result of this BACKUP command?()Acontrol fileBall datafilesCpassword fileDonline redo log fileEarchive redo log fileFserver parameter fileGonly the SYSTEM datafile