Oracle 1Z0-051 Online Practice Questions and Exam Preparation

Oracle 1Z0-051 Online Questions & Answers

• Question 181:

  The following data exists in the PRODUCTS table:

  PROD_ID PROD_LIST_PRICE

  123456 152525.99

  You issue the following query:

  SQL> SELECT RPAD(( ROUND(prod_list_price)), 10,'*')

  FROM products

  WHERE prod_id = 123456;

  What would be the outcome?

  A. 152526****
  B. **152525.99
  C. 152525**
  D. an error message
  A. 152526****

• Question 182:

  You need to create a table for a banking application. One of the columns in the table has the following requirements:

  You want a column in the table to store the duration of the credit period The data in the column should be stored in a format such that it can be easily added and subtracted with DATE data type without using conversion The maximum period of the credit provision in the application is 30 days the interest has to be calculated for the number of days an individual has taken a credit for Which data type would you use for such a column in the table?

  A. INTERVAL YEAR TO MONTH
  B. NUMBER
  C. TIMESTAMP
  D. DATE
  E. INTERVAL DAY TO SECOND
  E. INTERVAL DAY TO SECOND

• Question 183:

  Examine the structure and data of the CUSTJTRANS table:

  CUSTJRANS Name Null? Type CUSTNO NOT NULL CHAR(2) TRANSDATE DATE TRANSAMT NUMBER(6.2) CUSTNO TRANSDATE TRANSAMT 11 01-JAN-07 1000 22 01-FEB-07 2000 33 01-MAR-07 3000

  Dates are stored in the default date format dd-mon-rr in the CUSTJTRANS table. Which three SQL statements would execute successfully? (Choose three.)

  A. SELECT transdate + '10' FROM custjrans;
  B. SELECT * FROM custjrans WHERE transdate = '01-01-07':
  C. SELECT transamt FROM custjrans WHERE custno > '11':
  D. SELECT * FROM custjrans WHERE transdate='01-JANUARY-07':
  E. SELECT custno - 'A' FROM custjrans WHERE transamt > 2000:
  A. SELECT transdate + '10' FROM custjrans;
  C. SELECT transamt FROM custjrans WHERE custno > '11':
  D. SELECT * FROM custjrans WHERE transdate='01-JANUARY-07':

• Question 184:

  View the Exhibit and examine the structure of the CUSTOMERS table.

  

  NEW_CUSTOMERS is a new table with the columns CUST_ID, CUST_NAME and CUST_CITY that have the same data types and size as the corresponding columns in the CUSTOMERS table. Evaluate the following INSERT statement:

  

  The INSERT statement fails when executed. What could be the reason?

  A. The VALUES clause cannot be used in an INSERT with a subquery
  B. The total number of columns in the NEW_CUSTOMERS table does not match the total number of columns in the CUSTOMERS table
  C. The WHERE clause cannot be used in a sub query embedded in an INSERT statement
  D. Column names in the NEW_CUSTOMERS and CUSTOMERS tables do not match
  A. The VALUES clause cannot be used in an INSERT with a subquery

• Question 185:

  Here is the structure and data of the CUST_TRANS table: Exhibit:

  

  Dates are stored in the default date format dd-mm-rr in the CUST_TRANS table. Which three SQL statements would execute successfully? (Choose three.)

  A. SELECT transdate + '10' FROM cust_trans;
  B. SELECT * FROM cust_trans WHERE transdate = '01-01-07';
  C. SELECT transamt FROM cust_trans WHERE custno > '11';
  D. SELECT * FROM cust_trans WHERE transdate='01-JANUARY-07';
  E. SELECT custno + 'A' FROM cust_trans WHERE transamt > 2000;
  A. SELECT transdate + '10' FROM cust_trans;
  C. SELECT transamt FROM cust_trans WHERE custno > '11';
  D. SELECT * FROM cust_trans WHERE transdate='01-JANUARY-07';

• Question 186:

  You need to calculate the number of days from 1st January 2007 till date . Dates are stored in the default format of dd-mon-rr. Which two SQL statements would give the required output? (Choose two.)

  A. SELECT SYSDATE - '01-JAN-2007' FROM DUAL:
  B. SELECT SYSDATE - TOJDATE(X)1/JANUARY/2007") FROM DUAL:
  C. SELECT SYSDATE - TOJDATE('01-JANUARY-2007') FROM DUAL:
  D. SELECT TO_CHAR(SYSDATE. 'DD-MON-YYYY') - '01-JAN-2007' FROM DUAL:
  E. SELECT TO_DATE(SYSDATE. *DD/MONTH/YYYY') - '01/JANUARY/2007' FROM DUAL:
  B. SELECT SYSDATE - TOJDATE(X)1/JANUARY/2007") FROM DUAL:
  C. SELECT SYSDATE - TOJDATE('01-JANUARY-2007') FROM DUAL:

• Question 187:

  Which three statements are true regarding subqueries? (Choose three.)

  A. Subqueries can contain GROUP BY and ORDER BY clauses.
  B. Main query and subquery can get data from different tables.
  C. Main query and subquery must get data from the same tables.
  D. Subqueries can contain ORDER BY but not the GROUP BY clause.
  E. Only one column or expression can be compared between the main query and subquery.
  F. Multiple columns or expressions can be compared between the main query and subquery.
  A. Subqueries can contain GROUP BY and ORDER BY clauses.
  B. Main query and subquery can get data from different tables.
  F. Multiple columns or expressions can be compared between the main query and subquery.

• Question 188:

  Which view should a user query to display the columns associated with the constraints on a table owned by the user?

  A. USER_CONSTRAINTS
  B. USER_OBJECTS
  C. ALL_CONSTRAINTS
  D. USER_CONS_COLUMNS
  E. USER_COLUMNS
  D. USER_CONS_COLUMNS

• Question 189:

  Which four are valid Oracle constraint types? (Choose four.)

  A. CASCADE
  B. UNIQUE
  C. NONUNIQUE
  D. CHECK
  E. PRIMARY KEY
  F. CONSTANT
  G. NOT NULL
  B. UNIQUE
  D. CHECK
  E. PRIMARY KEY
  G. NOT NULL

• Question 190:

  Examine the structure of the EMPLOYEES table:

  EMPLOYEE_ID NUMBER Primary Key FIRST_NAME VARCHAR2(25) LAST_NAME VARCHAR2(25)

  Which three statements insert a row into the table? (Choose three.)

  A. INSERT INTO employees VALUES ( NULL, 'John', 'Smith');
  B. INSERT INTO employees( first_name, last_name) VALUES( 'John', 'Smith');
  C. INSERT INTO employees VALUES ( 1000, 'John', NULL);
  D. INSERT INTO employees (first_name, last_name, employee_id) VALUES ( 1000, 'John', 'Smith');
  E. INSERT INTO employees (employee_id) VALUES (1000);
  F. INSERT INTO employees (employee_id, first_name, last_name) VALUES ( 1000, 'John', ' ');
  C. INSERT INTO employees VALUES ( 1000, 'John', NULL);
  E. INSERT INTO employees (employee_id) VALUES (1000);
  F. INSERT INTO employees (employee_id, first_name, last_name) VALUES ( 1000, 'John', ' ');