A.The checkpoint frequency decreases with the smaller r……

多项选择题After performing a clean shut down of the database instance for maintenance， you mount the database andthen execute a command to open the database：SQL> ALTER DATABASE OPEN； Which two statements are true（）

A.The online redo log files and online data files are opened.
B.All the online data file headers are checked for consistency.
C.Instance recovery is performed before opening the database.
D.The path and existence of all the log file members are checked

单项选择题InwhichsituationistheUNDO_RETENTIONparameterbeignored，evenifitissettoavalue（）

A.When the data file of the undo tablespace is autoextensible
B.When there are more than one undo tablespaces available in the database
C.When the undo tablespace is of a fixed size and retention guarantee is not enabled
D.When the undo tablespace is autoextensible and retention guarantee is not enabled

多项选择题The user HR receives the following error while inserting data into the TTK table：ERROR at line 1： ORA-01653： unable to extend table HR.TTK by 128 in tablespace SMD Upon investigation， you find that SMDis a small file tablespace. Which three action would allow the user to insert data（）

A.Add a data file to the SMD tablespace.
B.Add a data file to the temporary tablespace associated with the user HR.
C.Resize the data file associated with the SMD tablespace to make it larger.
D.Alter the data file associated with the SMD tablespace to grow automatically.
E.Change the segment space management for the SMD tablespace to automatic

单项选择题View the Exhibit and examine the attributes of an undo tablespace. In an OLTP system, the user SCOTT hasstarted a query on a large table in the peak transactional hour that performs bulk inserts. The query runs formore than 15 minutes and then SCOTT receives the following error:ORA-01555: snapshot too old What could be the reason for this error（）

A.The query is unable to get a read-consistent image.
B.There is not enough space in Flash Recovery Area.
C.There is not enough free space in the flashback archive.
D.The query is unable to place data blocks in undo tablespace

单项选择题View the Exhibit and examine the privileges granted to the SL_REP user. The EMP table is owned by theSCOTT user. The SL_REP user executes the following command：SQL> GRANT SELECT ON scott.emp TO hr； Which statement describes the outcome of the command（）

A.The command executes successfully.
B.The command produces an error because the EMP table is owned by SCOTT.
C.The command produces an error because SL_REP has the GRANT ANY OBJECT PRIVILEGE withoutADMIN_OPTION.
D.The command produces an error because SL_REP does not have the SELECT privilege withGRANT_OPTION on the EMP table