No more data files can be added to the tablespace.
Segment space is managed by free lists in the tablespace.
A user created without being assigned a default tablespace uses this tablespace.
The tablespace can be dropped with the current setting with segments present in it
第1题:
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.
第2题:
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?()
第3题:
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. ‘/ u01/app/oracle/oradata/orcl/users01.dbf
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
第4题:
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?()
第5题:
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? ()
第6题:
A. 1
B. 2
C. 3
D. 4
E. 5
F. 所有语句都会执行成功
第7题:
Which two statements about bigfile tablespaces are true? ()
第8题:
ExaminethecommandsexecutedinaDBAsession:SQL>CREATEBIGFILETABLESPACEMRKT2DATAFILE’/u01/app/oracle/oradata/orcl/mrkt.dbf’size10MLOGGING3EXTENTMANAGEMENTLOCALSEGMENTSPACEMANAGEMENTAUTO;Tablespacecreated.SQL>ALTERDATABASEDEFAULTTABLESPACEMRKT;Databasealtered.WhichtwostatementsaretrueregardingtheMRKTtablespace()
A.Nomoredatafilescanbeaddedtothetablespace.
B.Segmentspaceismanagedbyfreelistsinthetablespace.
C.Ausercreatedwithoutbeingassignedadefaulttablespaceusesthistablespace.
D.Thetablespacecanbedroppedwiththecurrentsettingwithsegmentspresentinit
第9题:
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?()
第10题:
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?()