QN=40 (7992) Normalization is a process of analyzing the given relation schema based on their Functional Dependencies (FDs) and primary keys to achieve the following:

b. Minimizing insertion anomalies

d. Minimizing deletion and update anomalies

QN=45 (8006) What is "normalization"?

a. Normalizing data means eliminating redundant information from a table and organizing the data so that future changes to the table are easier

b. Normalizing data means minimizing columns from a table and organizing the data so that future changes to the table will be made more quickly

c. Normalizing data means removing columns from a table and organizing the data so that future changes to the table will be made more quickly

d. Normalizing data means adding more columns to a table and organizing the data so that future changes to the table will be made more quickly

QN=46 (7997) Which of the following are guidelines for designing the relational schema ?

a. Reduce the redundant values in tuples

b. Reduce the NULL values in tuples

Pay attention into the following query: SELECT * FROM R WHERE A LIKE '%a%'; So, in the above case, the wildcard % represents what?

a. % (percent sign) represents zero, one, or more character

b. % (percent sign) represents exactly 1 character

With SQL, how do you select all the records from a table named "Persons" where the value of the column "FirstName" starts with an "a"?

d. SELECT * FROM Persons WHERE FirstName LIKE 'a%'

a. SELECT * FROM Persons WHERE FirstName='a'

b. SELECT * FROM Persons WHERE FirstName LIKE '%a'

c. SELECT * FROM Persons WHERE FirstName='%a%'

What does the keyword ESCAPE mean?

a. The keyword ESCAPE is used to match any string that contains the characters "%" or "_"

b. There is no keyword named ESCAPE

c. The keyword ESCAPE is used to match any string that contains the characters "?" or "*"

d. The keyword ESCAPE is used to match any string that contains the characters "@" or "$"

The SQL BETWEEN operator:

b. Specifies which tables we are selecting from.

c. Specifies that a column is a primary key.

Database integrity ensures that:

a. data entered into the database is accurate, valid, and consistent

b. data entered into the database is accurate, and consistent

c. data entered into the database is valid, and consistent

d. data entered into the database is accurate, and valid

Which of the following statements is the most correct?

a. Poorly designed indexes and a lack of indexes are primary sources of database application bottlenecks.

b. Designing efficient indexes is paramount to achieve good database and application performance

c. The selection of the right indexes for a database and its workload is a complex balancing act between query speed and update cost

c. A view is a virtual table which results of executing a pre-compiled query. A view is not a part of the physical database schema, while the regular tables are.

a. A view is a database diagram

b. A view is a special stored procedure executed when certain event occurs

Suppose an updatable view ParamountMovies is associated with Movies relation. Choose a correct answer.

c. An update on ParamountMovies is translated into Movies

a. Drop Movies relation also delete the view ParamountMovies

b. Drop ParamountMovies also delete Movies

Why we should use stored procedures?

b. They can reduce network traffic

c. They allow modular programming

d. They can be used as a security mechanism

Consider the following statement: "When drawing ERD, if an entity has no non-key attribute and it is the 'one' in many-one relationship, then we should set it to the attribute of other entities" That above statement describes which principle?

B.Picking the right kind of element principle

C.Limit the use of weak entity sets principle

When drawing an ERD: (a)Entity sets and their attributes should reflect reality (b)Redundancy is not important, so we can ignore it (c) Avoid introducing more elements into the design than is absolutely necessary (d) Choosing the right relationships

B.(a) and (c) and (d) are correct

A.(a) and (b) and (c) are correct

C.(a) and (b) and (d) are correct

D.(b) and (c) and (d) are correct

B.does not have enough key attribute(s)

A.does not depend on other entities

C.is an entity that has not any key-attribute

Choose the correct statement

A.Except for COUNT, aggregate functions ignore null values

B.Except for SUM, aggregate functions ignore null values

C.Except for AVG, aggregate functions ignore null values

D.Except for MIN, aggregate functions ignore null values

E.Except for MAX, aggregate functions ignore null values

What is the difference between Where and Having Clause?

A.WHERE is for Rows and HAVING is for Groups

B.WHERE is for Groups and HAVING is for Rows

C.WHERE and HAVING are the same

D.We can use aggregation functions in WHERE clause

What does the following SQL statement do: SELECT Customer, COUNT(Order) FROM Sales GROUP BY Customer HAVING COUNT(Order) > 5

C.Selects all customers from table Sales that have made more than 5 orders.

