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

Which operator can be used in a multiple-row subquery to match a single value to a list of values?

• A.IN
• B.NOT NULL
• C.=
• D.EXISTS

What happens when a temporary table is created in Oracle Database?

• A.It is permanently stored in the database.
• B.It is created for the duration of a user session or transaction.
• C.It cannot have any constraints.
• D.It is stored in external files.

Which SQL function converts a string representation of a date into a date data type?

• A.TO_DATE
• B.DATE_CONVERT
• C.CAST_TO_DATE
• D.CONVERT_TO_DATE

What happens when a unique index is created on a table column?

• A.The column can only contain NULL values.
• B.The column cannot contain duplicate values.
• C.The column values are automatically encrypted.
• D.The column data type is converted to a primary key.

What is the purpose of using external tables in Oracle Database?

• A.To create temporary tables for session-specific data
• B.To store backup copies of database tables
• C.To improve the performance of complex queries
• D.To manage data stored in external files using SQL