Tag: databases

Questions Related to databases

Which of the following WHERE clauses represent equi-join?

technology databases

  1. Table1.column1=Table2.column2

  2. Table1.column1=Table2.column1

  3. Table1.column2=Table2.column1

  4. None of the above

Show answer
Correct Option: B

LAST_DAY(date) finds the date of the last day of the month that contains date.

technology databases

  1. True

  2. False

Show answer
Correct Option: B

When is a Cartesian product formed?

technology databases

  1. When a join condition is omitted.

  2. When a join condition is invalid.

  3. All rows in the first table are joined to all rows in the second table.

  4. All of the above.

Show answer
Correct Option: D

A Non equi-join is a join condition that does not contain an equality operator.
technology databases

  1. True

  2. False

Show answer
Correct Option: B

SYSDATE is a date function that returns the current database server date and time.
technology databases

  1. True

  2. False

Show answer
Correct Option: B

Which keyword used in DML statements prohibits you from changing rows that are not in the sub-query?
technology databases

  1. CHECK keyword

  2. WITH CHECK keyword

  3. WITH CHECK OPTION keyword

  4. None of the Above

Show answer
Correct Option: C

Explicit Defaults can be used in
technology databases

  1. INSERT statement

  2. UPDATE statement

  3. Both of the Above

  4. None of the Above

Show answer
Correct Option: C

MERGE statement
technology databases

  1. Avoids separate updates

  2. ncreases performance and ease of use

  3. Is useful in data warehousing applications

  4. All of the above

Show answer
Correct Option: D

Database transactions end with
technology databases

  1. COMMIT or ROLLBACK

  2. A DDL or DCL statement executing

  3. USER exiting iSQL*Plus or System crash

  4. Any one of the above

Show answer
Correct Option: D

You can update more than 1 row in a table with one update syntax
technology databases

  1. True

  2. False

Show answer
Correct Option: B