问题:单选题You have set Tablespace Full Metrics Threshold values for the USERS tablespace as follows: Warning (%): 90 Critical (%): 95 Which background process is responsible for issuing alerts when the threshold is crossed()A System monitor (SMON)B Process mon...
查看答案
问题:单选题You want to import schema objects of the HR user using Oracle Data Pump from the development database,DEVDB, to the production database, PRODDB. A database link devdb.us.oracle.com is created betweenPRODDB and DEVDB. You execute the following command o...
问题:多选题You execute this command to drop the ITEM table, which has the primary key referred in the ORDERS table:SQL DROP TABLE scott.item CASCADE CONSTRAINTS PURGE; Which two statements are true about theeffect of the command()ANo flashback is possible to bri...
问题:多选题Which three descriptions are correct about the effects of the TRUNCATE command on a table()AThe corresponding indexes for the table are also truncated.BDelete triggers on the table are fired during the execution of the TRUNCATE command.CThe child table...
问题:Which two statements are true about the Automatic Database D...
问题:单选题These are points that describe the contents of different memory components: 1: Descriptive information or metadata about schema objects that are queried by using SQL statements 2: The run-time area for data manipulation language (DML) or data definit...
问题:单选题You are managing an Oracle Database 11g database with this backup strategy: - Every Sunday night, level 0 backup is performed. - On Monday night and subsequent days, level 1 incremental backup is performed. The backups are not cumulative incremental...
问题:To make audit information more productive, the DBA executes ...
问题:Which statements regarding the server parameter file (SPFIL...
问题:多选题User SCOTT wants to perform a bulk insert operation in the EMP_DEP table. SCOTT receives thefollowing error after the INSERT statement is issued and few rows are inserted: INSERT INTO EMP_DEP (emp_id,name,salary,dep_name,mgr_id) * ERROR at line 1: OR...
问题:单选题Note the functionalities of various background processes: 1:Perform recovery at instance startup. SMON 2:Free the resources used by a user process when it fails. PMON 3:Cleanup the database buffer cache when a process fails. PMON 4:Dynamically regi...
问题:多选题A database user SMITH tries to query the V$SESSION view and fails to access it as follows: SQL connect smith/smith Connected. SQL SELECT * FROM v$session; SELECT * FROM v$session * ERROR at line 1: ORA-00942: table or view does not exist Which ar...
问题:单选题The TRANS_SUMMARY table contains product-wise transaction details that get updated with every transactionin the system. Each row has cumulative transaction details of a single product and every product is identified bya product code, which is the prima...
问题:You want to create a role to meet these requirements: 1. The...
问题:单选题You are installing Oracle Database 11g on your server. During the installation Oracle UniversalInstaller (OUI) prompts you to enter the path of the inventory directory and also prompts you to specify anoperating system group name. Which statement is t...
问题:单选题Examine the commands executed in the following sequence: 1:SQL CREATE ROLE mgrrole; 2:SQL GRANT create user,select any table,connect,resource TO mgrrole; 3:SQL GRANT select,update ON sh.sales TO mgrrole; 4:SQL CREATE ROLE ceo IDENTIFIED BY boss; 5...
问题:单选题You have issued a SHUTDOWN ABORT command to bring down your database instance. Consider the stepsthat will be performed later when you open the database: 1. SGA is allocated. 2. Control file is read. 3. Redo log files are read. 4. Instance recovery is ...
问题:单选题You want to create a role to meet these requirements: 1:The role is to be protected from unauthorized usage. 2:The password of the role is not to be embedded in the application source code or stored in a table. Which method would you use to restrict...
问题:单选题Automatic Shared Memory Management is disabled for your database instance. You realize that there arecases of SQL statements performing poorly because of repeated parsing activity, resulting in degradation ofperformance. What would be your next step t...