多项选择题Which two statements are true regarding the database in ARCHIVELOG mode?()

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.


您可能感兴趣的试卷

你可能感兴趣的试题

1.单项选择题Because of a power outage, instance failure has occurred. From what point in the redo log does recovery begin and where does it end? ()

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

2.单项选择题Which step do you need to perform to enable a user with the SYSDBA privilege to log in as SYSDBA in iSQL*Plus?()

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.

3.单项选择题According to your backup strategy, you performed an incremental level 0 backup of yourdatabase. Which statement regarding this backup is true?()

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.

4.单项选择题Which statement regarding the contents of the V$PARAMETER view is true?()

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

5.多项选择题Which three statements are correct about temporary tables?()

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.

6.单项选择题The UNDO_RETENTION parameter in your database is set to 1000 and undo retention is not guaranteed. Which statement regarding retention of undo data is correct?()

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.

7.单项选择题You received complaints about the degradation of SQL query performance. You identified top SQL queries that consume time. What would be your next step to find out recommendations about statistics collection and restructuring of the SQL statement to improve query performance?()

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

8.多项选择题Which three statements are true about the stages of database startup?()

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

9.多项选择题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

10.多项选择题

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.

最新试题

You find that the database performance degrades while you backup the PROD database using Recovery Manager (RMAN). The PROD database is running in shared server mode. The database instance is currently using 60% of total operating system memory. You suspect the shared pool fragmentation to be the reason.Which action would you consider to overcome the performance degradation?()

题型:单项选择题

Your database is started by using the server parameter file (SPFILE). You issued this command to change the value of the LOG_BUFFER initialization parameter: ALTER SYSTEM SET LOG_BUFFER=24M SCOPE=BOTH; What would be the outcome of this command?()

题型:单项选择题

According to your backup strategy, you performed an incremental level 0 backup of your database. Which statement regarding this backup is true?()

题型:单项选择题

Your database is in NOARCHIVELOG mode and a logswitch happens every 20 minutes. On Thursday morning, media failure resulted in corruption of a data file belonging to the TOOLS tablespace. Backups are taken on every Sunday.What would you do in this situation?()

题型:单项选择题

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 configured in NOARCHIVELOG mode. All the control files have been lost due to a hard disk failure but the data files are not lost. You have the closed whole database backup available to you. Which two statements are true in this scenario?()

题型:多项选择题

In which situation would you use the Oracle Shared Server configuration?()

题型:单项选择题

Which two statements regarding the LOGGING clause of the CREATE TABLESPACE. .. statement are correct?()

题型:多项选择题

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?()

题型:多项选择题

The SAVE_AMT column in the ACCOUNTS table contains the balance details of customers in a bank. As part of the year­end 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?()

题型:单项选择题