多选

1 Which two statements are true about space-saving features in an Oracle Database?(Choose two.) 

多选

2 Which two statements are true about views?(Choose two.) 

多选

3 Examine the description of the products tableWhich query is valid?

多选

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

多选

5 Which two statements are true about the PMON background process?(Choose two.) 

多选

6 Examine the description of the BOOKS_TRANSACTIONS table:Examine this partial SQL statement:Which two WHERE conditions give the same result?(Choose two.) 

多选

7 Which three statements are true?Now examine this sequence of statements issued in a new session:

多选

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

多选

9 Examine the description of the MEMBERs table: Examine the partial query: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?

多选

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

多选

11 Which two statemnents are true about undo segments and the use of undo by transactions in an Oracle database instance

多选

12  In the PROMOTIONs table,the PROMO_BEGIN_DATE column is of data type DATE and the default date format is DD-MON-RRWhich two statements are true about expressions using PROMO_BEGIN_DATE contained in a query?

多选

13 Which three statements are true about the naming methods and their features supported byOracle database used to resolve connection information?

多选

14 Examine the description of the SATES1 table NameSALES2 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 SALES2 and wish to see the duplicates too.Which set operator generates the required output?

多选

15 Which two statements are true about Oracle synonyms?(Choose two.) 

多选

16 Examine the description of the PRODUCT_DETAILs table:Which two statements are true?(Choose two.) 

多选

17 Which three statements are true about connection strings and service names used to connect to an Oracle database instance?（Choose three.） 

多选

18 Which compression method is recommended for Direct-Path Insert operations?

多选

19 Which three statements are true about Deferred Segment Creation in Oracle databases?（Choose three.） 

多选

20 Which two Oracle database space management features require the use of locally managed Table spaces?

多选

21 Which three statements are true about data block storage in an Oracle Database?（Choose three.） 

多选

22 Which two are true about a SQL statement using SET operators such as UNION?

多选

23 Which two are benefits of external tables?

多选

24 Which three statements are true regarding the UNION and UNION ALL operators?

多选

25 The SALES table has columns PROD_ID and QUANTITY_SOLD of data type NUMBER.Which two queries execute successfully?(Choose two.) 

多选

26 Which two statements are true about INTERVAL data types?

多选

27 Which two statements are true concerning logical and physical database structures?

多选

28 Which two statements are true about the Oracle join and ANSI join syntax?

多选

29 Examine this commandWhich two statements are true?

多选

30 Which three are types of segments in an Oracle Database?

多选

31 Which two statements are true about the SET VERIPY ON command?

多选

32 Which are two of the account management capabilities that can be configured using Oracle profiles?

多选

33 Which three statements are true regarding single row subqueries?

多选

34 You execute this command:[oracle@host.01 ~]$ expdp system/oracle \> FULL=Y  \> DUMPFILE=exp_dh_full.dmp \> PARALLEL=4> LOGFILE=exp_db_full.log> JOB_NAME=exp_db_fullDuring the export operation, you detach from the job by using crtl+c and then execute this commandExport> STOP_JOB=immediateAre you sure you wish to stop the job ([yes]/no):yesWhich two statements are true about the job?

多选

35 Which three statements are true about the Automatic Diagnostic Repository(ADR)?

多选

36 Examine this commandALTER DATABASE           MOVE DATAPILE  '/u01/sales01.dbf'                      TO             '/u02/sales02.dbf'Which two statements are true?

多选

37 Which two statements are true about substitution variables?

多选

38 Examine this description of the TRANSACTIONS tableName                                Null?                                Type-----------------------        ----------------------         ----------------------TRANSACTION_ID             NOT NULL                        VARCHAR2(6)TRANSACTION_DATE                                                 DATEAMOUNT                                                                   NUMBER(10,2)CUSTOMER_ID                                                           VARCHAR2 (6)Which two SQL statements execute successfully?

多选

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

多选

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

多选

41 Examine the description of the EMPLOYEES table NLS_DATE_FORMAT is set to DD- MON-YYWhich query requires explicit_data type conversion?

多选

42 Your database instance is started with an SPFILE. A PFILE is also availableYou execute this commandALTER SYSTEM SET DB CACHE_SIZE=100KWhere is the value changed?

多选

43 The ORCL database has RESUMABTE_TIMEOUT=7200 and DEFERRED SEGMENT CREATION=FALSEUser 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 executeIn the alert log, the database administrator (DBA) finds this2017-03-06T12:15:17.183438+05:30statement 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?

