问题:单选题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...
查看答案
问题:单选题ou executed the command to create a password file in the database server: $ orapwd file=orapworcl entries=5 ignorecase=N Which statement describes the purpose of the above password file()A It records usernames and passwords of users when granted the D...
问题:单选题Given below is a list of scenarios: 1) A user terminates his session abnormally. 2) The connection between the server and the client application terminates because of a network failure. 3) A schema is accidentally dropped. 4) The tablespace is accident...
问题:You want to enable archiving on your database. Presently, th...
问题:单选题You have executed this command to change the size of the database buffer cache: SQL ALTER SYSTEM SET DB_CACHE_SIZE=2516582; System altered. To verify the change in size, you executed this command: SQL SHOW PARAMETER DB_CACHE_SIZE NAME TYPE VALUE ----...
问题:单选题In which situation is the UNDO_RETENTION parameter be ignored, even if it is set to a value()A When the data file of the undo tablespace is autoextensibleB When there are more than one undo tablespaces available in the databaseC When the undo tablespac...
问题:You receive complaints from users regarding the high waiting...
问题:单选题Your database is open and the LISTENER listener is running. The new DBA of the system stops thelistener by using the command: LSNRCTL STOP What happens to the sessions that are presently connected to the database instance()A The sessions are able to ...
问题:单选题In which situation may the UNDO_RETENTION parameter be ignored, even if it is set to a value()A when the data file of the undo tablespace is autoextensibleB when there are more than one undo tablespaces available in the databaseC when the undo tablespa...
问题:All the database users are presently connected to the databa...
问题:多选题The session of user SCOTT receives the following error after executing an UPDATE command onthe EMP table: ERROR at line 1: ORA-00060: deadlock detected while waiting for resource On investigation, you find that a session opened by user JIM has a tra...
问题:多选题Which three operations require undo data()Acommitting a transactionBflashing back a transactionCrecovering a failed transactionDrunning a read-consistent queryEchanging a tablespace status from READ ONLY to READ WRITE...
问题:单选题You used the IMMEDIATE option to shut down your database instance. Consider the steps that may occurwhen a database instance is started and database is opened: 1. SGA is allocated. 2. Control file is read. 3. Redo log files are opened.4. Instance recov...
问题:Given below is a list of scenarios: 1) A user terminates his...
问题:多选题You are managing an Oracle Database 11g database. The database is open, and you plan to performRecovery Manager (RMAN) backups. Which three statements are true about these backups()AThe backups would be consistent.BThe backups would be inconsistent.C...
问题:多选题Which statements are true about checkpointing()AThe checkpoint frequency decreases with the smaller redo log file size.BIt ensures that all committed data is written to the data files during normal shutdown.CThe frequent full checkpoint in a database ...
问题:多选题You notice that the performance of the database has degraded because of frequent checkpoints. Which two actions resolve the issue()ADisable automatic checkpoint tuning.BCheck the size of the redo log file size and increase the size if it is small.CSet ...
问题:单选题You executed this command to create a temporary table: SQL CREATE GLOBAL TEMPORARY TABLE report_work_area (startdate DATE, enddateDATE, class CHAR(20)) ON COMMIT PRESERVE ROWS; Which statement is true about the rows inserted into the REPORT_WORK_AREA t...
问题:多选题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...
问题:单选题User A executes the following command to drop a large table in your database:SQL DROP TABLE trans; While the drop table operation is in progress, user B executes the following command on the same table:SQL DELETE FROM trans WHERE tr_type=’SL’; Which st...