0

databases Online Quiz - 165

Description: databases Online Quiz - 165
Number of Questions: 20
Created by:
Tags: databases
Attempted 0/20 Correct 0 Score 0
  1. update database table

  2. verify that the inserted data is correct

  3. select data from 2 or more tables related by common attribute (table column).

  4. delete data from database table


Correct Option: C
  1. we are using left and right join together

  2. we are joining more than 2 tables

  3. we are joining table to itself

  4. when joining a table and its view


Correct Option: C
  1. The DELETE clause deletes all rows in a database table, while the TRUNCATE clause can have a WHERE condition and might or might not delete all rows in a table.

  2. The TRUNCATE clause is identical to the DELETE clause

  3. The TRUNCATE clause deletes all rows in a database table, while the DELETE clause can have a WHERE condition and might or might not delete all rows in a table.

  4. None fo the above


Correct Option: C
  1. Creates a database view

  2. Creates a new database table

  3. Creates a stored procedure

  4. Creates a trigger


Correct Option: C
  1. A trigger is part of data extraction process.

  2. A trigger is a special kind of stored procedures executed when certain event occurs.

  3. A trigger defines relations between tables.

  4. A trigger is a part of error handling


Correct Option: C
  1. List of columns that will be selected or the * symbol.

  2. The JOIN SQL clause.

  3. The name of the table we are selecting from.

  4. Selects a database


Correct Option: A

What is Identity Column?

  1. Work as primary key

  2. Uniquely identify the records

  3. show a relation between the primary key and unique key

  4. All of the above

  5. None of these


Correct Option: E

You want to make changes in another database object whenever any new database object is created. which of the following triggers will you use?

  1. DML Trigger

  2. Instead of Trigger

  3. DDL Trigger

  4. Nested Trigger


Correct Option: C

You are creating an index for an existing table. There is already a nonclustered index on the primary key. You would like to put the data into address sequence, which is made up of several fields. The address is not the primary key. What should you do?

  1. Change the primary key index to clustered and create a nonclustered index on the address

  2. Create a nonclustered index on the address.

  3. Create a clustered index on the address.

  4. Change the primary key to the address and make the index clustered.


Correct Option: C

Which SQL keyword is used to retrieve a minimum value?

  1. DOWN

  2. LOW

  3. MIN

  4. LOWER


Correct Option: C

What is the default value of PAD INDEX option in creation of indexes?

  1. ON

  2. OFF

  3. NULL

  4. None of the options


Correct Option: B

What Work Process is responsible for Database DML opeartions like Insert, Update and Delete?

  1. Insert Work Process

  2. Batch Work Process

  3. Dialog Work Process

  4. Update Work Process


Correct Option: D

Where do we find the Oracle alert log?

  1. /oracle//saptrace

  2. /oracle//dbs

  3. /oracle//sapdata

  4. /oracle//trace


Correct Option: A

Deviating from SAP naming conventions for Oracle Database will result in?

  1. May Cause Oracle Database components to function improperly

  2. May Cause some Management Components of SAP to function improperly

  3. May Cause both Oracle components and SAP components to function improperly

  4. No need to follow any SAP standard


Correct Option: B

What is the purpose of the SQL AS clause?

  1. The AS SQL clause is used change the name of a column in the result set or to assign a name to a derived column.

  2. The AS clause is used with the JOIN clause only.

  3. The AS clause defines a search condition.

  4. The AS clause defines a group


Correct Option: A
- Hide questions