Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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!

image text in transcribed

image text in transcribed

image text in transcribed

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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Databases questions