082_11a20

Which three statements are true about a self join? (Choose three.). The ON clause must be used. The query must use two different aliases for the table. It must be an equijoin. It must be an inner join. The ON clause can be used. It can be an outer join.

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?. SELECT &&col1, &&col2 FROM &table WHERE &&condition = &&cond;. SELECT &col1, &col2 FROM &&table WHERE &condition;. SELECT &col1, &col2 FROM &"table" WHERE &condition;. SELECT '&&col1', '&&col2' FROM &table WHERE '&&condition' = '&cond';. SELECT &&col1, &&col2 FROM &table WHERE &&condition;.

SELECT * FROM customers WHERE city LIKE 'D_%';. SELECT * FROM customers WHERE city = '%D_';. SELECT * FROM customers WHERE city LIKE 'D_';. SELECT * FROM customers WHERE city = 'D_%';.

DML may be performed on tables with one or more extents in this data file during the execution of this command. The tablespace containing SALES1.DBF must be altered READ ONLY before executing the command. The tablespace containing SALES1.DBF must be altered OFFLINE before executing the command. If Oracle Managed Files (OMF) is used, then the file is renamed but moved to DB_CREATE_FILE_DEST. The file is renamed and stored in the same location.

Which three statements are true about dropping and unused columns in an Oracle database? (Choose three.). A primary key column referenced by another column as a foreign key can be dropped if using the CASCADE option. An UNUSED column's space is reclaimed automatically when the block containing that column is next queried. An UNUSED column's space is reclaimed automatically when the row containing that column is next queried. Partition key columns cannot be dropped. A DROP COLUMN command can be rolled back. A column that is set to UNUSED still counts towards the limit of 1000 columns per table.

Which three statements are true about single-row functions? (Choose three.). They can be used only in the WHERE clause of a SELECT statement. The argument can be a column name, variable, literal or an expression. The data type returned can be different from the data type of the argument. They can be nested to any level. They can accept only one argument. They return a single result row per table.

Which two statements are true about the ORD_ITEMS table and the ORD_SEQ sequence? (Choose two.). If sequence ORD_SEQ is dropped then the default value for column ORD_NO will be NULL for rows inserted into ORD_ITEMS. Any user inserting rows into table ORD_ITEMS must have been granted access to sequence ORD_SEQ. Column ORD_NO gets the next number from sequence ORD_SEQ whenever a row is inserted into ORD_ITEMS and no explicit value is given for ORD_NO. Sequence ORD_SEQ cycles back to 1 after every 5000 numbers and can cycle 20 times. Sequence ORD_SEQ is guaranteed not to generate duplicate numbers.

Which three instance situations are possible with the Oracle Database server without multi-tenant? (Choose three.). two or more instances on separate servers all associated with one database. one instance on one server associated with one database. one instance on one server associated with two or more databases on the same server. one instance on one server not associated with any database. one instance on one server associated with two or more databases on separate servers.

Which two statements are true about the ORDER BY clause when used with a SQL statement containing a SET operator such as UNION? (Choose two.). Column positions must be used in the ORDER BY clause. Only column names from the first SELECT statement in the compound query are recognized. The first column in the first SELECT of the compound query with the UNION operator is used by default to sort output in the absence of an ORDER BY clause. Each SELECT statement in the compound query must have its own ORDER BY clause. Each SELECT statement in the compound query can have its own ORDER BY clause.

Which four account management capabilities can be configured using Oracle profiles? (Choose four.). the number of hours for which an account is locked after the configured number of login attempts has been reached. the number of days for which an account may be inactive before it is locked. the maximum amount of CPU time allowed for a user's sessions before their account is locked. the ability to prevent a password from ever being reused. the number of password changes required within a period of time before a password can be reused. the number of days for which an account is locked after the configured number of login attempts has been reached. the maximum number of sessions permitted for a user before the account is locked.