Question: I need these SQL MULTIPLE CHOICE questions answered as soon a possible , please. Thank you in advance! QUESTION 1 Which of the below is

I need these SQL MULTIPLE CHOICE questions answered as soon a possible, please.

Thank you in advance!

I need these SQL MULTIPLE CHOICE questions answered as soon a possible,

please. Thank you in advance! QUESTION 1 Which of the below is

not a property of Referential Integrity? a. Ensuring that values entered into

QUESTION 1 Which of the below is not a property of Referential Integrity? a. Ensuring that values entered into child table attributes already exist in the parent table b. Cascading Insert from parent to child record c. Preventing a record in a parent table from being deleted if it is currently being referenced by a child table d. Cascading delete from parent to child record QUESTION 2 Which of the below is Data and not an Information? a. Average age of a country's population b. Percentage of sunny daylight hours c. Annual net profit of an incorporation d. Driver's License Number QUESTION 3 Which of the below define(s) data redundancy in an RDBMS? a. Same data is stored in more than one location b. Same data is stored multiple times in one location c. Both of the above d. None of the above QUESTION 4 Which amongst the below is not a good database design rule? a. All calculated values that are directly derived from other fields should be part of the table b. Every cell in the database must have atomic values cEvery table must have a unique identifier or primary key d. Must avold redundant data QUESTION 5 Which of the below is a mandatory cause in an old SQL Joln statement? a. USING b. ORDER BY CWHERE d.ON QUESTION 6 Which of the below has the primary purpose of centralizing data to avold repeated data groups and can be used to populate a dropdown list on a website or user interface? a. Lookup Table b. Data Table c Dual Table d. Temporary Table QUESTION 7 Which type of relationship is simulated using a bridge or Junction table in RDBMS? a. 1-to-1 b.O-to-1 c. many-to-many d. 1-to-many QUESTION The most common type of relationship in relational databases is a. 1-to-many relationship b. O-to-many relationship c. mary-to-many relationship d. 1-to-1 relationship QUESTION 9 Which of the below clauses of an SQL statement is the 3rd one in the order of execution? a. FROM b. WHERE C SELECT d. ORDER BY QUESTION 10 When designing a table, an attribute, or combination of attributes, that could potentially be considered to uniquely identify a row is called a. Primary Key b. Composite key c. Candidate key d. Surrogate key QUESTION 11 Which of the below is not a single row function? a. MONTHS_BETWEEN b. SQRT CROWNUM d. SYSDATE QUESTION 12 Which of the below does not form the basis of a relational model? a. Data is represented by a series of two dimensional tables b. Each column and row intersection should have an atomic value c. Every column In a table represents an attribute of the entity d. All rows in a table combine together to represent a single Instance of the entity in the table

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!