Good exam

题 1: Choose the best answer The CUSTOMERS table has a CUST_LAST_NAME column of data type VARCHAR2. The table has two rows whose COST_LAST_MANE values are Anderson and Ausson. Which query produces output for CUST_LAST_SAME containing Oder for the first row and Aus for thesecond?.

A. SELECT REPLACE (REPLACE(cust_last_name,'son',''),'An','O') FROM customers;. B. SELECT REPLACE (TRIM(TRALING 'son' FROM cust_last_name), 'An','O') FROM customers;. C. SELECT INITCAP (REPLACE(TRIM('son' FROM cust_last_name),'An','O')) FROM customers;. D. SELECT REPLACE (SUBSTR(cust_last_name,-3), 'An', 'O') FROM customers;

题 2: Which two statements are true about the PMON background process?.

A. It rolls back transactions when a process fails. B. It registers database services with all local and remote listeners known to the database instance . C. It frees unused temporary segments. D. It frees resources held by abnormally terminated processes .

题 3: Which statement is true about database links?.

A. 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. B. Private database link creation requires the same user to exist in both the local and the remote databases. C. 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. D. A public database link can be created only by sys.

题 4: In the spfile of a single instance database, LOCAL_LISTENER is set to LISTENER_1. The TNSNAMES.ORA file in $ORACLE HOME/network/admin in the database home contains: LISTENER_1 = (ADDRESS= (PROTOCOL= TCP) (HOST =host1.abc.com) (PORT=1521)) Which statement is true?.

A. There are two listeners named LISTENER and LISTENER_1 running simultaneously using port 1521on the same host as the database instances. B. The definition for LISTENER_1 requires a CONNECT_DATA section to enable dynamic service registration. C. LISTENER_1 must also be defined in the LISTENER. ORA file to enable dynamic service registration. D. The LREG process registers services dynamically with the LISTENER_1 listener .

题 5: Examine this command Which two statements are true?.

A. DML may be performed on tables with one or more extents in this data file during the execution of this command. B. It overwrites any existing file with the name SALES02.DBF in /u02 by default. C. Tables with one or more extents in this data file may be queried during the execution of this command. D. Compressed objects in sales01.DBF will be uncompressed in SALES02.DBF after the move .

题 6: Which two statements are true about the tools used to configure Oracle Net Services?.

A. The lsnrctrl utility requires a listener. ora file to exist before it is started. B. The Oracle Net Configuration Assistant is only used when running the Oracle installer. C. Enterprise Manager Cloud Control can be used to centrally configure net service names for any database server target. D. Oracle Net Manager can be used to centrally configure listeners on any database server target. .

题 7: Which two statements are true about the DUAL table?.

A. It can display multiple rows and columns. B. It can be accessed only by the sys user. C. It can display multiple rows but only a single column. D. It can be used to display only constants or pseudo columns.

题 8: Which three statements are true about the naming methods and their features supported by Oracle database used to resolve connection information?.

A. Directory Naming can be used if Connect-Time Failover is required. B. Local Naming requires setting the TNS_ADMIN environment variable on the client side . C. Local naming can be used if Connect-Time Failover is required. D. Directory Naming requires setting the TNS_ADMIN environment variable on the client side.

题 9: Which two statements are true concerning logical and physical database structures?.

A. A segment's blocks can be of different sizes. B. A segment might have only one extent. C. All tablespaces may have one or more data files . D. Segments can span multiple tablespaces.

题 10: Examine the description of the CUSTOMERS table: You need to display last names and credit limits of all customers whose last name starts with A or B in lower or upper case, and whose credit limit is below 1000 .Examine this partial query SELECT cust_last_name, cust_credit_limit FROM customers .Which two WHERE conditions give the required result?.

