RAG082-71Q

Which two statements are true regarding a SAVEPOINT? (Choose two.). Rolling back to a SAVEPOINT can undo a CREATE INDEX statement. Rolling back to a SAVEPOINT can undo a TRUNCATE statement. Only one SAVEPOINT may be issued in a transaction. A SAVEPOINT does not issue a COMMIT. Rolling back to a SAVEPOINT can undo a DELETE statement.

Which three statements are true regarding single row subqueries?. They must be placed on the right side of the comparison operator or condition. They must be placed on the left side of the comparison operator or condition. They can be used in the where clause. A SQL statement may have multiple single row subquery blocks. They must return a row to prevent errors in the SQL statement. They can be used in the having clause.

Which three statements are true about the tools used to configure Oracle Net Services? (Choose three.). The Oracle Net Configuration Assistant is only used when running the Oracle installer. Oracle Net Manager can be used to centrally configure listeners on any database server target. The lsnrctl utility requires a listener.ora file to exist before it is started. Oracle Net Manager can be used to locally configure naming methods on a database server. Enterprise Manager Cloud Control can be used to centrally configure listeners on any managed database server. Enterprise Manager Cloud Control can be used to centrally configure net service names for any database server target.

Examine the description of the PROMOTIONS table: SELECT promo_cost, promo_category FROM promotions ORDER BY by 1;. SELECT DISTINCT promo_cost || ’ in ‘ || DISTINCT promo_category FROM promotions ORDER BY 1;. SELECT DISTINCT promo_category || ‘ has ‘ || promo_cost AS COSTS FROM promotions ORDER BY 1;. SELECT promo_category, DISTINCT promo_cost FROM promotions ORDER BY 2;. SELECT DISTINCT promo_category, promo_cost FROM promotions ORDER BY 1;.

The second rollback command restores the row that was inserted. The first rollback command leaves the table's 100 original rows locked. The second rollback command rolls back the rollback to savepoint a command. The first rollback command leaves the inserted row locked. The first RollBack command restores the row that was inserted. The second rollback command restores the 100 rows that were in the table originally. The first rollback command restores the 100 rows that were in the table originally.

Which three statements are true about GLOBAL TEMPORARY TABLES? (Choose three.). A TRUNCATE command issued in a session causes all rows in a GLOBAL TEMPORARY TABLE for the issuing session to be deleted. GLOBAL TEMPORARY TABLE rows inserted by a session are available to any other session whose user has been granted select on the table. GLOBAL TEMPORARY TABLE space allocation occurs at session start. Any GLOBAL TEMPORARY TABLE rows existing at session termination will be deleted. A GLOBAL TEMPORARY TABLE’S definition is available to multiple sessions. A DELETE command on a GLOBAL TEMPORARY TABLE cannot be rolled back.

Which two statements are true about segment types in an Oracle Database?. Table segments always have two or more extents. Temporary segments are only stored in a temporary tablespace. Undo segments are only stored in an undo tablespace. Cluster segments may contain data from multiple tables. Index segments always have two or more extents.

In the ORCL database, UNDOTBS1 is the active undo tablespace with these properties: 1. A size of 100 MB 2. AUTOEXTEND is off 3. UNDO_RETENTION is set to 15 minutes 4. It has RETENTION GUARANTEE UNDOTBS1 fills with uncommitted undo 10 minutes after the database opens. What will happen when the next update is attempted by any transaction?. It succeeds and the generated undo is stored in SYSTEM. It fails and returns the error message “ORA-30036: unable to extend segment by 8 in undo tablespace 'UNDOTBS1'”. It succeeds and the least recently written undo block of UNDOTBS1 is overwritten by the generated undo. It succeeds and the generated undo is stored in SYSAUX. It succeeds and the least recently read undo block of UNDOTBS1 is overwritten by the generated undo.

