The control file will be multiplexed.
The control file will be recreated.
The script containing the CREATE CONTROLFILE statement will be created.
The binary backup of the control file will be created.
第1题:
You issue this statement:ALTER DATABASE BACKUP CONTROLFILE TO TRACE; What does the statement generate?()
第2题:
RMAN enables you to open the target database when it is already mounted. Which command must you execute at the RMAN prompt to open the database?()
第3题:
You are the database administrator for an accounting company. You are installing SQL Server 2000 on a new Microsoft Windows 2000 Server computer. The computer will run two client/server database applications that your company has purchased. Each application uses a separate database.
During the installation, you specify SQL_Latin1_General_CP1_CI_AI as the default collation for the SQL server computer. After completing the installation, you discover that one of the new applications, named Financials, is sorting information incorrectly.
You contact the application vendor and discover that the Financials application requires the SQL_Latin1_CP437_BIN collation. You need to configure the correct collation for the applications without diminishing the performance of the SQL Server computer.
What should you do?
A.Rerun the SQL Server Setup and specify the SQL_Latin1_General_CP437_BIN collation.
B.Run the rebuildm utility and specify the SQL_Latin1_General_CP437_BIN collation.
C.Use the ALTER DATABASE statement to specify the SQL_Latin1_General_CP437_BIN collation for the Financials database.
D.Use the ALTER TABLE statement to specify the SQL_Latin1_General_CP437_BIN collation for each table in the Financials database.
第4题:
You issued the following statement: SQL>ALTER DATABASE ENABLE RESUMABLE TIMEOUT n; What will be the result of issuing the above statement?()
第5题:
You issued the following statement: SQL> ALTER DATABASE BACKUP CONTROLFILE TO TRACE; What will be the result of issuing the statement?()
第6题:
Your database is in ARCHIVELOG mode. You have two online redo log groups, each of which contains one redo member. When you attempt to start the database, you receive the following errors: ORA-00313: open failed for members of log group 1 of thread 1 ORA-00312: online log 1 thread 1: 'D:/REDO01.LOG' You discover that the online redo log file of the current redo group is corrupted. Which statement should you use to resolve this issue?()
第7题:
You just issued the following statement: ALTER TABLE SALES DROP COLUMN PROFIT. Which of the following choices identifies when the column will actually be removed from Oracle?()
第8题:
You issued the following statement: SQL> ALTER SESSION SET NLS_LANG=FRENCH_CANADA.WE8ISO8859P1; Which parameter is NOT overridden by using the above statement?()
第9题:
You issued the following statement in your SQL*Plus session: SQL>ALTER SESSION ENABLE RESUMABLE TIMEOUT 600; Which operation is neither suspended nor resumed using the Automatic Resumable Allocation feature in your database?()
第10题:
You are managing a single instance Oracle 10g database that utilizes the following parameters: Which of the following set of commands must you execute to enable Flashback Database?()