Question 1

Which of the following is not a group function?

technology databases

avg()
sqrt()
max()
sum()

Answer

Correct Option: B

Question 2

You query the database with this command SELECT name FROM employee WHERE name LIKE ‘_a%’; Which names are displayed?

technology databases

Names starting with “a”
Names with "a" as second character
Last character as "a"
Names with atleast two "a" at the start.

AI Explanation

AI 1

To answer this question, let's analyze the given SQL command:

SELECT name FROM employee WHERE name LIKE '_a%';

The LIKE keyword is used for pattern matching in SQL queries. In this case, it is used with the pattern '_a%'.

Let's break down the pattern:

_ (underscore): This represents a single character.
a: This represents the character 'a'.
% (percent sign): This represents any sequence of characters (including zero characters).

So, the pattern '_a%' means that we are looking for names with:

Any single character as the first character.
The second character as 'a'.
Any sequence of characters (including zero characters) after the second character.

Now, let's go through each option to determine which names would be displayed:

Option A) Names starting with "a" - This option is incorrect. The pattern '_a%' does not specify that the names should start with "a". It only specifies that the second character should be "a".

Option B) Names with "a" as the second character - This option is correct. The pattern '_a%' matches names where the second character is "a". Therefore, this option correctly identifies the names that would be displayed.

Option C) Last character as "a" - This option is incorrect. The pattern '_a%' does not specify anything about the last character. It only specifies the second character as "a".

Option D) Names with at least two "a" at the start - This option is incorrect. The pattern '_a%' does not specify that there should be at least two "a" at the start. It only specifies the second character as "a".

Therefore, the correct answer is B) Names with "a" as the second character. This option correctly identifies the names that would be displayed based on the given SQL command.

Answer

Correct Option: B

Question 3

Which SQL keyword is used to specify conditional search?

technology databases

SELECT
WHERE
SEARCH
FIND

Answer

Correct Option: B

Question 4

The HAVING clause can be used only with

technology databases

DELETE clause
INSERT clause
SELECT clause
JOIN clause

Answer

Correct Option: C

Question 5

What does SQL stand for?

technology databases

Strong Query Language
Standard Query Language
Strict Query Language
Structured Query Language

Answer

Correct Option: D

Question 6

What does follow after the SQL WHERE clause?

technology databases

The name of the table we are selecting from
list of columns to be selected
Definition of the condition to be met for the rows to be returned
None of above

Answer

Correct Option: C

Question 7

What is a primary key?

technology databases

The primary key column is a column or combination of columns whose values can be non-unique
The primary key is a column or combination of columns whose values uniquely identify each row in the table
The primary key is a column that can have NULL values
all of above

Answer

Correct Option: B

Question 8

What is an index?

technology databases

An index is the same as alias
An index is a database table attribute, which speeds-up data search within a table
An index is a special way to join 2 or more tables
None of above

Answer

Correct Option: B

Question 9

What is a view?

technology databases

A view is a special stored procedure executed when certain event occurs
A view is a database diagram
A view is a virtual table which results of executing a pre-compiled query. A view is not part of the physical database schema, while the regular tables are
All of above

Answer

Correct Option: C

Question 10

In sql server 2008, whats the new concepts?

technology databases

XML data types
Table value parameters
Transactions
none of these

Answer

Correct Option: B

Question 11

What do you mean by OLTP

technology databases

online transfer processing
online transfer process
online transaction processing
online train processing

Answer

Correct Option: C

Question 12

what is/are etltools in given list

technology databases

informatica, businessobjects,cognos
datastage,hyperion,oracle builder
informatica,datastage,abinitio
abinitio,oraclebuilder,microstrategy

Answer

Correct Option: C

Question 13

SCD refers to ?

technology databases

slow change dimension
slowly change direction
Slowly changing dimension
slow chance direction

Answer

Correct Option: C

Question 14

SCD refers to ?

technology databases

slow change dimension
slowly change direction
Slowly changing dimension
slow chance direction

Answer

Correct Option: C

Question 15

SCD refers to ?

technology databases

slow change dimension
slowly change direction
Slowly changing dimension
slow chance direction

Answer

Correct Option: C

Question 16

SSIS?

technology databases

SQL Server Integrated Server
SQL Server Integration Services
SQL Server Information Server
SQL Server Information Service

Answer

Correct Option: B

Question 17

DMS is a ------- database model

technology databases

Relational
Network
Hierarchical
None of the above

Answer

Correct Option: B

Question 18

what is the "basic unit of a record"?

technology databases

Data Item
Database Key
Record Occurence
Record Structure

Answer

Correct Option: A

Question 19

A data item describes a particular attribute of a record.

technology databases

True
False

Answer

Correct Option: A

Question 20

A collection of data items with real life values is called a

technology databases

None
Record
Record Structure
Record Occurence

Answer

Correct Option: B,D

Description: databases Online Quiz - 113
Number of Questions: 20
Created by: Aliensbrain Bot
Tags: databases

databases Online Quiz - 113

AI Explanation

Find more quizzes from top tags