网友您好, 请在下方输入框内输入要搜索的题目:

题目内容 (请给出正确答案)

You have been asked to create three users, PUB1, PUB2 and PUB3, for three newly hired employees and to allocate unlimited quota on their default tablespace PUBLISHER_TBS with no other privileges. After creating the users, which method can you use for granting the required privileges?()

  • A、grant CONNECT role to all of the three users
  • B、grant RESOURCE role to all of the three users
  • C、grant both CONNECT and RESOURCE role to all of the three users
  • D、execute ALTER USER .. QUOTA UNLIMITED ON publisher_tbs command for all of the three users
  • E、create role with UNLIMITED TABLESPACE system privilege and assign the role to all of the three users

参考答案

更多 “You have been asked to create three users, PUB1, PUB2 and PUB3, for three newly hired employees and to allocate unlimited quota on their default tablespace PUBLISHER_TBS with no other privileges. After creating the users, which method can you use for granting the required privileges?()A、grant CONNECT role to all of the three usersB、grant RESOURCE role to all of the three usersC、grant both CONNECT and RESOURCE role to all of the three usersD、execute ALTER USER .. QUOTA UNLIMITED ON publisher_tbs command for all of the three usersE、create role with UNLIMITED TABLESPACE system privilege and assign the role to all of the three users” 相关考题
考题 Which option is best practice for creating a recovery catalog owner in the catalog database?() A. Granting UNLIMITED QUOTA on the SYSTEM tablespace to the ownerB. Allocating the SYSTEM tablespace as the default tablespace and granting the SYSDBA privilege to the userC. Creating a new tablespace, allocating this as the default, and granting UNLIMITED QUOTA on this tablespace to the userD. Allocating the SYSAUX tablespace as the default tablespace and granting UNLIMITED QUOTA on this tablespace to the user

考题 You have 100 segments in the USERS tablespace. You realize that the USERS tablespace is running low on space. You can use Segment Advisor to()。 A. identify the segments that you should shrinkB. modify the storage parameters for the tablespaceC. automatically shrink the segments with unused spaceD. check the alerts generated for the tablespace that is running low on space

考题 You create a new pluggable database, HR_PDB, from the seed database. Which three tablespaces arecreated by default in HR_PDB?() A.SYSTEMB.SYSAUXC.EXAMPLED.UNDOE.TEMPF.USERS

考题 Your IT director has decided to allow employees to use their laptops at home as well as in the office. You have deployed the Junos Pulse client to allow access to the offices 802.1X-enabled wired network. Your company also has the Junos Pulse Secure Access Service deployed. You want the Junos Pulse client to automatically launch the appropriate access method depending on each users location.Which three are supported to determine the users location?()A. MAC addressB. DNS serverC. DHCP serverD. resolve addressE. endpoint address

考题 You create a new pluggable database, HR_PDB, from the seed database. Which three tablespaces arecreated by default in HR_PDB?()A、SYSTEMB、SYSAUXC、EXAMPLED、UNDOE、TEMPF、USERS

考题 You are the network administrator for Company. You have been assigned the task to create and deploy a standard Windows 2000 Professional image to all 2,500 client computers that today are installed with Windows 98. You log on to a client computer called Company by using a local administrative account called SetupUser and install three Windows 2000 professional compatible software packages on Company. You create an image using third party software. You deploy the image to a test client computer and join the client computer to a domain. You want to create shortcuts on all users' desktops for the software packages you installed. You also want users to have the option to delete the icons.  Which profile must you edit?()A、The SetupUser profileB、The Default User profileC、The Administrator profileD、The System profileE、The All Users profile

考题 Your IT director has decided to allow employees to use their laptops at home as well as in the office. You have deployed the Junos Pulse client to allow access to the offices 802.1X-enabled wired network. Your company also has the Junos Pulse Secure Access Service deployed. You want the Junos Pulse client to automatically launch the appropriate access method depending on each users location. Which three are supported to determine the users location?()A、MAC addressB、DNS serverC、DHCP serverD、resolve addressE、endpoint address

考题 You have 100 segments in the USERS tablespace. You realize that the USERS tablespace is running low on space. You can use Segment Advisor to()。A、identify the segments that you should shrinkB、modify the storage parameters for the tablespaceC、automatically shrink the segments with unused spaceD、check the alerts generated for the tablespace that is running low on space

