Tag: databases

Quizzes (243) Questions (4862)

Questions Related to databases

Multiple choice technology databases

Which three SELECT Statements displays 8000 in the format “$8,000.00”?(Choose three)
  1. A. SELECT TO CHAR(8000,’$#,###.##’) FROM DUAL;
  2. B. SELECT TO CHAR(8000,’$0,000.00’) FROM DUAL;
  3. C. SELECT TO CHAR(8000,’$9,999.00’) FROM DUAL;
  4. D. SELECT TO CHAR(8000,’$9,999.99’) FROM DUAL;
  5. E. SELECT TO CHAR(8000,’$8,000.00’) FROM DUAL;
  6. F. SELECT TO CHAR(8000,’$N,NNN.NN’) FROM DUAL;
Reveal answer Fill a bubble to check yourself
B,C,D Correct answer
Full explanation
Multiple choice technology databases

Evaluate the set of SQL statements: CREATE TABLE dept (deptno NUMBER(2), dname VARCNAR2(14), loc VARCNAR2(13)); ROLLBACK; DESCRIBE DEPT What is true about the set?

  1. The DESCRIBE DEPT statement returns an error ORA-04043: object DEPT does not exist

  2. The ROLLBACK statement frees the storage space occupies by the DEPT table

  3. The DESCRIBE DEPT statement displays the structure of the DEPT table

  4. The DESCRIBE DEPT statement displays the structure of the DEPT table only if there is a COMMIT statement introduced before the ROLLBACK statement
Reveal answer Fill a bubble to check yourself
C Correct answer
Full explanation