02

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 (PASSWORD_LOCK_TIME). the number of days for which an account may be inactive before it is locked (INACTIVE_ACCOUNT_TIME). 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. PASSWORD_REUSE_TIME or PASSWORD_REUSE_MAX unlimited. the number of password changes required within a period of time before a password can be reused (PASSWORD_REUSE_MAX). the number of days for which an account is locked after the configured number of login attempts has been reached (PASSWORD_LOCK_TIME). the maximum number of sessions permitted for a user before the account is locked.

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.

You want to use table compression suitable for OLTP that will: 1. Compress rows for all DML statements on that table 2. Minimize the overheads associated with compression Which compression option is best suited for this?. COLUMN STORE COMPRESS FOR QUERY LOW. ROW STORE COMPRESS BASIC. COLUMN STORE COMPRESS FOR ARCHIVE LOW. COLUMN STORE COMPRESS FOR ARCHIVE HIGH. ROW STORE COMPRESS ADVANCED.

Which two statements are true about space-saving features in an Oracle Database? (Choose two.). Private Temporary Tables (PTTS) store metadata in memory only. An index created with the UNUSABLE attribute has no segment. If they exist for a session, Private Temporary Tables (PTTs) are always dropped at the next COMMIT OR ROLLBACK statement. An index that is altered to be UNUSABLE will retain its segment. A table that is truncated will always have its segment removed.

Which two statements are true about the PMON background process? (Choose two.). It registers database services with all local and remote listeners known to the database instance. It frees resources held by abnormally terminated processes. It records checkpoint information in the control file. It frees unused temporary segments. It kills sessions that exceed idle time.

In which three situations does a new transaction always start? (Choose three.). when issuing a SELECT FOR UPDATE statement after a CREATE TABLE AS SELECT statement was issued in the same session. when issuing a TRUNCATE statement after a SELECT statement was issued in the same session. when issuing a CREATE TABLE statement after a SELECT statement was issued in the same session. when issuing the first Data Manipulation Language (DML) statement after a COMMIT OR ROLLBACK statement was issued in the same session. when issuing a CREATE INDEX statement after a CREATE TABLE statement completed successfully in the same session. when issuing a DML statement after a DML statement failed in the same session.

Examine the description of the SALES1 table: SALES2 is a table with the same description as SALES1. Some sales data is duplicated in both tables. You want to display the rows from the SALES1 table which are not present in the SALES2 table. Which set operator generates the required output?. INTERSECT. UNION ALL. UNION. SUBTRACT. MINUS.

Your database instance is started with a PFILE. Examine these parameters: You want to increase the size of the buffer cache. Free memory is available to increase the size of the buffer cache. You execute the command: SQL> ALTER SYSTEM SET DB_CACHE_SIZE=1024M; What is the outcome?. The value is changed only in the PFILE and takes effect at the next instance startup. The value is changed for the current instance and in the PFILE. It fails because the SCOPE clause is missing. Change is applied to the current instance, but does not persist after instance restart.

Which three Oracle database space management features will work with both Dictionary and Locally managed tablespaces? (Choose three.). Oracle Managed Files (OMF). Online table segment shrink - only with ASSM - LMT. Online index segment shrink - only with ASSM - LMT. Automatic data file extension (AUTOEXTEND). Capacity planning growth reports based on historical data in the Automatic Workload Repository (AWR).

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.). You can no longer monitor it. You can reattach to it and monitor it. It is paused and can be resumed. It continues to run in the background. It terminates.

In one of your databases, you create a user, HR, and then execute this command: GRANT CREATE SESSION TO hr WITH ADMIN OPTION; Which four actions can HR perform? (Choose four.). Revoke the CREATE SESSION privilege from other users. Revoke the CREATE SESSION privilege from user HR. Log in to the database instance. Grant the CREATE SESSION privilege with ADMIN OPTION to other users. Execute DDL statements in the HR schema. Execute DML statements in the HR schema.

Which two statements are true about the WHERE and HAVING clauses in a SELECT statement? (Choose two.). Aggregating functions and columns used in HAVING clauses must be specified in the SELECT list of a query. WHERE and HAVING clauses can be used in the same statement only if applied to different table columns. The HAVING clause can be used with aggregating functions in subqueries. The WHERE clause can be used to exclude rows before dividing them into groups. The WHERE clause can be used to exclude rows after dividing them into groups.

Which two statements are true about UNDO and REDO? (Choose two.). The generation of UNDO generates REDO. DML modifies Oracle database objects and only generates UNDO. The generation of REDO generates UNDO. DML modifies Oracle database objects and only generates REDO. DML modifies Oracle database objects and generates UNDO and REDO.

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?. as SCOTT in DALLAS_DB. as SCOTT in BOSTON_DB. as SCOTT in BOSTON_DB and SYS in DALLAS_DB. as SYS in both the databases. as SCOTT in both the databases.

Which three statements are true about the DESCRIBE command? (Choose three.). It displays the PRIMARY KEY constraint for any column or columns that have that constraint. It can be used from SQL Developer. It displays the NOT NULL constraint for any columns that have that constraint. It can be used to display the structure of an existing view. It displays all constraints that are defined for each column. It can be used only from SQL*Plus.

Examine the description of the CUSTOMERS table: For customers whose income level has a value, you want to display the first name and due amount as 5% of their credit limit. Customers whose due amount is null should not be displayed. Which query should be used?. SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNT FROM customers WHERE cust_income_level IS NOT NULL AND due_amount IS NOT NULL;. SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNT FROM customers WHERE cust_income_level != NULL AND cust_credit_ level !=NULL;. SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNT FROM customers WHERE cust_income_level <> NULL AND due_amount <> NULL;. SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNT FROM customers WHERE cust_income_level != NULL AND due_amount ! = NULL;. SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNT FROM customers WHERE cust_income_level IS NOT NULL AND cust_credit_limit IS NOT NULL;.

The INVOICE table has a QTY_SOLD column of data type NUMBER and an INVOICE_DATE column of data type DATE. NLS_DATE_FORMAT is set to DD-MON-RR. Which two are true about data type conversions involving these columns in query expressions? (Choose two.). CONCAT (qty_sold, invoice_date) : requires explicit conversion. invoice_date = '15-march-2019' : uses implicit conversion. invoie_date > '01-02-2019' : uses implicit conversion. qty_sold BETWEEN '101' AND '110' : uses implicit conversion. qty_sold = '0554982' uses implicit conversion.

Which three are types of segments in an Oracle Database? (Choose three.). undo. index. stored procedures. sequences. tables. clusters.

Which two statements are true about the results of using the INTERSECT operator in compound queries? (Choose two.). Column names in each SELECT in the compound query can be different. The number of columns in each SELECT in the compound query can be different. Reversing the order of the intersected tables can sometimes affect the output. INTERSECT returns rows common to both sides of the compound query. INTERSECT ignores NULLs.

Which two statements are true about single row functions? (Choose two.). MOD : returns the quotient of a division operation. FLOOR : returns the smallest integer greater than or equal to a specified number. TRUNC : can be used with NUMBER and DATE values. CONCAT : can be used to combine any number of values. CEIL : can be used for positive and negative numbers.