1Z0-082 試験問題を無料オンラインアクセス

Which two statements are true about substitution variables?

• A.A substitution variable prefixed with to prompts only once for a value in a session unless it is set to undefined in the session
• B.A substitution variable can be used only in a select statement.
• C.A substitution variable can be used with any clause in a select statement.
• D.A substitution variable used to prompt for a column name must be enclosed in single quotation marks.
• E.A substitution variable prefixed with & always prompts only once for a value in a session.
• F.A substitution variable used to prompt for a column name must be enclosed in double quotation marks.

Which three statements are true about the Automatic Diagnostic Repository (ADR)?

• A.The ADR base is specified In the diagnostic_dest database parameter.
• B.It can be used for problem diagnosis of a database when that database's instance is down.
• C.It is only used for Oracle Database diagnostic information.
• D.It is a file-based repository held outside any database.
• E.It Is held Inside an Oracle database schema.

Examine these commands:

Which two statements are true about the sqiidr execution?

• A.It overwrites the data for Alan and adds data for Curl and Bob
• B.It appends data from EMP.DAT TO EMP.
• C.It generates a log that contains control file entries, which can be used with normal SQL'Loader operations.
• D.It generates a sqi script that it uses to load data from EMP.DAT TO EMP.
• E.It overwrites all data in emp with data from emp.dat.

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?

• A.SELECT REPLACE(REPLACE(cust_last_name, 'son', ''), 'An', 'O'> FROM customers;
• B.SELECT REPLACE<TRIM<TRAILING 'son* FROM cust_last_name), 'An', *O'> FROM customers;
• C.SELECT INITCAP (REPLACE(TRIM('son' FROM cust_last_name), 'An', 'O*)) FROM customers;
• D.SELECT REPLACE(SUBSTR(cust_last_name, -3), 'An', 'O') FROM customers;

What is true about non-equijoin statement performance? (Choose two.)

• A.The BETWEEN condition always performs better than using the >= and <= conditions
• B.Table aliases can improve performance
• C.The join syntax used makes no difference to performance
• D.The BETWEEN condition always performs less well than using the >= and <= conditions
• E.The Oracle join syntax performs better than the SQL:1999 compliant ANSI join syntax