Higher Study | Database

Which of the following is an SQL trigger supported by Oracle?

ক

BEFORE

খ

INSTEAD OF

গ

AFTER

ঘ

None of the above

A shared lock allows which of the following types of transactions to occur?

ক

Delete

খ

Insert

গ

Read

ঘ

Update

websites without a database attached to them have which of the following characteristics?

ক

The ability to generate data via SQL

খ

Static information using HTML or JAVA Script

গ

The need to use TCP/ IP as the network protocol

ঘ

None

Which of the following is not a component of a data warehouse?

ক

Data metadata

খ

Data extraction/cleaning/preparation programs

গ

Data warehouse data

ঘ

None of the Mentioned

Which one of the following sorts rows in SQL?

ক

Sort By

খ

Align By

গ

Group By

ঘ

Order By

How can you find rows that do not match some specified condition?

ক

EXISTS

খ

Double use of NOT EXISTS

গ

NOT EXISTS

ঘ

None of the mentioned

What type of join is needed when you wish to include rows that do not have matching values?

ক

Equi-join

খ

Natural join

গ

Outer join

ঘ

All of the Mentioned

What type of join is needed when you wish to return rows that do have matching values?

ক

Equi-join

খ

Natural join

গ

Outer join

ঘ

All of the Mentioned

Which of the following is one of the basic approaches for joining tables?

ক

Subqueries

খ

Union Join

গ

Natural join

ঘ

All of the Mentioned

A UNION query is which of the following?

ক

Combines the output from no more than two queries and must include the same number of columns

খ

Combines the output from no more than two queries and does not include the same number of columns

গ

Combines the output from multiple queries and must include the same number of columns

ঘ

Combines the output from multiple queries and does not include the same number of columns

Which of the following statements is true concerning subqueries?

ক

Involves the use of an inner and outer query

খ

Cannot return the same result as a query that is not a subquery

গ

Does not start with the word SELECT

ঘ

All of the mentioned

Which of the following is a correlated subquery?

ক

Uses the result of an inner query to determine the processing of an outer query

খ

Uses the result of an outer query to determine the processing of an inner query

গ

Uses the result of an inner query to determine the processing of an inner query

ঘ

Uses the result of an outer query to determine the processing of an outer query

How many tables may be included with a join?

ক

One

খ

Two

গ

Three

ঘ

All of the Mentioned

Which of the following is a disadvantage of replication?

ক

Improved performance

খ

To move data closer to the user

গ

Easy maintenance

ঘ

None of the mentioned

Which of the following statements concerning business rules is true?

ক

It should be complex.

খ

It should not be convertible to computer code.

গ

It may include restrictions.

ঘ

All of the Mentioned