Tag: databases

Questions Related to databases

SELECT ROUND(TRUNC(MOD(1600,10),-1),2)
technology databases

  1. ERROR

  2. 0

  3. 1

  4. 0.00

Show answer
Correct Option: B

What can you create to restrict user access to a table?
technology databases

  1. Index

  2. synonym

  3. view

  4. trigger

Show answer
Correct Option: C

What can be used in a SELECT statement to obtain search criteria for the SELECT statement?

technology databases

  1. HAVING clause

  2. ORDER BY clause

  3. Subquery

  4. GROUP BY clause

Show answer
Correct Option: C

What database object is used to increase performance for accessing data within a database?
technology databases

  1. Roles

  2. Sequences

  3. Synonyms

  4. Index

Show answer
Correct Option: D

Which clause of the CREATE SEQUENCE statement will cause the sequence to continue to generate numbers even after the maximum limit is reached?
technology databases

  1. MAXVALUE

  2. MINVALUE

  3. CYCLE

  4. INCREMENT BY

Show answer
Correct Option: C

Which datatypes are alphanumeric?

technology databases

  1. Number

  2. Blob

  3. Char

  4. Raw

Show answer
Correct Option: C

How do you execute an anonymous block within SQL*Plus?
technology databases

  1. exec command

  2. / command

  3. execute command

  4. None of these

Show answer
Correct Option: B

Where can NOT a subquery be used within a SQL statement that is in a PL/SQL block?
technology databases

  1. WHERE

  2. FROM

  3. INSERT

  4. UPDATE

Show answer
Correct Option: B

What tasks are you able to perform within a PL/SQL block?
technology databases

  1. DELETE

  2. CREATE

  3. UPDATE

  4. ALTER

Show answer
Correct Option: A,C

Which database model allows you to store and execute a PL/SQL program as part of an object?

technology databases

  1. Hierarchical

  2. Relational

  3. Object Relational

  4. Network

Show answer
Correct Option: C