网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
多选题
Examine the commands executed in a DBA session：SQL> CREATE BIGFILE TABLESPACE MRKT 2 DATAFILE ’/u01/app/oracle/oradata/orcl/mrkt.dbf’ size 10M LOGGING 3 EXTENT MANAGEMENT LOCALSEGMENT SPACE MANAGEMENT AUTO； Tablespace created. SQL> ALTER DATABASE DEFAULT TABLESPACE MRKT； Database altered. Which two statements are trueregarding the MRKT tablespace（）
A
No more data files can be added to the tablespace.
B
Segment space is managed by free lists in the tablespace.
C
A user created without being assigned a default tablespace uses this tablespace.
D
The tablespace can be dropped with the current setting with segments present in it
参考答案
参考解析
解析：
暂无解析
更多 “多选题Examine the commands executed in a DBA session：SQL CREATE BIGFILE TABLESPACE MRKT 2 DATAFILE ’/u01/app/oracle/oradata/orcl/mrkt.dbf’ size 10M LOGGING 3 EXTENT MANAGEMENT LOCALSEGMENT SPACE MANAGEMENT AUTO； Tablespace created. SQL ALTER DATABASE DEFAULT TABLESPACE MRKT； Database altered. Which two statements are trueregarding the MRKT tablespace（）ANo more data files can be added to the tablespace.BSegment space is managed by free lists in the tablespace.CA user created without being assigned a default tablespace uses this tablespace.DThe tablespace can be dropped with the current setting with segments present in it” 相关考题
考题
You executed the following command:RMAN RECOVER COPY OF DATAFILE ‘／u01／app／oracle／oradata／orcl／users01.dbf‘;Which statement regarding the above command is correct?()
A. The ‘/u01/app/oracle/oradata/orcl/users01.dbf‘ data file is recovered from the image copyB. The ‘/u01/app/oracle/oradata/orcl/users01.dbf‘ data file is recovered from the last incremental backupC. Image copies of the ‘/u01/app/oracle/oradata/orcl/users01.dbf‘ data file are updated with all changes up to incremental backup SCN. ‘/ u01/app/oracle/oradata/orcl/users01.dbfD. Image copies of the ‘/u01/app/oracle/oradata/orcl/users01.dbf‘ data file are recovered using the above command if data file recovery fails
考题
ExaminethecommandsexecutedinaDBAsession：SQLCREATEBIGFILETABLESPACEMRKT2DATAFILE’/u01/app/oracle/oradata/orcl/mrkt.dbf’size10MLOGGING3EXTENTMANAGEMENTLOCALSEGMENTSPACEMANAGEMENTAUTO；Tablespacecreated.SQLALTERDATABASEDEFAULTTABLESPACEMRKT；Databasealtered.WhichtwostatementsaretrueregardingtheMRKTtablespace（）A.Nomoredatafilescanbeaddedtothetablespace.B.Segmentspaceismanagedbyfreelistsinthetablespace.C.Ausercreatedwithoutbeingassignedadefaulttablespaceusesthistablespace.D.Thetablespacecanbedroppedwiththecurrentsettingwithsegmentspresentinit
考题
Youexecutedthefollowingcommand:RMANRECOVERCOPYOFDATAFILE’／u01／app／oracle／oradata／orcl／users01.dbf’;Whichstatementregardingtheabovecommandiscorrect?()
A.The’/u01/app/oracle/oradata/orcl/users01.dbf’datafileisrecoveredfromtheimagecopy.B.The’/u01/app/oracle/oradata/orcl/users01.dbf’datafileisrecoveredfromthelastincrementalbackup.C.Imagecopiesofthe’/u01/app/oracle/oradata/orcl/users01.dbf’datafileareupdatedwithallchangesuptoincrementalbackupSCN.D.Imagecopiesofthe’/u01/app/oracle/oradata/orcl/users01.dbf’datafilearerecoveredusingtheabovecommandifdatafilerecoveryfails.
考题
以下创建表空间的语句会在执行哪一行时失败? 1 CREATE BIGFILE TABLESPACE users 2 DATAFILE '／u01／oracle／data／users.dbf' SIZE 50M 3 EXTENT MANAGEMENT LOCAL 4 FREELISTS 5 5 NOLOGGING()
A. 1B. 2C. 3D. 4E. 5F. 所有语句都会执行成功
考题
You are creating a locally managed tablespace to meet the following requirements： All the extents should be of the same size. The data should be spread across two data files. A bitmap should be used to record the free space within the allocated extents. Which three options would you choose？（）A、set PCTFREE and PCTUSED to 50B、specify extent allocation as UniformC、specify extent allocation as AutomaticD、create the tablespace as bigfile tablespaceE、create the tablespace as smallfile tablespaceF、set segment space management to AutomaticG、use the RESIZE clause while creating the tablespace
考题
Which two statements about bigfile tablespaces are true？ （）A、The bigfile tablespace have only one data file.B、The segment space management is automatic.C、The extent management is dictionary managed.D、The database can have only one bigfile tablespace.E、The bigfile tablespace can be converted to a smallfile tablespace.
考题
Examine the following commands executed in your database： SQL ALTER SESSION RECYCLEBIN=ON； Session altered SQL CREATE TABLE emp TABLESPACE tbsfd AS SELECT * FROM hr.employees； Table created. Further， you executed the following command to drop the table： SQL DROP TABLE emp； Table dropped. What happens in this scenario？ （）A、The table is moved to the SYSAUX tablespace.B、The table is moved to the SYSTEM tablespace.C、The table is removed from the database permanently.D、The table is renamed and remains in the TBSFD tablespace.
考题
You executed the following command： RMAN RECOVER COPY OF DATAFILE ’/u01/app/oracle/oradata/orcl/users01.dbf’； Which statement regarding the above command is correct？（） A、 The ’/u01/app/oracle/oradata/orcl/users01.dbf’ data file is recovered from the image copy.B、 The ’/u01/app/oracle/oradata/orcl/users01.dbf’ data file is recovered from the last incremental backup.C、 Image copies of the ’/u01/app/oracle/oradata/orcl/users01.dbf’ data file are updated with all changes up to incremental backup SCN.D、 Image copies of the ’/u01/app/oracle/oradata/orcl/users01.dbf’ data file are recovered using the above command if data file recovery fails.
考题
You executed the following command: RMAN RECOVER COPY OF DATAFILE '/u01/app/oracle/oradata/orcl/users01.dbf'; Which statement regarding the above command is correct?（）A、The '/u01/app/oracle/oradata/orcl/users01.dbf' data file is recovered from the image copyB、The '/u01/app/oracle/oradata/orcl/users01.dbf' data file is recovered from the last incremental backupC、 Image copies of the '/u01/app/oracle/oradata/orcl/users01.dbf' data file are updated with all changes up to incremental backup SCN. '/ u01/app/oracle/oradata/orcl/users01.dbfD、Image copies of the '/u01/app/oracle/oradata/orcl/users01.dbf' data file are recovered using the above command if data file recovery fails
考题
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；
考题
Which of the following represents the correct way to perform an online recovery of datafile 4， which is assigned to a tablespace called USERS？（） A、 shutdown restore datafile 4； recover datafile 4； alter database open；B、 Sql alter database datafile 4 offline； restore datafile 4； recover datafile 4； alter database open；C、 Sql alter database datafile 4 offline； restore datafile 4； Sql alter database datafile 4 online；D、 Sql alter database datafile 4 offline； restore database datafile 4； recover database datafile 4；Sql alter database datafile 4 online；E、 Sql alter database datafile 4 offline； restore datafile 4； recover datafile 4； Sql alter database datafile 4 online；
考题
You execute the following set of commands to create a database user and to grant the system privileges in your production environment. SQL CREATE USER user01 IDENTIFIED BY oracle DEFAULT TABLESPACE tbs1 TEMPORARY TABLESPACE temp PROFILE default / SQL GRANT create session， create table TO user01； While executing the command to create a table， the user gets the following error message and the CREATE TABLE.. command fails. ERROR at line 1： ORA-01950： no privileges on tablespace What could be the possible reason for this error message？（）A、The tablespace TBS1 is full.B、The user is not the owner of the SYSTEM tablespace.C、The user does not have quota on the TBS1 tablespace.D、The user does not have sufficient system privileges to create table in the TBS1 tablespace.E、The user does not have sufficient privileges to create table on the default permanent tablespace.
考题
You executed the following command to create a tablespace called SALES_DATA： SQL CREATE TABLESPACE sales_data DATAFILE SIZE 100M SEGMENT SPACE MANAGEMENT AUTO； Which two statements are true about the SALES_DATA tablespace（）A、The database automatically determines the extent-sizing policy for the tablespace.B、The segments are automatically shrunk when the contents are removed from them.C、The allocation of extents within the tablespace is managed through the dictionary tables.D、The space utilization description of the data blocks in segments is recorded in bitmap blocks.E、The space utilization description of the data blocks in segments is managed through free lists.
考题
Examine the commands executed in a DBA session：SQL CREATE BIGFILE TABLESPACE MRKT 2 DATAFILE ’/u01/app/oracle/oradata/orcl/mrkt.dbf’ size 10M LOGGING 3 EXTENT MANAGEMENT LOCALSEGMENT SPACE MANAGEMENT AUTO； Tablespace created. SQL ALTER DATABASE DEFAULT TABLESPACE MRKT； Database altered. Which two statements are trueregarding the MRKT tablespace（）A、No more data files can be added to the tablespace.B、Segment space is managed by free lists in the tablespace.C、A user created without being assigned a default tablespace uses this tablespace.D、The tablespace can be dropped with the current setting with segments present in it
考题
Examine the statement： SQL CREATE TABLESPACE user_data 2 EXTENT MANAGEMENT LOCAL 3 SEGMENT SPACE MANAGEMENT AUTO； Which twp assumptions must be true for this statement to execute successfully？（）A、Oracle Managed Files are used for this instance.B、The USER_DATA tablespace is managed using FET$/UET$ tables.C、The COMPATIBLE initialization parameter must be 9.0.0 or higher.D、Space within segments in the USER_DATA tablespace is managed with freelists.
考题
You executed the following command to create a tablespace called SALES_DATA： CREATE TABLESPACE sales_data DATAFILE SIZE 100M SEGMENT SPACE MANAGEMENT AUTO； Which two statements are true about the SALES_DATA tablespace （）A、The database automatically determines the extent-sizing policy for the tablespace.B、The segments are automatically shrunk when the contents are removed from them.C、The allocation of extents within the tablespace is managed through the dictionary tables.D、The space utilization description of the data blocks in segments is recorded inbitmapblocks.E、The space utilization description of the data blocks in segments is managed through free lists.MANUAL
考题
You specified extent management as local for a tablespace. How will it affect space management in the tablespace？（）A、All the extents will be of the same size.B、Bitmap will be used to record free and allocated extents.C、Free extents will be managed by the data dictionary tables.D、The tablespace will be system managed and the users cannot specify the extent size.
考题
You issue the following command in Oracle: CREATE TABLESPACE DAT_TBS DATAFILE "dat_tbs.dbf" SIZE 2M;. Later queries against the database reveal that the tablespace is located in the /u01/oradata/oracle directory. Which of the following choices identifies how Oracle likely determined what directory to place dat_tbs.dbf file in?（）A、DB_CREATE_FILE_DEST B、DB_CREATE_ONLINE_LOG_1 C、DB_CREATE_ONLINE_LOG_2D、The directory is an operating system-specific default value in Oracle that can neigher be specified manually nor changed
考题
单选题You specified extent management as local for a tablespace. How will it affect space management in the tablespace？（）A
All the extents will be of the same size.B
Bitmap will be used to record free and allocated extents.C
Free extents will be managed by the data dictionary tables.D
The tablespace will be system managed and the users cannot specify the extent size.
考题
多选题Examine the statement： SQL CREATE TABLESPACE user_data 2 EXTENT MANAGEMENT LOCAL 3 SEGMENT SPACE MANAGEMENT AUTO； Which twp assumptions must be true for this statement to execute successfully？（）AOracle Managed Files are used for this instance.BThe USER_DATA tablespace is managed using FET$/UET$ tables.CThe COMPATIBLE initialization parameter must be 9.0.0 or higher.DSpace within segments in the USER_DATA tablespace is managed with freelists.
考题
单选题Examine the following commands executed in your database： SQL ALTER SESSION RECYCLEBIN=ON； Session altered SQL CREATE TABLE emp TABLESPACE tbsfd AS SELECT * FROM hr.employees； Table created. Further， you executed the following command to drop the table： SQL DROP TABLE emp；Table dropped. What happens in this scenario？（）A
The table is moved to the SYSAUX tablespace.B
The table is moved to the SYSTEM tablespace.C
The table is removed from the database permanently.D
The table is renamed and remains in the TBSFD tablespace.
考题
单选题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；
考题
多选题Examine the commands executed in a DBA session：SQL CREATE BIGFILE TABLESPACE MRKT 2 DATAFILE ’/u01/app/oracle/oradata/orcl/mrkt.dbf’ size 10M LOGGING 3 EXTENT MANAGEMENT LOCALSEGMENT SPACE MANAGEMENT AUTO； Tablespace created. SQL ALTER DATABASE DEFAULT TABLESPACE MRKT； Database altered. Which two statements are trueregarding the MRKT tablespace（）ANo more data files can be added to the tablespace.BSegment space is managed by free lists in the tablespace.CA user created without being assigned a default tablespace uses this tablespace.DThe tablespace can be dropped with the current setting with segments present in it
考题
多选题You executed the following command to create a tablespace called SALES_DATA： CREATE TABLESPACE sales_data DATAFILE SIZE 100M SEGMENT SPACE MANAGEMENT AUTO； Which two statements are true about the SALES_DATA tablespace （）AThe database automatically determines the extent-sizing policy for the tablespace.BThe segments are automatically shrunk when the contents are removed from them.CThe allocation of extents within the tablespace is managed through the dictionary tables.DThe space utilization description of the data blocks in segments is recorded inbitmapblocks.EThe space utilization description of the data blocks in segments is managed through free lists.MANUAL
考题
多选题You executed the following command to create a tablespace called SALES_DATA： SQL CREATE TABLESPACE sales_data DATAFILE SIZE 100M SEGMENT SPACE MANAGEMENT AUTO； Which two statements are true about the SALES_DATA tablespace（）AThe database automatically determines the extent-sizing policy for the tablespace.BThe segments are automatically shrunk when the contents are removed from them.CThe allocation of extents within the tablespace is managed through the dictionary tables.DThe space utilization description of the data blocks in segments is recorded in bitmap blocks.EThe space utilization description of the data blocks in segments is managed through free lists.
考题
多选题Which two statements about bigfile tablespaces are true？ （）AThe bigfile tablespace have only one data file.BThe segment space management is automatic.CThe extent management is dictionary managed.DThe database can have only one bigfile tablespace.EThe bigfile tablespace can be converted to a smallfile tablespace.
考题
单选题You issue the following command in Oracle: CREATE TABLESPACE DAT_TBS DATAFILE "dat_tbs.dbf" SIZE 2M;. Later queries against the database reveal that the tablespace is located in the /u01/oradata/oracle directory. Which of the following choices identifies how Oracle likely determined what directory to place dat_tbs.dbf file in?（）A
DB_CREATE_FILE_DEST B
DB_CREATE_ONLINE_LOG_1 C
DB_CREATE_ONLINE_LOG_2D
The directory is an operating system-specific default value in Oracle that can neigher be specified manually nor changed
热门标签
最新试卷