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

Which initialization parameter specifies the location of the alert log file

  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

Which best describes an inline view?

  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

Can we apply update, insert or delete on a view?

  1. True

  2. False


Correct Option: A

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

Say for e.g. we declare x char(20): = 'name' and y varchar2(20):='name' If we compare x and y then what should be the result?

  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

In PL/SQL if we write select statement with INTO clause which of the following exceptions are returned

  1. NO_DATA_FOUND

  2. ROWTYPE_MISMATCH

  3. TOO_MANY_ROW

  4. DUP_VAL_ON_INDEX


Correct Option: A,C

Without closing the cursor, If you want to open it what will happen. If error, get what is the error?

  1. INVALID_CURSOR

  2. CURSOR_ALREADY_OPEN

  3. TIMEOUT_ON_RESOURCE

  4. SYS_INVALID_ROWID


Correct Option: B

What is Detail Object?

  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

How can we resolve the loops?

  1. Only Alias

  2. Removing the unnecessary tables.

  3. Aliases or context

  4. Only Context


Correct Option: C

Name the types of chart available.

  1. 2D Area chart

  2. pie chart

  3. 3D line chart

  4. all off the above


Correct Option: D
- Hide questions