0

databases Online Quiz - 200

Description: databases Online Quiz - 200
Number of Questions: 20
Created by:
Tags: databases
Attempted 0/20 Correct 0 Score 0

In a SELECT statement that includes a WHERE clause, where is the GROUP BY clause placed in the SELECT statement?

  1. Immediately after the SELECT clause

  2. After the ORDER BY clause

  3. After the WHERE clause

  4. Before the WHERE clause


Correct Option: C
  1. SELECT SUBSTR( ‘Hello World’,1) FROM dual;

  2. SELECT INITCAP(TRIM (‘Hello World’, 1,1)) FROM dual;

  3. SELECT LOWER(TRIM (‘H’ FROM ‘Hello World’)) FROM dual;

  4. SELECT LOWER(SUBSTR(‘Hello World’, 2, 1) FROM dual;


Correct Option: C
  1. SELECT ename, salary*12 ‘Annual Salary’ FROM employees;

  2. SELECT ename, salary*12 “Annual Salary” FROM employees;

  3. SELECT ename, salary*12 AS Annual Salary FROM employees;

  4. SELECT ename, salary*12 AS INITCAP(“ANNUAL SALARY”) FROM employees


Correct Option: B
  1. ORDER BY SALARY > 5000

  2. GROUP BY SALARY > 5000

  3. HAVING SALARY > 5000

  4. WHERE SALARY > 5000


Correct Option: D

You need to calculate the total of all salaries in the accounting department. Which group function should you use?

  1. MAX

  2. MIN

  3. SUM

  4. TOTAL


Correct Option: C
  1. SELECT TO_CHAR(SYSDATE,'yyyy') FROM dual;

  2. SELECT TO_DATE(SYSDATE,'yyyy') FROM dual;

  3. SELECT DECODE(SUBSTR(SYSDATE, 8), 'YYYY') FROM dual;

  4. SELECT DECODE(SUBSTR(SYSDATE, 8), 'year') FROM dual;


Correct Option: A
  1. You want to identify the most senior employee in the company.

  2. You want to find the manager supervising the largest number of employees

  3. You want to identify the person who makes the highest salary for all employees.

  4. You want to rank the top three sales representatives who have sold the maximum


Correct Option: D

Tables must always be assigned a Primary Index at creation

  1. True

  2. False


Correct Option: A
  1. Null

  2. dropped

  3. have duplicates

  4. All of the above


Correct Option: B
  1. A method of storing and presenting key enterprise data

  2. Allows End users to analyze data to understand business results

  3. To accurately forecast future results

  4. All of the above


Correct Option: D
  1. The cursor is moved to another row

  2. The row the cursor is on is deleted by the application

  3. The row the cursor is on is deleted by another application

  4. The row the cursor is on needs to be updated by another application


Correct Option: B

When the program name is not in the plan, we get

  1. -810

  2. -801

  3. -805

  4. -825


Correct Option: C
  1. Space Issues

  2. Data Issues

  3. No records found while querying the table

  4. Both a & b


Correct Option: A
- Hide questions