Which is the default column or columns for sorting output from compound queries using SET operators such as intersect In a SQL statement?
Which statement is true about the INTERSECT operator used in compound queries?
Examine this description of the TRANSACTIONS table:
Which two SQL statements execute successfully? (Choose two.)
Which three statements are true about the tools used to configure Oracle Net Services? (Choose three.)
The customers table has a cust_last_name column of data type varchar2.
The table has two rows whose "jst_last_name values are Andersen and Ausson.
Which query produces output for cust_last_xame containing Oder for the first row and Aus for the second?
You execute this command:
During the export operation, you detach from the job by using CTRL+C and then execute this command:
Export> STOP_JOB=immediate
Are you sure you wish to stop the job ([yes]/no): yes
Which two statements are true about the job? (Choose two.)
Evaluate these commands which execute successfully:
Which two statements are true about the ORD_ITEMS table and the ORD_SEQ sequence? (Choose two.)
Which three statements are true about Oracle synonyms? (Choose three.)
In one of your databases, you create a user, HR, and then execute this command:
GRANT CREATE SESSION TO hr WITH ADMIN OPTION;
Which three actions can HR perform? (Choose three.)
You currently have an active transaction in your session and have been granted select access to vstransaction.
In which three situations will re-executing this query still return a row but with a different XID, indicating a new transaction has started?
You want to write a query that prompts for two column names and the WHERE condition each time it is executed in a session but only prompts for the table name the first time it is executed.
The variables used in your query are never undefined in your session.
Which query can be used?
Which three statements are true about connection strings and service names used to connect to an Oracle database instance?
Which three statements are true about undo segments and the use of undo by transactions in an Oracle database instance? (Choose three.)
Which three statements are true about the Oracle Data Dictionary? (Choose three.)
Which two statements are true about date/time functions in a session where NLS_DATE_FORMAT is set to DD-MON-YYYY HH24:MI:SS? (Choose two.)
Your database instance is started with an SPFILE.
A PFILE is also available. You execute this command:
ALTER SYSTEM SET DB_CACHE_SIZE=100K;
Where Is the value changed?
The SCOTT/TIGER user exists in two databases, BOSTON_DB and DALLAS_DB, in two different locations.
Each database has a tnsnames.ora file defining DALLAS_DB as a service name.
Examine this command:
CREATE DATABASE LINK dblink1 CONNECT TO scott IDENTIFIED BY tiger USING ‘dallas_db’;
How do you execute the command so that only SCOTT in BOSTON_DB can access the SCOTT schema in DALLAS_DB?
Which three statements are true about advanced connection options supported by Oracle Net for connection to Oracle Database instances? (Choose three.)
Which three statements are true about roles?
Which three statements are true about the Automatic Diagnostic Repository (ADR)?
Which three activities are recorded in the database alert log? (Choose three.)