Tag: databases

Questions Related to databases

Which will not allow to drop a table?

technology databases

  1. (a) UNION

  2. (b) SCHEMABINDING

  3. (c) CHECK OPTION

  4. (d) All

Show answer
Correct Option: B

Which option restricts changes to data to conform to the select criteria of a view?
technology databases

  1. (a) SCHEMABINDING

  2. (b) CHECK OPTION

  3. (c) ANSI_NULLS

  4. (d) All

Show answer
Correct Option: B

Which of the following aggregate functions returns a row count as an integer?
technology databases

  1. (a) AVG

  2. (b) COUNT

  3. (c) STDEV

  4. (d) COUNT_BIG

Show answer
Correct Option: B

Which Joins allows to bring non matching data in TSQL
technology databases

  1. (a) Full outer join

  2. (b) Inner join

  3. (c) Right outer join

  4. (d) Left outer join

Show answer
Correct Option: A,C,D

Which will allow us to create a column alias?
technology databases

  1. (a) AS

  2. (b) STR

  3. (c) FROM

  4. (d) COLUMN

Show answer
Correct Option: A

Which three SELECT Statements displays 8000 in the format “$8,000.00”?(Choose three)
technology databases

  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;

Show answer
Correct Option: B,C,D

You are sorting data in a table in you SELECT statement in descending order. The column you are sorting on contains NULL records, where will the NULL record appears?
technology databases

  1. At the beginning of the list

  2. At the end of the list

  3. In the middle of the list

  4. At the same location they are listed in the unordered table

Show answer
Correct Option: A

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?
technology databases

  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

Show answer
Correct Option: C

Which three are DATETIME data types that can be used when specifying column definitions? (Choose three)

technology databases

  1. TIMESTAMP

  2. INTERVAL MONTH TO DAY

  3. TIMESTAMP WITH DATABASE TIMEZONE

  4. INTERVAL YEAR TO MONTH

  5. INTERVAL DAY TO SECOND

Show answer
Correct Option: A,D,E

Which data dictionary table should you query to view the object privileges granted to the user on specific columns?
technology databases

  1. USER_TAB_PRIVS_MADE

  2. USER_TAB_PRIVS

  3. USER_COL_PRIVS_MADE

  4. USER_COL_PRIVS

Show answer
Correct Option: D