Words That Rhyme With "Andwich"
- 1.
SELECT SUBSTR(“Azure Skies”,-5, 5)FROM DUAL;What would be returned?
- A.
An error message.
- B.
Azure
- C.
Skies
- D.
Nothing
Correct Answer
C. SkiesExplanation
The given SQL statement is using the SUBSTR function to extract a substring from the string "Azure Skies". The parameters for the SUBSTR function are (-5, 5), which means it will start from the 5th character from the end of the string and extract the next 5 characters. Therefore, the result of the query will be "Skies".Rate this question:
-
- 2.
The UPPER function in SQL
- A.
Converts letters currently uppercase into lowercase
- B.
Converts all characters to uppercase
- C.
Converts the first letter of each word to uppercase
Correct Answer
B. Converts all characters to uppercaseExplanation
The UPPER function in SQL is used to convert all characters in a given string to uppercase. This means that regardless of whether the original letters are already uppercase or lowercase, the function will convert all of them to uppercase. This can be useful when you want to standardize the case of the characters in a string for consistency or when performing case-insensitive comparisons.Rate this question:
-
- 3.
The INITCAP function in SQL
- A.
Sets all letters to uppercase (CAPS)
- B.
Sets the first letter of each word to caps provided there is a space before each word
- C.
Sets the first letter of each word to caps provided there is not a space before each word
Correct Answer
B. Sets the first letter of each word to caps provided there is a space before each wordExplanation
The INITCAP function in SQL sets the first letter of each word to uppercase, but only if there is a space before each word.Rate this question:
-
- 4.
The INSTR function is used to find one string within another string. It can be called in one of three ways. Which of the following is not a valid way of calling the function?
- A.
INSTR(Name, ‘:’)
- B.
SELECT Name, INSTR(Name ‘:’, 15)
- C.
SELECT Name, INSTR(Name, ‘es’, -5, 2)
- D.
SELECT Name, INSTR(Name, ‘es’, 1, 2)
Correct Answer
C. SELECT Name, INSTR(Name, ‘es’, -5, 2)Explanation
The INSTR function is used to find the position of a substring within a string. It can be called in three different ways:
1. INSTR(Name, ‘:’): This will find the position of the colon character within the string 'Name'.
2. SELECT Name, INSTR(Name ‘:’, 15): This is an invalid way of calling the function because there is a missing comma between 'Name' and ':'.
3. SELECT Name, INSTR(Name, ‘es’, 1, 2): This will find the position of the substring 'es' within the string 'Name', starting from position 1 and returning the second occurrence.
Therefore, the option "SELECT Name, INSTR(Name, ‘es’, -5, 2)" is not a valid way of calling the function.Rate this question:
-
- 5.
Given the following:TRIM(‘ SQL is fun! ‘)The expected output would be (without the quotes)
- A.
‘SQLisfun!’
- B.
‘SQL is fun! ‘
- C.
‘SQL is fun!’
- D.
‘ SQL is fun!’
Correct Answer
C. ‘SQL is fun!’Explanation
The TRIM function is used to remove leading and trailing spaces from a string. In this case, the given string ' SQL is fun! ' has leading and trailing spaces. The TRIM function will remove those spaces and return the string 'SQL is fun!'. Therefore, the expected output is 'SQL is fun!'.Rate this question:
-
- 6.
All of the following are true regarding the TRANSLATE function except
- A.
A. Translate is used to replace one character with another
- B.
B. Translate can eliminate characters by having fewer replacement characters specified than characters to replace
- C.
C. If the replacement string is NULL it means that all the characters to replace should be deleted
Correct Answer
C. C. If the replacement string is NULL it means that all the characters to replace should be deletedExplanation
The TRANSLATE function is used to replace one character with another, as mentioned in option A. It can also eliminate characters by having fewer replacement characters specified than characters to replace, as mentioned in option B. However, if the replacement string is NULL, it does not mean that all the characters to replace should be deleted. Therefore, option C is incorrect.Rate this question:
-
- 7.
The REPLACE function is used to replace one string with another string
- A.
True
- B.
False
Correct Answer
A. TrueExplanation
The statement is true because the REPLACE function is indeed used to replace one string with another string. This function allows users to search for a specific substring within a given string and replace it with a different substring. It is commonly used in programming languages and database systems to modify text or data.Rate this question:
-
- 8.
The CONCAT function can concatenate any number of character strings together
- A.
True
- B.
False
Correct Answer
B. FalseExplanation
The CONCAT function in SQL can concatenate two or more character strings together, but it cannot concatenate any number of character strings together. It requires a specific number of arguments to be provided. Therefore, the statement "The CONCAT function can concatenate any number of character strings together" is false.Rate this question:
-
- 9.
Given the following SQL function:ROUND(568.8615, 1)
- A.
568.9
- B.
570
- C.
568.862
- D.
568.86
Correct Answer
A. 568.9Explanation
The given SQL function ROUND(568.8615, 1) rounds the number 568.8615 to one decimal place. In this case, the number 568.8615 is rounded to 568.9, which is the closest number to the original value with one decimal place.Rate this question:
-
- 10.
Given the following SQL function:ROUND(563.399, -1)
- A.
564
- B.
560
- C.
563.4
- D.
600
Correct Answer
B. 560Explanation
The ROUND function in SQL is used to round a number to a specified number of decimal places or to the nearest whole number. In this case, the function is rounding the number 563.399 to the nearest 10th place (-1 means rounding to the nearest 10). Since 563.399 is closer to 560 than 570, the correct answer is 560.Rate this question:
-
- 11.
The MOD function calculates the remainder of a division
- A.
True
- B.
False
Correct Answer
A. TrueExplanation
The MOD function in mathematics calculates the remainder when one number is divided by another. It is a useful tool for finding the leftover value after a division operation. Therefore, the statement that the MOD function calculates the remainder of a division is true.Rate this question:
-
- 12.
Which of the following is not a format mask for the day portion of a date
- A.
DDD
- B.
DDDD
- C.
Day
- D.
DD
Correct Answer
B. DDDDExplanation
The format mask "DDDD" is not a valid format mask for the day portion of a date. The format mask "DDD" represents the day of the year (1-366), "DD" represents the day of the month (01-31), and "Day" is not a valid format mask for the day portion of a date.Rate this question:
-
- 13.
Given the following function:TO_CHAR(56.89, ‘9.0’)The expected output would be
- A.
5.6
- B.
An error since the mask is not large enough for the number to be displayed
- C.
####
- D.
6.9
Correct Answer
C. ####Explanation
The answer is "####" because the mask "9.0" specifies that only one digit should be displayed before the decimal point and one digit after the decimal point. Since the number 56.89 has two digits before the decimal point, it cannot be fully displayed within the given mask, resulting in the output of "####" to indicate that the number is too large for the mask.Rate this question:
-
- 14.
The NVL function is used to
- A.
Check a column for null and return either the column value if not null or a replacement value of the same type if it is null.
- B.
Check a column for null and return either the column value if not null or a replacement value of any type if it is null.
- C.
Check a column for null and return one replacement value when it is null and a different replacement value if it is not null.
Correct Answer
A. Check a column for null and return either the column value if not null or a replacement value of the same type if it is null.Explanation
The NVL function is used to check a column for null and return either the column value if not null or a replacement value of the same type if it is null. This means that if the column value is not null, it will be returned as is. However, if the column value is null, it will be replaced with a specified replacement value of the same data type.Rate this question:
-
- 15.
The NVL2 function is used to
- A.
Check a column for null and return either the column value if not null or a replacement value of any type if it is null.
- B.
Check a column for null and return either the column value if not null or a replacement value of the same type if it is null.
- C.
Check a column for null and return one replacement value when it is null and a different replacement value if it is not null.
Correct Answer
C. Check a column for null and return one replacement value when it is null and a different replacement value if it is not null.Explanation
The NVL2 function is used to check a column for null and return one replacement value when it is null and a different replacement value if it is not null. This means that if the column value is not null, it will return one specific value, and if the column value is null, it will return a different specific value.Rate this question:
-
- 16.
Which of the statements regarding the DECODE function are false?
- A.
The function searches for a value provided among a list of possible outcomes
- B.
If the value provided matches one of the possible outcomes, the value associated with that outcome is returned
- C.
If the value provided does not match one of the possible outcomes, the value provided by DEFAULT is returned
- D.
DEFAULT is optional. If omitted the DECODE function returns an error.
Correct Answer
D. DEFAULT is optional. If omitted the DECODE function returns an error.Explanation
The DECODE function searches for a value provided among a list of possible outcomes. If the value provided matches one of the possible outcomes, the value associated with that outcome is returned. If the value provided does not match one of the possible outcomes, the value provided by DEFAULT is returned.Rate this question:
-
- 17.
Which column function will count all records in a result set, regardless of the presence of null values?
- A.
COUNT()
- B.
COUNT(*)
- C.
COUNT(%)
- D.
COUNT(ColumnName)
Correct Answer
B. COUNT(*)Explanation
The COUNT(*) function will count all records in a result set, regardless of the presence of null values. This is because the asterisk (*) symbol represents all columns, so COUNT(*) will count all rows in the result set. The other options, such as COUNT() and COUNT(ColumnName), may exclude null values from the count. COUNT(%) is not a valid column function.Rate this question:
-
- 18.
When using the AVG() column function, NULL values are included in the calculation.
- A.
True
- B.
False
Correct Answer
B. FalseExplanation
When using the AVG() column function, NULL values are not included in the calculation. The AVG() function calculates the average of the non-NULL values in the column. Therefore, the statement "NULL values are included in the calculation" is incorrect.Rate this question:
-
- 19.
Select the true statement about column functions:
- A.
A column function takes an entire column of data and summarizes it into a single data item.
- B.
A column function takes an entire row of data and summarizes it into a single data item.
- C.
A column function takes the values of two columns and adds them together to create a new value.
- D.
When using column functions, the WHERE clause cannot be used.
Correct Answer
A. A column function takes an entire column of data and summarizes it into a single data item.Explanation
A column function takes an entire column of data and summarizes it into a single data item. This means that the function performs an operation on each value in the column and then combines the results to produce a single value. This can be useful for calculating aggregate values such as the sum, average, minimum, or maximum of a column. The other options are incorrect because they either refer to row functions or make incorrect statements about the purpose or usage of column functions.Rate this question:
-
- 20.
A SELECT statement that uses column functions can also include a WHERE clause.
- A.
True
- B.
False
Correct Answer
A. TrueExplanation
A SELECT statement is used to retrieve data from a database table. Column functions are used to perform calculations or operations on the data in a specific column. The WHERE clause is used to filter the data based on certain conditions. Therefore, it is possible to include a WHERE clause in a SELECT statement that uses column functions to further refine the results based on specific criteria.Rate this question:
-
- 21.
Select the true statements about HAVING clauses from the list below. (There are more than one.)
- A.
If a column function is used on the HAVING clause, it will be calculated after the GROUP BY, creating additional processing.
- B.
HAVING is used to eliminate groups from the result set.
- C.
HAVING clause normally consists of one or more of the column functions applied to each of the groups.
- D.
HAVING is used to eliminate rows from the result set.
Correct Answer(s)
B. HAVING is used to eliminate groups from the result set.
C. HAVING clause normally consists of one or more of the column functions applied to each of the groups.Explanation
The HAVING clause is used to eliminate groups from the result set based on a specified condition. It allows filtering of groups that do not meet the condition specified in the HAVING clause. Additionally, the HAVING clause can consist of one or more column functions applied to each group. This means that aggregate functions can be used in the HAVING clause to further filter the groups.Rate this question:
-
- 22.
A subquery can return many columns of data as its query result.
- A.
True
- B.
False
Correct Answer
B. FalseExplanation
A subquery is a query that is nested inside another query. It is used to retrieve data that will be used in the main query. However, a subquery can only return a single value or a single column of data as its query result. It cannot return multiple columns of data. Therefore, the statement that a subquery can return many columns of data is false.Rate this question:
-
- 23.
The ORDER BY clause cannot be used in a subquery.
- A.
True
- B.
False
Correct Answer
A. TrueExplanation
The ORDER BY clause is used to sort the result set of a query. It cannot be used in a subquery because subqueries are used to retrieve data to be used in the main query, and the order of the data in a subquery does not affect the final result of the main query. Therefore, using the ORDER BY clause in a subquery would not have any impact and is not allowed.Rate this question:
-
- 24.
The INSERT, DELETE and UPDATE statements are considered what in SQL?
- A.
DML (Data Manipulation Language)
- B.
DDL (Data Defnition Language)
- C.
Transactions
- D.
All the above
Correct Answer
A. DML (Data Manipulation Language)Explanation
The INSERT, DELETE, and UPDATE statements in SQL are considered as DML (Data Manipulation Language) because they are used to manipulate or modify data in the database. DML statements allow users to insert new data into tables, delete existing data, and update existing data in the database. DDL (Data Definition Language) is used to define the structure of the database, while transactions are used to ensure the atomicity, consistency, isolation, and durability of database operations. Therefore, the correct answer is DML (Data Manipulation Language).Rate this question:
-
- 25.
When inserting a new row with a date, and you want to insert the date today, you can use the symbolic constant 'TODAY'.
- A.
True
- B.
False
Correct Answer
B. FalseExplanation
The statement is false because there is no symbolic constant 'TODAY' that can be used to insert the date today when inserting a new row. Instead, one would need to use a specific function or syntax provided by the database management system to insert the current date.Rate this question:
-
- 26.
To update the column 'Name' on a table to a null, you use the following syntax:'SET Name TO NULL'
- A.
True
- B.
False
Correct Answer
B. FalseExplanation
The given statement is incorrect. To update a column 'Name' on a table to a null, the correct syntax would be 'UPDATE table_name SET Name = NULL'. Therefore, the correct answer is False.Rate this question:
-
- 27.
When deleting from a table, the DELETE statement must specify the columns on the table to delete. Example:DELETE CustNumFROM CustomersWHERE CustNum = 100;
- A.
True
- B.
False
Correct Answer
B. FalseExplanation
The DELETE statement does not require specifying the columns to delete. The DELETE statement only needs to specify the table from which the rows should be deleted and any conditions for selecting the rows to be deleted. In the given example, the correct syntax would be: DELETE FROM Customers WHERE CustNum = 100.Rate this question:
-
- 28.
In the ANSI/ISO transaction model, a program is always in transaction mode.
- A.
True
- B.
False
Correct Answer
A. TrueExplanation
In the ANSI/ISO transaction model, a program is always in transaction mode. This means that any operations performed by the program are considered part of a transaction and are subject to the ACID properties (Atomicity, Consistency, Isolation, Durability). This ensures that the program's operations are executed reliably and consistently, even in the event of failures or concurrent access. Therefore, the statement "True" is correct as per the ANSI/ISO transaction model.Rate this question:
-
- 29.
In the Non-ANSI/ISO transaction model, a transaction can be partially rolled back to a named point.
- A.
True
- B.
False
Correct Answer
A. TrueExplanation
In the Non-ANSI/ISO transaction model, a transaction can be partially rolled back to a named point. This means that if a transaction encounters an error or failure, it can be rolled back to a specific point in the transaction where it was previously successful. This allows for more flexibility in managing transactions and ensures that only the necessary changes are undone, rather than rolling back the entire transaction.Rate this question:
-
- 30.
When using a view, execution speed in the database is
- A.
Slower since the view adds overhead.
- B.
Not affected as views do not affect execution speed at all.
- C.
Faster, since selecting from a view is not as much work.
- D.
Affected by what the view contains, so it might be slower, faster or the same.
Correct Answer
A. Slower since the view adds overhead.Explanation
When using a view, the execution speed in the database is slower because the view adds overhead. Views are virtual tables that are created by executing a query, and they do not store any data themselves. Whenever a query is executed on a view, the database engine needs to fetch the underlying data from the tables and apply any filters or transformations specified in the view definition. This additional processing and retrieval of data can slow down the execution speed compared to directly querying the tables.Rate this question:
-
- 31.
When a table is dropped, any view that uses that table is
- A.
Marked as invalid – it must be dropped and recreated.
- B.
Dropped as well.
- C.
Not affected in any way.
- D.
Unavailable until the table is recreated.
Correct Answer
D. Unavailable until the table is recreated.Explanation
When a table is dropped, any view that uses that table becomes unavailable until the table is recreated. This is because the view relies on the existence and structure of the table to function properly. Since the table no longer exists, the view cannot retrieve or manipulate data from it. Therefore, the view needs to be recreated once the table is restored in order to continue functioning correctly.Rate this question:
-
- 32.
What is a vertical view?
- A.
It is a view that contains a subquery.
- B.
It is a view that returns a subset of columns in a table but returns all of the rows.
- C.
It is a view that returns all columns in a table but returns a subset of the rows.
- D.
It is a view that selects data from 2 or more tables.
Correct Answer
B. It is a view that returns a subset of columns in a table but returns all of the rows.Explanation
A vertical view is a type of view that returns a subset of columns in a table but returns all of the rows. This means that when using a vertical view, you will get all the rows from the table, but only a specific set of columns will be included in the view. This can be useful when you only need certain information from a table and want to simplify your query results by excluding unnecessary columns.Rate this question:
-
- 33.
What is a horizontal view?
- A.
It is a view that contains a subquery.
- B.
It is a view that selects data from 2 or more tables.
- C.
It is a view that returns all columns in a table but returns a subset of the rows.
- D.
It is a view that returns a subset of columns in a table but returns all of the rows.
Correct Answer
C. It is a view that returns all columns in a table but returns a subset of the rows.Explanation
A horizontal view is a type of view that returns all columns in a table but only a subset of the rows. This means that the view will display all the columns of the table, but only show a portion of the data based on certain conditions or filters. This allows for a more focused and specific view of the data, making it easier to analyze and work with.Rate this question:
-
- 34.
Some views must be 'materialized'. Materializing means that
- A.
The programmer must run a subquery first and then run another command to send the result set to the next select statement.
- B.
That a materials fee must be paid before the query can be run.
- C.
A create table statement must be executed first.
- D.
The query in the view must be run first and an intermediate result set built before the query against the view can be run.
Correct Answer
D. The query in the view must be run first and an intermediate result set built before the query against the view can be run. -
- 35.
In Oracle, the view that displays the tables you have created is called
- A.
User_Tables
- B.
DBA_Tables
- C.
System Catalog
- D.
All_Tables
- E.
Dictionary
Correct Answer
A. User_TablesExplanation
The correct answer is User_Tables. In Oracle, the User_Tables view is used to display the tables that a user has created in the database. This view provides information about the table names, their owners, and other details such as the number of rows and the table's status. It is a useful tool for users to manage and monitor their own tables within the Oracle database.Rate this question:
-
- 36.
When creating a view you can use 'WITH CHECK OPTION'. What does this do to the view?
- A.
This option ensures that all constraints are checked before the view allows any rows to be updated.
- B.
This option prevents any sort of update from occurring to the source table in the view if the view cannot see the rows being updated.
- C.
This option turns on or off a view's ability to be updated.
- D.
This option ensures that only check constraints are checked before the view allows any rows to be updated.
Correct Answer
B. This option prevents any sort of update from occurring to the source table in the view if the view cannot see the rows being updated.Explanation
The option 'WITH CHECK OPTION' prevents any sort of update from occurring to the source table in the view if the view cannot see the rows being updated. This means that if the view does not have access to the rows being updated, it will not allow any updates to be made to the source table. This ensures that the view remains consistent with the underlying data and prevents any potential inconsistencies or errors from occurring.Rate this question:
-
- 37.
In Oracle, owner of the system catalog is
- A.
SYS
- B.
MASTER
- C.
ROOT
- D.
SYSTEM
- E.
DBA
Correct Answer
A. SYSExplanation
In Oracle, the owner of the system catalog is SYS. The SYS user is a powerful user account that is created automatically when Oracle is installed. It is used to perform administrative tasks and manage the system catalog, which stores metadata about the database objects. The SYS user has the highest level of privileges and can perform actions that are not allowed for other users. Therefore, SYS is the correct answer for the owner of the system catalog in Oracle.Rate this question:
-
- 38.
In Oracle’s User_Constraints view, what indicates a foreign key in the Constraint_Type column?
- A.
U
- B.
C
- C.
V
- D.
P
- E.
R
Correct Answer
E. RExplanation
In Oracle's User_Constraints view, the "R" value in the Constraint_Type column indicates a foreign key.Rate this question:
-
- 39.
Some of the views in the System Catalog have a prefix 'USER_'. What is found in these tables? (Select all that apply)
- A.
Information on system tables.
- B.
Information on tables you have been granted access to.
- C.
Information on your tables (tables in your schema).
Correct Answer
C. Information on your tables (tables in your schema).Explanation
The views in the System Catalog with a prefix 'USER_' contain information on your tables, specifically the tables in your schema. These views provide details about the tables that you have created and have ownership of. They do not include information on system tables or tables that you have been granted access to.Rate this question:
-
- 40.
Some of the views in the System Catalog have a prefix 'ALL_'. What is found in these tables? (Select all that apply)
- A.
Information on your tables (tables in your schema).
- B.
Information on system tables.
- C.
Information on tables you have been granted access to.
Correct Answer(s)
A. Information on your tables (tables in your schema).
B. Information on system tables.
C. Information on tables you have been granted access to.Explanation
The views in the System Catalog with a prefix 'ALL_' contain information on your tables (tables in your schema), information on system tables, and information on tables you have been granted access to. These views provide a comprehensive overview of the tables in the database, including both user-defined tables and system tables, as well as the tables that you have permission to access.Rate this question:
-
- 41.
If DeptCode and DeptName are both non-key columns in a table and given that logically the Deptname can be obtained if one knows the Deptcode this is an example of a(n) _____ dependency.
- A.
Transitive
- B.
Derived
- C.
Partial
- D.
Relational
- E.
Inverse
Correct Answer
A. TransitiveExplanation
This is an example of a transitive dependency because the DeptName can be obtained by knowing the DeptCode. In other words, there is a functional dependency between the non-key columns DeptCode and DeptName, where DeptCode determines DeptName.Rate this question:
-
- 42.
If EmployeeAge and EmployeeDateOfBirth are both non-key columns in a table and given that logically the EmployeeAge can be obtained if one knows the EmployeeDateOfBirth this is an example of a(n) _____ dependency.
- A.
Inverse
- B.
Relational
- C.
Derived
- D.
Transitive
- E.
Partial
Correct Answer
C. DerivedExplanation
This is an example of a derived dependency. The age of an employee can be derived or calculated based on their date of birth. It is not a direct dependency but rather a derived value from another column.Rate this question:
-
- 43.
A relational table has a primary key consisting of WareHouseNumber and ProductNumber. That is, each row in the table will contain data about a product stored in a warehouse. One of the columns is ProductDescription. If a product description changes, multiple rows will have to be changed assuming that the product is stored in more than one warehouse. This is an example of a(n) __ anomaly.
- A.
Redundancy
- B.
Insertion
- C.
Deletion
- D.
Modification
- E.
None of the above
Correct Answer
D. ModificationExplanation
This is an example of a modification anomaly because changing the product description will require modifying multiple rows in the table if the product is stored in more than one warehouse. This can lead to data inconsistency and redundancy.Rate this question:
-
- 44.
A relational table has a primary key consisting of ProductNumber. On each row, non-key attributes WareHouseNumber and the warehouse address information are also found. That is, each row in the table will contain data about a product stored in a warehouse. If the last product in a particular warehouse is removed from the database, it results in the loss of all the information of the warehouse where it is located. This is an example of a(n) __ anomaly.
- A.
Redundancy
- B.
Insertion
- C.
Deletion
- D.
Modification
- E.
None of the above
Correct Answer
C. DeletionExplanation
This is an example of a deletion anomaly. When the last product in a particular warehouse is removed from the database, it results in the loss of all the information of the warehouse where it is located. This means that deleting a single row can cause the loss of related data, leading to a deletion anomaly.Rate this question:
-
- 45.
A relational table has a primary key consisting of VIN and EngineCode. That is, each row in the table will contain data about a particular automobile and its engine. If new engine is designed and built, it could not be added to the database unless it was placed in a particular automobile. This is an example of a(n) __ anomaly.
- A.
Redundancy
- B.
Insertion
- C.
Deletion
- D.
Modification
- E.
None of the above
Correct Answer
B. InsertionExplanation
This is an example of an insertion anomaly. An insertion anomaly occurs when it is not possible to add certain data to a database without also adding unrelated data. In this case, if a new engine is designed and built, it cannot be added to the database unless it is placed in a particular automobile. This means that the insertion of a new engine is dependent on the existence of a corresponding automobile record, resulting in an insertion anomaly.Rate this question:
-
- 46.
A Medical Clinic table contains one row per clinic. Each row contains attributes about all the doctors working in the clinic. This violates ____ normal form.
- A.
1st
- B.
2nd
- C.
3rd
- D.
4th
- E.
None of the above
Correct Answer
A. 1stExplanation
The given scenario violates the 1st normal form. The 1st normal form requires that each attribute in a relation should contain only atomic values and not multiple values. In this case, the attributes in the Medical Clinic table contain multiple values as they store information about all the doctors working in the clinic in a single row. To adhere to the 1st normal form, the table should be normalized by creating a separate table for doctors and establishing a relationship between the clinic and doctors.Rate this question:
-
- 47.
DeptCode and DeptName are both non-key columns in a table. Given that logically the Deptname can be obtained if one knows the Deptcode, this would voilate _____ normal form.
- A.
1st
- B.
2nd
- C.
3rd
- D.
4th
- E.
None of the above
Correct Answer
C. 3rdExplanation
This scenario violates the 3rd normal form. The 3rd normal form states that every non-key column in a table must depend only on the key column(s) and not on any other non-key columns. In this case, the DeptName column depends on the DeptCode column, which is a non-key column. Therefore, it violates the 3rd normal form.Rate this question:
-
- 48.
EmployeeAge and EmployeeDateOfBirth are both non-key columns in a table. Given that the EmployeeAge can be obtained if one knows the EmployeeDateOfBirth, this would violate _____ normal form.
- A.
1st
- B.
2nd
- C.
3rd
- D.
4th
- E.
None of the above.
Correct Answer
C. 3rdExplanation
This would violate the 3rd normal form. The 3rd normal form states that all non-key columns in a table should depend only on the key columns and not on other non-key columns. In this case, the EmployeeAge column depends on the EmployeeDateOfBirth column, which is a non-key column. Therefore, it violates the 3rd normal form.Rate this question:
-
- 49.
A CoursesTaught table has a primary key combining both a Course code and an Instructor code. If Instructor name is an attribute of this table it would violate ___ normal form.
- A.
1st
- B.
2nd
- C.
3rd
- D.
4th
- E.
None of the above
Correct Answer
B. 2ndExplanation
If the Instructor name is an attribute of the CoursesTaught table, it would violate the 2nd normal form. The 2nd normal form states that a table should not have partial dependencies, meaning that all non-key attributes should depend on the entire primary key. In this case, the Instructor name is not dependent on the entire primary key (Course code and Instructor code), but only on the Instructor code. Therefore, it violates the 2nd normal form.Rate this question:
-
Quiz Review Timeline +
Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.
-
Current Version
-
Mar 21, 2023Quiz Edited by
ProProfs Editorial Team -
Dec 12, 2017Quiz Created by
Jo
- Active And Passive Voice Quizzes
- Adjective Quizzes
- Adverb Quizzes
- Article Quizzes
- Capitalization Quizzes
- Clause Quizzes
- Comparatives And Superlatives Quizzes
- Conjunction Quizzes
- Dangling Modifier Quizzes
- Definition Quizzes
- Dictionary Quizzes
- Direct And Indirect Quizzes
- Essay Quizzes
- Glossary Quizzes
- Idiom Quizzes
- Metaphor Quizzes
- Parts Of Speech Quizzes
- Phrase Quizzes
- Plural Quizzes
- Prefix Quizzes
- Prefix And Suffix Quizzes
- Pronoun Quizzes
- Pronunciation Quizzes
- Punctuation Quizzes
- Riddle Quizzes
- Sentence Quizzes
- Simile Quizzes
- Slang Quizzes
- Speaking Quizzes
- Speech Quizzes
- Spelling Quizzes
- Subject And Predicate Quizzes
- Suffix Quizzes
- Synonym Quizzes
- Synonyms And Antonyms Quizzes
- Tense Quizzes
- Voice Quizzes
- Writing Quizzes