Which of the following is used in database design to increase data$-$retrieval speed?

Group of answer choices

A$.$ Derived attributes

B$.$ Combine two tables

C$.$ Use or $1.\mathrm{.}1$ relationships

D$.$ Use single$-$valued attributes

Flag this Question

Question $291$ pts

When three entities are associated, identify the relationship that exists.

Group of answer choices

A$.$ Binary

B$.$ Ternary

C$.$ Unary

D$.$ Weak

Flag this Question

Question $301$ pts

What will you use for uniquely identifying each entity instance?

Group of answer choices

A$.$ Attribute

B$.$ Primary key

C$.$ Method

D$.$ Relationships

Flag this Question

Question $311$ pts

You are evaluating and correcting table structures to minimize data redundancies, thereby reducing the likelihood of data anomalies. What is the name of the process that you are using?

Group of answer choices

A$.$ Manipulation

B$.$ Normalisation

C$.$ Standardisation

D$.$ Denormalisation

Flag this Question

Question $321$ pts

Which one of the following resolves the conflicts between efficiency, information requirements and processing speed in a database environment?

Group of answer choices

A$.$ Too many large tables joined

B$.$ Additional input$/$output operations

C$.$ Increase the number of database tables

D$.$ Denormalising tables

Flag this Question

Question $331$ pts

Select an incorrect rule for the fourth normal form $(4$NF$).?$

Group of answer choices

A$.$ All attributes must be dependent on the primary key

B$.$ All attributes must be independent of each other

C$.$ No row may contain two or more multivalued facts about an entity

D$.$ Should have a single primary key

Flag this Question

Question $341$ pts

Which of the following provides the big picture of an organisation$$s data requirements and operations?

Group of answer choices

A$.$ Entity Relationship Diagram $($ERD$)$

B$.$ Size of the organisation

C$.$ Business type

D$.$ Organisational structure

Flag this Question

Question $351$ pts

Conflicts between design efficiency, information requirements and processing speed are a challenge in any database. How can you reduce these challenges?

Group of answer choices

A$.$ Reducing the number of tables

B$.$ Reducing entity relationships

C$.$ Use the Denormalisation process

D$.$ Using Entity relationship diagrams $($ERD$)$

Flag this Question

Question $361$ pts

What is the problem with the first normal form $(1$NF$)$ table structure?

Group of answer choices

A$.$ All attributes dependent on the primary key

B$.$ Each row intersection contains a set of values

C$.$ All key attributes are not defined

D$.$ There are repeating groups

Flag this Question

Question $371$ pts

A database administrator has been making changes to several tables in a database. Which one of the following commands will ensure the changes are saved permanently?

Group of answer choices

A$.$ COMMIT

B$.$ DELETE

C$.$ INSERT

D$.$ ROLLBACK

Flag this Question

Question $381$ pts

You are the database administrator for a retail company. You need to give access rights to the user according to their needs for the data. Which one of the following will make you accomplish this?

Group of answer choices

A$.$ Data definition language $($DDL$)$

B$.$ Data manipulation language $($DML$)$

C$.$ Access granting language $($AGL$)$

D$.$ Right allocation language $($RAL$)$

Flag this Question

Question $391$ pts

In a database, you want to restrict the date for future data changes to be after a specific date. What constraint should you use to achieve this?

Group of answer choices

A$.$ CHECK

B$.$ DEFAULT

C$.$ NOT NULL

D$.$ UNIQUE