Oracle Oracle Certifications 1Z0-071 Questions & Answers

• Question 241:

  The SYSDATE function displays the current Oracle Server date as:

  21 -MAY-19

  You wish to display the date as:

  MONDAY, 21 MAY, 201 9

  Which statement will do this?

  A. SELECT TO_DATE(SYSDATE, 'FMDAY, DD MONTH, YYYY') FROM DUAL;

  B. SELECT TO_CHAR(SYSDATE, 'FMDD, DAY MONTH, YYYY') FROM DUAL;

  C. SELECT TO_CHAR(SYSDATE, 'FMDAY, DD MONTH, YYYY') FROM DUAL;

  D. SELECT TO_CHAR(SYSDATE, 'FMDAY, DDTH MONTH, YYYY') EROM DUAL;

  Correct Answer: C

• Question 242:

  Which two are true about creating tables in an Oracle database?

  A. A create table statement can specify the maximum number of rows the table will contain.

  B. The same table name can be used for tables in different schemas.

  C. A system privilege is required.

  D. Creating an external table will automatically create a file using the specified directory and file name.

  E. A primary key constraint is manadatory.

  Correct Answer: BC

• Question 243:

  Examine the description PRODUCTS table:

  

  Examine the description of the NEW_PRODUCTS table:

  

  Which two queries execute successfully?

  A. SELECT prod_id FROM products UNION ALL SELECT prod_id, prod_name FROM new_products;

  B. SELECT prod_id, exp_date FROM products UNION ALL

  SELECT prod_id, NULL FROM new_products;

  C. SELECT * FROM products MINUS SELECT prod_id, FROM new_products;

  D. SELECT prod_id, prod_name FROM products INTERSECT SELECT 100, prod_name FROM new_products;

  E. SELECT * FROM products UNION SELECT * FROM new_products;

  Correct Answer: BE

• Question 244:

  Examine this statement:

  

  On Which two columns of the table will an index be created automatically?

  A. SERIAL_NO

  B. ORDER_DATE

  C. PRODUCT_ ID

  D. ORDER TOTAL

  E. ORDER_ ID

  F. STATUS

  Correct Answer: AE

• Question 245:

  Examine the description of the SALES table:

  

  The SALES table has 55,000 rows. Examine this statement:

  

  Which two statements are true? (Choose two.)

  A. SALES1 is created with 55,000 rows.

  B. SALES1 has NOT NULL constraints on any selected columns which had those constraints in the SALES table.

  C. SALES1 is created with no rows.

  D. SALES1 is created with 1 row

  E. SALES1 has PRIMARY KEY and UNIQUE constraints on any selected columns which had those constraints in the SALES table.

  Correct Answer: AB

• Question 246:

  You execute these commands successfully:

  

  Which two are true?

  A. You can add a foreign key to the table.

  B. When you terminate your session, the row will be deleted.

  C. To drop the table in this session, you must first truncate it.

  D. You can add a column to the table in this session.

  E. Other sessions can view the committed row.

  Correct Answer: BC

• Question 247:

  Examine this partial command:

  

  Which two clauses are required for this command to execute successfully?

  A. the DEFAULT DIRECTORY clause

  B. the REJECT LIMIT clause

  C. the LOCATION clause

  D. the ACCESS PARAMETERS clause

  E. the access driver TYPE clause

  Correct Answer: AC

• Question 248:

  In your session NLS_ DATE_ FORMAT is set to DD-MON_RR.

  Which two queries display the year as four digits?

  A. SELECT TO_DATE(TO_CHAR(SYSDATE,'MM/DD/YYYY'),'MM/DD/YYYY') FROM DUAL;

  B. SELECT TO_CHAR (ADD_MONTHS (SYSDATE,6)) FROM DUAL;

  C. SELECT TO_DATE (SYSDATE, 'RRRR-MM-DD') FROM DUAL;

  D. SELECT TO_DATE (ADD_MONTHS(SYSDATE,6), 'dd-mon-yyyy') FROM DUAL;

  E. SELECT TO_CHAR (SYSDATE, 'MM/DD/YYYY') FROM DUAL;

  F. SELECT TO_CHAR (ADD_MONTHS (SYSDATE, 6), 'dd-mon-yyyy') FROM DUAL;

  Correct Answer: EF

• Question 249:

  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?

  

  A. Option A

  B. Option B

  C. Option C

  D. Option D

  E. Option E

  Correct Answer: D

• Question 250:

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

  E. The first NUMBER or VARCHAR2 column in the last SELECTof the compound query

  Correct Answer: A