多选题

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

    多选题查看答案