The CUSTOMERS table has a CUST_CREDIT_LIMIT column of data type NUMBER. Which two queries execute successfully? (Choose two.). SELECT NVL(cust_credit_limit * .15, ‘Not Available’) FROM customers;. SELECT NVL2(cust_credit_limit * .15, ‘Not Available’) FROM customers;. SELECT NVL(TO_CHAR(cust_credit_limit * .15), ‘Not Available’) FROM customers;. SELECT TO_CHAR(NVL(cust_credit_limit * .15, ‘Not Available’)) FROM customers;. SELECT NVL2(cust_credit_limit, TO_CHAR(cust_credit_limit * .15), ‘Not Available’) FROM customers;.

In the promotions table, the PROMO_BEGIN_DATE column is of data type date and the default date format Is DD-MON-RR h two statements are true about expressions using PROMO_BEGIN_DATE contained In a query?. to_numberipromo_begin_date) - s will return a number. PROMO_ BEGIN_DATE - sysdate will return a number. PROMO_ BEGIN_DATE - sysdate will return an error. PROMO_ BEGIN_DATE - 5 will return a date. TO_date(PROMO_ BEGIN_DATE * 5| will return a date.

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?. SELECT REPLACE<TRIM<TRAILING 'son* FROM cust_last_name), 'An', *O'> FROM customers;. SELECT REPLACE(SUBSTR(cust_last_name, -3), 'An', 'O') FROM customers;. SELECT REPLACE(REPLACE(cust_last_name, 'son', ''), 'An', 'O'> FROM customers;. SELECT INITCAP (REPLACE(TRIM('son' FROM cust_last_name), 'An', 'O*)) FROM customers;.

Which three activities are recorded in the database alert log? (Choose three.). Data Definition Language (DDL) statements. non-default database parameters. block corruption errors. deadlock errors. session logins and logouts.

The primary key constraint will be enabled and deferred. The foreign key constraint will be enabled and deferred. The foreign key constraint will be disabled. The foreign key constraint will be enabled and immediate. The primary key constraint will be enabled and immediate.

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.

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_%’;.

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?. It must be the value of the SERVICE_NAMES parameter on the client side. It must resolve to a valid connect descriptor in the server’s tnsnames.ora file. It must resolve to a valid connect descriptor in the client’s tnsnames.ora file. It must be the name of the database to whose instance HR wishes to connect. It must be the name of the server running the database to whose instance HR wishes to connect.

Which three statements are true about undo segments and the use of undo by transactions in an Oracle database instance? (Choose three.). An undo segment may be used by multiple transactions simultaneously. Undo segments can wrap around to the first extent when a transaction fills the last extend of the undo segment. Undo segments have a minimum of three extents. Undo segments can extend when a transaction fills the last extent of the undo segment. A single transaction may use multiple undo segments simultaneously. Undo segments must be stored in a BIGFILE tablespace. Undo segments must be stored in a SMALLFILE tablespace.

In the SALES database, DEFERRED_SEGMENT_CREATION is TRUE. Examine this command: SQL> CREATE TABLE T1(c1 INT PRIMARY KEY, c2 CLOB); Which segment or segments, if any, are created as a result of executing the command?. T1, an index segment for the primary key, a LOB segment, and a lobindex segment. no segments are created. T1 only. T1 and an index segment created for the primary key only. T1, an index segment for the primary key, and a LOB segment only.

Which two are true about a SQL statement using SET operators such as UNION? (Choose two.). The data type group of each column returned by the second query must match the data type of the corresponding column returned by the first query. The number, but not names, of columns must be identical for all SELECT statements in the query. The data type of each column returned by the second query must exactly match the data type of the corresponding column returned by the first query. The names and number of columns must be identical for all SELECT statements in the query. The data type of each column returned by the second query must be implicitly convertible to the data type of the corresponding column returned by the first query.

Which two tasks can you perform using DBCA for databases? (Choose two.). Configure a nonstandard block size for a new database. Register a new database with an available Enterprise Manager Management server. Change the standard block size of an existing database. Configure incremental backups for a new database. Enable flashback database for an existing database.

Examine this command: SQL> ALTER TABLE ORDERS SHRINK SPACE COMPACT Which two statements are true?. The high-water mark (HWM) of orders is adjusted. Only queries are allowed on ORDERS while the shrink is executing. Queries and DML statements are allowed on ORDERS while the shrink is executing. The shrink operation causes rows to be moved to empty space starting from the beginning of the orders segmen. Dependent indexes become UNUSABLE. The shrink operation causes rows to be moved to empty space starting toward the end of the orders segment.

You start your database instance in NOMOUNT state. Which two actions are performed?. The control files are opened. The consistency of the database is checked. All required background processes are started. SYS can access the database. Memory is allocated for the SG1.

Which three statements are true about views in an Oracle database? (Choose three.). Views can be updated without the need to re-grant privileges on the view. Tables in the defining query of a view must always exist in order to create the view. The WITH CHECK clause prevents certain rows from being displayed when querying the view. Data Manipulation Language (DML) can always be used on views. Inserting one or more rows using a view whose defining query contains a GROUP BY clause will cause an error. Deleting one or more rows using a view whose defining query contains a GROUP BY clause will cause an error.

The sales user must have a quota on the TEMP tablespace. The sales user must have a quota on the SALES_Q1 tablespace to hold the initial extends of all tables they plan to create in their schema. The sales user must have been granted the CREATE SESSION privilege. The sales user must have their quota on the users tablespace removed. The sales user must have a quota on the SALES_Q1 tablespace to hold all the rows to be inserted into any table in their schema. The sales user must have been granted the CREATE TABLE privilege.

Which three statements are true about the Automatic Diagnostic Repository (ADR)?. It Is held Inside an Oracle database schema. The ADR base is specified In the diagnostic_dest database parameter. It is only used for Oracle Database diagnostic information. It is a file-based repository held outside any database. It can be used for problem diagnosis of a database when that database's instance is down.

While one of your databases was in mount state, the datafiles were renamed because they had been moved to a new file system. The database was then opened. Which two statements are true?. DBA_DATA_FILES displays the original name for the data files. V$DATAFILE displays the new names for the data files. DBA_DATA _FILES displays both the new name and the old name for the data files. DBA_DATA_FILES displays the new name for the data files. DBA_DATA_FILES must be resynchronized manually with the control file an order to have it display the new file names.

Which two statements are true regarding Oracle database space management within blocks managed by Automatic Segment Space Management (ASSM)? (Choose two.). PCTFREE defaults to 10% for all blocks in all segments for all compression methods. ASSM assigns blocks to one of four fullness categories based on what percentage of the block is allocated for rows. Update operations always attempt to find blocks with free space appropriate to the length of the row being updated. Insert operations always attempt to find blocks with free space appropriate to the length of the row being inserted. A block will always be eligible for inserts if the row is short enough to fit into the block.

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.

The EMPLOYEES table contains columns EMP_ID of data type NUMBER and HIRE_DATE of data type DATE. You want to display the date of the first Monday after the completion of six months since hiring. The NLS_TERRITORY parameter is set to AMERICA in the session and, therefore, Sunday is the first day on the week. Which query can be used?. SELECT emp_id, ADD_MONTHS(hire_date, 6), NEXT_DAY(‘MONDAY’) FROM employees;. SELECT emp_id, NEXT_DAY(ADD_MONTHS(hire_date, 6), ‘MONDAY’) FROM employees;. SELECT emp_id, NEXT_DAY(MONTHS_BETWEEN(hire_date, SYSDATE), 6) FROM employees;. SELECT emp_id, NEXT_DAY(ADD_MONTHS(hire_date, 6), 1) FROM employees;.

ORDER BY 1, LNAME DESC. ORDER BY 1, 2. WHERE city LIKE *%AN%*. WHERE city = =%AN%. WHERE city IN (•%AN%'). ORDER BY last_narae DESC, city ASC.

An Oracle database session has an uncommitted transaction in progress which updated 5000 rows in a table. Which three situations does the transaction complete thereby committing the updates?. when a DBA issues a successful SHUTDOWN TRANSACTIONAL statement and the user then issues a COMMIT. when a CREATE INDEX statement is executed successfully in the same session. when a COMMIT statement is issued by the same user from another session in the same database instance. when the session logs out successfully. when a DBA issues a successful SHUTDOWN IMMEDIATE statement and the user then issues a COMMIT. when a CREATE TABLE AS SELECT statement is executed unsuccessfully in the same session.

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, &&col2FROM &tableWHERE &&condition = &&cond;. SELECT &col1, &col2FROM &&tableWHERE &condition;. SELECT &col1, &col2FROM “&table”WHERE &condition;. SELECT ‘&&col1’, ‘&&col2’FROM &tableWHERE ‘&&condition’ = ‘&cond’;. SELECT &&col1, &&col2FROM &tableWHERE &&condition;.

Which three statements are true about Oracle synonyms? (Choose three.). A synonym cannot be created for a PL/SQL package. A synonym can be available to all users. A SEQUENCE can have a synonym. A synonym created by one user can refer to an object belonging to another user. Any user can drop a PUBLIC synonym.

Which two statements are true about Oracle synonyms?. A synonym has an object number. A synonym can be created on an object in a package. A synonym can have a synonym. All private synonym names must be unique in the database. Any user can create a PUBLIC synonym.

You execute this query: SELECT TO_CHAR(NEXT_DAY(LAST_DAY(SYSDATE), ‘MON’), ‘dd “Monday for” fmMonth rrrr’) What is the result?. It executes successfully but does not return any result. It returns the date for the first Monday of the next month. It generates an error. It returns the date for the last Monday of the current month.

Which three statements are true about sequences in a single instance Oracle database?. Sequences can always have gaps. A sequence can Issue duplicate values. A sequence's unallocated cached values are lost if the instance shuts down. Two or more tables cannot have keys generated from the same sequence. A sequence can only be dropped by a DBA. A sequence number that was allocated can be rolled back if a transaction fails.

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.

INTERSECT. UNION ALL. UNION. SUBTRACT. MINUS.

The service DB01.abc.com is dynamically registered. The LOCAL_LISTENER database parameter is not set to a service name that refers to LISTENER_1. The service DB01.abc.com is statically registered. The listener is not listening on the default port 1521. The SID_LIST_LISTENER section is not contained in the LISTENER.ORA file.

Which two statements are true about the WHERE and HAVING clauses in a SELECT statement? (Choosetwo.). 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 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. Online index segment shrink. Automatic data file extension (AUTOEXTEND). Capacity planning growth reports based on historical data in the Automatic Workload Repository (AWR).

Which two statements are true about Database Instances and Real Application Clusters (RAC)?. A RAC database can have one Instance. A RAC database can have instances on separate servers. Two RAC databases can share their instances. A RAC database must have three or more Instances. A RAC database must have two or more instances.

Which two statements are true about the Automatic Diagnostic Repository (ADR)? (Choose two.). The ADR base defaults to $ORACLE_HOME/rdbms/admin ifneither DIAGNOSTIC_DEST nor ORACLE_BASE is set. The ADR base defaults to $ORACLE_HOME/dbs if the DIAGNOSTIC_DEST parameter and the ORACLE_BASE environment variable are not set. It supports diagnostics for Automatic Storage Management (ASM). It supports diagnostics for Oracle Clusterware. It is held inside an Oracle database schema.

SALES1 has not NULL constraints on any selected columns which had those constraints in the sales table. SALES1 has primary key and unique constraints on any selected columns which had those constraints in the sales table. SALES1 is created with 55,000 rows. SALES1 is created with no rows. SALES1 is created with 1 row.

Which two statements are true about the Oracle Data Dictionary?. It is owned by the sys user. Data dictionary base tables can be queried directly. It is owned by the system user. Data dictionary views are always created with queries that join two or more base tables. All data dictionary view joins base tables to dynamic performance views.

You want to use table compression suitable for OLTP that will: Compress rows for all DML statements on that table 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.

Examine the description of the BOOKS table: The second ROLLBACK command does nothing. The second ROLLBACK command replays the delete. The first ROLLBACK command restores the 101 rows that were deleted, leaving the inserted row still to be committed. The second ROLLBACK command undoes the insert. The first ROLLBACK command restores the 101 rows that were deleted and commits the inserted row.

Which three statements are true about time zones, date data types, and timestamp data types in an Oracle database? (Choose three.). The CURRENT_TIMESTAMP function returns data without time zone information. A TIMESTAMP WITH LOCAL TIMEZONE data type column is stored in the database using the time zone of the session that inserted the row. A TIMESTAMP data type column contains information about year, month, and day. The DBTIMEZONE function can return an offset from Universal Coordinated Time (UTC). The SESSIONTIMEZONE function can return an offset from Universal Coordinated Time (UTC).

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.

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.

SELECT prod_id Il q"'s not available" FROM product_status where status = 'OUT OF STOCK';. SELECT prod_id II q'l's not available)' FROM product_status WHERE status = 'OUT OF STOCK';. SELECT prod_id "CURRENT AVAILABILITY" II q'<'s not available)' FROM product_status WHERE status = 'OUT OF STOCK. SELECT prod_id I I q' (*s not available)' "CURRENT AVAILABILITY" FROM product_status WHERE status = 'OUT OF STOCK. SELECT prod_id I I q' ('s not available) • 'CURRENT AVAILABILITY' FROM product_status WHERE status = 'OUT OF STOCK. SELECT prod_id q's not available" FROM product_status WHERE status = 'OUT OF STOCK*;.

SELECT dept_id, AVG(MAX(salary)) FROM employees GROUP BY dept_id;. SELECT dept_id, join_date, SUM(salary) FROM employees GROUP BY dept_id;. SELECT dept_id, join_date, SUM(salary) FROM employees GROUP BY dept_id, join_date;. SELECT dept_id, MAX(AVG(salary)) FROM employees GROUP BY dept_id;.

Which two statements are true about undo and undo tablespaces?. There can be only one undo tablespace created in a database. An instance will crash if the active undo tablespace is lost. An undo tablespace may be owned by only one instance. undo segments are owned by SYSTEM. undo segments are owned by SYSBACKUP.

Which statement is true about database links?. Private database link creation requires the same user to exist in both the local and the remote databases. A public database link can be created only by sys. A database link can be created only between two Oracle databases. A public database link can be used by a user connected to the local database instance to connect to any schema in the remote database instance. A database link created in a database allows a connection from that database's instance to the target database's Instance, but not vice versa.

Which two statements are true about date/time functions in a session where NLS_DATE_FORMAT is set to DD-MON-YYYY HH24:MI:SS? (Choose two.). CURRENT_TIMESTAMP returns the same date and time as SYSDATE with additional details of fractional seconds. SYSDATE can be queried only from the DUAL table. CURRENT_DATE returns the current date and time as per the session time zone. SYSDATE can be used in expressions only if the default date format is DD-MON-RR. SYSDATE and CURRENT_DATE return the current date and time set for the operating system of the database server. CURRENT_TIMESTAMP returns the same date as CURRENT_DATE.

What is true about non-equijoin statement performance? (Choose two.). Table aliases can improve performance. The BETWEEN condition always performs better than using the >= and <= conditions. The join syntax used makes no difference to performance. The BETWEEN condition always performs less well than using the >= and <= conditions. The Oracle join syntax performs better than the SQL:1999 compliant ANSI join syntax.

Which statement is true about aggregate functions?. Aggregate functions can be nested to any number of levels. The AVG function implicitly converts NULLS to zero. Aggregate functions can be used in any clause of a SELECT statement. The MAX and MIN functions can be used on columns with character data types.

Which two statements are true about the SET VERIFY ON command? (Choose two.). It can be used only in SQL*Plus. It displays values for variables used only in the WHERE clause of a query. It can be used in SQL Developer and SQL*Plus. It displays values for variables created by the DEFINE command. It displays values for variables prefixed with &&.

Which two statements are true about User Authentication in an Oracle Database?. Operating System authentication may be used for system-privileged administrative users. REKOTE_LOGIN_PASSMOREFiLE must be set to exclusive to permit password changes for system-privileged administrative users. Password authentication must be used for system-privileged administrative users. Password File authentication must be used for system-privileged administrative users. Password File authentication is supported for any type of database user.

Which three statements are true about roles?. All roles granted to a user are set on by default when the user logs in,. Object privileges may not be granted to roles. The SET ROLE statement can disable one or more roles for a session. Roles must be password protected. Roles may be granted to roles. The SET ROLE statement can enable one or more roles for a session.

Which statement is true about the INTERSECT operator used in compound queries?. Multiple INTERSECT operators are not possible in the same SQL statement. It processes NULLs in the selected columns. INTERSECT is of lower precedence than UNION or UNION ALL. It ignores NULLs.

Which two queries execute successfully?. SELECT NULLIF(NULL, 100) FROM DUAL;. SELECT COALESCE (100, 'AM FROM DUAL;. SELECT 2TOLLIF(100, 'A') FROM DUAL;. SELECT NULLIF(100,100) FROM DUAL;. SELECT COALESCE(100, NULL, 200) FROM DUAL;.

Which two statements are true about the rules of precedence for operators? (Choose two.). The concatenation operator | | is always evaluated before addition and subtraction in an expression. NULLS influence the precedence of operators in an expression. The + binary operator has the highest precedence in an expression in a SQL statement. Arithmetic operators with equal precedence are evaluated from left to right within an expression. Multiple parentheses can be used to override the default precedence of operators in an expression.

The sales table has columns prod_id and quantity_sold of data type number In two queries execute successfully? x. SELECT prod_id FROM sales WHERE quantity_sold > 55000 GROUP BY prod_id HAVING COUNT(-) > 10;. SELECT prod_id FROM sales WHERE quantity_sold > 5S000 AND COUNT(-) > 10 GROUP BY prod_id HAVING COUNT(-) > 10;. SELECT COUNT|prod_id> FROM sales WHERE quantity_sold > 55000 GROUP BY prod_id;. SELECT COUNTlprod_id> FROM sales GROUP BY prod_id WHERE quantity_Sold > 55000;. SELECT prod_id FROM sales WHERE quantity_scld > 55000 AND COUNT(-) > 10 GROUP BY COUNT(-) > 10;.

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 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 your data center, Oracle Managed Files (OMF) is used for all databases. All tablespaces are smallfile tablespaces. SALES_Q1 is a permanent user-defined tablespace in the SALES database. Examine this command which is about to be issued by a DBA logged in to the SALES database: ALTER TABLESPACE sales_q1 ADD DATAFILE; Which are two actions, either one of which you could take to ensure that the command executes successfully? (Choose two.). Ensure that DB_RECOVERY_FILE_DEST and DB_CREATE_FILE_DEST each specify with at least 50 Mb of available space. Specify a path in the DATAFILE clause of the command specifying a location with at least 100M of available space. Ensure that DB_CREATE_FILE_DEST specifies a location with at least 100 Mb of available space. Add the AUTOEXTEND ON clause with NEXT set to 100M. Ensure that DB_RECOVERY_FILE_DEST and DB_CREATE_FILE_DEST each specify locations with at least 50 Mb of available space.

Examine the description of the employees table: SELECT join_date FROM employees WHERE join_date > '10-02-2018';. SELECT join_date I I ' ' II salary FROM employees;. SELECT SUBSTR<join_date, 1, 2) - 10 FROM employees;. SELECT join_date + '20' FROM employees; SELECT salary * '120.50' FROM employees;.

The stores table has a column START_DATE of data type DATE, containing the date the row was inserted. You only want to display details of rows where START_DATE is within the last 25 months. Which where clause can be used?. WHERE MON'THS_BETWEEN (SYSDATE, start_date) <= 25. WHERE ADD_MONTHS<start_date, 25) <= SYSDATE. WHERE TO_XUMBER(start_date - SYSDATE) <= 25. WHERE MON'THS_BETWEEN (start_date, SYSDATE) <= 25.

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.

Compressed objects in SALES01.DBF will be uncompressed In SALES02.DBF after the move. DML may be performed on tables with one or more extents in this data file during the execution of this command. It overwrites any existing file with the name SALES02.DBF.dbf in /u02 by default. The "to" clause containing the new file name must be specified even if Oracle Managed Files (OMF) is used. Tables with one or more extents in this data file may be queried during the execution of this command.