A.You have to shut down the database to perform the backups.
B.Archiving information is written to the data files and redo log files.
C.You can perform complete database backups without closing the database.
D.Online redo log files have to be multiplexed before putting the database in ARCHIVELOG mode.
E.All the previous database backups become invalid after you configure the database to ARCHIVELOG mode.
您可能感兴趣的试卷
你可能感兴趣的试题
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.
最新试题
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？（）
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？（）
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？（）
The SAVE_AMT column in the ACCOUNTS table contains the balance details of customers in a bank. As part of the yearend tax and interest calculation process， all the rows in the table need to be accessed. The bank authorities want to track access to the rows containing balance amounts exceeding $200，000， and then send an alert message to the administrator. Which method would you suggest to the bank for achieving this task？（）
In which situation would you use the Oracle Shared Server configuration？（）
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？（）
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？（）
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？（）
The ST_INFO master table has millions of rows that are updated very rarely. It has a STATE_CODE column that contains the value for 25 states. The table is frequently queried on the STATE_CODE column. Which type of index would you suggest to improve the query performance？（）