The database instance is not available.
The ALTER TABLE command does not have WAIT option
The table or a row in the table is currently locked by another user session.
The database instance is busy processing other user sessions commands.
The CUSTOMERS table has no long running query active at the time when this request is made.
The server process executing the ALTER TABLE command is busy with another command execution
第1题:
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?()
第2题:
Which statement adds a constraint that ensures the CUSTOMER_NAME column of the CUSTOMERS table holds a value?()
第3题:
You execute the following command in your Certkiller .com production database to change the width of the CUST_NAME column of the CUSTOMERS table: ALTER TABLE customers MODIFY (cust_nameVARCHAR2 (40)) / When you execute the command, it displays the following error message: ERROR at line 1: ORA-00054: resource busy and acquire with NOWAIT specified What could be the reason for the error message?()
第4题:
You execute the following command in your Supportcenter.cn production database to change the width of the CUST_NAME column of the CUSTOMERS table: ALTER TABLE customers MODIFY (cust_nameVARCHAR2 (40)) / When you execute the command, it displays the following error message: ERROR at line 1: ORA-00054: resource busy and acquire with NOWAIT specified What could be the reason for the error message?()
第5题:
Examine this command: SQL > exec DBMS_STATS.SET_TABLE_PREFS (‘SH’, ‘CUSTOMERS’, ‘PUBLISH’, ‘false’); Which three statements are true about the effect of this command?()
第6题:
You have lost all your database control files. To recover them, you are going to use the results of the alter database backup controlfile to trace command. Your datafiles and your online redo logs are all intact. Which of the following is true regarding your recovery?()
第7题:
when you change the name of a datafile
when you drop a table from the database
when you take an export of the database
when you back up the database using OS utilities
when you issue an ALTER SYSTEM SWITCH LOGFILE statement
when you issue a BACKUP command from inside the RMAN run block
第8题:
The database instance is not available.
The ALTER TABLE command does not have WAIT option
The table or a row in the table is currently locked by another user session.
The database instance is busy processing other user sessions commands.
The CUSTOMERS table has no long running query active at the time when this request is made.
The server process executing the ALTER TABLE command is busy with another command execution
第9题:
Statistics collection is not done for the CUSTOMERS table when schema stats are gathered.
Statistics collection is not done for the CUSTOMERS table when database stats are gathered.
Any existing statistics for the CUSTOMERS table are still available to the optimizer at parse time.
Statistics gathered on the CUSTOMERS table when schema stats are gathered are stored as pending statistics.
Statistics gathered on the CUSTOMERS table when database stats are gathered are stored as pending statistics.
第10题:
The database instance is not available.
The ALTER TABLE command does not have WAIT option
The table or a row in the table is currently locked by another user session.
The database instance is busy processing other user sessions commands.
The CUSTOMERS table has no long running query active at the time when this request is made.
The server process executing the ALTER TABLE command is busy with another command execution
第11题:
Immediately following statement execution
After the ALTER TABLE DROP UNUSED COLUMNS command is issued
After the ALTER TABLE SET UNUSED COLUMN command is issued
After the ALTER TABLE MODIFY command is issued
第12题:
Because row IDs may change during the flashback operation
Because the object number changes after the flashback operation
Because the rows are retrieved from the recycle bin during the flashback operation
Because the table is moved forward and back to a temporary during the flashback opertion
第13题:
You are working in an online transaction processing (OLTP) environment. You use the FLASHBACKTABLE command to flash back the CUSTOMERS table. Before executing the FLASHBACK TABLE command, the system change number (SCN) was 663571. After flashing back the CUSTOMERS table, you realize that the table is not in the correct state. Now, you need to reverse the effects of the FLASHBACK TABLE command. Which is the fastest and the most efficient option to reverse the effects of the FLASHBACK TABLE command?()
第14题:
You work as a database administrator for Certkiller .com. Your database is in the MOUNT state and you execute the following command to open it ALTER DATABASE OPEN; What two actions are performed as a result of this command?()
第15题:
Your database is running in the ARCHIVELOG mode. You have configured RMAN for backup and recovery operations. You execute the following command from the RMAN prompt: RMAN> CONFIGURE CONTROLFILE AUTOBACKUP ON; After executing this command, in which of the following cases will RMAN make an auto-backup of the control file? ()
第16题:
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?()
第17题:
You are working in an online transaction processing (OLTP) environment. You used the FLASHBACK TABLE command to flash back the CUSTOMERS table. Before executing the FLASHBACK TABLE command, the System Change Number (SCN) was 663571. After flashing back the CUSTOMERS table, you realize that the table is not in the correct state and the resultant changes are not what you had desired. So, you need to reverse the effects of the FLASHBACK TABLE command while ensuring that: a) No other user data in the database is affected. b) The operation takes the minimum possible time. Which option would you choose?()
第18题:
use the ROLLBACK command with SCN 663571
perform Flashback Transaction Query with SCN 663571
execute the FLASHBACK DATABASE statement to retrieve the CUSTOMERS table as it was at SCN 663571
execute another FLASHBACK TABLE statement to retrieve the CUSTOMERS table as it was at SCN 663571
第19题:
Because row IDs may change during the flashback operation
Because the object number changes after the flashback operation
Because the rows are retrieved from the recycle bin during the flashback operation
Because the table is moved forward and back to a temporary during the flashback opertion
第20题:
Restore the backup control file and open the database with RESETLOGS option.
Perform point-in-time recovery because flashback cannot be performed again on this table
Execute the FLASHBACK DATABASE statement to retrieve the CUSTOMERS table as it was at SCN 663571
Execute another FLASHBACK TABLE statement to retrieve the CUSTOMERS table as it was at SCN 663571
第21题:
Modify the UPDATE statement in the OLE DB Command transform to use the PAGLOCK table hint.
Modify the UPDATE statement in the OLE DB Command transform to use the TABLOCK table hint.
Stage the data in the data flow. Replace the OLE DB Command transform in the data flow with an Execute SQL task in the control flow.
Stage the data in the data flow. Replace the UPDATE statement in the OLE DB Command transform with a DELETE statement followed by an INSERT statement.
第22题:
Use ROLLBACK command with SCN 663571.
Perform Flashback Transaction Query with SCN 663571.
Execute the FLASHBACK DATABASE statement to retrieve the CUSTOMERS table as it was at SCN 663571.
Execute another FLASHBACK TABLE statement to retrieve the CUSTOMERS table as it was at SCN 663571.
第23题:
’SQL ALTER DATABASE OPEN’;
SQL ALTER DATABASE ’OPEN’;
OPEN DATABASE;
DATABASE OPEN
第24题:
You will need to open the database with the resetlogs command.
All you need to do is execute the trace file from SQL*Plus and it will perform the recovery for you.
You will use the resetlogs version of the create controlfile command.
You will use the noresetlogs version of the create controlfile command.
You will use the trace file to create a backup control file, and then you will recover the database with the recover database using backup controlfile command