首页计算机考试Oracle认证
(多选题)

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

正确答案

来源:www.examk.com

答案解析

相似试题

  • (多选题)

    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?()

    答案解析

快考试在线搜题