Tag: databases

Questions Related to databases

Which four statements correctly describe a schema? (Choose four.
technology databases

  1. There is no one-to-one relationship between schemas and users in a database

  2. the concept of a database schema is directly tied to the concept of a database user, or a grant from the schema owner

  3. The database user and the schema never have the same name

  4. A schema can allow another schema to use its objects by granting access

  5. An Oracle Application products database objects are divided between the product schema and the APPS Schema

Show answer
Correct Option: B

Which SQL statement is used to extract data from a database?

technology databases

  1. FETCH

  2. EXTRACT

  3. GET

  4. SELECT

Show answer
Correct Option: D

Which SQL statement is used to delete data from a database table?
technology databases

  1. DROP

  2. DELETE

  3. TRUNCATE

  4. REMOVE

Show answer
Correct Option: B

What is a trigger
technology databases

  1. A piece of logic written in PL/SQL

  2. Executed at the arrival of a SQL*FORMS event

  3. Both A & B

  4. None of the above

Show answer
Correct Option: C

RENAME command is a :

technology databases

  1. DCL command

  2. TCL command

  3. DDL command

  4. DML command

Show answer
Correct Option: C

Data Dictionary:

technology databases

  1. Is a collection of tables created and maintained by oracle server.

  2. Contain user information.

  3. Contain database information.

  4. Both a and c

  5. All

Show answer
Correct Option: E

A DML statement is executed when you:

technology databases

  1. Modify existing rows in a table.

  2. Add a new column in a table

  3. Both a & b

  4. None

Show answer
Correct Option: A

Select the correct order of evaluation for following operators: I.LIKE II.NOT III.AND IV.OR

technology databases

  1. I,III,IV,II

  2. I,II,III,IV

  3. IV,III,II,I

  4. IV,II,I,III

Show answer
Correct Option: B

Which SQL keyword is used to sort the result set:
technology databases

  1. ORDER

  2. SORT

  3. ORDER BY

  4. GROUP BY

Show answer
Correct Option: C

What will be the correct order of the below mentioned clauses in a SQL if select part of the query contains on group function and there is one filter condition. I.Where II.GROUP BY III.HAVING IV.ORDER BY

technology databases

  1. I,III,II,IV

  2. I,II,III,IV

  3. II,IV,III,I

  4. II,I,IV,III

Show answer
Correct Option: B