Question

Need answers for Normalization, Physical Design, Sql, And Security exam.

1. The database you're creating will be installed on a group of three servers. What feature of an enterprise RDBMS will allow one server to pick up the processing work if the main server becomes nonoperational?
A. Failover
B. Business intelligence
C. Data warehouse
D. Load balancing

2. What type of clause must you always use with DELETE or UPDATE to avoid inadvertently changing data elsewhere in the database?
A. SET
B. WHERE
C. ORDER
D. FROM

3. When users enter data into the database, they find they have to enter a value for every column, as the
database won't allow them to continue otherwise. What type of value has been disallowed for this database?
A. 0
B. Null
C. Duplicate
D. Tab key
4. What term is used to describe any action a database takes?
A. Attribute
B. Function
C. Transaction
D. Dependency

5. Why should you perform the denormalization process on a database?
A. Improve performance
B. Increase data protection
C. Correct attribute names
D. Correct incorrect linkages
6. Which keyword should you use to provide a substitute name for a column?
A. ORDER
B. SELECT
C. UPDATE
D. AS
7. You're working on setting a data type for a field that requires a high degree of precision, as it will be taking scientific values. Which data type should you likely set for this field?
A. Decimal
B. Int
C. Real
D. Money

8. When a database system requests a login name and password to allow a user to enter the database, what process is being performed?
A. Permission
B. Mapping
C. Authorization
D. Authentication

9. You have a field that will be taking a fixed-length-width text entry in different languages, including Russian. Which data type should you likely use?
A. varchar
B. nvarchar
C. char
D. nchar
10. Which keyword yields the same results as using the >= and <= operators?
A. BETWEEN
B. WHERE
C. IS
D. LIKE

Answer 1

1. B) Business Intelligence

Business Intelligence is a feature of an enterprise RDBMS that will allow one server to pick up the processing work if the main server becomes nonoperational.

2. A) Set

SET Clause is used with DELETE or UPDATE to avoid inadvertently changing data elsewhere in the database

3. C) Duplicate

Dupilcate type of value has been disallowed for the database

4. C) Transaction

Transaction is the term used to describe any action a database takes.

5. A) Improve Performance

The denormalization process on a database is used to improve Performance.

6. D) As

AS keyword is used to provide a substitute name for a column

7. A) Decimal

As they are scientific values,they can be in both decimal format and integer values.So Decimal is the data type used for this kind.

8. D) Authentication

Authentication is the process of entering into the database by clients with their provided login credentials.

9. A) Varchar

For a fixed-length-width text,we use Varchar field...

10. A) Between

Between is the used for the comparison...and this operator is used to test for a range of values.