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
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.
最新试题
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?()
You execute the following command to audit the database activities: SQL> AUDIT DROP ANY TABLE BY scott BY SESSION WHENEVER SUCCESSFUL; What is the effect of this command?()
You find today’s performance of your production database to be the best ever. Therefore, you want to be notified in the future whenever the performance degrades by 10% of today’s performance. What is the first step that you would take to ensure this?()
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 are using flat files as the data source for one of your data warehousing applications. You plan to move the data from the flat file structures to an Oracle database to optimize the application performance. In your database you have clustered tables. While migrating the data, you want to have minimal impact on the database performance and optimize the data load operation. Which method would you use to load data into Oracle database?()
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?()
You plan to use static database registration for a new listener when you create it. What could be the two reasons for this?()
In your Oracle 10g database , you have scheduled a job to update the optimizer statistics at 05:00 pm every Friday. The job has successfully completed. Which three pieces of information would you check to confirm that the statistics have been collected?()
Which three statements are true regarding the logical structure of the Oracle database?()
One of the users in the PROD database, Adams, complains that his update on the table, TRANS, is taking an unusually long time to complete. You find that the table gets locked by another database user before Adams starts his transactions, and you are unable to contact the user holding the table lock. As Adams is updating some crucial rows in the table, he should get the highest priority. Which method would you use to overcome this problem?()