你可能感興趣的試題

多項(xiàng)選擇題

Exhibit：

View the Exhibit.
Your Oracle 10g database has 6 tablespaces in which：
-TEMP is the default temporary tablespace
-UNDOTBS1 is the default undo tablespace
-USERS is the default permanent tablespace
In this database， which two tablespaces can be made read only？（）

A.TEMP
B.PROD
C.USERS
D.SYSAUX
E.SYSTEM
F.UNDOTBS1

多項(xiàng)選擇題

What are the consequences of executing the SHUTDOWN ABORT command？（）

A.The database files are synchronized.
B.Uncommitted changes are not rolled back.
C.The database is closed， but the instance is still started.
D.Database buffers and redo buffers are not written to the disk.
E.The database undergoes automatic media recovery during the next startup.

View the Exhibit. The DBA creates a new user as follows： SQL> CREATE USER manfus IDENTIFIED BY manfus TEMPORARY TABLESPACE temp； User manfus creates a table as follows： SQL> CREATE TABLE material（id NUMBER（3））； In which tablespace will the material table be created？（）

你可能感興趣的試題

Exhibit： View the Exhibit. Your Oracle 10g database has 6 tablespaces in which： -TEMP is the default temporary tablespace -UNDOTBS1 is the default undo tablespace -USERS is the default permanent tablespace In this database， which two tablespaces can be made read only？（）

What are the consequences of executing the SHUTDOWN ABORT command？ （）

View the Exhibit.
The DBA creates a new user as follows：
SQL> CREATE USER manfus IDENTIFIED BY manfus TEMPORARY TABLESPACE temp；
User manfus creates a table as follows：
SQL> CREATE TABLE material（id NUMBER（3））；
In which tablespace will the material table be created？（）

Exhibit：

View the Exhibit.
Your Oracle 10g database has 6 tablespaces in which：
-TEMP is the default temporary tablespace
-UNDOTBS1 is the default undo tablespace
-USERS is the default permanent tablespace
In this database， which two tablespaces can be made read only？（）

What are the consequences of executing the SHUTDOWN ABORT command？（）