You are developing a database for your college project. Which of the following will you use for datatype of variable length of up to $2000$ characters?

Group of answer choices

A$.$ CHAR

B$.$ WORDS

C$.$ STRING

D$.$ VARCHAR

Flag this Question

Question $411$ pts

The query language, Structured Query Language $($SQL$,)$ have words that perform specific functions and they are not used for column names. What is the term for these words?

Group of answer choices

A$.$ Querying words

B$.$ Reserved words

C$.$ Special words

D$.$ Unique words

Flag this Question

Question $421$ pts

Which one of the following command does not need NOT NULL and UNIQUE specifications?

Group of answer choices

A$.$ CHAR

B$.$ VARCHAR

C$.$ PRIMARY KEY

D$.$ NAME

Flag this Question

Question $431$ pts

You intend to grand access rights to a table LECTURER to a new professor at a university. Which of the following command will you use if the professor$$s code is GRET?

Group of answer choices

A$.$ GRANT USE OF TABLE LECTURE TO GRET;

B$.$ GRANT USE OF TABLE TO GRET;

C$.$ GRANT USE OF LECTURE TABLE TO GRET

D$.$ GRANT USE OF TABLE

Flag this Question

Question $441$ pts

What is the purpose of access control in a database?

Group of answer choices

A$.$ Prevent only external access to data

B$.$ Ensure hardware is secure

C$.$ Ensure software meets user needs

D$.$ Prevent unauthorised accessing and modification of data

Flag this Question

Question $451$ pts

An organisation is implementing a security framework. Identify the incorrect purpose of a security framework.

Group of answer choices

A$.$ Avoidance

B$.$ Detection

C$.$ Stopping

D$.$ Authentication

Flag this Question

Question $461$ pts

In database administration, what are the rules used to evaluate the quality of a given activity?

Group of answer choices

A$.$ Policies

B$.$ Procedures

C$.$ Standards

D$.$ Sequence

Flag this Question

Question $471$ pts

You are a Junior Database Administrator at your organisation. Your task is ensuring that there is an incremental backup of the Organisations Data, done every week, and a full backup is done every month. Which of the following maintenance categories would your task be classified under?

Group of answer choices

A$.$ Adaptive Maintenance

B$.$ Corrective Maintenance

C$.$ Preventative Maintenance

D$.$ Redundancy Maintenance

Flag this Question

Question $481$ pts

During a database initial study, the database developer is notified that the database encompasses only the marketing, production and accounts departments. In what action of the database initial study was this revealed.

Group of answer choices

A$.$ Analyse the company situation

B$.$ Define problems and constraints

C$.$ Define objectives

D$.$ Define scope and boundaries

Flag this Question

Question $491$ pts

A user has erroneously made changes to a table in a database. Which of the following commands will remove these changes and bring the table to its previous state?

Group of answer choices

A$.$ COMMIT

B$.$ INSERT

C$.$ UPDATE

D$.$ ROLLBACK

Flag this Question

Question $501$ pts

Which of the following database failures occurs due to a deadlock in the database and the transaction is aborted?

Group of answer choices

A$.$ Hardware failure

B$.$ Programming Exemption failure

C$.$ Software failure

D$.$ Transaction failure