Oracle Database: SQL Fundamentals I : 1Z1-051

Which object privileges can be granted on a view?

• A. ALTER, DELETE, INSERT, SELECT
• B. none
• C. DELETE, INSERT,SELECT
• D. DELETE, INSERT, SELECT, UPDATE

Which four are types of functions available in SQL? (Choose 4)

• A. integer
• B. calendar
• C. character
• D. string
• E. date
• F. conversion
• G. translation
• H. numeric

Evaluate the following query:

What would be the outcome of the above query?

• A. It executes successfully and displays the literal" {'s start date was} " for each row in theoutput.
• B. It executes successfully and introduces an 's at the end of each promo_name in the output.
• C. It produces an error because the data types are not matching.
• D. It produces an error because flower braces have been used.

You need to create a table with the following column specifications:
1.Employee ID (numeric data type) for each employee
2.Employee Name (character data type) that stores the employee name
3.Hire date, which stores the date of joining the organization for each employee
4.Status (character data type), that contains the value 'ACTIVE' if no data is entered
5.Resume (character large object [CLOB] data type), which contains the resume submitted by the employee
Which is the correct syntax to create this table?

• A. CREATE TABLE 1_EMP
  (emp_id NUMBER(4),
  emp_name VARCHAR2(25),
  start_date DATE,
  emp_status VARCHAR2(10) DEFAULT 'ACTIVE',
  resume CLOB);
• B. CREATE TABLE EMP_1
  (emp_id NUMBER(4),
  emp_name VARCHAR2(25),
  start_date DATE,
  emp_status VARCHAR2(10) DEFAULT "ACTIVE",
  resume CLOB);
• C. CREATE TABLE EMP_1
  (emp_id NUMBER(4),
  emp_name VARCHAR2(25),
  start_date DATE,
  e_status VARCHAR2(10) DEFAULT 'ACTIVE',
  resume CLOB(200));
• D. CREATE TABLE EMP_1
  (emp_id NUMBER,
  emp_name VARCHAR2(25),
  start_date DATE,
  emp_status VARCHAR2(10) DEFAULT 'ACTIVE',
  resume CLOB);

Examine the data in the ORD_ITEMS table:
ORD_NO ITEM_NO QTY
1 111 10
1 222 20
1 333 30
2 333 30
2 444 40
3 111 40
Evaluate the following query:
SQL>SELECT item_no, AVG(qty)
FROM ord_items
HAVING AVG(qty) > MIN(qty) * 2
GROUP BY item_no;
Which statement is true regarding the outcome of the above query?

• A. It gives an error because the HAVING clause should be specified after the GROUP BY clause.
• B. It displays the item nos with their average quantity where the average quantity is more than double the minimum quantity of that item in the table.
• C. It gives an error because all the aggregate functions used in the HAVING clause must be specified in the SELECT list.
• D. It displays the item nos with their average quantity where the average quantity is more than double the overall minimum quantity of all the items in the table.