多选题You perform differential incremental level 1 backups of your database on each working day and level 0 backupon Sundays, to tape. Which two statements are true about differential incremental backups()AThe backup performed on Sundays contains all the blo...
Sunday, May 5, 2024
单选题You are working on an instance started using the SPFILE. You want to move the Flash Recovery Area of yourdatabase to a new location. You want the Flashback log files to be stored in the new location. Given below are the steps to accomplish the task in ...
Tuesday, May 21, 2024
多选题Which two statements are true regarding Oracle Data Pump()AEXPDP and IMPDP are the client components of Oracle Data Pump.BDBMS_DATAPUMP PL/SQL packages can be used independently of the Data Pump clients.COracle Data Pump export and import operations ca...
Friday, February 17, 2023
多选题You plan to move data from a flat file to a table in your database. You decide to use SQL*Loader direct pathload method to perform this task. The table in which you plan to load data is an important table having variousintegrity constraints defined on ...
Thursday, March 30, 2023
多选题Which 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...
Tuesday, October 17, 2023
All the database users are presently connected to the databa...
Monday, September 19, 2022
单选题You have created a database link, devdb.us.oracle.com, between the databases PRODDB and DEVDB. You want to import schema objects of the HR user using Oracle Data Pump from thedevelopment database, DEVDB, to the production database, PRODDB. You execute ...
单选题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 notice that the performance of the database has degraded...
Thursday, September 15, 2022
单选题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...
Wednesday, March 15, 2023
单选题In your database instance, the STATISTICS_LEVEL initialization parameter is set to BASIC. What isthe impact of this setting()A Optimizer statistics are collected automatically.B Only timed operating system (OS) statistics and plan execution statistics...
Saturday, March 18, 2023
多选题Identify the situations in which you use the alert log file in your database to check the detail.()ARunning a query on a table returns ORA-600: Internal Error.BInserting a value in a table returns ORA-01722: invalid number.CCreating a table returns ORA...
单选题What could be the reason for this()A The listener is not running on the database node.B The TNS_ADMIN environmental variable is set to a wrong value.C The orcl.oracle.com database service is not registered with the listener.D The DEFAULT_DOMAIN par...
Saturday, January 6, 2024
多选题Which two files in the database can be configured for automatic backups by using the autobackupfeature in Recovery Manager (RMAN)()Adata filesBcontrol filesCparameter fileDonline redo log filesEserver parameter file...
Tuesday, October 10, 2023
单选题You executed this command to create a temporary table: SQL CREATE GLOBAL TEMPORARY TABLE report_work_area (startdate DATE, enddate DATE, class CHAR(20))ON COMMIT PRESERVE ROWS; Which statement is true about the rows inserted into the REPORT_WORK_AREA...
单选题In your database instance, the user sessions are connected to the database server from the remote machines.You want to achieve the following for these users: 1. The user account must be locked after four unsuccessful login attempts. 2. The user must be...
Sunday, November 19, 2023
多选题Which statements regarding the server parameter file (SPFILE) are true()AAn SPFILE is a binary file.BAn SPFILE cannot reside on a client.CAn SPFILE cannot contain static parameters.DAn SPFILE can store changes persistently across instance restarts.EAn...
Wednesday, July 5, 2023
单选题In your production database, data manipulation language (DML) operations are executed on the SALES table.You have noticed some dubious values in the SALES table during the last few days. You are able to track users, actions taken, and the time of the a...
Tuesday, May 7, 2024
单选题Which task would you perform before you run Oracle Universal Installer (OUI) in silent or suppressedmode for an installation()A Run the root.sh script.B Create the oraInst.loc file.C Create the tnsnames.ora file.D Run the oraintRoot.sh script....
Monday, February 12, 2024
单选题The HR user creates a stand-alone procedure as follows and grants the EXECUTE privilege on theprocedure to many database users: CREATE OR REPLACE PROCEDURE create_dept ( v_deptno NUMBER, v_dname VARCHAR2, v_mgr NUMBER, v_loc NUMBER) BEGIN INSERT INTO...