网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
In your Supportcenter.cn 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 Supportcenter.cn 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 are working in a dedicated server environment. Your database is running in the automatic Program Global Area （PGA） memory management mode. Which two statements are correct in this scenario？ （）A、 The WORK_AREASIZE_POLICY initialization parameter cannot be set to AUTO.B、 The Oracle database automatically controls the amount of PGA memory allotted to SQL work areas.C、 Setting the value of the SGA_TARGET initialization parameter to 0 will disable the automatic PGA memory management.D、 The SORT_AREA_SIZE parameter is ignored by all the sessions running in the automatic PGA memory management mode.
考题
Your database is started by using the server parameter file （SPFILE）. You issued this command to change the value of the LOG_BUFFER initialization parameter： ALTER SYSTEM SET LOG_BUFFER=24M SCOPE=BOTH; What would be the outcome of this command？（）A、The command would return an error because LOG_BUFFER is a static parameter.B、The parameter value would be changed and it would come into effect immediately.C、You need to restart the database so that parameter changes can come into effect.D、The command would succeed only if initialization parameter LOG_ARCHIVE_MAX_PROCESS is set to value 2.
考题
Your boss at Supportcenter.cn 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？（）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. 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 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 maintaining your database in Oracle10g. You are performing the backup by using the BACKUP AS BACKUPSET command at the RMAN prompt. Which file cannot be backed up by using the BACKUP AS BACKUPSET command？（）A、DatafilesB、 Current control fileC、 Server parameter file （spfile）D、 Password file
考题
In your Supportcenter.cn 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
考题
Every Sunday the Unix system administrator has a job that executes a full backup of the entire Unix system your database is on. Is this backup usable for backup and recovery of your database？（） A、 Yes， if the database is in ARCHIVELOG modeB、 Yes， if the database is in NOARCHIVELOG modeC、 No， the backup is not usable in any wayD、 Only if the ENABLE_ONLINE_BACKUP parameter is set to TRUE
考题
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.
考题
What are the prerequisites for enabling Flashback Database？ （）A、 The database must be started in the MOUNT EXCLUSIVE state.B、 The database must have multiplexed control files.C、 The database must be opened by using a text-based parameter file instead of a server parameter file （SPFILE）.D、 The database must be in ARCHIVELOG mode.E、 The database must be in the NOMOUNT state.F、 The database must be opened in RESTRICTED mode.
考题
In your Supportcenter.cn 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 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. A user database named Products is included by your SQL Server 2005 computer. SQL Server Integration Services （SSIS） packages are utilized to export data from the Products database to a text file. You deliver the text file to your company’s trading partners by utilizing FTP. You are required to make sure that your SSIS packages can be recovered from the occurrence of a disaster. Which action should be performed to finish the task？（）A、To finish the task，the Products database should be backed up.B、To finish the task，your server should be set to utilize the full recovery model.C、To finish the task，your server should be set to utilize the bulk-logged recovery model.D、To finish the task， the msdb database should be backed up.
考题
单选题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 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
考题
多选题In your production database， you have observed that the database server performance degrades whenever there is a switch between the log groups. On further investigation， you find that the database is running in ARCHIVELOG mode and the archived log files are being written to the same disk that is used to store the redo log members. Which two actions would you take to improve the performance of the database server？（）Aincrease the size of the redo log bufferBincrease the number of redo log groupsCincrease the number of log writer processesDincrease the number of ARCn processesEchange the appropriate LOG_ARCHIVE_DEST_n parameter to place the archived log files in a separate location
考题
单选题Your database is started by using the server parameter file （SPFILE）. You issued this command to change the value of the LOG_BUFFER initialization parameter： ALTER SYSTEM SET LOG_BUFFER=24M SCOPE=BOTH； What would be the outcome of this command？ （）A
The command would return an error because LOG_BUFFER is a static parameter.B
The parameter value would be changed and it would come into effect immediately.C
You need to restart the database so that parameter changes can come into effect.D
The command would succeed only if initialization parameter LOG_ARCHIVE_MAX_PROCESS is set to value 2.
考题
单选题You have lost datafile 4 from your database. Which is typically the fastest way to restore your database? （）A
Restore and recover the datafile. B
Restore and recover the tablespace. C
Restore and recover the database. D
Restore and recover the control file. E
Restore and recover the parameter file.
考题
多选题What are the prerequisites for enabling Flashback Database？ （）AThe database must be started in the MOUNT EXCLUSIVE state.BThe database must have multiplexed control files.CThe database must be opened by using a text-based parameter file instead of a server parameter file （SPFILE）.DThe database must be in ARCHIVELOG mode.EThe database must be in the NOMOUNT state.FThe database must be opened in RESTRICTED mode.
考题
单选题Every Sunday the Unix system administrator has a job that executes a full backup of the entire Unix system your database is on. Is this backup usable for backup and recovery of your database？（）A
Yes， if the database is in ARCHIVELOG modeB
Yes， if the database is in NOARCHIVELOG modeC
No， the backup is not usable in any wayD
Only if the ENABLE_ONLINE_BACKUP parameter is set to TRUE
考题
单选题Your boss at Supportcenter.cn 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 are maintaining your database in Oracle10g. You are performing the backup by using the BACKUP AS BACKUPSET command at the RMAN prompt. Which file cannot be backed up by using the BACKUP AS BACKUPSET command？（）A
DatafilesB
Current control fileC
Server parameter file （spfile）D
Password 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. 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.
考题
单选题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.
考题
多选题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
热门标签
最新试卷
