GradePack

    • Home
    • Blog
Skip to content
bg
bg
bg
bg

GradePack

Which statement about an index is true?

Which statement about an index is true?

Read Details

You want to issue the following command on a database that i…

You want to issue the following command on a database that includes your company’s inventory information: ALTER TABLE products SET UNUSED COLUMN color; What will be the result of issuing this command?

Read Details

Evaluate the structure of the EMPLOYEES table: EMPLOYEE_ID N…

Evaluate the structure of the EMPLOYEES table: EMPLOYEE_ID NUMBER(9) LAST_NAME VARCHAR2(25) FIRST_NAME VARCHAR2(25)DEPARTMENT_ID NUMBER(9) MANAGER_ID NUMBER(9)SALARY NUMBER(7,2)Which statement should you use to increase the LAST_NAME column length to 35 if the column currently contains 200 records?

Read Details

You need to ensure that the LAST_NAME column only contains c…

You need to ensure that the LAST_NAME column only contains certain character values. No numbers or special characters are allowed. Which type of constraint should you define on the LAST_NAME column?

Read Details

Which type of constraint by default requires that a column b…

Which type of constraint by default requires that a column be both unique and not null?

Read Details

You need to add a row to an existing table. Which DML statem…

You need to add a row to an existing table. Which DML statement should you use?

Read Details

You cannot modify data in a view if the view contains ______…

You cannot modify data in a view if the view contains ______.

Read Details

You need to create a report that lists all employees in depa…

You need to create a report that lists all employees in department 10 (Sales) whose salary is not equal to $25,000 per year. Which query should you issue to accomplish this task?

Read Details

Examine the data from the LINE_ITEM table: LINE_ITEM_ID O…

Examine the data from the LINE_ITEM table: LINE_ITEM_ID ORDER_ID PRODUCT_ID PRICE DISCOUNT 890898 847589 848399 8.99 0.10 768385 862459 849869 5.60 0.05 867950 985490 945809 5.60   954039 439203 438925 5.25 0.15 543949 349302 453235 4.50   You query the LINE_ITEM table and a *value of 3 is returned. Which SQL statement did you execute?

Read Details

You have been asked to create a report that lists all custom…

You have been asked to create a report that lists all customers who have placed orders of at least $2,500. The report’s date should be displayed in the Day, Date Month, Year format (For example, Tuesday, 13 April, 2004 ). Which statement should you issue?

Read Details

Posts pagination

Newer posts 1 … 37,616 37,617 37,618 37,619 37,620 … 78,634 Older posts

GradePack

  • Privacy Policy
  • Terms of Service
Top