A.Selects the total number of orders from the Sales table, if this number is greater than 5

B.Selects all Customers from the Sales table

The relation R(A,B) may have duplicate tuples. Choose the query that create non-duplicated results, regardless of what tuples R contains?

B.SELECT A, B FROM R GROUP BY A, B

C.SELECT A FROM R WHERE A NOT IN (SELECT B FROM R)

QN=18 (8537) What is a "join"?

a. 'join' used to connect two or more tables logically with or without common field(s) a

b. 'join' used to connect two or more tables logically with common field(s)

c. 'join' used to connect two or more tables logically without common field(s)

d. 'join' used to connect two or more tables logically with aliases

Given relations R(A,B) and S(B,C,D). The result of natural join of the relations R and S has

b. Only two attributes R.B and S.B

Relation R(x,y) currently consists of only one tuple (NULL, NULL). Which of the following queries will produce a nonempty output? That is, at least one tuple will be produced, although the tuple(s) may have NULL's.

a. SELECT * FROM R WHERE x IS NULL

b. SELECT * FROM R WHERE x = NULL

d. SELECT * FROM R WHERE x <> 10

Choose the in-correct statement:

d. When the sequence of tasks is complete, the SAVE POINT closes the transaction

a. In SQL Server, every DML operation is a transaction regardless of whether it has a BEGIN TRANSACTION or not

b. COMMITTING a transaction makes permanent the changes resulting from all SQL statements in the transaction

c. ROLLING back a transaction rejects any of the changes resulting from the SQL statements in the transaction

QN=43 (8610) In order to modify or delete an existing constraint, it is necessary that:

c. the constraint has some attributes

QN=37 (8611) Look at the following tables and then choose the correct statment: ARTISTS Airtist_id Airtist_Name ----------------------------------- 1 Bono 2 Cher ALBUM artist_id Album_name ------------------------------------ 3 Eat the rich

b. The above picture is an example of a database that has not enforced entity integrity

a. The above picture is an example of a database that has not enforced referential integrity

c. The above picture is an example of a database that has not enforced domain integrity

QN=33 (8576) The IN SQL keyword

c. Determines if a value any of the values in a list or a sub-query

a. Is used with the DISTINCT SQL keyword only

b. Is used with the INSERT SQL keyword only

d. Defines the tables we are selecting or deleting data from

Choose a right answer.

[A] A SOL environment is the framework under which data may exist and SQL operations on data may be executed

[C] Within a SQL environment are two special kinds of processes: SQL clients and SQL servers.

[D] A SQL environment is a DBMS running at some installation.

DBI202_PART2

Quiz

•

Other

•

University

•

Practice Problem

•

Easy

Phạm Ngân

Used 1+ times

FREE Resource

120 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

QN=17 (6831) What is a primary key?

a. A primary key is the field(s) in a table that uniquely defines that table in a database

b. A primary key is the field(s) in a table that is used to establishes a relationship between two tables

c. A primary key is the field(s) in a table that uniquely defines the row in the table

d. A primary key is the field(s) in a table that is used to establishes a relationship between two databases

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

a. only A

b. only B

c. A and B

d. B and C

Access all questions and much more by creating a free account

Create resources

Host any resource

Get auto-graded reports

Continue with Google

Continue with Email

Continue with Classlink

Continue with Clever

or continue with

Microsoft

Apple

Others

Already have an account?

Similar Resources on Wayground

115 questions

BEE EXAM

Quiz

•

University

120 questions

Test positionnement MCO

Quiz

•

University

117 questions

ôn Dược Liệu

Quiz

•

University

125 questions

chương 6

Quiz

•

University

119 questions

Câu hỏi Kinh tế Vĩ mô

Quiz

•

University

123 questions

Quiz về Tư tưởng Hồ Chí Minh

Quiz

•

University

123 questions

Панабек Сессия

Quiz

•

University

120 questions

CBTH-01

Quiz

•

University

Popular Resources on Wayground

15 questions

Fractions on a Number Line

Quiz

•

3rd Grade

20 questions

Equivalent Fractions

Quiz

•

3rd Grade

25 questions

Multiplication Facts

Quiz

•

5th Grade

$fractions$

22 questions

fractions

Quiz

•

3rd Grade

20 questions

Main Idea and Details

Quiz

•

5th Grade

20 questions

Context Clues

Quiz

•

6th Grade

15 questions

