1Z0-082 무료 덤프문제 온라인 액세스

Which three statements are true about external tables in Oracle 18c and later releases? (Choose three.)

• A.The ORACLE_DATAPUMP access driver can be used to unload data from a database into an external table
• B.They support UPDATEs but not INSERTs and DELETEs
• C.The ORACLE_DATAPUMP access driver can be used to load data into a database from an external table
• D.External table files can be used for other external tables in a different database
• E.They cannot be partitioned
• F.The ORACLE_LOADER access driver can be used to unload data from a database into an external table

Which three statements are true about inner and outer joins? (Choose three.)

• A.A full outer join returns matched and unmatched rows
• B.Outer joins can only be used between two tables per query
• C.An inner join returns matched rows
• D.A left or right outer join returns only unmatched rows
• E.A full outer join must use Oracle syntax
• F.Outer joins can be used when there are multiple join conditions on two tables

Which two statements are true about the SET VERIFY ON command? (Choose two.)

• A.It displays values for variables created by the DEFINE command
• B.It can be used in SQL Developer and SQL*Plus
• C.It can be used only in SQL*Plus
• D.It displays values for variables prefixed with &&
• E.It displays values for variables used only in the WHERE clause of a query

In one of your databases, the user HR has the password HRMGR.
You want to connect to a database instance whose listener listens on port 1531 by using this statement:
CONNECT HR/HRMGR@orcl
No name server is used.
Which statement is true about ORCL?

• A.It must resolve to a valid connect descriptor in the server's tnsnames.ora file
• B.It must be the value of the SERVICE_NAMES parameter on the client side
• C.It must resolve to a valid connect descriptor in the client's tnsnames.ora file
• D.It must be the name of the server running the database to whose instance HR wishes to connect
• E.It must be the name of the database to whose instance HR wishes to connect

Which two statements are true about substitution variables?

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