多选

44 While one of your databases was in mount state, the datafiles were renamed because they had been moved to a new file systemThe database was then openedWhich two statements are true?

多选

45 Which two statements are true about Database Instances and Real Application Clusters(RAC)

多选

46 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 commandCREATE USER sales              IDENTIFIED BY sales_123              DEFAULT TABLESPACE sales_ql              TEMPORARY TABLESPACE temp              QUOTA 5M ON users;Which three statements must be true so that the sales user can create tables in SALES_Q1?

多选

47 Which two statements are true about the DUAL table?

多选

48 Which three statements are true about the DESCRIBE command?

多选

49 Which two queries execute successfully?

多选

50 Which three statements are true about inner and outer joins?

多选

51 View the Exhibit and examine the description1 of the tables You execute this SQL statementINSERT INTO sales VALUES (    23, 2300, SYSDATE,   (SELECT channel_id        FROM channels     WHERE channel_desc ='Direct Sales'),   12, 1, 500);Which three statements are true? (Choose three.) 

多选

52 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 apromotion time intervalExamine this SQL statementSELECT prod idFROM costsWHERE promo id IN(SELECT、promo idFROM promotionsWHERE promo cost ALL(SELECT MAX (promo cost)FROM promotionsGROUP BY (promoend_date -promo _begin date)));What will be the result?

多选

53 You must create a tablespace of non-standard block size in a new file system and plan to use this commandCREATE TABLESPACE ns_tbs             DATAPILE '/u02/oracle/data/nstbg_f01.dbf'             SIZE 100G             BLOCKSIZE 32K;The standard block size is 8k but other non-standard block sizes will also be usedWhich two are requirements for this command to succeed?

多选

54 Which two statements are true about single row functions?

多选

55 Examine the description of the PRODUCR_STATUS tableName                      Nu11?                         Type------------------     -------------------        -------------------PROD_ID                 NOT NULL                  NUMBER(2)STATUS                   NOT NULL                  VARCHAR2(15)The STATUS column contains the values 'in stock' or 'OUT OF STOCK' for each rowWhich two queries will execute successfully?

多选

56 Which two statements are true about Enterprise Manager(EM)Express?

多选

57 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=hostl.abc.com)(PORT=1521))Which statement is true?

多选

58 Which two statements are true about UNDO and REDO?

多选

59 Examine the description of the CUSTOMERS table:Name                               Nu11?                              Type-------------------             ----------------------        --------------------------------CUST ID                           NOT NULL                        VARCHAR2(2)CUST_LAST_NAME                                                   VARCHAR2(30)CITY                                                                          VARCHAR2(10)CUST_CREDIT_LIMIT                                                NUMBER(6,2)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 1000Examine this partial querySELECT cust_last_name,cust_credit_limit FROM customersWhich two WHERE conditions give the required result?

多选

60 Which two statements are true about the tools used to configure Oracle Net Services?

多选

61 Which statement is true about database links?

多选

62 Which two statements are true about the Oracle Data Dictionary?

多选

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

多选

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

多选

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

多选

66 Which two statements are true about UNDO and UNDO tablespaces?

多选

67 Which two statements are true regarding indexes?

多选

68 In your data center, Oracle Managed Files(OMF)is used for all databases.All tablespaces are smallfile tablespacesSALE_Q1 is a permanent user-defined tablespace in the sales databaseExamine this command which is about to be issued by a DBA logged in to the sales databaseALTER TABLESPACE sales_ql ADD DATAFILE;Which are two actions, either one of which you could take to ensure that the command executes successfully?

多选

69 The CUSTOMERS table has a CUST_LAST_NAME column of data type VARCHAR2The table has two rows whose CUST_LAST_NAME values are ANderson and AussonWhich query produces output for CUST_LAST_NAME containing Oder for the first row and Aus for the second?

多选

70 Examine these commands[oracle@host01 ~]$ sqlplus u1/oracleSQL> SELECT* FROM emp;ENO             ENAME                   DN---------       -----------               -----------1                   Alan                        22                   Ben                         2SQL> exit[oracle@host01 ~]$ cat emp.dat1,Alan,23,Cur1,44,Bob,4[oracle@host01 ~]$ sqlldr u1/oracle TABLE=empWhich two statements are true about the sqlldr execution?

多选

71 Which two tasks can you perform using DBCA for databases?

多选

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

多选

73 What is true about non-equijoin statement performance?

多选

74 You start your database instance in NOMOUNT state. Which two actions are performed?