Equivalent Fractions

Quiz

•

4th Grade

20 questions

Figurative Language Review

Quiz

•

6th Grade

Discover more resources for Other

12 questions

IREAD Week 4 - Review

Quiz

•

3rd Grade - University

23 questions

Subject Verb Agreement

Quiz

•

9th Grade - University

7 questions

Force and Motion

Interactive video

•

4th Grade - University

7 questions

Renewable and Nonrenewable Resources

Interactive video

•

4th Grade - University

5 questions

Poetry Interpretation

Interactive video

•

4th Grade - University

19 questions

Black History Month Trivia

Quiz

•

6th Grade - Professio...

15 questions

Review1

Quiz

•

University

15 questions

Pre1

Quiz

•

University

DBI202_PART2

120 questions

QN=17 (6831) What is a primary key?

QN=19 (6822) Which statement is used to add a column named D into the relation R?

QN=20 (6821) Which one of the following is NOT a DML command?

QN=22 (6811) The relational operator that adds all possible pairs of rows from two tables is known as the .... operator.

QN=23 (7956) Let R(ABCDEFGH) satisfies the following functional dependencies:
A -> B,
CH -> A,
B -> E,
BD -> C,
EG -> H,
DE -> F.
Which of the following FDs is also guaranteed to be satisfied by R?

QN=25 (7969) Consider a relation with schema R(A, B, C, D) and FD's BC -> D, D -> A, A -> B. Which of the following is the key of R?

QN=26 (7963) Given the relation schema R(A,B,C) and functional dependencies
F = {AB-> C, B->A, C->B}.
Which attribute(s) is/are prime?

QN=27 (7971) Given the relation R(ABCDE) with the following FD's:
D -> C,
CE ->A,
D ->A, and
AE ->D
Which of the following attribute set is a key?

QN=29 (7967) A set of attributes forms a ____ for a relation if we do not allow 2-tuples in a relation instance to have the same values in all that attributes

QN=32 (7981) Suppose we have a relation R(ABCD) with FD's:
BC -> A ;
AD -> C ;
CD -> B ;
BD -> C

Access all questions and much more by creating a free account

Similar Resources on Wayground

Popular Resources on Wayground

Discover more resources for Other

DBI202_PART2

120 questions

QN=17 (6831) What is a primary key?

QN=19 (6822) Which statement is used to add a column named D into the relation R?

QN=20 (6821) Which one of the following is NOT a DML command?

QN=22 (6811) The relational operator that adds all possible pairs of rows from two tables is known as the .... operator.

QN=23 (7956) Let R(ABCDEFGH) satisfies the following functional dependencies:A -> B,CH -> A,B -> E,BD -> C,EG -> H,DE -> F.Which of the following FDs is also guaranteed to be satisfied by R?

QN=25 (7969) Consider a relation with schema R(A, B, C, D) and FD's BC -> D, D -> A, A -> B. Which of the following is the key of R?

QN=26 (7963) Given the relation schema R(A,B,C) and functional dependenciesF = {AB-> C, B->A, C->B}.Which attribute(s) is/are prime?

QN=27 (7971) Given the relation R(ABCDE) with the following FD's:D -> C,CE ->A,D ->A, andAE ->DWhich of the following attribute set is a key?

QN=29 (7967) A set of attributes forms a ____ for a relation if we do not allow 2-tuples in a relation instance to have the same values in all that attributes

QN=32 (7981) Suppose we have a relation R(ABCD) with FD's:BC -> A ;AD -> C ;CD -> B ;BD -> C

Access all questions and much more by creating a free account

Similar Resources on Wayground

Popular Resources on Wayground

Discover more resources for Other

QN=23 (7956) Let R(ABCDEFGH) satisfies the following functional dependencies:
A -> B,
CH -> A,
B -> E,
BD -> C,
EG -> H,
DE -> F.
Which of the following FDs is also guaranteed to be satisfied by R?

QN=26 (7963) Given the relation schema R(A,B,C) and functional dependencies
F = {AB-> C, B->A, C->B}.
Which attribute(s) is/are prime?

QN=27 (7971) Given the relation R(ABCDE) with the following FD's:
D -> C,
CE ->A,
D ->A, and
AE ->D
Which of the following attribute set is a key?

QN=32 (7981) Suppose we have a relation R(ABCD) with FD's:
BC -> A ;
AD -> C ;
CD -> B ;
BD -> C