Examine the command： SQL> ALTER USER skd ACCOUNT LOCK； Which two statements are true after the command is executed（）
A. The SKD user cannot log in to the database instance.
B. The objects owned by the SKD user are not accessible to any user.
C. The other users can access the objects owned by the SKD user， on which they have access.
D. The password for the SKD user expires and the user is forced to change the password at the next log in
查看答案
相关试题
换一换
Examine the command： SQL> ALTER USER skd ACCOUNT LOCK； Which two statements are true after the command is executed（）
A.The SKD user cannot log in to the database instance. B.The objects owned by the SKD user are not accessible to any user. C.The other users can access the objects owned by the SKD user， on which they have access. D.The password for the SKD user expires and the user is forced to change the password at the next log in
答案
Examine the command： SQL> ALTER USER skd ACCOUNT LOCK； Which two statements are true after the command is executed（）
A.The SKD user cannot log in to the database instance. B.The objects owned by the SKD user are not accessible to any user. C.The other users can access the objects owned by the SKD user， on which they have access. D.The password for the SKD user expires and the user is forced to change the password at the next log in.
答案
Examine the RMAN command： SWITCH DATAFILE ’/DISK3/user_data01.dbf’； Which command do you need to issue before you issue the above command， so that RMAN finds the file in the restored location of ’DISK2/user_data01.dbf’？ （）
A.RESTORE DATAFILE ’/DISK2/user_data01.dbf’ B.RESTORE DATAFILE ’/DISK3/user_data01.dbf’ C.SET NEWNAME FOR ’/DISK3/user_data01.dbf’ TO’/DISK2/user_data01.dbf’ D.SET NEWNAME FOR ’/DISK2/user_data01.dbf’ TO’/DISK3/user_data01.dbf’
答案
Examine the RMAN command： SWITCH DATAFILE ’/DISK3/user_data01.dbf’； Which command do you need to issue before you issue the above command， so that RMAN finds the file in the restored location of ’DISK2/user_data01.dbf’？ （）
A.RESTORE DATAFILE ’/DISK2/user_data01.dbf’ B.RESTORE DATAFILE ’/DISK3/user_data01.dbf’ C.SET NEWNAME FOR ’/DISK3/user_data01.dbf’ TO’/DISK2/user_data01.dbf’ D.SET NEWNAME FOR ’/DISK2/user_data01.dbf’ TO’/DISK3/user_data01.dbf’
答案
Which command will result in a trace file being created with the create controlfile command contained in it？（）
A. alter database backup controlfile B. alter database backup controlfile to trace C. alter database controlfile backup D. alter database controlfile backup to ’/ora01/oracle/ctrl_backup.ctl’ E. alter database begin controlfile backup
答案
Which command will result in a trace file being created with the create controlfile command contained in it?（）
A.alter database backup controlfile B.alter database backup controlfile to trace C.alter database controlfile backup D.alter database controlfile backup to ’/ora01/oracle/ctrl_backup.ctl’ E.alter database begin controlfile backup
答案
Which command will result in a trace file being created with the create controlfile command contained in it?（）
A.alter database backup controlfile B.alter database backup controlfile to trace C.alter database controlfile backup D.alter database controlfile backup to ’/ora01/oracle/ctrl_backup.ctl’ E.alter database begin controlfile backup
答案
What is the implication of this command?（）
A.The command produces an error because the retention time cannot be reduced. B.ll historical data is retained but the subsequent flashback data archives are maintained for only three years. C.ll historical data is purged and the new flashback data archives are maintained for three years. D.ll historical data older than three years is purged from the flashback archive FLA1.
答案
You issued the following command to drop the PRODUCTS table: SQL> DROP TABLE products; What is the implication of this command?（）
A.All data along with the table structure is deleted B.The pending transaction in the session is committed C.All indexes on the table will remain but they are invalidated D.All views and synonyms will remain but they are invalidated E.All data in the table are deleted but the table structure will remain
答案
You issued the following command： ALTER DATABASE ENABLE BLOCK CHANGE TRACKING； What will be the result of issuing this command？（）
A. The block change tracking feature is enabled， and the information about the system change number is written in the change tracking file. B. The block change tracking feature is enabled， and the information about the log sequence number is written in the change tracking file. C. The block change tracking feature is enabled， and the information about the blocks that are changed since the last backup is written in the change tracking file. D. The block change tracking feature is enabled， and the information about the locations of the datafiles and the online redo log files are written in the change tracking file.
答案
热门试题
You issued the following command to drop the PRODUCTS table: SQL> DROP TABLE products; What is the implication of this command?（）
What is the purpose of the catalog command？（）
What is the purpose of the recover command？（）
In RMAN， when the RESYNC CATALOG command is issued， in which two situations does the command file actually perform synchronization？（）
Which command creates an image copy？（）
You perform a backup using the following BACKUP command: RMAN> BACKUP AS COMPRESSED BACKUPSET DATABASE,Which statement is true of this command?（）
You executed the following command in Recovery Manager （RMAN）： RMAN> RESTORE CONTROLFILE; Which operation must you perform before this command is executed？（）
Why would you execute the report obsolete command？（）
Why would you run the delete obsolete command？（）
Which of the following does the recover command not do？（）
What are the consequences of executing the SHUTDOWN ABORT command？ （）
You are using the following command to clear the log file group： ALTER DATABASE CLEAR LOFFILE GROUP 2； In which case would the command be successful？（）
What information does the report schema command not provide？（）
Which statement is true regarding the VALIDATE DATABASE command？（）
After the recovery is complete， which command should you execute？（）
Which command is used to begin a tablespace point-in-time recovery？（）
You executed the following command in Recovery Manager （RMAN） against your Oracle 10g database：RMAN> REPORT NEED BACKUP days 3；What would be the output of this command？（）
When an ASM instance receives a SHUTDOWN NORMAL command，what command does it pass on to all database instances that rely on the ASM instances disk groups？（）
Which is the correct command to put the database in ARCHIVELOG mode？（）
What command is used to reset a database to a previous incarnation？（）
使用微信扫一扫登录
