Oracle 1Z0-051 Online Practice Questions and Exam Preparation

Oracle 1Z0-051 Online Questions & Answers

• Question 211:

  What is true about sequences?

  A. The start value of the sequence is always 1.
  B. A sequence always increments by 1.
  C. The minimum value of an ascending sequence defaults to 1.
  D. The maximum value of descending sequence defaults to 1.
  C. The minimum value of an ascending sequence defaults to 1.

• Question 212:

  What is true about the WITH GRANT OPTION clause?

  A. It allows a grantee DBA privileges.
  B. It is required syntax for object privileges.
  C. It allows privileges on specified columns of tables.
  D. It is used to grant an object privilege on a foreign key column.
  E. It allows the grantee to grant object privileges to other users and roles.
  E. It allows the grantee to grant object privileges to other users and roles.

• Question 213:

  View the Exhibit and examine the data in the PROMOTIONS table. PROMO_BEGIN_DATE is stored in the default date format, dd-mon-rr. You need to produce a report that provides the name, cost, and start date of all promos in the POST

  category that were launched before January 1, 2000.

  Which SQL statement would you use?

  A. SELECT promo_name, promo_cost, promo_begin_date FROM promotions WHERE promo_category = 'post' AND promo_begin_date < '01-01-00';
  B. SELECT promo_name, promo_cost, promo_begin_date FROM promotions WHERE promo_cost LIKE 'post%' AND promo_begin_date < '01-01-2000';
  C. SELECT promo_name, promo_cost, promo_begin_date FROM promotions WHERE promo_category LIKE 'P%' AND promo_begin_date < '1-JANUARY-00';
  D. SELECT promo_name, promo_cost, promo_begin_date FROM promotions WHERE promo_category LIKE '%post%' AND promo_begin_date < '1-JAN-00';
  D. SELECT promo_name, promo_cost, promo_begin_date FROM promotions WHERE promo_category LIKE '%post%' AND promo_begin_date < '1-JAN-00';

• Question 214:

  A data manipulation language statement _____.

  A. completes a transaction on a table
  B. modifies the structure and data in a table
  C. modifies the data but not the structure of a table
  D. modifies the structure but not the data of a table
  C. modifies the data but not the structure of a table

• Question 215:

  Which tasks can be performed using SQL functions that are built into Oracle database? (Choose three.)

  A. finding the remainder of a division
  B. adding a number to a date for a resultant date value
  C. comparing two expressions to check whether they are equal
  D. checking whether a specified character exists in a given string
  E. removing trailing, leading, and embedded characters from a character string
  A. finding the remainder of a division
  C. comparing two expressions to check whether they are equal
  D. checking whether a specified character exists in a given string

• Question 216:

  View the Exhibit and examine the structure of the PROMOTIONS table. Which SQL statements are valid? (Choose all that apply.)

  

  A. SELECT promo_id. DECODE(NVL(promo_cost.O).promo_cost * 0.25. 100) "Discount" FROM promotions;
  B. SELECT promo id. DECODE(promo_cost. 10000. DECODE(promo_category. 'Gl\ promo_cost * 25. NULL). NULL) "Catcost" FROM promotions;
  C. SELECT promo_id. DECODE(NULLIF(promo_cost. 10000). NULL. promo_cost*.25, *N/A') "Catcost" FROM promotions;
  D. SELECT promo_id. DECODE(promo_cost. >10000. 'High'.
  A. SELECT promo_id. DECODE(NVL(promo_cost.O).promo_cost * 0.25. 100) "Discount" FROM promotions;
  B. SELECT promo id. DECODE(promo_cost. 10000. DECODE(promo_category. 'Gl\ promo_cost * 25. NULL). NULL) "Catcost" FROM promotions;

• Question 217:

  View the Exhibit and examine the structure of the ORDERS and CUSTOMERS tables.

  

  Evaluate the following SQL command:

  SQL> SELECT o.order_id, c.cust_name, o.order_total, c.credit_limit FROM orders o JOIN customers c USING (customer_id)

  WHERE o.order_total > c.credit_limit

  FOR UPDATE

  ORDER BY o.order_id;

  Which two statements are true regarding the outcome of the above query? (Choose two.)

  A. It locks all the rows that satisfy the condition in the statement.
  B. It locks only the columns that satisfy the condition in both the tables.
  C. The locks are released only when a COMMIT or ROLLBACK is issued.
  D. The locks are released after a DML statement is executed on the locked rows.
  A. It locks all the rows that satisfy the condition in the statement.
  C. The locks are released only when a COMMIT or ROLLBACK is issued.

• Question 218:

  You need to design a student registration database that contains several tables storing academic information.

  The STUDENTS table stores information about a student. The STUDENT_GRADES table stores information about the student's grades. Both of the tables have a column named STUDENT_ID. The STUDENT_ID column in the STUDENTS

  table is a primary key.

  You need to create a foreign key on the STUDENT_ID column of the STUDENT_GRADES table that points to the STUDENT_ID column of the STUDENTS table. Which statement creates the foreign key?

  A. CREATE TABLE student_grades (student_id NUMBER(12),semester_end DATE, gpa NUMBER(4,3), CONSTRAINT student_id_fk REFERENCES (student_id) FOREIGN KEY students(student_id));
  B. CREATE TABLE student_grades(student_id NUMBER(12),semester_end DATE, gpa NUMBER(4,3), student_id_fk FOREIGN KEY (student_id) REFERENCES students(student_id));
  C. CREATE TABLE student_grades(student_id NUMBER(12),semester_end DATE, gpa NUMBER(4,3), CONSTRAINT FOREIGN KEY (student_id) REFERENCES students(student_id));
  D. CREATE TABLE student_grades(student_id NUMBER(12),semester_end DATE, gpa NUMBER(4,3), CONSTRAINT student_id_fk FOREIGN KEY (student_id) REFERENCES students(student_id));
  D. CREATE TABLE student_grades(student_id NUMBER(12),semester_end DATE, gpa NUMBER(4,3), CONSTRAINT student_id_fk FOREIGN KEY (student_id) REFERENCES students(student_id));

• Question 219:

  Examine the structure proposed for the TRANSACTIONS table:

  

  Which two statements are true regarding the storage of data in the above table structure? (Choose two.)

  A. The TRANS_DATE column would allow storage of dates only in the dd-mon-yyyy format.
  B. The CUST_CREDIT_VALUE column would allow storage of positive and negative integers.
  C. The TRANS_VALIDITY column would allow storage of a time interval in days, hours, minutes, and seconds.
  D. The CUST_STATUS column would allow storage of data up to the maximum VARCHAR2 size of 4,000 characters.
  B. The CUST_CREDIT_VALUE column would allow storage of positive and negative integers.
  D. The CUST_STATUS column would allow storage of data up to the maximum VARCHAR2 size of 4,000 characters.

• Question 220:

  Which SQL statement would you use to remove a view called EMP_DEPT_VU from your schema?

  A. DROP emp_dept_vu;
  B. DELETE emp_dept_vu;
  C. REMOVE emp_dept_vu;
  D. DROP VIEW emp_dept_vu;
  E. DELETE VIEW emp_dept_vu;
  F. REMOVE VIEW emp_dept_vu;
  D. DROP VIEW emp_dept_vu;