AIt records usernames and passwords of users when granted the DBA role.
BIt contains usernames and passwords of users for whom auditing is enabled.
CIt is used by Oracle to authenticate users for remote database administration.
DIt records usernames and passwords of all users when they are added to OSDBA or OSOPER operating system groups.
ou are in the middle of a transaction updating a very important table. The machine on which adatabase was running reboots because of power outage. This caused a database instance failure. Which statement is true in this situation()
单选题查看答案
ou need to configure fine-grained access control to external network resources from within your database. You create an access control list (ACL) using the DBMS_NETWORK_ACL_ADMIN package. Which statement is true regarding the ACL created?()
单选题查看答案
ou have a large amount of historical data in a flat file. Some analysts in your organization need to query thisdata in the file. The file is too large to load the data in it into your current database. Which is the most effectivemethod to access this data in your database()
单选题查看答案
ou are using the flash recovery area (fast recovery area in 11g Release 2) to store backup related files in your database. After regular monitoring of space usage in the Mash recovery area. You realize that the flash recovery area is (jetting filled up very fast and it is running out of space. Your database flash recovery area is low on specie and you have no more room on disk. Proactively, which two options could you use to make more space available in the flash recovery()
多选题查看答案
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?()
多选题查看答案
You have the following online redo log configuration: Group Member 1 ’/disk1/oradata/redo01a.log’ 2 ’/disk2/oradata/redo02a.log’ 3 ’/disk3/oradata/redo03a.log’ You decide to multiplex the online redo log groups for recovery of redo log files in case of any disaster. Which two statements will you NOT issue to multiplex the online redo log files?()
多选题查看答案
Given: 11. public void genNumbers() { 12. ArrayList numbers = new ArrayList(); 13. for (int i=0; i
单选题查看答案
What is true regarding a transaction executed in Automatic Undo Management mode?()
单选题查看答案
Which three table transformations can be done using online redefinition of tables?()
多选题查看答案