databases Online Quiz - 200

Description: databases Online Quiz - 200
Number of Questions: 20
Created by:
Tags: databases
Attempted 0/20 Correct 0 Score 0
  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

Which SELECT statement will the result ‘ello world’ from the string ‘Hello World’?

  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;



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

Primary Index can not be

  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