Oracle 1Z0-071 Oracle Database SQL Exam Practice Test Questions

• Question 1

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

  • A create table statement can specify the maximum number of rows the table will contain.
    
  • The same table name can be used for tables in different schemas.
    
  • A system privilege is required.
    
  • Creating an external table will automatically create a file using the specified directory and file name.
    
  • A primary key constraint is manadatory.
    

  Show Answer Answer: 1,,2 Next

• Question 2

  The INVOICE table has a QTY_SOLD column of data type NUMBER and an INVOICE_DATE column of data type DATE NLS_DATE_FORMAT is set to DD-MON-RR.Which two are true about data type conversions involving these columns in query expressions?

  • invoice_date> '01-02-2019': uses implicit conversion
    
  • qty_sold ='05549821 ': requires explicit conversion
    
  • CONCAT(qty_sold, invoice_date): requires explicit conversion
    
  • qty_sold BETWEEN '101' AND '110': uses implicit conversion
    
  • invoice_date = '15-march-2019': uses implicit conversion
    

  Show Answer Answer: 4,,5 Next

• Question 3

  A session's NLS_DATE_FORMAT is set to DD Mon YYYY .Which two queries return the value 1 Jan 2019?

  • SELECT to_date(' 2019-01-01 ', 'YYYY -MM-DD' ) FROM DUAL;
    
  • SELECT DATE '2019-01-01' FROM DUAL ;
    
  • SELECT TO_CHAR('2019-01-01') FROM DUAL; 2019-01-01
    
  • SELECT '2019-01-01' FROM DUAL ; 2019-01-01
    
  • SELECT TO_ DATE('2019-01-01') FROM DUAL;
    

  Show Answer Answer: 1,,2 Next

• Question 4

  Which two are SQL features?

  • providing graphical capabilities
    
  • providing variable definition capabilities.
    
  • providing database transaction control
    
  • processing sets of data
    
  • providing update capabilities for data in external files
    

  Show Answer Answer: 3,,4 Next

• Question 5

  Which three statements are true about multiple row subqueries?

  • They can contain HAVING clauses.
    
  • Two or more values are always returned from the subquery.
    
  • They cannot contain subquery.
    
  • They can return multiple columns.
    
  • They can contain GROUP BY clauses.
    

  Show Answer Answer: 1,,2,,5 Next