多选

75 Which three statements are true about sequences in a single instance Oracle database?

多选

76 Which three activities are recorded in the database alert log?

多选

77 Examine the description of the SALES tableName                          Nu1l?                             Type---------------------     ---------------------        --------------------PRODUCT ID               NOT NULL                     NUMBER(10)CUSTOMER_ID            NOT NULL                     NUMBER (10)TIME_ID NOT NULL DATECHANNEL_ID NOT NULL NUMBER (5)PROMO_ID NOT NULL NUMBER(5)QUANTITY_SOLD NOT NULL NUMBER (10,2)PRICE NUMBER(10,2)AMOUNT_SOLD NOT NULL CNUMBER(10,2)The sALEs table has 55,000 rows.Examine this statement:SQL>CREATE TABLE sales1 (prod_id,cust_id,quantity_soud,price) AS SELECT product_id,customer_id,quantity_sold,price FROM sales WHERE 1=1;Which two statements are true? (Choose two.)

多选

78 Which two statements are true about User Authentication in an Oracle Database?

多选

79 Which two statements are true about segment types in an Oracle Database?

多选

80 Which three tasks are performed by background processes in an Oracle database instance?

多选

81 Examine these SOL statements which execute successfullyWhich two statements are true after execution?CREATE TABLE emp     (emp_no    NUMBER(2) CONSTRAINT emp_emp_no_pk PRIMARY KEY,      enamo      VARCHAR2 (15),      salary       NUMBER(8,2),      mgr_no    NUMBER(2));ALTER TABLE emp ADD CONSTRAINT emp_mgr_fk    FOREIGN KEY (mgr no)    REFERENCES emp (emp_no)    ON DELETE SET NULLAALTER TABLE empDISABLE CONSTRAINT emp_emp no pk     CASCADE；ALTER TABLE emp     ENABLE CONSTRAINT emp_emp_no_pk；

多选

82 Which three statements are true about Private Temporary Tables (PTTs)in an Oracle Database?

多选

83 Table ORDER_ITEMS contains columns ORDER_ID, UNIT_PRICE and QUANTITY,of data type NUMBER.Examine these SQL statements  Statement 1:  SELECT MAX(unit_price· quantity) "Maximum Order"      FROM order_items;  Statement 2:  SELECT MAX(unit_price * quantity) "Maximum Order"      FROM order_items   GROUP BY order_id;Which two statements are true?

多选

84 Which two statements are true about the results of using the INTERSECT operator in compound queries?

多选

85 Which three statements are true about using SQL*Plus?

多选

86 Which three statements are true about a self join?

多选

87 Which two statements are true about a full outer join?

多选

88 Which two statements are true about the UNLIMITED TABLESPACE system privilege and space quotas?

多选

89 NULL

多选

90 Which two statements are true about time zones, date data types, and timestamp data types in an Oracle database?

多选

91 Which two statements are true about GLOBAL TEMPORARY TABLES?

多选

92 Which three statements are true about indexes and their administration in an Oracle database?

多选

93 Which two statements are true regarding a SAVEPOINT?

多选

94 Examine the description of the PRODUCT_INFORMATION table:Name                          Nu11?                            Type---------------------     ----------------------      --------------------PROD_ID                     NOT NULL                     NUMBER(2)PROD_NAME                                                    VARCHAR2(10)LIST_PRICE                                                        NUMBER(6,2)Which query retrieves the number of products with a null list price?

多选

95 Which four activities can be performed using SQL Developer?

多选

96 You issued this command DROP TABLE hr.employees;Which three statements are true?

多选

97 Choose twoExamine the data in the CUST_NAME column of the CUSTOMERS table:CUST_NAME------------------------------------------------------------------------------------------------------Renske LadwiJason MallinSamuel McCainAllan MCEwenIrene MikkilineniZulia NayerYou want to display the CUST_NAME values where the last name starts with Mc or MC.Which two WHERE clauses give the required result?

多选

98 Choose twoExamine 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?

多选

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

多选

100 Which two queries execute successfully?Examine the structure of the two tables:PRODUCE:Name                        Nu11?              Type---------------------- --------------- ---------------------PROD_ID                                              CHAR (2)PROD_NAME                                       CHAR (4)EXP_DATE                                            TIMESTAMP(6)NEW_PRODUCTS:Name                         Nu11?            Type---------------------- --------------- ---------------------PROD_ID                                            CHAR (4)PROD_NAME                                      CHAR (10)EXP_DATE                                            DATE