考题 The EMPLOYEES table is stored in the USERS tablespace. You need to check if the EMPLOYEES table is affected by the block corruption found in the USERS tablespace. Which option would you use?()A、 the RMAN LIST commandB、 the DBNEWID utilityC、 the RMAN REPORT commandD、 the RMAN BLOCKRECOVER commandE、 the RMAN CROSSCHECK commandF、 the ANALYZE command

考题 You want to take the backup of the USERS tablespace. It has a single data file of 900 MB. You have tape drives of 300 MB each. The SBT channel is configured for the RMAN. To accomplish the backup, you issued the following RMAN command:   RMAN BACKUP SECTION SIZE 300M TABLESPACE users;   Which two statements are true regarding the execution of the above command?()A、 The RMAN parallelizes the backup although the parallelism is not set for a channel.B、 The backup piece size will be limited to 300 MB.C、 The operation is accomplished using the default channel available.D、 Three channels for the tape drive must be configured by setting the parallelism to three.

考题 You are creating a recovery catalog for use with RMAN. You have issued these commands: SQL CREATE TABLESPACE rman_ts DATAFILE  ’/DISK1/rman_ts01.dbf’ 2 SIZE 20M 3 DEFAULT STORAGE (initial 100K next 100K pctincrease 0); SQL CREATE USER rman_db01 IDENTIFIED BY rman_db01 2 DEFAULT TABLESPACE rman_ts 3 QUOTA unlimited ON rman_ts;  Which command should you issue next?()A、RESYNC CATALOG;B、REGISTER DATABASE;C、CREATE CATALOG TABLESPACE rman_ts;D、GRANT recovery_catalog_owner TO rman_db01;

考题 From the V$SESSION_LONGOPS view, you find that some of the database users have long-running queries and are consuming a lot of CPU time. This causes problems for you when you try to log on as the system user and perform small maintenance tasks. You would like to ensure that users SYS and SYSTEM get priority over all other users.   Which method would you use to achieve this objective?()A、create a plan directive in the SYS_GROUPB、create the pending area for the consumer groupC、activate the provided SYSTEM_PLAN in Resource ManagerD、set the TIMED_STATISTICS parameter to TRUE in the parameter fileE、set the execution time limit for all users, except SYS and SYSTEM, in their profiles

考题 Which option is best practice for creating a recovery catalog owner in the catalog database?()  A、 Granting UNLIMITED QUOTA on the SYSTEM tablespace to the ownerB、 Allocating the SYSTEM tablespace as the default tablespace and granting the SYSDBA privilege to the userC、 Creating a new tablespace,allocating this as the default, and granting UNLIMITED QUOTA on this tablespace to the userD、 Allocating the SYSAUX tablespace as the default tablespace and granting UNLIMITED QUOTA on this tablespace to the user

考题 While creating a database using Database Configuration Assistant tool, you created a database default temporary tablespace. Which activity would cause the default temporary tablespace of the database to be used?()A、the CREATE TABLE .. commandB、sorting of the SYSTEM tablespace’s dataC、sorting of data required by recursive SQL statementsD、the CREATE TABLE .. ORGANIZATION EXTERNAL .. commandE、sorting of data if the users have not been allocated temporary tablespace explicitlyF、sorting of data if the users have been allocated temporary tablespace explicitly

考题 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、profileB、account lockC、account unlockD、password expireE、quota 10MB on TBS1F、password never expireG、default tablespace TBS1H、quota unlimited on TBS1I、temporary tablespace TEMPJ、temporary tablespace SYSTEM

考题 View the Exhibit.You executed the following command to perform a backup of the USERS tablespace: RMAN BACKUP TABLESPACE USERS;  Which three types of files are backed up? ()A、 all the data files belonging to the USERS tablespaceB、 password fileC、 online redo log filesD、 the current control fileE、 archived redo log filesF、 the current server parameter fileG、 data files belonging to the USERS tablespace and all the default tablespaces

考题 You have an Exchange Server 2010 organization.You need to ensure that all users in the organization can automatically schedule the use of a projector.What should you do?()A、Create a new sharing policyB、Create a mailboxC、Modify the properties of the Calendar managed default folderD、Modify the schedule for the Managed Folder Assistant

