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?()
Aprofile
Baccount lock
Caccount unlock
Dpassword expire
Equota 10MB on TBS1
Fpassword never expire
Gdefault tablespace TBS1
Hquota unlimited on TBS1
Itemporary tablespace TEMP
Jtemporary tablespace SYSTEM
正确答案
答案解析
相似试题
(多选题)
A developer is creating a class Book, that needs to access class Paper. The Paper class is deployed in a JAR named myLib.jar. Which three, taken independently, will allow the developer to use the Paper class while compiling the Bookclass?()
(单选题)
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?()
(单选题)
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 DB A. 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?()
(单选题)
You are using an Automatic Storage Management (ASM) instance to manage the files of your production database. While studying the parameter file of the ASM instance, you find the following entry: ASM_DISKSTRING = /devices/* What could be the reason for this setting?()
(单选题)
You are using an Automatic Storage Management (ASM) instance to manage the files of your production database. While studying the parameter file of the ASM instance, you find the following entry: ASM_DISKSTRING = /devices/* What could be the reason for this setting?()
(单选题)
You work as a database administrator for Supportcenter.cn. Users in the Supportcenter.cn PROD database complain about the slow response of transactions. While investigating the reason you find that the transactions are waiting for the undo segments to be available, and undo retention has been set to zero. What would you do to overcome this problem?()
(单选题)
Which naming method uses the tnsnames.ora file to store the connect descriptor used by the client while connecting to the database instance from a remote machine()
(单选题)
You configured automatic archive logging for the database. On the next startup the database runs for a while, but then hangs. After checking the alert log, you determine that all the online redo logs need archiving. Which step was skipped when you set up automatic archive log?()
(多选题)
A user receives the following error while executing a query: ORA/x7f01555:snapshot too old Which two options can be the solutions to avoid such errors in future?()
(多选题)
You work as a database administrator for Supportcenter.cn. While setting up the database for your production environment, you want to create a user according to the requirements in the exhibit. Which three options of the CREATE USER command would you use to achieve this objective?()