• databases Online Quiz - 165
Back
0

databases Online Quiz - 165

Description: databases Online Quiz - 165
Number of Questions: 20
Created by:
Tags: databases
Start the Quiz
Attempted 0/20 Correct 0 Score 0
‹
›

Which of the following is a SQL aggregate function

technology databases

  1. join

  2. len

  3. left

  4. avg

Show answer
Correct Option: D

The JOIN is a SQL keyword used to ...

technology databases

  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

Show answer
Correct Option: C

AI Explanation

To answer this question, you need to understand the concept of JOIN in SQL.

The JOIN keyword is used to select data from multiple tables that are related by a common attribute (table column). It allows you to combine rows from different tables based on their related values.

Let's go through each option to understand why it is correct or incorrect:

Option A) Update database table - This option is incorrect. The JOIN keyword is not used to update database tables. The UPDATE keyword is used for that purpose.

Option B) Verify that the inserted data is correct - This option is incorrect. The JOIN keyword is not used to verify the correctness of inserted data. Data validation is usually done using constraints, triggers, or other mechanisms.

Option C) Select data from 2 or more tables related by a common attribute (table column) - This option is correct. The JOIN keyword is used to combine rows from multiple tables based on a common attribute or column. It allows you to retrieve data from related tables in a single query.

Option D) Delete data from a database table - This option is incorrect. The JOIN keyword is not used to delete data from a database table. The DELETE keyword is used for that purpose.

The correct answer is Option C. This option is correct because the JOIN keyword is used to select data from multiple tables related by a common attribute (table column).

We refer to a join as a self-join when…
technology databases

  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

Show answer
Correct Option: C

The difference between the DELETE and TRUNCATE SQL clauses is:

technology databases

  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

Show answer
Correct Option: C

What does the CREATE TABLE statement do?

technology databases

  1. Creates a database view

  2. Creates a new database table

  3. Creates a stored procedure

  4. Creates a trigger

Show answer
Correct Option: C

What is a trigger?

technology databases

  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

Show answer
Correct Option: C

What does follow after the SQL SELECT clause?

technology databases

  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

Show answer
Correct Option: A

Which clause specifies conditions that determines the groups included in the query?

technology databases

  1. Having Clause

  2. Where clause

  3. Distinct

  4. Exists

Show answer
Correct Option: A

What is Identity Column?

technology databases

  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

Show answer
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?

technology databases

  1. DML Trigger

  2. Instead of Trigger

  3. DDL Trigger

  4. Nested Trigger

Show answer
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?

technology databases

  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.

Show answer
Correct Option: C

Which SQL keyword is used to retrieve a minimum value?

technology databases

  1. DOWN

  2. LOW

  3. MIN

  4. LOWER

Show answer
Correct Option: C

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

technology databases

  1. ON

  2. OFF

  3. NULL

  4. None of the options

Show answer
Correct Option: B

AI Explanation

To answer this question, let's first understand what the PAD INDEX option is in the context of index creation.

When an index is created on a table in a database management system, the PAD INDEX option determines the amount of space that is reserved for each index entry. This reserved space is used to accommodate future growth in the index.

Now, let's go through each option to determine the default value of the PAD INDEX option:

Option A) ON - This option is incorrect because the default value of the PAD INDEX option is not "ON".

Option B) OFF - This option is correct. The default value of the PAD INDEX option is "OFF". This means that no extra space is reserved for each index entry.

Option C) NULL - This option is incorrect. The default value of the PAD INDEX option is not "NULL".

Option D) None of the options - This option is incorrect. The correct answer is option B, "OFF".

Therefore, the correct answer is option B. The default value of the PAD INDEX option in index creation is "OFF", meaning no extra space is reserved for each index entry.

Name the SAP utility provided for performing Database administration activities like (backup,restore)

technology databases

  1. BRUTILITY

  2. SAPTOOLS

  3. BRTOOLS

  4. SAPUTILITY

Show answer
Correct Option: C

Find the Valid Oracle SID among the options given below

technology databases

  1. GRQ

  2. GRQUALITY

  3. GRQ12

  4. ALL THE ABOVE

Show answer
Correct Option: A

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

technology databases

  1. Insert Work Process

  2. Batch Work Process

  3. Dialog Work Process

  4. Update Work Process

Show answer
Correct Option: D

Where do we find the Oracle alert log?

technology databases

  1. /oracle//saptrace

  2. /oracle//dbs

  3. /oracle//sapdata

  4. /oracle//trace

Show answer
Correct Option: A

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

technology databases

  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

Show answer
Correct Option: B

Can you use both SELECT and WHERE SQL clauses in one SQL statement?

technology databases

  1. True

  2. False

Show answer
Correct Option: A

What is the purpose of the SQL AS clause?

technology databases

  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

Show answer
Correct Option: A
- Hide questions
ADVERTISEMENT

Find more quizzes from top tags

general knowledge
3615 Quizzes
119858 Questions
 technology
307 Quizzes
36705 Questions
 sports
963 Quizzes
19148 Questions
 history
1187 Quizzes
13475 Questions
 physics
598 Quizzes
13441 Questions
 biology
1160 Quizzes
12174 Questions
 science & technology
551 Quizzes
11015 Questions
 chemistry
490 Quizzes
9892 Questions
 maths
518 Quizzes
9324 Questions
 softskills
0 Quizzes
7131 Questions