多项选择题

Which three pieces of information are considered while deciding the size of the undo tablespace in your database？（）

A.the size of an undo block
B.the size of the redo log files
C.undo blocks generated per second
D.the size of the database buffer cache
E.the value of the UNDO_RETENTION parameter

点击查看答案

上一题目录下一题

相关考题

多项选择题

You connected to the database using the following connection string： CONNECT hr/hr@test.us.oracle.com：1521/mydb
Which three statements are correct regarding the connection string？（）

A.mydb is a service name.
B.test.us.oracle.com is a database name.
C.1521 is the listener port number.
D.mydb is a host name.
E.test.us.oracle.com is a net service name.
F.hr is a username.
G.test.us.oracle.com is an instance name.

单项选择题

View the Exhibit to see the output of queries on DATABASEPROPERTIES and DBAUSERS.
You observe that the current default permanent tablespace of the database is
running out of space and you decide to change it to NEWDEFTBSP. You create a new user， USER04， after changing the default permanent tablespace of the database. What would be the new user’s default tablespace？（）

A.DEFTBSP
B.SYSTEM
C.NEWDEFTBSP
D.USERS and NEWDEFTBSP both
E.USERS

多项选择题

Identify the two tablespaces whose data files are so critical that only a closed recovery is possible.（）

A.SYSAUX
B.TOOLS
C.UNDO
D.INDEX
E.SYSTEM
F.USERS
G.TEMP