A. WHERE(INITCAP(cust_last_name) LIKE 'A%' OR INITCAP(cust_last_name) LIKE 'B%') AND cust_credit_limit < 1000. B. WHERE UPPER(cust_last_name IN ('A%', 'B%' ) AND cust_credit_limit < 1000. C. WHERE (UPPER(cust_last_name LIKE INITCAP('A') OR UPPER(cust -Last-name.LIKE INITCAP('B')) AND ROUND(cust_credit_limit)< ROUND(1000)；. D. WHERE( UPPER(cust_last_name LIKE 'A% OR UPPER(Cust_last_name LINK ‘B%’ AND ROUND(cust_credit_limit)< 1000.

题 11: Table ORDER_ITEMS contains columns ORDER_ID, UNIT_PRICE and QUANTITY, of data type NUMBER.Examine these SQL statements. Which two statements are true?.

A. Statement 1 returns only one row of output. . B. Statement 2 may return multiple rows of output. . C. Statement 2 returns only one row of output. D. Both the statements give the same output.

题 12: Which two Oracle database space management features require the use of locally managed Table spaces?.

A. Oracle Managed Files(OMF). B. Server-generated tablespace space alerts . C. Online segment shrink. D. Free space management with bitmaps .

题 13: You must create a tablespace of non-standard block size in a new file system and plan to use this command .The standard block size is 8k but other non-standard block sizes will also be used .Which two are requirements for this command to succeed?.

A. DB_32K_CACHE_SIZE must be set to a value that can be accommodated in the SGA . B. DB_32K_CACHE_SIZE should be set to a value greater than DB_CACHE_SIZE . C. DB_32K_CACHE_SIZE must be less than DB_CACHE_SIZE. D. The operating system must use a 32k block size.

题 14: Which two statements are true about undo segments and the use of undo by transactions in an Oracle database instance.

A. A single transaction may use multiple undo segments simultaneously. . B. Undo segments can be stored in the SYSAUX tablespace. C. Undo segments can extend when a transaction fills the last extent of the undo segment. D. Undo segments can wrap around to the first extent when a transaction fills the last extend of the undo segment.

题 15: Which two statements are true about substitution variables?.

A. A substitution variable used to prompt for a column name must be enclosed in double quotation marks. B. A substitution variable prefixed with s always prompts only once for a value in a session. C. A substitution variable used to prompt for a column name must be enclosed in single quotation marks. D. A substitution variable prefixed with && prompts only once for a value in a session unless it is set to undefined in the session.

题 16: Which three statements are true regarding the UNION and UNION ALL operators?.

A. The number of columns selected by the first SELECT statement can be greater than the number selected in subsequent SELECT statements. B. Duplicates are eliminated automatically by the UNION ALL operator. C. The number of columns selected in each SELECT statement must be identical . D. NULLS are not ignored during duplicate checking.

题 17: Which two statements are true about a full outer join?.

A. It returns matched and unmatched rows from both tables being joined . B. It returns only unmatched rows from both tables being joined. C. It includes rows that are returned by a Cartesian product. D. The Oracle join operator (+)must be used on both sides of the join condition in the WHERE clause.

题 18: The SALES_Q1 and USERS tablespaces exist in one of your databases And TEMP is a temporary tablespace.Segment creation is not deferred. You execute this command .Which three statements must be true so that the sales user can create tables in SALES_Q1?.

A. The sales user must have been granted the CREATE TABLE privilege. B. The sales user must have been granted the CREATE SESSION privilege . C. The sales user must have a quota on the TEMP tablespace. D. The sales user must have a quota on the SALES_Q1 tablespace to hold the initial extents of all tables they plan to create in their schema.

题 19: Which two statements are true about INTERVAL data types?.

A. INTERVAL YEAR TO MONTH columns support yearly intervals. B. The YEAR field in an INTERVAL YEAR TO MONTH column must be a positive value. C. The value in an INTERVAL DAY TO SECOND column can be copied into an INTERVAL YEAR TOMONTH column. D. INTERVAL YEAR TO MONTH columns only support monthly intervals within a single year .

题 20: Which two statements are true about the SET VERIPY ON command?.

A. It displays values for variables prefixed with &&. B. It displays values for variables created by the DEFINE command . C. It can be used in SQL Developer and SQL*Plus. D. It can be used only in SQL*Plus.

题 21: Which two queries execute successfully?.

A. SELECT NULLIF(100, 100) FROM DUAL . B. SELECT NULLIF(100,A) FROM DUAL; . C. SELECT COALESCE(100, 'A') FROM DUAL;. D. SELECT COALESCE(100, NULL, 200) FROM DUAL; .

题 22: Which two statements are true about UNDO and UNDO tablespaces?.

A. An UNDO tablespace may be owned by only one instance. B. UNDO segments are owned by SYSBACKUP . C. UNDO segments are owned by SYSTEM. D. There can be only one UNDO tablespace created in a database .

题 23: Which three are types of segments in an Oracle Database?.

A. clusters. B. sequences . C. stored procedures . D. views.

题 24: You execute this command: During the export operation, you detach from the job by using crtl+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?.

A. You can reattach to it and monitor it . B. You can reattach to it but not monitor it . C. It terminates. D. It continues to run in the backaround .

题 25: Which are two of the account management capabilities that can be configured using Oracle profiles?.

A. the number of days for which an account may be logged in to one or more sessions before it is locked. B. the number of days for which an account may be inactive before it is locked. C. the maximum number of sessions permitted for a user before the password must be changed . D. the ability to prevent a password from ever being reused.

题 26: Choose two Examine the data in the CUST NAME column of the CUSTOMERS table: CUST_NAME ---- 【Renske Ladwig--Jason Mallin--Samuel McCain--Allan MCEwen--Irene Mikkilineni--Julia Nayer】You want to display the CUST_NAME values where the last name starts with Mc or M

A. Which two WHERE clauses give the required result?. B. WHERE INITCAP (SUBSTR(cust_name, INSTR(cust_name,' ') +1 ) ) IN ('MC%', 'Mc%). C. WHERE UPPER (SUBSTR(cust_name, INSTR(cust_name, ' ') +1 ) ) LIKE UPPER('MC%'). D. WHERE INITCAP(SUBSTR(cust_name, INSTR(cust_name,' ') +1 ) ) LIKE 'Mc%'.

题 27: Which two statements are true about Enterprise Manager(EM)Express?.

A. By default, EM Express is available for a database after database creation using DBCA . B. You can shut down a database instance using EM Express. C. EM Express uses a separate repository database to store target database metadata. D. You cannot start up a database instance using EM Express.

题 28: Which three statements are true about inner and outer joins?.

A. Outer joins can be used when there are multiple join conditions on two tables . B. Outer joins can only be used between two tables per query. C. A left or right outer join returns only unmatched rows. D. A full outer join returns matched and unmatched rows .

题 29: Which three statements are true about Private Temporary Tables (PTTs)in an Oracle Database?.

A. Concurrent sessions may have PTTs with the same name but different column definitions . B. Concurrent sessions may have PTTs with the same name and the same column definitions . C. Creating a PTT is DDL and commits any active transaction for the session. D. It is possible to preserve the private table definition but remove the rows when a session with a PTT issues a COMMIT.

题 30: Choose two. Which two are true about transactions in the Oracle Database?.

A. An uncommitted transaction is automatically committed when the user exits SQL*Plus. B. A DDL statement issued by a session with an uncommitted transaction automatically commits that transaction. C. DDL statements automatically commit only data dictionary updates caused by executing the DDL. D. A session can see uncommitted updates made by the same user in a different session.

题 31: Which three filesare used by conventional path SQL*Loader when the TABLE option is not specified?.

A. password files. B. dump files. C. input files. D. control files.

题 32: Which two statements are true about space-saving features in an Oracle Database?.

A. An index created with the UNUSABLE attribute has no segment. B. Private Temporary Tables (PTTs) store metadata in memory only. C. Private Temporary Tables (PTTs) when used, are always dropped at the next commit statement. . D. An index that is altered to be UNUSABLE will retain its segment.

题 33: Which is the default column or columns for sorting output from compound queries using SET operators such as INTERSECT in a SQL statement?.

A. the first NUMBER or VARCHAR2 column in the last select of the compound query. B. the first NUMBER column in the first select of the compound query. C. the first vARCHAR2 column in the first select of the compound query . D. the first column in the first select of the compound query.

题 34: The CUSTOMERS table has a CUST_LAST_NAME column of data type VARCHAR2 The table has two rows whose CUST_LAST_NAME values are ANderson and Ausson Which query produces output for CUST_LAST_NAME containing Oder for the first row and Aus for the second?.

A. SELECT REPLACE(SUBSTR(cust_last_name, -3),'AN', "O')FROM customers; . B. SELECT INITCAPREPLACE(TRIM('SON FROM cust_last_name.,'AN,'O'))FROM customers;. C. SELECT REPLACE(TRIM(TRAILING "SON' FROM cust_last_name.,'AN, 'O') FROM customers. D. SELECT REPLACE(REPLACE(cust_last_name, ' son', ''),'AN', 'O') FROM customers;

题 35: Examine the description of the SALES table: The SALES table has 55,000 rows. Examine this statement: CREATE TABLE sales1 (prod_id, cust_id, quantity_sold, price) AS SELECT product_id, customer_id, quantity_sold, price FROM sales WHERE 1 = 1; Which two statements are true?.

A. SALES1 is created with 55,000 rows. B. SALES1 is created with no rows. C. SALES1 has NOT NULL constraints on any selected columns which had those constraints in the SALES table. D. SALES1 has PRIMARY KEY and UNIQUE constraints on any selected columns which had those constraints in the SALES table.

题 36: Which three statements are true about performing DML operations on a view with no INSTEAD OF triggers defined?.

A. Insert statements can always be done on a table through a view. B. The WITH CHECK clause has no effect when deleting rows from the underlying table through the view. C. Delete statements can always be done on a table through a view. D. Views cannot be used to add rows to an underlying table If the table has columns with NOT NULL constraints lacking default values which are not referenced in the defining query of the view.

题 37: In the PROMOTIONs table, the PROMO_BEGIN_DATE column is of data type DATE and the default date format is DD-MON-RR Which two statements are true about expressions using PROMO_BEGIN_DATE contained in a query?.

A. PROMO_BEGIN_DATE- SYSDATE will return a number . B. TO_DATE(PROMO_BEGIN_DATE * 5) will return a date. C. TO_NUMBER(PROMO_BEGIN_DATE - 5) will return a number . D. PROMO_BEGIN_DATE- SYSDATE will return an error .

题 38: Your database instance is started with an SPFILE.A PFILE is also available You execute this command .ALTER SYSTEM SET DB CACHE_SIZE=100K Where is the value changed?

A. in the SPFILE and PFTIE. B. in the SPFILE, PFILE, and memory . C. only in the SPFILE. D. in the SPFILE and in memory .

题 39: Which two statements are true about the configuration and use of UNDO RETENTION with no GUARANTEED RETENTION?.

A. Unexpired UNDO is always retained. B. UNDO RETENTION specifies for how long Oracle attempts to keep unexpired UNDO. C. UNDO_RETENTION specifies for how long Oracle attempts to keep expired and unexpired UNDO. D. UNDO RETENTION specifies how long all types of UNDO are retained .

题 40: Which three statements are true about Deferred Segment Creation in Oracle databases?.

A. It is the default behavior for tables and indexes. B. It is supported for sys-owned tables contained in locally managed tablespaces. C. Sessions may dynamically switch back and forth from DEFERRED to IMMEDIATE segment creation. D. Indexes inherit the DEFERRED or IMMEDIATE segment creation attribute from their parent table.

题 41: Which two statements are true about time zones, date data types, and timestamp data types in an Oracle database?.

A. The DBTIMEZONE function can return an offset from Universal Coordinated Time(UTC). B. A TIMESTAMP WITH LOCAL TIMEZONE data type column is stored in the database using the time zone of the session that inserted the row. C. The CURRENT TIMESTAMP function returns data without time zone information. D. The SESSIONTIMEZONE function can return an offset from Universal Coordinated Time(UTC).

题 42: Which three statements are true about the Automatic Diagnostic Repository (ADR)?.

A. It is a file-based repository held outside any database. B. The ADR base is specified in the DIAGNOSTIC_DEST database paramete . C. It is only used for Oracle Database diagnostic information. D. It is held inside an Oracle database schema.

题 43: Which three statements are true about roles?.

A. Roles must be password protected. B. Object privileges may not be granted to roles. C. The SET ROLE statement can disable one or more roles for a session. D. Roles may be granted to roles.

题 44: Which three are benefits of using temp UNDO when performing DML on global temporary tables?.

A. It reduces I/Os to the SYSTEM tablespace. B. It reduces the amount of redo generated. C. It reduces the amount of UNDO stored in the UNDO tablespace. D. It permits DML on Global temporary tables even if the database is opened read only.

题 45: Choose two The PRODUCT_INFORMATION table has a UNIT_PRICE column of data type NUMBER(8, 2). Evaluate this SQL statement: SELECT TO_CHAR(unit_price,'$9,999') FROM PRODUCT_INFORMATION; Which two statements are true about the output?.

A. A row whose UNIT_PRICE column contains the value 1023.99 will be displayed as $1,024. B. A row whose UNIT_PRICE column contains the value 1023.99 will be displayed as $1,023. C. A row whose UNIT_PRICE column contains the value 10235.99 will be displayed as $1,0236. D. A row whose UNIT_PRICE column contains the value 10235.99 will be displayed as $1,023.

题 46: 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 .What will be the result?.

A. It executes successfully and gives the required result. B. It gives an error because the GROUP BY clause is not valid . C. It executes successfully but does not give the required result . D. It gives an error because the ALL keyword is not valid

题 47: Examine the description of the PRODUCT INFORMATION table: Which query retrieves the number of products with a null list price?.

A. SELECT COUNT (NVL (list_price, 0)) FROM product_information WHERE list_price IS NULL;. B. SELECT COUNT (DISTINCT list_price) FROM product_information WHERE list_price IS NULL;. C. SELECT COUNT (list_price) FROM product information WHERE list_price IS NULL;. D. SELECT COUNT (list_price) FROM product information WHERE list_price = NULL;

题 48: Which two statements are true about single row functions?.

A. FLOOR: retums the smallest integer greater than or equal to a specified number. B. CEIL: can be used for positive and negative numbers. C. CONCAT: can be used to combine any number of values . D. TRUNC: can be used only with NUMBER data types .

题 49: Which two statements are true about UNDO and REDO?.

A. The generation of UNDO generates REDO. B. DML modifies Oracle database objects and generates UNDO and REDO . C. DML modifies Oracle database objects and only generates UNDO. . D. The generation of REDO generates UNDO.

题 50: Examine the description of the SATES1 table SALES2 is a table with the same description as SALES1 Some sales data is contained erroneously in both tables. You must display rows from SALES1 and SALES and wish to see the duplicates too. Which set operator generates the required output?.

A. MINUS . B. UNION ALL . C. SUBTRACT. D. UNION.

题 51: Which four activities can be performed using SQL Developer?.

A. It can be used to back up and recover databases using RMAN. B. It can be used to debug PL/SQL programs. C. It must be configured to allow SQLcl to be used. D. It can be used to develop server-side java programs.

题 52: Examine the description of the products table，Which query is valid?.

A. SELECT prod_id, AVG(MAX (cost)) FROM products GROUP BY prod_id. . B. SELECT prod_id, MAX (AVG (cost)) FROM products GROUP BY prod_id: . C. Select prod_id, release_date, SUM(cost) FROM products GROUP BY prod_id. D. SELECT prod_id, release_date, SUM(cost) FROM products GROUP BY prod_id, release_date

题 53: Which two statements are true regarding indexes?.

A. An update to a table can result in updates to any or all of the table's indexes . B. An update to a table can result in no updates to any of the table's indexes. C. A non-unique index can be altered to be unique. D. A table belonging to one user cannot have an index that belongs to a different user .

题 54: You currently have an active transaction in your session and have been granted select access to V$TRANSACTION，In which three situations will re-executing this query still return a row but with a different XID indicating a new transaction has started?.

A. after successfully executing a TRUNCATE statement followed by a DML statement. B. after successfully executing a CREATE TABLE AS Select statement followed by a SELECT FOR UPDATE statement. C. after successfully executing a CREATE TABLE statement followed by a CREATE INDEX statement. D. after successfully executing a commit or ROLLBACK followed by a DML statement .

题 55: Examine these commands Which two statements are true about the sqlldr execution?.

A. It overwrites the data for Alan and adds data for Curl and Bob. B. It generates a sql script that it uses to load data from EMP. DAT to EMP . C. It overwrites all data in EMP with data from EMP. DAT. D. It generates a log that contains control file entries, which can be used with normal SQL*Loader operations.

题 56: 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?.

A. DBA_DATA_FILES displays both the new name and the old name for the data files . B. DBA_DATA_FILES displays the original name for the data files. C. V$DATAEILE displays the new names for the data files. D. DBA_DATA_FILES must be resynchronized manually with the control file in order to have it display the new file names.

题 57: Examine the description of the SALES table.

A. SALES1 has NOT NULL constraints on any selected columns which had those constraints in the SAIES table. B. SALES1 is created with 55,000 rows. C. SALES1 has PRIMARY KEY and UNIQUE constraints on any selected columns which had those constraints in the sales table. D. SALES1 is created with no rows.

题 58: Examine this description of the TRANSACTIONS table Which two SQL statements execute successfully?.

A. SELECT customer_id CUSTID, transaction date TRANS_DATE, amount+ 100 DUES FROM transactions. B. SELECT customer_id AS "CUSTOMER-ID", transaction date AS DATE, amount + 100 “DUES” FROM transactions. C. SELECT customer_id AS ‘CUSTOMER-ID’, transaction date AS DATE, amount + 100 ‘DUES’ FROM transactions. D. SELECT customer_id AS "CUSTOMER-ID ", transaction date AS "DATE”, amount +100 DUES FROM transactions.

题 59: Which two statements are true about Database Instances and Real Application Clusters(RAC).

A. A RAC database can have instances on separate servers. B. A RAC database can have one instance. C. A RAC database must have two or more instances . D. Two RAC databases can share their instances.

题 60: Examine the description of the PRODUCT_DETAILs table: Which two statements are true?.

A. PRODUCT_NAME cannot contain duplicate values. B. EXPIRY_DATE contains the SYSDATE by default if no date is assigned to it . C. EXPIRY_DATE cannot be used in arithmetic expressions. D. PRODUCT_PRICE can be used in an arithmetic expression even if it has no value stored in it. .

题 61: Examine the description of the BOOKS_TRANSACTIONS table: Which two WHERE conditions give the same result?.

A. WHERE borrowed_date= SYSDATE AND (transaction_ type ='RM' AND (member_id='A101' OR member_id ='A102' )). B. WHERE borrowed_date= SYSDATE AND (transaction type='RM' OR member_id IN ('A101', 'A102')). C. WHERE borrowed_date= SYSDATE AND (transaction type ='RM' AND member_id 'A101' OR member id ='A102'). D. WHERE borrowed_date= SYSDATE AND transaction type ='RM' OR member id IN('A101', 'A102').

题 62: Which three statements are true regarding single row subqueries?.

A. They must be placed on the left side of the comparison operator or condition . B. They must return a row to prevent errors in the SQL statement. C. They can be used in the HAVING clause. D. A SQL statement may have multiple single row subquery blocks .

题 63: Which two are benefits of external tables?.

A. They support UPDATES which transparently updates records in the file system as if they were table. B. They can be queried while the database is in the MOUNT state like dynamic performance views . C. They support DELETEs which transparently deletes records in the file system as if they were table rows. D. The results of a complex join or aggregating function or both can be unloaded to a file for transportation to another database.

题 64: Which three statements are true about a self join?.

A. It can be an outer join. B. The ON clause can be used. C. The query must use two different aliases for the table . D. It must be an equijoin.

题 65: Which three statements are true about using SQL*Plus?.

A. It can run scripts passed to it by a shell script. B. It can run scripts entered at the SQL prompt. C. It has both command-line and graphical user interfaces(Gui). D. It has its own commands that are separate from any SQL statements .

题 66: Which three statements are true about indexes and their administration in an Oracle database?.

A. An INVISIBLE index is not maintained when Data Manipulation Language (DML) is performed on its underlying table. B. A descending index is a type of function-based index. C. An index can be created as part of a CREATE TABLE statement. D. If a query filters on an indexed column then it will always be used during execution of the query.

题 67: You start your database instance in NOMOUNT state. Which two actions are performed?.

A. sys can access the database. B. All required background processes are started . C. Memory is allocated for the SGA. D. The consistency of the database is checked .

题 68: Which three statements are true about dynamic performance views?.

A. They are owned by the SYSTEM user. B. V$FIXED_TABLE can be queried to display the name of all dynamic performance views. C. Data displayed by querying dynamic performance views is derived from metadata in the data dictionary. D. Data displayed by querying dynamic performance views is derived from memory structures.

题 69: In one of your databases, you create a user, HR, and then execute this command GRANT CREATE SESSION TO hr WITH ADMIN OPTION: Which three actions can HR perform?.

A. Grant the CREATE SESSION privilege with ADMTN OPTION to other users . B. Log in to the database instance. C. Revoke the CREATE session privilege from other users . D. Execute DDL statements in the HR schema.

题 70: Choose two Examine this query: SELECT employee_id,first_name,salary FROM employees WHERE hire_date > '&1'; Which two methods should you use to prevent prompting for a hire date value when this query is executed?.

A. Use the DEFINE command before executing the query. B. Store the query in a script and pass the substitution value to the script when executing it. C. Replace '&1' with '&&1' in the query. D. Execute the SET VERIFY OFF command before executing the query.

题 71: Examine the description of the EMPLOYEES table NLS_DATE_FORMAT is set to DD-MON-YY Which query requires explicit_data type conversion?.

A. SELECT join_date FROM employees WHERE join_date > '10-02-2018'; . B. SELECT join_date || ' ' || salary FROM employees. C. SELECT salary + '120.50' FROM employees. D. SELECT SUBSTR( join_date, 1, 2)-10 FROM employees .

题 72: View the Exhibit and examine the description of the tables You execute this SQL statement Which three statements are true?.

A. The sales table has five foreign keys. B. The statement will execute successfully and a new row will be inserted into the SALES table. C. A product can have a different UNIT_PRICE at different times. D. A customer can exist in many countries.

题 73: 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?.

A. V$DATAFILE displays the new names for the data files. B. DBA_DATA_FILES displays the original name for the data files. C. DBA_DATA_FILES must be resynchronized manually with the control file in order to have it display the new file names. D. DBA_DATA_FILES displays the new name for the data files.

题 74: Which three activities are recorded in the database alert log?.

A. block corruption errors. B. Data Definition Language(DDL)statements . C. Non-default database parameters . D. deadlock errors.

题 75: Which two statements are true about views?.

A. A view must only refer to tables in its defining query. B. The WITH CHECK clause prevents certain rows from being displayed when querying the view. C. Views can be updated without the need to re-grant privileges on the view. D. The WITH CHECK clause prevents certain rows from being updated or inserted in the underlying table through the view. .

题 76: Which three statements are true about data block storage in an Oracle Database?.

A. An index block can contain row data. B. A data block header is of a fixed length. C. A table block must always contain row data. D. A block header contains a row directory pointing to all rows in the block.

题 77: Examine these SOL statements which execute successfully，Which two statements are true after execution?.

A. The primary key constraint will be enabled and IMMEDIATE . B. The foreign key constraint will be enabled and DEFERRED . C. The foreign key constraint will be disabled. D. The foreign key constraint will be enabled and IMMEDIATE .

题 78: As the DBA, you execute this command: GRANT CREATE VIEW TO usr1 WITH ADMIN OPTION; USR1 then executes this command: GRANT CREATE VIEW TO usr2 WITH ADMIN OPTION; USR2 then executes this command: GRANT CREATE VIEW TO usr3; Which statement is true?.

A. USR1 can revoke the CREATE VIEW privilege from USR3. B. The DBA can revoke only ADMIN OPTION from USR1. C. When the DBA revokes the CREATE VIEW privilege from USR1, it is revoked from USR2 but not USR3. D. When the DBA revokes the CREATE VIEW privilege from USR1, it is neither revoked from USR2 nor USR3.

题 79: The ORCL database has RESUMABTE_TIMEOUT =7200 and DEFERRED SEGMENT CREATION=FALSE User U1 has a 1 MB quota in tablespace DATA. Ul executes this command .Ul complains that the command is taking too long to execute .In the alert log, the database administrator (DBA ) finds this 2017-03-06912: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 take to resume the session?

A. Set AUTOEXTEND ON for data files in DAMA. B. Set DEFERRED SEGMENT CREATION to TRUE. C. Increase Ul's quota sufficiently in DATA . D. Grant UNLIMIRED TABLESPACE to U1.

题 80: Which two statements are true about the Oracle Data Dictionary?.

A. Data dictionary base tables can be queried directly. B. All data dictionary view join base tables to dynamic performance views . C. It is owned by the SYSTEM user. D. Data dictionary views are always created with queries that join two or more base tables .

题 81: Examine the description of the PRODUCR_STATUS table.The STATUS column contains the values 'in stock' or 'OUT OF STOCK' for each row .Which two queries will execute successfully?.

A. SELECT prod_id || q ' ('s not available)' from product status WHERE status = 'OUT OF STOCK';. B. SELECT prod_id || q ' ('s not available)' "CURRENT AVAILABILITY" FROM product status WHERE status = 'OUT OF STOCK ';. C. SELECT prod_id "CURRENT AVAILABILITY" || q ' ('s not available)' from product status WHERE status = 'OUT OF STOCK';. D. SELECT prod_id || q('s not available)' 'current AVAILABILITY ' FROM product status WHERE status = 'OUT OF STOCK'.

题 82: What is true about non-equijoin statement performance?.

A. The join syntax used makes no difference to performance. B. The BETWEEN condition used with an non-equijoin sometimes performs better than using the >=and<= conditions. C. The BETWEEN condition used with an non-equijoin always performs better than when using the>=and <= conditions. D. The Oracle join syntax performs better than the sql: 1999 compliant ANSI join syntax .

题 83: Which two tasks can you perform using DBCA for databases?.

A. Configure a nonstandard block size for a new database . B. Configure incremental backups for a new database. C. Change the standard block size of an existing database. D. Register a new database with an available Enterprise Manager Management server.

题 84: Which two statements are true about GLOBAL TEMPORARY TABLES?.

A. GLOBAL TEMPORARY TABLE rows inserted by a session are available to any other session whose user has been granted select on the table. B. A GLOBAL TEMPORARY TABLE's definition is available to multiple sessions. C. A TRUNCATE command issued in a session causes all rows in a GLOBAL TE MPORARY TABLE for the issuing session to be deleted. D. A DELETE command on a GLOBAL TEMPORARY TABLE cannot be rolled back.

题 85: Which three statements are true about UNDO and REDO?.

A. UNDO is used for some flashback operations. B. Both REDO and UNDO can be multiplexed. C. UNDO is used for read consistency. D. REDO is used for ROLLBACK.

题 86: Which two statements are true about User Authentication in an Oracle Database?.

A. Password File authentication is supported for any type of database user. B. Operating System authentication may be used for system-privileged administrative users C. Password authentication must be used for system-privileged administrative users . D. Password File authentication must be used for system-privileged administrative users.

题 87: Which three tasks are performed by background processes in an Oracle database instance?.

A. registering services with Oracle Net listeners. B. writing dirty database block images from the buffer cache . C. writing redo to log files. D. reading database blocks into the buffer cache .

题 88: A database is configured to use automatic undo management with temporaryundo enabled. An UPDATE is executed on a temporary table. Where is the UNDO stored?.

A. in the undo tablespace. B. in the SYSAUX tablespace. C. in the SGA. D. in the PGA.

题 89: Which two statements are true about the results of using the INTERSECT operator in compound queries?.

A. Reversing the order of the intersected tables can sometimes affect the output . B. INTERSECT returns rows common to both sides of the compound query . C. Column names in each SELECT in the compound query can be different. D. The number of columns in each SELECT in the compound query can be different .

题 90: You want to apply the principle of Least Privilege in all your live databases.One of your requirements is to revoke unnecessary privileges from all users who have them using Privilege Analysis.Which two are types of analyses that can be done using the DBMS_PRIVILEGE_CAPTURE package?.

A. analysis of privileges that a user has on other schema's objects . B. analysis of privileges that a user has on their own schema objects. C. analysis of privileges granted indirectly to a role that are then used by a user who has been granted that role. D. analysis of privileges granted directly to a role that are then used by a user who has been granted that role.