0

databases Online Quiz - 96

Description: databases Online Quiz - 96
Number of Questions: 20
Created by:
Tags: databases
Attempted 0/20 Correct 0 Score 0
  1. UTL_FILE_DIR

  2. USER_DUMP_DEST

  3. LOG_ARCHIVE_DEST

  4. BACKGROUND_DUMP_DEST


Correct Option: D
  1. MANAGER must be a role.

  2. It allows the MANAGER to pass the specified privileges on to other users.

  3. It allows the MANAGER to create tables that refer to the STUDENT_GRADES table.

  4. It allows the MANAGER to apply all DML statements on the STUDENT_GRADES table.

  5. It allows the MANAGER the ability to select from, insert into, and update the STUDENT_GRADES table.

  6. It allows the MANAGER the ability to select from, delete from, and update the STUDENT_GRADES table.


Correct Option: B,E
  1. A Schema Object

  2. A subquery that can contain an ORDER BY clause

  3. Another name for a view that contains group functions

  4. A subquery that is part of the FROM clause of another query


Correct Option: D
  1. A MERGE statement is used to merge the data of one table with data from another.

  2. A MERGE statement replaces the data of one table with that of another.

  3. A MERGE statement can be used to insert new rows into a table.

  4. A MERGE statement can be used to update existing rows in a table.


Correct Option: A,B,C
  1. String

  2. Character

  3. Integer

  4. Date

  5. Numeric

  6. Conversion


Correct Option: B,D,E,F

Find the error in the line for the query written below?

  1. Line 1

  2. Line 2

  3. Line 3

  4. Line 4


Correct Option: D
  1. a. View is a named SQL query stored in data dictionary

  2. b. View is a database object which stores data

  3. c. View is used for data hiding

  4. d. Views doesn’t occupy memory


Correct Option: A,C,D

How many columns are there in dual table?

  1. 1

  2. 2

  3. >1

  4. N


Correct Option: A

There is a % sign in one field of a column. Say for example table test_chk has a column name1 which contains a value “desdf%dsf”. What will be the queries to find it?

  1. SELECT * FROM test_chk ;

  2. select * from test_chk where name1 like '%%\%' escape '\'

  3. select * from test_chk where name1 like ' \ ' escape '\';

  4. select * from test_chk where name1 like '%!%%' escape '!'


Correct Option: A,D

There is a % sign in one field of a column. Say for example table test_chk has a column name1 which contains a value “desdf%dsf”. What will be the queries to find it?

  1. SELECT * FROM test_chk ;

  2. select * from test_chk where name1 like '%%\%' escape '\'

  3. select * from test_chk where name1 like ' \ ' escape '\';

  4. select * from test_chk where name1 like '%!%%' escape '!'


Correct Option: A,D

Can a function have an out parameter?

  1. True

  2. False


Correct Option: A
  1. Both values will be equal

  2. Both values will not be equal

  3. You can’t compare these two values

  4. Both will be NULL


Correct Option: B
  1. INVALID_CURSOR

  2. CURSOR_ALREADY_OPEN

  3. TIMEOUT_ON_RESOURCE

  4. SYS_INVALID_ROWID


Correct Option: B
  1. More detail about either Dimension/Measure

  2. More detail about Measure

  3. More detail about Dimension

  4. separate object for Time Dimension


Correct Option: C
  1. Only Alias

  2. Removing the unnecessary tables.

  3. Aliases or context

  4. Only Context


Correct Option: C
  1. 2D Area chart

  2. pie chart

  3. 3D line chart

  4. all off the above


Correct Option: D
- Hide questions