A.Indexes and views can be created on temporary tables.
B.Both the data and the structure of temporary tables can be exported.
C.Temporary tables are always created in a user’s temporary tablespace.
D.The data inserted into a temporary table in a session is available to other sessions.
E.Data manipulation language （DML） locks are never acquired on the data of temporary tables.
您可能感兴趣的试卷
你可能感兴趣的试题
A.Undo data becomes obsolete after 1，000 seconds.
B.Undo data gets refreshed after every 1，000 seconds.
C.Undo data will be stored permanently after 1，000 seconds.
D.Committed undo data would be retained for 1，000 seconds if free undo space is available.
E.Undo data will be retained in the UNDO tablespace for 1，000 seconds，then it gets moved to the TEMPORARY tablespace to provide read consistency.
A.run Segment Advisor
B.run SQL Tuning Advisor on top SQL statements
C.run the Automatic Workload Repository （AWR） report
D.run the Automatic Database Diagnostic Monitor （ADDM）on top SQL statements
A.Data files and redo log files can be renamed at the MOUNT stage.
B.Control files are read at the OPEN stage for the location of data files.
C.Control files are required to bring the database to the NOMOUNT stage.
D.Data files and redo log files are made available to users at the OPEN stage.
E.Data files and online redo log files are checked for consistency while opening the 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
A.SYSAUX
B.TOOLS
C.UNDO
D.INDEX
E.SYSTEM
F.USERS
G.TEMP
A.NLSLANG
B.NLSLENGTHSEMANTICS
C.NLSTERRITORY
D.NLSLANGUAGE
E.NLSCHARACTERSET
F.NLSDATELANGUAGE
G.NLSNCHARCHARACTERSET
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？（）
A.SYSTEM
B.USERS
C.PROD
D.SYSAUX
E.TEMP
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
最新试题
The user SCOTT executes the following command successfully to increase the salary values in one of his sessions： SQL> UPDATE emp SET sal=sal*1.15 WHERE deptno=20; Before SCOTT ends the transaction， user HR who has the privileges on EMP table executes a query to fetch the salary details but finds the old salary values instead of the increased values. Why does HR still see the old data？（）
You want to monitor and control the resource usage by sessions. You want to be warned automatically when more than 100 sessions are opened with your database. What action would you take to achieve this？（）
You have been recently hired as a database administrator. Your senior manager asks you to study the production database server and submit a report on the settings done by the previous DBA. While observing the server settings， you find that the following parameter has been set in the parameter file of the database： REMOTE_OS_AUTHENT = TRUE What could have been the reason to set this parameter as TRUE？（）
Which two statements regarding the LOGGING clause of the CREATE TABLESPACE. .. statement are correct？（）
User SCOTT executes the following command on the EMP table but has not issued COMMIT， ROLLBACK，or any data definition language （DDL） command： SQL> SELECT job FROM emp 2 WHERE job=’CLERK’ FOR UPDATE OF empno; SCOTT has opened another session to work with the database. Which three operations would wait when issued in SCOTT’s second session？（）
While setting up the database for your production environment， you want to create a user with following requirements. 1.The objects created by the user must be stored in a tablespace， TBS1， if the TABLESPACE option is not defined during the object creation. 2.The user should be able to use 10MB of space in the tablespace TBS1. 3.The user must change the password immediately after logging in for the first time. Which three options of the CREATE USER command would you use to achieve this objective？（）
Your database is open and users are connected using the LISTENER listener. The new DBA of the system stops the listener by using the following command：LSNRCTL> STOP What would happen to the sessions that are presently connected to the database instance？（）
When you try to open your database， you receive the following error： ORA-00205： error in identifying control file Where would you find the details required to resolve this error？（）
Which three statements are true regarding the logical structure of the Oracle database？（）
A user receives the following error while executing a query：ORA01555：snapshot too oldWhich two options can be the solutions to avoid such errors in future？（）