Tag: databases

Questions Related to databases

Review the following SQL, and choose the most appropriate option.
technology databases

  1. The statement will show the number of jobs in each department

  2. The statement will show the number of employees in each department.

  3. The statement will generate an error.

  4. The statement will work if the GROUP BY clause is removed.

Show answer
Correct Option: C

Which datatype stores data outside Oracle Database?

technology databases

  1. UROWID

  2. BFILE

  3. BLOB

  4. NCLOB

Show answer
Correct Option: B

The DEPT table has the following data

technology databases

  1. The INSERT statement is invalid; a valid table name is missing.

  2. 50 is not a valid DEPTNO value, since the subquery limits DEPTNO to 10.

  3. The statement will work without error.

  4. A subquery and a VALUES clause cannot appear together.

Show answer
Correct Option: B

The following statements are executed: create sequence my_seq; select my_seq.nextval from dual; select my_seq.nextval from dual; rollback; select my_seq.nextval from dual;
technology databases

  1. 0

  2. 1

  3. 2

  4. 3

Show answer
Correct Option: D

The current time in Dubai is 04-APR-2008 08:50:00, and the time in Dallas is 03-APR-2008 23:50:00. A user from Dubai is connected to a session in the database located on a server in Dallas. What will be the result of his query?

technology databases

  1. 04?APR?2008 08:50:00

  2. 03?APR?2008 23:50:00

  3. 03?APR?2008 2324:50:00

  4. None of the above

Show answer
Correct Option: B

I/O operations on the data warehouse is expensive ?
technology databases

  1. True

  2. False

Show answer
Correct Option: A

SYS_CONTEXT can be used to know details about a session running the code?

technology databases

  1. True

  2. False

Show answer
Correct Option: A

Which are appropriate scheduling tools for use in EIP database?

technology databases

  1. CONTROL M

  2. DBMS_JOB

  3. DBMS_SCHEDULER

  4. All

Show answer
Correct Option: D

What can be used to optimize the performance of simple SQL?
technology databases

  1. DYNAMIC PARALLELISM

  2. HINTS

  3. STORED OUTLINES

  4. ALL

Show answer
Correct Option: D

COMPLETE REFRESH by default will _________________all rows in an mview before inserting new rows

technology databases

  1. Create

  2. Delete

  3. Append

  4. Do Nothing

Show answer
Correct Option: B