dumpstool logo
You need to recover a database running In NOARCHIVELOG mode. Which two statements are true in this scenario?
Your database instance is running. db01 is a net service name. You issue a connection request by using the command:
SQL> CONNECT scott/tiger@db01
Which component receives the request and establishes the appropriate connection?
Your customer is planning for a maximum-availability architecture at their data center to address their planned downtime, unplanned downtime, and replication needs.
Consider these options:
- Instance, site recovery, and heterogeneous setup
- Inter-region and intra-region load balancing across replicated databases
- Fine-grained error investigation of incorrect results
- Integrated client and application failover
- Fastest and simplest database replication
Which four options would you recommend?
Examine the command:
SQL> CREATE TABLE orders(oid NUMBER (6) PRIMARY KEY, odato DATE, ccode NUMBER (6), oamt NUMBER (10, 2)) TABLESPACE users ;
Which two statements are true about the execution of the command?
Which three events signal a database writer (DWR) to write buffers to disk?
Oracle Database 12c provides new task-specific privileges (SYSBACKUP, SYSDG, and SYSKM) to handle standard administration duties. Which two statements about these standard administration privileges are true?
Examine the table:
Table name: PRODUCTS
Schema: SCOTT
Tablespace: USERS
Organization: Standard (Heap Organized)
This table contains 20 rows. In the data that has been entered, the PROD_ID column contains only single-digit values, PROD_NAME has a maximum of five characters, and PROD_RATE has four-digit values for all rows.
Which two statements are true regarding the modifications that can be performed to the structure of the PRODUCTS table?
YOU want to move all objects of the CONSULTANT user from the test database to theDB-USER schema of the production database. Which option of IMPDP would you use to accomplish this task?
As part of your Oracle Database 12c post-installation tasks, you run these commands:
Cd $ORACLE_HOME/bin
srvctl stop database -d myDb
chopt enable dm
srvctl start database -d myDb
What does this do?
Examine the command below:
BEGIN DBMS_REDACT.ADD_POLICY(
object_schema => 'mavis',
object_name => 'cust_info',
column_name => 'emp_id',
policy_name => 'redact_cust_ids',
function_type => DBMS_REDACT.REGEXP,
expression => '1=1',
regexp_pattern => '(\d\d\d)(\d\d)(\d\d\d\d)',
regexp_replace_string => 'XXXXX\3',
regexp_position => 1,
regexp_occurrence => 0,
regexp_match_parameter => 'i',
policy_description => 'Redacts customer IDs',
column_description => 'emp_id contains employee ID numbers');
END;
/
What do the regexp_pattern and regexp_replace_string parameters accomplish?
Examine the command below:
LSNRCTL> SERVICES LISTENER2
Connecting to (DESCRIPTION=(ADDRESS= (PROTOCOL=TCP) (HOST=estb. us. abc.com) (PORT=1525)))
Services Summary. . .
Service "orcl.oracle.com" has 1 instance(s).
Instance "oracle", status UNKNOWN, has 1 handler(s) for this service... Handler(s):
"DEDICATED" established:2 refused:0 LOCAL SERVER The command completed successfully
Which two statements are true about LISTENER2?
You add the following code in the tnsnames.ora file on a client PC:
sales=
(DESCRIPTION=
(ADDRESS= (PROTOCOL=TCP)(HOST=salesdata) (PORT=1521) )
(CONNECT_DATA=
(SERVICE_NAME=sales.acme)))
Which statement is true about the code with respect to creating a new connect identifier?
Which three statements about Automatic Database Diagnostic Monitor (ADDM) are true?
TESTED 23 Dec 2024