A.current redo log and inactive redo log
B.checkpoint position to end of redo log
C.beginning of redo log to end of redo log
D.all redo logs before the point of last commit
E.beginning of redo log to checkpoint position
您可能感兴趣的试卷
你可能感兴趣的试题
A.The user must be granted the database administrator (DBA) privilege.
B.The user must be listed in the password file for the authentication.
C.No special setup is needed for the user to connect as SYSDBA in iSQL*Plus.
D.Set up a user in the Oracle Application Server Containers for J2EE (OC4J) user manager,and grant the webDba role to the user.
A.The backup is similar to image copy.
B.The backup contains all used data blocks.
C.The backup contains only unused data blocks.
D.The backup contains all data blocks changed since the last incremental level 1 backup.
A.displays only the list of default values
B.displays only the list of all basic parameters
C.displays the currently in effect parameter values
D.displays only the list of all advanced parameters
E.displays the list of all the parameter files of a database
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
最新试题
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?()
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?()
Which three statements are true regarding the finegrained auditing (FGA)?()
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?()
The application workload on your database is same between 10 a.m. and 11 a.m. on weekdays. Suddenly you observe poor performance between 10 a.m. and 11 a.m. in the middle of the week. How would you identify the changes in configuration settings, workload profile,and statistics to diagnose the possible causes of the performance degradation?()
You plan to use static database registration for a new listener when you create it. What could be the two reasons for this?()
Which statement is true about the loss of systemcritical data files in ARCHIVELOG mode?()
Your database is functional with peak load for one hour. You want to preserve the performance statistics collected during this period so that they can be used for comparison while analyzing the performance of the database in the future. What action would you take to achieve this task?()
In which situation would you use the Oracle Shared Server configuration?()