考题 You upgraded a computer to Windows 2000 Professional and kept the FAT32 file system. You want each of three employees who use this computer to have their own documents area that no one else can access. You create a shared folder for each of the three users. You give only the owner permission to use the folder. Later in the week you are informed that User1's folder was modified while User1 was on vacation. What is wrong with your security configuration? ()A、Local computer policy must restrict the rights of the three users.B、You gave each share the same name under the users’ Documents and Settings folders.C、Shared folder security only works when accessing the folder over the network.D、Domain authentication should be required at log on.

考题 单选题You have 100 segments in the USERS tablespace. You get an alert that the USERS tablespace is running low on space. You decide to shrink some segments. Which option would you use to determine which segments to shrink?()A Segment Advisor B SQL Tuning Advisor C SQL Access Advisor D Segment Resource Estimation E Automatic Database Diagnostic Monitor (ADDM)

考题 多选题View the Exhibit.You executed the following command to perform a backup of the USERS tablespace: RMAN BACKUP TABLESPACE USERS;  Which three types of files are backed up? ()Aall the data files belonging to the USERS tablespaceBpassword fileConline redo log filesDthe current control fileEarchived redo log filesFthe current server parameter fileGdata files belonging to the USERS tablespace and all the default tablespaces

考题 单选题You are creating a recovery catalog for use with RMAN. You have issued these commands: SQL CREATE TABLESPACE rman_ts DATAFILE  ’/DISK1/rman_ts01.dbf’ 2 SIZE 20M 3 DEFAULT STORAGE (initial 100K next 100K pctincrease 0); SQL CREATE USER rman_db01 IDENTIFIED BY rman_db01 2 DEFAULT TABLESPACE rman_ts 3 QUOTA unlimited ON rman_ts;  Which command should you issue next?()A RESYNC CATALOG;B REGISTER DATABASE;C CREATE CATALOG TABLESPACE rman_ts;D GRANT recovery_catalog_owner TO rman_db01;

考题 单选题You upgraded a computer to Windows 2000 Professional and kept the FAT32 file system. You want each of three employees who use this computer to have their own documents area that no one else can access. You create a shared folder for each of the three users. You give only the owner permission to use the folder. Later in the week you are informed that User1's folder was modified while User1 was on vacation. What is wrong with your security configuration? ()A Local computer policy must restrict the rights of the three users.B You gave each share the same name under the users’ Documents and Settings folders.C Shared folder security only works when accessing the folder over the network.D Domain authentication should be required at log on.

考题 单选题While designing your database, you have created the EMPLOYEES table as an index-organized table (IOT). You want to create a bitmap index on the JOB_ID column to make queries faster. Which task must have been completed so that you are able to create the bitmap index?()A A primary key must have been created.B A mapping table must have been created.C An overflow tablespace must have been specified.D The PCTTHRESHOLD option must have been specified.

考题 单选题The EMPLOYEES table is stored in the USERS tablespace. You need to check if the EMPLOYEES table is affected by the block corruption found in the USERS tablespace. Which option would you use?()A the DBNEWID utilityB the ANALYZE commandC the RMAN LIST commandD the RMAN REPORT commandE the RMAN CROSSCHECK commandF the RMAN BLOCKRECOVER command

考题 单选题You have 100 segments in the USERS tablespace. You realize that the USERS tablespace is running low on space. You can use Segment Advisor to().A add data files to the tablespace B identify the segments that you should shrink C modify the storage parameters for the tablespace D automatically shrink the segments with unused space E check the alerts generated for the tablespace that is running low on space

考题 单选题You have been asked to create three users, PUB1, PUB2 and PUB3, for three newly hired employees and to allocate unlimited quota on their default tablespace PUBLISHER_TBS with no other privileges. After creating the users, which method can you use for granting the required privileges?()A grant CONNECT role to all of the three usersB grant RESOURCE role to all of the three usersC grant both CONNECT and RESOURCE role to all of the three usersD execute ALTER USER .. QUOTA UNLIMITED ON publisher_tbs command for all of the three usersE create role with UNLIMITED TABLESPACE system privilege and assign the role to all of the three users

考题 单选题Which option is best practice for creating a recovery catalog owner in the catalog database?()A Granting UNLIMITED QUOTA on the SYSTEM tablespace to the ownerB Allocating the SYSTEM tablespace as the default tablespace and granting the SYSDBA privilege to the userC Creating a new tablespace, allocating this as the default, and granting UNLIMITED QUOTA on this tablespace to the userD Allocating the SYSAUX tablespace as the default tablespace and granting UNLIMITED QUOTA on this tablespace to the user