Mock-Test Window

It Is Not Possible To Shrink Either Indexes Or Index Organized Tables (iots) It Always Eliminates All Migrated Rows If Any Exist In The Table To Shrink A Table It Must Have A Primary Key Constraint To Shrink A Table It Must Have A Unique Key Constraint To Shrink A Table It Must Have Row Movement Enabled It Must Be In A Tablespace That Uses Automatic Segment Space Management (assm)

Which three statements are true about advanced connection options supported by Oracle Net for connection to Oracle Database instances? (Choose three.)

Connect Time Failover Requires The Use Of Transparent Application Failover (taf) Source Routing Requires The Use Of A Name Server Source Routing Enables The Use Of Connection Manager (cman) Which Enables Network Traffic To Be Routed Through A Firewall Load Balancing Can Balance The Number Of Connections To Dispatchers When Using A Shared Server Configuration Load Balancing Requires The Use Of A Name Server Connect Time Failover Requires The Connect String To Have Two Or More Listener Addresses Configured

Examine this SQL statement: SELECT cust_id, cust_last_name “Last Name” FROM customersWHERE country_id = 10 UNION SELECT cust_id CUST_NO, cust_last_name FROM customers WHERE country_id = 30 Identify three ORDER BY clauses, any one of which can complete the query successfully. (Choose three.)

Order By “last Name” Order By 2 1 Order By 2 Cust_id Order By Cust_no Order By “cust_no”

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 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

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 performed by Oracle Automatic Storage Management (ASM) instances? (Choose three.)

Mounting Disk Groups Managing Allocation Units (aus) For Disk Group Content Managing Extent Allocation For Oracle Database Segments Acting As An I/o Server To Write Data File Blocks To Asm Disks On Behalf Of Database Writer Processes (dbwn) Managing Space Allocation For Oracle Asm Files Acting As An I/o Server To Read Data File Blocks From Asm Disks On Behalf Of Database Server Processes

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 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 With Check Clause Prevents Certain Rows From Being Updated Or Inserted

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?

The table has 100 rows. Examine this sequence of statements issued in a new session: INSERT INTO books VALUES (‘ADV112’, ‘Adventures of Tom Sawyer’, NULL, NULL); SAVEPOINT a; DELETE FROM books; ROLLBACK TO SAVEPOINT a; ROLLBACK; Which two statements are true? (Choose two.)

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 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

A Full Outer Join Returns Matched And Unmatched Rows An Inner Join Returns Matched Rows Outer Joins Can Only Be Used Between Two Tables Per Query A Full Outer Join Must Use Oracle Syntax Outer Joins Can Be Used When There Are Multiple Join Conditions On Two Tables A Left Or Right Outer Join Returns Only Unmatched Rows

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.

View the Exhibits and examine the structure of the COSTS and PROMOTIONS tables. You want to display PROD_IDS whose promotion cost is less than the highest cost PROD_ID in a promotion time interval. Examine this SQL statement:

It Gives An Error Because The All Keyword Is Not Valid It Gives An Error Because The Group By Clause Is Not Valid It Executes Successfully But Does Not Give The Required Result It Executes Successfully And Gives The Required Result

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

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

The ORCL database has RESUMABLE__TIMEOUT = 7200 and DEFERRED_SEGMENT_CREATION = FALSE User U1 has a 1 MB quota in tablespace DATA. U1 executes this command: SQL> CREATE TABLE t1 AS (SELECT object_name, sharing, created FROM dba_objects); U1 complains that the command is taking too long to execute. In the alert log, the database administrator (DBA) finds this: 2017-03-06T12:15:17.183438+05:30 statement in resumable session ‘User U1(136), Session 1, Instance 1’ was suspended due to ORA-01536: space quota exceeded for tablespace ‘DATA’ Which are three actions any one of which the DBA could take to resume the session? (Choose three.)

Add A Data File To Data Drop Other U1 Objects In Data Increase U1’s Quota Sufficiently In Data Set Deferred_segment_creation To True Grant Unlimited Tablespace To U1 Set Autoextend On For Data Files In Data

Which three statements are true about the Oracle Data Dictionary? (Choose three.)

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 As Sys In Both The Databases As Scott In Both The Databases

Otracle database administration 1 Quiz

🏅