网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
多选题
While setting up the database for your production environment， you want to create a user with following requirements. 1.The objects created by the user must be stored in a tablespace， TBS1， if the TABLESPACE option is not defined during the object creation. 2.The user should be able to use 10MB of space in the tablespace TBS1. 3.The user must change the password immediately after logging in for the first time. Which three options of the CREATE USER command would you use to achieve this objective？（）
A
profile
B
account lock
C
account unlock
D
password expire
E
quota 10MB on TBS1
F
password never expire
G
default tablespace TBS1
H
quota unlimited on TBS1
I
temporary tablespace TEMP
J
temporary tablespace SYSTEM
参考答案
参考解析
解析：
暂无解析
更多 “多选题While setting up the database for your production environment， you want to create a user with following requirements. 1.The objects created by the user must be stored in a tablespace， TBS1， if the TABLESPACE option is not defined during the object creation. 2.The user should be able to use 10MB of space in the tablespace TBS1. 3.The user must change the password immediately after logging in for the first time. Which three options of the CREATE USER command would you use to achieve this objective？（）AprofileBaccount lockCaccount unlockDpassword expireEquota 10MB on TBS1Fpassword never expireGdefault tablespace TBS1Hquota unlimited on TBS1Itemporary tablespace TEMPJtemporary tablespace SYSTEM” 相关考题
考题
单选题You executed the following command to start the database： SQL STARTUP ORACLE instance started. Total System Global Area 281018368 bytes Fixed Size 789000 bytes Variable Size 229635576 bytes Database Buffers 50331648 bytes Redo Buffers 262144 bytes ORA-00205： error in identifying controlfile， check alert log for more info Which view would you query at this stage to investigate this missing control file？（）A
V$INSTANCEB
V$CONTROLFILEC
DBA_CONTROL_FILESD
V$DATABASE_PROPERTIESE
V$CONTROLFILE_RECORD_SECTION
考题
单选题You work as a database administrator for Certkiller .com. While loading data into the Certkiller STAFF table using Oracle Enterprise Manager 10g Database Control， you find the status of the job as failed. On further investigation， you find the following error message in the output log： ORA-01653 unable to extend table HR. Certkiller STAFF by 8 intablespaceUSERS Which task would you perform to load the data successfully without affecting the users who are accessing the table？（）A
Restart the database instance and run the jobB
Truncate the Certkiller STAFF table and run the jobC
Delete all rows from the Certkiller STAFF table and run the jobD
Increase the size of the USERStablespacethe and run the jobE
Increase the size of the database default permanenttablespaceand run the job
考题
单选题You work as a database administrator for Supportcenter.cn. You find that users with DBA role are using more CPU resources than what is allocated in their profiles. Which action would you take to ensure that resources limits are imposed on these users？（）A
Assign the DEFAULT profile to the usersB
Set the RESOURCE_LIMIT parameter to TRUE in the parameter fileC
Create a new profile with CPU restrictions and assign it to the usersD
Specify the users as members of the DEFAULT_CONSUMER_GROUPE
Revoke the DBA role and grant CONNECT and RESOURCE role to the users
考题
多选题Which three statements are true regarding the fine/x7fgrained auditing （FGA）？（）AFGA is possible on SELECT statements only.BThe audit trail for FGA is stored in the FGA_LOG$ table.CThe audit trail for FGA is stored in the AUD_LOG$ table.DFGA enables a SQL predicate to define when to audit an event.EFGA audits DELETE statements only when audit columns are specified.FFGA includes the SQL statement used by the user as part of the audit event entry.
考题
多选题You work as a database administrator for Certkiller .com. In your transaction application， you have scheduled a job to update the optimizer statistics at05：00 pm every Friday. The job has successfully completed. Which three pieces of information would you check to confirm that the statistics have been collected？（）AAverage row sizeBLast analyzed dateCSize of table in bytesDSize of table in database blocksENumber of free blocks in the free listFNumber of extents present in the table.
考题
单选题Redo log files are not multiplexed in your database. Redo log blocks are corrupted in group 2， and archiving has stopped. All the redo logs are filled and database activity is halted. Database writer has written everything to disk. Which command would you execute to proceed further？（）A
RECOVER LOGFILE BLOCK GROUP 2；B
ALTER DATABASE DROP LOGFILE GROUP 2；C
ALTER DATABASE CLEAR LOGFILE GROUP 2；D
ALTER DATABASE RECOVER LOGFILE GROUP 2；E
ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 2；
考题
多选题In your Oracle 10g database ， you have scheduled a job to update the optimizer statistics at 05：00 pm every Friday. The job has successfully completed. Which three pieces of information would you check to confirm that the statistics have been collected？（）Aaverage row sizeBlast analyzed dateCsize of table in bytesDsize of table in database blocksEnumber of free blocks in the free listFnumber of extents present in the table
考题
多选题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.
考题
单选题Your database is in the NOARCHIVELOG mode. Since last night’s offline backup， the logs in group 1 have been written to twice. This morning， the SYSTEM data file has become corrupted. Up to what point can it be recovered？（）A
until the last commitB
cannot be recoveredC
until the last offline backupD
until the beginning of the last transaction
热门标签
最新试卷
