Good exam

题 1: 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; .

题 2: The ORDERS table has a column ORDER_DATE of data type DATE. The default display format for a date is DD-MON-RR Which two WHERE conditions demonstrate the correct usage of conversion functions?

A. WHERE order_date=TO_DATE(ADD_MONTHS(SYSDATE, 6), 'MON DD YYYY') . B. WHERE TO_CHAR(order date, 'MON-DD-YYYY') = 'JAN 20 2019'. C. WHERE order_date > TO_DATE('JUL 10 2018','MON DD YYYY'). D. WHERE order_date=TO_CHAR(ADD_MONTHS(SYSDATE, 6), 'MON DD YYYY).

题 3: 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.

题 4: 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;

题 5: 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.

题 6: 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.

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

题 8: 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 .

题 9: 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.

题 10: 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').

题 11: Which compression method is recommended for Direct-Path Insert operations?.

A. COLUMN STORE COMPRESS ADVANCED. B. ROW STORE COMPRESS ADVANCED . C. COLUMN STORE COMPRESS BASIC . D. ROW STORE COMPRESS BASIC

题 12: 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.

题 13: 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.

题 14: 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.

题 15: 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 .

题 16: Which two queries execute successfully?.

A. SELECT prod_id, exp_date FROM products UNION ALL SELECT prod_id, NULL FROM new_products;. B. SELECT prod_id, prod_name FROM products INTERSECT SELECT 100, prod_name FROM newproducts;. C. SELECT * FROM products UNION SELECT * FROM new_products;. D. SELECT k FROM products MINUS SELECT prod_id FROM new_products;.

题 17: 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.

题 18: 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. .

题 19: 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 .

题 20: 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.

题 21: 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.

题 22: Which four statements are true regarding primary and foreign key constraints and the effect they can have on table data?.

A. It is possible for child rows that have a foreign key to remain in the child table at the time the parent row is deleted. B. Primary key and foreign key constraints can be defined at both the column and table level. C. A table can have only one primary key and one foreign key. D. A table can have only one primary key but multiple foreign keys .

题 23: 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.

题 24: 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. .

题 25: 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 .

题 26: 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.

题 27: 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 .

题 28: 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 .

题 29: 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.

题 30: 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.

题 31: 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.

题 32: 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.

题 33: 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.

题 34: 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.

题 35: 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.

题 36: 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.

题 37: 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 .

题 38: Which two statements are true regarding Oracle database space management within blocks managed by Automatic Segment Space Management (ASSM)?.

A. Update operations always relocate rows into blocks with free space appropriate to the length of the row being updated. B. PCTFREE defaults to 10% for all blocks in all segments for all compression methods. C. The first block with enough free space to accommodate a row being inserted will always be used for that row. D. ASSM assigns blocks to one of four fullness categories based on what percentage of the block is allocated for rows.

题 39: 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 .

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

题 42: 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.

题 43: Examine this command SQL> ALTER TABLE ORDERS SHRINK SPACE COMPACT .Which two statements are true?.

A. Queries and DML statements are allowed on ORDERs while the SHRINK is executing. B. Dependent indexes become UNUSABLE. C. The SHRINK operation causes rows to be moved to empty space starting toward the end of the ORDERs segment. D. The SHRINK operation causes rows to be moved to empty space starting from the beginning of the ORDERs segment.

题 44: 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.

题 45: You need to calculate the number of days from 1st January 2019 until today. Dates are stored in the default format of DD-MON-RR .Which two queries give the required output?.

A. SELECT ROUND(SYSDATE-TO_DATE('01/JANUARY/2019'))FROM DUAL . B. SELECT SYSDATE-TO_DATE('01-JANUARY-2019') FROM DUAL; . C. SELECT ROUND(SYSDATE-'01-JAN-2019') FROM DUAL;. D. SELECT TO_DATE(SYSDATE, DD/MONTH/YYYY")-'01/JANUARY/2019' FROM DUALI

题 46: 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.

题 47: 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 .

题 48: Which two statements are true about Oracle synonyms?.

A. A synonym can be created on an object in a package. B. A synonym can have a synonym. C. Any user can create a PUBLIC synonym. D. A synonym has an object number.

题 49: 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.

题 50: Which two statements are true regarding a SAVEPOINT?.

A. Only one SAVEPOINT may be issued in a transaction. B. Rolling back to a SAVEPOINT can undo a CREATE INDEX statement. C. A SAVEPOINT does not issue a COMMIT. D. Rolling back to a SAVEPOINT can undo a DELETE statement.

题 51: Which two statements are true about the Oracle join and ANSI join syntax?.

A. The Oracle join syntax performs better than the SQL: 1999 compliant ANSI join syntax. . B. The Oracle join syntax lacks the ability to do outer joins. C. The SQL: 1999 compliant ANSI join syntax supports creation of a Cartesian product of two tables. D. The Oracle join syntax supports creation of a Cartesian product of two tables.

题 52: 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 .

题 53: 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.

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

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

题 55: 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.

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

题 57: 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.

题 58: 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.

题 59: Which three statements are true?.

A. The second ROLLBACK command restores the row that was inserted . B. The first ROLLBACK command leaves the inserted row locked. C. The second ROLLBACK command restores the 100 rows that were in the table originally . D. The second ROLLBACK command rolls back the ROLLBACK TO SAVEPOINT a command.

题 60: 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.

题 61: 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 .

题 62: Examine the description of the MEMBERs table:You want to display all cities that contain the string AN. The cities must be returned in ascending order with the last names further sorted in descending order.Which two clauses must you add to the query?.

A. ORDER BY 1, LAST_NAME DESC. B. ORDER BY1, 2. C. WHERE city IN (‘%AN%’) . D. WHERE city= ‘%AN%’ .

题 63: 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.

题 64: 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.

题 65: Which two statements are true about the UNLIMITED TABLESPACE system privilege and space quotas?.

A. It allows a role to have unlimited space in any tablespace in the database . B. It is overridden by a space quota specified for the user. C. It allows a user to have unlimited space only in their default permanent tablespace. . D. By default, users have no quota on their default permanent tablespace.

题 66: 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

题 67: 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 .

题 68: 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;

题 69: 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.

题 70: 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'.

题 71: 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.

题 72: 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.

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

题 74: 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 .

题 75: 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 .

题 76: 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.

题 77: Choose three. Which three statements are true about Resumable Space Allocation in Oracle databases?.

A. All sessions must have the same timeout value when waiting for resumable space allocations. B. A user's session may be suspended and resumed multiple times. C. A user's session may be suspended even if the user has the UNLIMITED TABLESPACE system privilege. D. Resumable space allocation is only possible with locally managed tablespaces.

题 78: 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.

题 79: Which two are true about a SQL statement using SET operators such as UNION?.

A. 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. B. The number, but not names, of columns must be identical for all SELECT statements in the query. C. The names and number of columns must be identical for all SELECT statements in the query. D. The data type of each column returned by the second query is automatically converted to the data type of the corresponding column returned by the first query.

题 80: 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 .

题 81: 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 .

题 82: Which three statements are true about the DESCRIBE command?.

A. It can be used from SQL Developer. B. It displays all constraints that are defined for each column. C. It can be used only from SQL*Plus. D. It displays the PRIMARY KEY constraint for any column or columns that have that constraint.

题 83: 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 .

题 84: 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.

题 85: 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 .

题 86: Which three statements are true about connection strings and service names used to connect to an Oracle database instance?.

A. A connection string must include the SID of a database instance. B. A single connection string can refer to multiple database instances. C. A connection string including a service name must be defined in the tnsnames.ora file. D. A service name is created by a listener.

题 87: 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

题 88: 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 .

题 89: 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 .

题 90: 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.