¡GoConqr estrena diseño! Cuéntanos qué te parece.

Regístrate gratis

Fichas

Oracle - Practice Exam

Amber Saxon Oracle SQL Inglés 200 fichas

Fichas del conjunto (200)

  1. 1Attributes that can be divided into smaller subparts are called. a) composite attribute b) volatile attribute c) single attribute d) Mandatory Attributea) composite attribute
  2. 2Which of the following entities most likely contains invalid attributes? a) Entity: Car. Attributes: Owner Occupation, Owner Salary, Speed b) Entity: Home. Attributes: Number of Bedrooms, Owner, Address, Date Built c) Entity: Pet. Attributes: Name, Birthdate, Owner d) Entity: Mother. Attributes: Name, birthdate, occupation, Number of Childrena) Entity: Car. Attributes: Owner Occupation, Owner Salary, Speed
  3. 3Candidate UID's (Unique Identifiers) must be made up of only 1 attribute a) True b) Falseb) False
  4. 4The PK uniquely identifies each row in a table and is based on the _______ from the LOGICAL DESIGN. a) Primary UID b) Composite UID c) Candidate UID d) Secondary UIDa) Primary UID
  5. 5A table has the following definition: EMPLOYEES( EMPLOYEE_ID NUMBER(6) NOT NULL, NAME VARCHAR2(20) NOT NULL, MANAGER_ID VARCHAR2(6)) and contains the following rows: (1001, 'Bob Bevan', '200') (200, 'Natacha Hansen', null) Will the folloiwng query work? SELECT * FROM employees WHERE employee_id = manager_id; a) Yes, Oracle will perform implicit datatype conversion, and the query will return one row of data. b) Yes, Oracle will perform implicit datatype conversion, but the WHERE clause will not find any matching data. c) No. You will have to re-write the statement and perform explicit datatype conversion. d) No, because the datatypes of EMPLOYEE_ID and MANAGER_ID are different.b) Yes, Oracle will perform implicit datatype conversion, but the WHERE clause will not find any matching data.
  6. 6If you use the RR format when writing a query using the date 27-Oct-17 and the year is 2001, what year would be the result? a) 1901 b) 2017 c) 2000 d) 1917b) 2017
  7. 7Which arithmetic operation will return a numeric value? a) SYSDATE + 30 / 24 b) NEXT_DAY(hire_date) + 5 c) SYSDATE - 6 d) TO_DATE('01-Jun-2004') - TO_DATE('01-Oct-2004')d) TO_DATE('01-Jun-2004') - TO_DATE('01-Oct-2004')
  8. 8Which SQL Statement should you use to display the prices in this format: "$00.30"? a) SELECT TO_CHAR(price, '$99,900.99') FROM product; b) SELECT TO_NUMBER(price, '$99,900.99') FROM product; c) SELECT TO_CHAR( price, '$99,990.99') FROM product; d) SELECT TO_CHAR(price, '$99,999.99') FROM product;a) SELECT TO_CHAR(price, '$99,900.99') FROM product;
  9. 9Which two statements concerning SQL functions are true? (Choose two.) a) Single-row functions manipulate groups of rows to return one result per group of rows. b) Conversion functions convert a value from one data type to another data type. c) Not all date functions return date values. c) Character functions can accept numeric input. d) Number functions can return number or character values.b) Conversion functions convert a value from one data type to another data type.
    c) Not all date functions return date values.
  10. 10You need to display the HIRE_DATE values in this format: 25th of July 2002. Which SELECT statement would you use? a) SELECT enroll_date(hire_date, 'DDspth "of" Month YYYY') FROM employees; b) SELECT TO_CHAR(hire_date, 'DDspth 'of' Month RRRR') FROM employees; c) SELECT TO_CHAR(hire_date, 'DDTH "of" Month YYYY') FROM employees; d) SELECT TO_CHAR(hire_date, 'ddth "of" Month YYYY') FROM employees;d) SELECT TO_CHAR(hire_date, 'ddth "of" Month YYYY') FROM employees;
  11. 11NVLNull Value Logic
  12. 12Which function compares two expressions? a) NVL b) NVL2 c) NULL d) NULLIFd) NULLIF (*)
  13. 13Which of the following General Functions will return the first non-null expression in the expression list? a) NULLIF b) COALESCE c) NVL2 d) NVLb) COALESCE (*)
  14. 14When executed, which statement displays a zero if the TUITION_BALANCE value is zero and the HOUSING_BALANCE value is null? Mark for Review (1) Points a) SELECT NVL (tuition_balance + housing_balance, 0) "Balance Due" FROM student_accounts; b) SELECT tuition_balance + housing_balance FROM student_accounts; c) SELECT TO_NUMBER(tuition_balance, 0), TO_NUMBER (housing_balance, 0), tutition_balance + housing_balance "Balance Due" FROM student_accounts; d) SELECT NVL(tuition_balance, 0), NVL (housing_balance), tuition_balance + housing_balance "Balance Due" FROM student_accounts;a) SELECT NVL (tuition_balance + housing_balance, 0) "Balance Due"
    FROM student_accounts;
    (*)
  15. 15Which statement about group functions is true? a) NVL and COALESCE, but not NVL2, can be used with group functions to replace null values. b) COALESCE, but not NVL and NVL2, can be used with group functions to replace null values. c) NVL and NVL2, but not COALESCE, can be used with group functions to replace null values. d) NVL, NVL2, and COALESCE can be used with group functions to replace null values.d) NVL, NVL2, and COALESCE can be used with group functions to replace null values. (*)
  16. 16Consider the following data in the Employees table: (last_name, commission_pct, manager_id) DATA: King, null, null Kochhar, null, 100 Vargas, null, 124 Zlotkey, .2, 100 What is the result of the following statement: SELECT last_name, COALESCE(commission_pct, manager_id, -1) comm FROM employees ; a) King, null Kochhar, 100 Vargas, 124 Zlotkey, .2 b) King, -1 Kochhar, 100 Vargas, 124 Zlotkey, .2 c) Statement will fail d) King, -1 Kochhar, 100 Vargas, 124 Zlotkey, 100b) King, -1
    Kochhar, 100
    Vargas, 124
    Zlotkey, .2
    (*)
  17. 17You need to replace null values in the DEPT_ID column with the text N/A. Which functions should you use? a) TO_NUMBER and NULLIF b) TO_CHAR and NULLIF c) TO_CHAR and NULL d) TO_CHAR and NVLd) TO_CHAR and NVL (*)
  18. 18All Human Resources data is stored in a table named EMPLOYEES. You have been asked to create a report that displays each employee's name and salary. Each employee's salary must be displayed in the following format: $000,000.00. Which function should you include in a SELECT statement to achieve the desired result? a) TO_DATE b) TO_CHAR c) TO_NUMBER d) CHARTOROWIDb) TO_CHAR (*)
  19. 19The EMPLOYEES table contains these columns: EMPLOYEE_ID NUMBER(9) LAST_NAME VARCHAR2 (25) FIRST_NAME VARCHAR2 (25) HIRE_DATE DATE You need to display HIRE_DATE values in this format: January 28, 2000 Which SQL statement could you use? a) SELECT TO_CHAR(hire_date, 'Month DD', ' YYYY') FROM employees; b) SELECT TO_CHAR(hire_date, 'Month DD, YYYY') FROM employees; c) SELECT hire_date(TO_CHAR 'Month DD', ' YYYY') FROM employees; d) SELECT TO_CHAR(hire_date, Month DD, YYYY) FROM employees;b) SELECT TO_CHAR(hire_date, 'Month DD, YYYY') FROM employees;
  20. 20A table has the following definition: EMPLOYEES( EMPLOYEE_ID NUMBER(6) NOT NULL, NAME VARCHAR2(20) NOT NULL, MANAGER_ID VARCHAR2(6)) and contains the following rows: (1001, 'Bob Bevan', '200') (200, 'Natacha Hansen', null) Will the following query work? SELECT * FROM employees WHERE employee_id = manager_id; a) Yes, Oracle will perform implicit dataype conversion, and the query will return one row of data. b) No, because the datatypes of EMPLOYEE_ID and MANAGER_ID are different. c) Yes, Oracle will perform implicit datatype conversion, but the WHERE clause will not find any matching data. d) No. You will have to re-wirte the statement and perform explicit datatype conversion.c) Yes, Oracle will perform implicit datatype conversion, but the WHERE clause will not find any matching data. (*)
  21. 21Which statement is true about SQL functions? a) Functions can convert values or text to another data type. b) Functions can round a number to a specified decimal place. c) Functions can convert upper case characters to lower case characters. d) a, b and c are true. e) None of the above statements are true.d) a, b and c are true. (*)
  22. 22The following script will run successfully. True or False? SELECT TO_CHAR(TO_DATE('25-Dec-2004','dd-Mon-yyyy')) FROM dual a) True b) Falsea) True (*)
  23. 23Which three statements concerning explicit data type conversions are true? (Choose three.) a) Use the TO_NUMBER function to convert a character string of digits to a number. b) Use the TO_CHAR function to convert a number or date value to a character string. c) Use the TO_DATE function to convert a character string to a date value. d) Use the TO_DATE function to convert a date value to a character string or number. e) Use the TO_NUMBER function to convert a number to a character string.a) Use the TO_NUMBER function to convert a character string of digits to a number. (*)
    b) Use the TO_CHAR function to convert a number or date value to a character string. (*)
    c) Use the TO_DATE function to convert a character string to a date value. (*)
  24. 24The following statement returns 0 (zero). True or False? SELECT 121/NULL FROM dual; a) True b) Falseb) False (*)
  25. 25When executed, which statement displays a zero if the TUITION_BALANCE value is zero and the HOUSING_BALANCE value is null? a) SELECT tuition_balance + housing_balance FROM student_accounts; b) SELECT NVL(tuition_balance, 0), NVL (housing_balance), tuition_balance + housing_balance "Balance Due" FROM student_accounts; c) SELECT TO_NUMBER(tuition_balance, 0), TO_NUMBER (housing_balance, 0), tutition_balance + housing_balance "Balance Due" FROM student_accounts; d) SELECT NVL (tuition_balance + housing_balance, 0) "Balance Due" FROM student_accounts;d) SELECT NVL (tuition_balance + housing_balance, 0) "Balance Due"
    FROM student_accounts;
    (*)
  26. 26You need to replace null values in the DEPT_ID column with the text N/A. Which functions should you use? a) TO_NUMBER and NULLIF b) TO_CHAR and NULLIF c) TO_CHAR and NULL d) TO_CHAR and NVLd) TO_CHAR and NVL
  27. 27Which statement about group functions is true? a) NVL and COALESCE, but not NVL2, can be used with group functions to replace null values. b) NVL and NVL2, but not COALESCE, can be used with group functions to replace null values. c) NVL, NVL2, and COALESCE can be used with group functions to replace null values. d) COALESCE, but not NVL and NVL2, can be used with group functions to replace null values.c) NVL, NVL2, and COALESCE can be used with group functions to replace null values. (*)
  28. 28Which statement will return a listing of last names, salaries, and a rating of 'Low', 'Medium', 'Good' or 'Excellent' depending on the salary value? a) SELECT last_name,salary, (CASE WHEN salary<5000 o:p="" ow="" then=""> WHEN salary<10000 edium="" o:p="" then=""> WHEN salary<20000 o:p="" ood="" then=""> ELSE 'Excellent' END) qualified_salary FROM employees; b) SELECT last_name,sal, (CASE WHEN sal<5000 o:p="" ow="" then=""> WHEN sal<10000 edium="" o:p="" then=""> WHEN sal<20000 o:p="" ood="" then=""> ELSE 'Excellent' END) qualified_salary FROM employees; c) SELECT last_name,salary, (RATING WHEN salary<5000 o:p="" ow="" then=""> WHEN salary<10000 edium="" o:p="" then=""> WHEN salary<20000 o:p="" ood="" then=""> ELSE 'Excellent' END) qualified_salary FROM employees; d) SELECT last_name,salary, (CASE WHEN salary<5000 o:p="" ow="" then=""> WHEN sal <10000 edium="" o:p="" then=""> WHEN sal <20000 o:p="" ood="" then=""> ELSE 'Excellenta) SELECT last_name,salary,
    (CASE WHEN salary<5000 o:p="" ow="" then="">
    WHEN salary<10000 edium="" o:p="" then="">
    WHEN salary<20000 o:p="" ood="" then="">
    ELSE 'Excellent'
    END) qualified_salary
    FROM employees;
  29. 29Which of the following is a conditional expression used in SQL? a) CASE b) NULLIF c) DESCRIBE d) WHEREa) CASE (*)
  30. 301. Sysdate is 12-May-2004. You need to store the following date: 7-Dec-89 Which statement about the date format for this value is true? Mark for Review (1) Points a) The RR date format will interpret the year as 1989, and the YY date format will interpret the year as 2089 b) Both the YY and RR date formats will interpret the year as 2089 c) The RR date format will interpret the year as 2089, and the YY date format will interpret the year as 1989 d) Both the YY and RR date formats will interpret the year as 1989a) The RR date format will interpret the year as 1989, and the YY date format will interpret the year as 2089 (*)
  31. 31Which functions allow you to perform explicit data type conversions? a) TO_CHAR, TO_DATE, TO_NUMBER b) LENGTH, SUBSTR, LPAD, TRIM c) NVL, NVL2, NULLIF d) ROUND, TRUNC, ADD_MONTHSa) TO_CHAR, TO_DATE, TO_NUMBER
  32. 32Which statement will return the salary (for example, the salary of 6000) from the Employees table in the following format? $6000.00 a) SELECT TO_CHAR(sal, '$99999.00') SALARY FROM employees b) SELECT TO_CHAR(salary, '$99999') SALARY FROM employees c) SELECT TO_CHAR(salary, '99999.00') SALARY FROM employees d) SELECT TO_CHAR(salary, '$99999.00') SALARY FROM employeesd) SELECT TO_CHAR(salary, '$99999.00') SALARY
    FROM employees
    (*)
  33. 33The EMPLOYEES table contains these columns: EMPLOYEE_ID NUMBER(9) LAST_NAME VARCHAR2 (25) FIRST_NAME VARCHAR2 (25) HIRE_DATE DATE You need to display HIRE_DATE values in this format: January 28, 2000 Which SQL statement could you use? a) SELECT TO_CHAR(hire_date, Month DD, YYYY) FROM employees; b) SELECT TO_CHAR(hire_date, 'Month DD', ' YYYY') FROM employees; c) SELECT TO_CHAR(hire_date, 'Month DD, YYYY') FROM employees; d) SELECT hire_date(TO_CHAR 'Month DD', ' YYYY') FROM employees;c) SELECT TO_CHAR(hire_date, 'Month DD, YYYY') FROM employees;
  34. 34Which three statements concerning explicit data type conversions are true? a) Use the TO_DATE function to convert a character string to a date value. b) Use the TO_CHAR function to convert a number or date value to a character string. c) Use the TO_DATE function to convert a date value to a character string or number. d) Use the TO_NUMBER function to convert a character string of digits to a number. e) Use the TO_NUMBER function to convert a number to a character string.a) Use the TO_DATE function to convert a character string to a date value. (*)
    b) Use the TO_CHAR function to convert a number or date value to a character string. (*)
    d) Use the TO_NUMBER function to convert a character string of digits to a number. (*)
  35. 35Which statement about group functions is true? Mark for Review (1) Points a) NVL and NVL2, but not COALESCE, can be used with group functions to replace null values. b) COALESCE, but not NVL and NVL2, can be used with group functions to replace null values. c) NVL and COALESCE, but not NVL2, can be used with group functions to replace null values. d) NVL, NVL2, and COALESCE can be used with group functions to replace null values.d) NVL, NVL2, and COALESCE can be used with group functions to replace null values. (*)
  36. 36Which number function may be used to determine if a value is odd or even? a) TRUNC b) MOD c) ROUND d) BINARYb) MOD (*)
  37. 37What is the result of the following SQL Statement: SELECT ROUND(45.923,-1) FROM DUAL; a) 46 b) 45.9 c) 50 d) None of the abovec) 50 (*)
  38. 38Which two functions can be used to manipulate number or date column values, but NOT character column values? (Choose two.) a) CONCAT b) INSTR c) ROUND d) RPAD e) TRUNCc) ROUND (*)
    e) TRUNC (*)
  39. 39Evaluate this function: MOD (25, 2) Which value is returned? a) 0 b) 25 c) 1 d) 2c) 1
  40. 40Which script displays '01-May-2004' when the HIRE_DATE value is '20-May-2004'? a) SELECT ROUND(hire_date, 'MON') FROM employees; b) SELECT ROUND(hire_date, 'MONTH') FROM employees; c) SELECT TRUNC(hire_date, 'MI') FROM employees; d) SELECT TRUNC(hire_date, 'MONTH') FROM employees;d) SELECT TRUNC(hire_date, 'MONTH')
    FROM employees;
    (*)
  41. 41You need to display the current year as a character value (for example: Two Thousand and One). Which element would you use? a) YY b) YYYY c) RR d) YEARd) YEAR (*)
  42. 42What is the result of the following query? SELECT ADD_YEARS ('11-Jan-1994',6) FROM dual; a) 11-Jul-1995 b) 11-Jan-2000 c) This in not a valid SQL statement. d) 11-Jul-2000c) This in not a valid SQL statement. (*)
  43. 43You need to display the number of months between today's date and each employee's hiredate. Which function should you use? a) ROUND b) ADD_MONTHS c) BETWEEN d) MONTHS_BETWEENd) MONTHS_BETWEEN
  44. 44Which query would return a whole number if the sysdate is 26-May-2004? a) SELECT TRUNC(MONTHS_BETWEEN(SYSDATE,'19-Mar-1979') /12) AS YEARS FROM DUAL; b) SELECT TRUNC(YEARS_BETWEEN(SYSDATE,'19-Mar-1979') /12) AS YEARS FROM DUAL; c) SELECT MONTHS_BETWEEN(SYSDATE,'19-Mar-1979') /12 AS YEARS FROM DUAL; d) None of the abovea) SELECT TRUNC(MONTHS_BETWEEN(SYSDATE,'19-Mar-1979') /12)
    AS YEARS
    FROM DUAL;
  45. 45Which SELECT statement will NOT return a date value? a) SELECT (hire_date - SYSDATE) + TO_DATE('25-Jun-2002') FROM employees; b) SELECT (30 + hire_date) + 1440/24 FROM employees; c) SELECT SYSDATE - TO_DATE('25-Jun-2002') + hire_date FROM employees; d) SELECT (SYSDATE - hire_date) + 10*8 FROM employees;d) SELECT (SYSDATE - hire_date) + 10*8
    FROM employees;
  46. 46You need to display each employee's name in all uppercase letters. Which function should you use? a) CASE b) TOUPPER c) UCASE d) UPPERd) UPPER
  47. 47The STYLES table contains this data: STYLE_ID STYLE_NAME CATEGORY COST 895840 SANDAL 85940 12.00 968950 SANDAL 85909 10.00 869506 SANDAL 89690 15.00 809090 LOAFER 89098 10.00 890890 LOAFER 89789 14.00 857689 HEEL 85940 11.00 758960 SANDAL 86979 12.00 You query the database and return the value 79. Which script did you use? a) SELECT SUBSTR(category, -2,2) WHERE style_id = 758960; b) SELECT SUBSTR(category, 2,2) FROM styles WHERE style_id = 895840; c) SELECT INSTR(category, 2,2) FROM styles WHERE style_id = 895840; d) SELECT INSTR(category, -2,2) FROM styles WHERE style_id = 895840;a) SELECT SUBSTR(category, -2,2)
    WHERE style_id = 758960;
  48. 48What does the following SQL SELECT statement return? SELECT UPPER( SUBSTR('Database Programming', INSTR('Database Programming','P'),20)) FROM dual; a) Programming b) Database c) PROGRAMMING d) DATABASEc) PROGRAMMING
  49. 49You issue this SQL statement: SELECT INSTR ('organizational sales', 'al') FROM dual; Which value is returned by this command? a) 1 b) 2 c) 17 d) 13d) 13
  50. 50Which of the following are types of SQL functions? (Choose two correct answers.) a) Column-Row Functions b) Multi-Row Functions c) Single-Row Functions d) Many-to-Many Functionsb) Multi-Row Functions (*)
    c) Single-Row Functions (*)
  51. 51The answer to the following script is 456. True or False? SELECT TRUNC(ROUND(456.98)) FROM dual; a) True b) Falseb) False
  52. 52You issue this SQL statement: SELECT ROUND (1282.248, -2) FROM dual; What value does this statement produce? a) 1200 b) 1300 c) 1282.25 d) 1282b) 1300
  53. 53You issue this SQL statement: SELECT TRUNC(751.367,-1) FROM dual; Which value does this statement display? a) 700 b) 750 c) 751.3 d) 751b) 750
  54. 54What is the result of the following SQL Statement: SELECT ROUND(45.923,-1) FROM DUAL; a) 46 b) 45.9 c) 50 d) None of the abovec) 50
  55. 55Which number function may be used to determine if a value is odd or even? a) BINARY b) MOD c) TRUNC d) ROUNDb) MOD
  56. 56If hire_date has a value of '03-Jul-2003', then what is the output from this code? SELECT ROUND(hire_date, 'Year') FROM employees; a) 01-Jul-2003 b) 01-Jan-2003 c) 01-Jan-2004 d) 01-Aug-2003c) 01-Jan-2004
  57. 57Which SELECT statement will return a numeric value? a) SELECT ROUND(hire_date, DAY) FROM employees; b) SELECT (SYSDATE - hire_date) / 7 FROM employees; c) SELECT SYSDATE + 600 / 24 FROM employees; d) SELECT SYSDATE - 7 FROM employees;b) SELECT (SYSDATE - hire_date) / 7 FROM employees;
  58. 58Which query would return a whole number if the sysdate is 26-May-2004? a) None of the below b) SELECT TRUNC(MONTHS_BETWEEN(SYSDATE,'19-Mar-1979') /12) AS YEARS FROM DUAL; c) SELECT TRUNC(YEARS_BETWEEN(SYSDATE,'19-Mar-1979') /12) AS YEARS FROM DUAL; d) SELECT MONTHS_BETWEEN(SYSDATE,'19-Mar-1979') /12 AS YEARS FROM DUAL;b) SELECT TRUNC(MONTHS_BETWEEN(SYSDATE,'19-Mar-1979') /12)
    AS YEARS
    FROM DUAL;
  59. 59You need to subtract three months from the current date. Which function should you use? a) ROUND b) MONTHS_BETWEEN c) ADD_MONTHS d) TO_DATEc) ADD_MONTHS
  60. 60What is the result of the following query? SELECT ADD_MONTHS ('11-Jan-1994',6) FROM dual; a) 17-Jul-1994 b) 11-Jul-1994 c) 17-Jan-1994 d) 11-Jan-1995b) 11-Jul-1994 (*)
  61. 61You need to display the number of characters in each customer's last name. Which function should you use? a) SUBSTR b) COUNT c) LENGTH d) LPADc) LENGTH
  62. 62Identify the output from the following SQL statement: SELECT RPAD('SQL',6, '*') FROM DUAL; a) SQL*** b) ******SQL c) ***SQL d) SQL******a) SQL*** (*)
    Pads up to 6 characters.
    * is used as padding character
  63. 63The EMPLOYEES table contains these columns: LAST_NAME VARCHAR2(20) FIRST_NAME VARCHAR2(20) HIRE_DATE DATE EVAL_MONTHS NUMBER(3) Evaluate this SELECT statement: SELECT hire_date + eval_months FROM employees; The values returned by this SELECT statement will be of which data type? a) DATE b) INTEGER c) NUMBER d) DATETIMEa) DATE (*)
  64. 64What is the result of the following query? SELECT ADD_YEARS ('11-Jan-1994',6) FROM dual; a) 11-Jul-2000 b) 11-Jan-2000 c) This in not a valid SQL statement. d) 11-Jul-1995c) This in not a valid SQL statement.
  65. 65What is the result of the following query? SELECT ADD_MONTHS ('11-Jan-1994',6) FROM dual; a) 11-Jan-1995 b) 11-Jul-1994 c) 17-Jan-1994 d) 17-Jul-1994b) 11-Jul-1994 (*)
  66. 66Which script displays '01-May-2004' when the HIRE_DATE value is '20-May-2004'? a) SELECT ROUND(hire_date, 'MONTH') FROM employees; b) SELECT ROUND(hire_date, 'MON') FROM employees; c) SELECT TRUNC(hire_date, 'MI') FROM employees; d) SELECT TRUNC(hire_date, 'MONTH') FROM employees;d) SELECT TRUNC(hire_date, 'MONTH')
    FROM employees;
  67. 67Which comparison operator retrieves a list of values? a) IS NULL b) BETWEEN IN c) LIKE d) INd) IN (*)
  68. 68Which SQL function is used to return the position where a specific character string begins within a larger character string? a) INSTR b) SUBSTR c) CONCAT d) LENGTHa) INSTR
  69. 69You query the database with this SQL statement: SELECT CONCAT(last_name, (SUBSTR(LOWER(first_name), 4))) "Default Password" FROM employees; Which function will be evaluated first? a) CONCAT b) SUBSTR c) LOWER d) All three will be evaluated simultaneously.c) LOWER (*)
  70. 70An entity can only have one Primary UID. True or False? a) True b) Falsea) True
  71. 71If an entity has no attribute suitable to be a Primary UID, we can create an artificial one. True or False? a) True b) Falsea) True (*)
  72. 72There is no limit to how many columns can make up an entity's UID. True or False? a) True b) Falsea) True (*)
  73. 73A unique identifier can only be made up of one attribute. True or False? a) True b) Falseb) False (*)
  74. 74When is an entity in 2nd Normal Form? a) When all non-UID attributes are dependent upon the entire UID. b) When attributes with repeating or multi-values are present. c) When no attributes are mutually independent and all are fully dependent on the primary key. d) None of the Above.a) When all non-UID attributes are dependent upon the entire UID. (*)
  75. 75What is the rule of Second Normal Form? a) No non-UID attributes can be dependent on any part of the UID. b) Some non-UID attributes can be dependent on the entire UID. c) All non-UID attributes must be dependent upon the entire UID. d) None of the abovec) All non-UID attributes must be dependent upon the entire UID. (*)
  76. 76Examine the following entity and decide how to make it conform to the rule of 2nd Normal Form: ENTITY: RECEIPT ATTRIBUTES: #CUSTOMER ID #STORE ID STORE LOCATION DATE a) Do nothing, it is already in 2nd Normal Form. b) Delete the attribute STORE ID c) Move the attribute STORE LOCATION to a new entity, STORE, with a UID of STORE ID, and create a relationship to the original entity. d) Move the attribute STORE LOCATION to a new entity, STORE, with a UID of STORE LOCATION, and create a relationship to the original entity.c) Move the attribute STORE LOCATION to a new entity, STORE, with a UID of STORE ID, and create a relationship to the original entity. (*)
  77. 77When any attribute in an entity is dependent on any other non-UID attribute in that entity, this is known as: a) Dependency b) Functional dependency c) Non-dependency d) Transitive dependencyd) Transitive dependency (*)
  78. 78Examine the following Entity and decide which rule of Normal Form is being violated: ENTITY: CLIENT ATTRIBUTES: # CLIENT ID FIRST NAME LAST NAME ORDER ID STREET ZIP CODE a) 1st Normal Form. b) 2nd Normal Form. c) 3rd Normal Form. d) None of the above, the entity is fully normalised.a) 1st Normal Form. (*)
  79. 79As a database designer, you do not need to worry about where in the datamodel you store a particular attribute; as long as you get it onto the ERD, your job is done. True or False? a) True b) Falseb) False (*)
  80. 80Examine the following Entity and decide which rule of Normal Form is being violated: ENTITY: CLIENT ATTRIBUTES: # CLIENT ID FIRST NAME LAST NAME STREET CITY ZIP CODE a)1st Normal Form. b) 2nd Normal Form. c) 3rd Normal Form. d) None of the above, the entity is fully normalised.d) None of the above, the entity is fully normalised.
  81. 81When data is stored in more than one place in a database, the database violates the rules of ___________. a) Normalcy b) Replication c) Normalization d) Decencyc) Normalization
  82. 82If an entity has a multi-valued attribute, to conform to the rule of 1st Normal Form we: a) Make the attribute optional b) Do nothing, an entity does not have to be in 1st Normal Form c) Create an additional entity and relate it to the original entity with a 1:M relationship. d) Create an additional entity and relate it to the original entity with a M:M relationship.c) Create an additional entity and relate it to the original entity with a 1:M relationship.
  83. 83An entity ORDER has the attributes Order ID, Order Date, Product id, Customer ID. This entity is in 1st Normal Form. True or False? a) True b) Falseb) False
  84. 84An entity can have repeated values and still be in 1st Normal Form. True or False? a) True b) Falseb) False
  85. 85Cascading UIDs are a feature often found in what type of Relationship? a) Invalid Relationship b) General Relationship c) Heirarchical Relationship d) Recursive Relationshipc) Heirarchical Relationship (*)
  86. 86A relationship between an entity and itself is called a/an: a) General Relationship b) Recursive Relationship c) Hierarchical Relationship d) Invalid Relationshipb) Recursive Relationship
  87. 87A single relationship can be both Recursive and Hierarchical at the same time. True or False? a) True b) Falseb) False (*)
  88. 88A Hierarchical relationship is a series of relationships that reflect entities organized into successive levels. True or False? a) True d) Falsea) True
  89. 89A particular problem may be solved using either a Recursive Relationship or a Hierarchical Relationship, though not at the same time. True or False? a) True b) Falsea) True
  90. 90Which of the following would best be represented by an arc? a) STUDENT (Grade A student, Average Student) b) PARENT (Girl, Bob) c) TEACHER (Female, Bob) d) DELIVERY ADDRESS (Home, Office)d) DELIVERY ADDRESS (Home, Office) (*)
  91. 91Arcs are used to visually represent _________ between two or more relationships in an ERD. a) Sameness b) Differences c) Exclusivity d) Inheritancec) Exclusivity
  92. 92An arc can often be modeled as Supertype and Subtypes. True or False? a) True b) Falsea) True (*)
  93. 93Which of the following would best be represented by an arc? a) STUDENT (Grade A student, Average Student) b) STUDENT (senior, male) c) STUDENT ( University, Technical College) d) STUDENT (graduating, female)c) STUDENT ( University, Technical College)
  94. 94Which of the following would be a logical constraint when modeling time for a country entity? a) Daily traffic patterns must be monitored to determine which countries are overcrowded. b) People have births and deaths in their countries that must be tracked by the system. c) If you are doing a system for France or Germany, you would need security clearance. d) Countries may change their names and/or borders over a period of time.d) Countries may change their names and/or borders over a period of time. (*)
  95. 95All systems must include functionality to provide logging or journaling in conceptual data models. True or False? a) True d) Falsed) False (*)
  96. 96When a system requires that old values for attributes are kept on record, this is know as Journaling or Logging. True or False? a) True b) Falsea) True
  97. 97There is no point in trying to group your entities together on your diagram according to volume, and making a diagram look nice is a waste of time. True or False? a) True b) Falseb) False
  98. 98Formal rules exist for drawing ERD's. You must always follow them, even if it results in an ERD that is difficult to read. True or False? a) True b) Falseb) False
  99. 99Which of the following scenarios should be modeled so that historical data is kept? (Choose two) a) LIBRARY and NUMBER OF BOOKS b) STUDENT and GRADE c) STUDENT and AGE d) LIBRARY and BOOKb) STUDENT and GRADE
    d) LIBRARY and BOOK
  100. 100Historical data must never be kept. True or False? a) True b) Falseb) False
  101. 101The explanation below is an example of which constraint type? A primary key must be unique, and no part of the primary key can be null. a) Referential integrity b) Column integrity c) Entity integrity d) User-defined integrityc) Entity integrity
  102. 102Foreign keys cannot be null when a) It refers to the same table b) It is part of a primary key c) It refers to another table d) It contains three or more columnsb) It is part of a primary key
  103. 103The explanation below is an example of which constraint type? If the value in the balance column of the ACCOUNTS table is below 100, we must send a letter to the account owner which will require extra programming to enforce. a) User-defined integrity b) Entity integrity c) Column integrity d) Referential integritya) User-defined integrity
  104. 104A foreign key cannot refer to a primary key in the same table. True or False? a) True b) Falseb) False
  105. 105Column integrity refers to a) Columns always containing text data less than 255 characters b) Columns always containing values consistent with the defined data format c) Columns always having values d) Columns always containing positive numbersb) Columns always containing values consistent with the defined data format
  106. 106When an Arc is transformed to the physical model every relationship in the Arc becomes a mandatory Foreign Key. True or False? a) True b) Falseb) False
  107. 107One-to-Many Optional to Mandatory becomes a _______________ on the Master table. a) Unique Key b) Optional Foreign Key c) Mandatory Foreign Key d) Primary Keyb) Optional Foreign Key
  108. 108A barred Relationship will result in a Foreign Key column that also is part of: a) The Column Name b) The Check Constraint c) The Table Name d) The Primary KeyThe Primary Key (*)
  109. 109Relationships on an ERD can only be transformed into UIDs in the physical model? True or False? a) True b) Falseb) False
  110. 110One-to-One relationships are transformed into Check Constraints in the tables created at either end of that relationship. True or False? a) True b) Falseb) False
  111. 111The "Arc Implementation" is a synonym for what type of implementation? a) Cascade Implementation b) Supertype Implementation c) Subtype Implementation d) Supertype and Subtype Implementationd) Supertype and Subtype Implementation
  112. 112When mapping supertypes, relationships at the supertype level transform as usual. Relationships at the subtype level are implemented as foreign keys, but the foreign key columns all become optional. True or False? a) True b) Falsea) True
  113. 113The transformation from an ER diagram to a physical design involves changing terminology. Entities in the ER diagram become __________ : a) Columns b) Tables c) Foreign Keys d) Unique Keysb) Tables
  114. 114The conceptual model is transformed into a physical model. The physical implementation will be a relational database. True or False? a) True b) Falsea) True (*)
  115. 115In an Oracle database, why would 1_TABLE not work as a table name? a) There is no problem here. You can create a table called 1_TABLE. b) Object names must not start with a number. They must begin with a letter. c) TABLE is a reserved word. d) The database does not understand all capital letters.b) Object names must not start with a number. They must begin with a letter.
  116. 116In an Oracle database, why would the following table name not be allowed 'EMPLOYEE JOBS'? a) JOBS is a reserved word b) The database does not understand all capital letters c) You cannot have spaces between words in a table name d) EMPLOYEE is a reserved wordc) You cannot have spaces between words in a table name
  117. 117In which phases of the System Development Life Cycle will we need to use SQL as a language? (Choose Two) a) Build and Document b) Analysis c) Transition d) Strategya) Build and Document
    c) Transition
  118. 118During which phases of the System Development Life Cycle would you roll out the system to the users? a) Build and Transition b) Design and Production c) Strategy and Analysis d) Transition and Productiond) Transition and Production
  119. 119When translating an arc relationship to a physical design, you must turn the arc relationships into foreign keys. What additional step must you take with the created foreign keys to ensure the exclusivity principle of arc relationships? (Assume that you are implementing an Exclusive Design) (Choose Two) a) Make all relationships mandatory b) Make all relationships optional c) Create an additional check constraint to verify that one foreign key is populated and the others are not d) All the aboveb) Make all relationships optional
    c) Create an additional check constraint to verify that one foreign key is populated and the others are not
  120. 120Which of the following is a valid reason for considering a Subtype Implementation? Mark for Review (1) Points a) The common access paths for the supertypes are different. b) The resulting table will reside in a single database and be used by just ONE user. c) Business functionality, business rules, access paths, and frequency of access are all very different between the subtypes. d) Most of the relationships are at the supertype level.c) Business functionality, business rules, access paths, and frequency of access are all very different between the subtypes.
  121. 121When mapping supertypes, relationships at the supertype level transform as usual. Relationships at subtype level are implemented as foreign keys, but the foreign key columns all become mandatory. True or False? a) True d) Falsed) False
  122. 122Why would this table name NOT work in an Oracle database? this_year_end+next_year a) Table names must begin with an alphabetic character. b) It is too long. c) The Plus sign + is not allowed in object names. d) None of the above.c) The Plus sign + is not allowed in object names.
  123. 123In a physical data model, an attribute becomes a _____________. a) Constraint b) Table c) Foreign Key d) Columnd) Column
  124. 124To resolve a many to many relationship in a physical model you create a(n) ___________________? a) Unique key constraints b) Intersection entity c) Intersection table d) Two tables with Foreign key constraints between themc) Intersection table
  125. 125The Oracle Database can implement a many to many relationship. You simply create two foreign keys between the two tables. True or False? a) True b) Falseb) False
  126. 126A barred Relationship will result in a Foreign Key column that also is part of: a) The Primary Key b) The Column Name c) The Check Constraint d) The Table Namea) The Primary Key
  127. 127Column integrity refers to a) Columns always containing positive numbers b) Columns always containing values consistent with the defined data format c) Columns always containing text data less than 255 characters d) Columns always having valuesb) Columns always containing values consistent with the defined data format
  128. 128The explanation below is an example of which constraint type? A column must contain only values consistent with the defined data format of the column a) Column integrity b) User-defined integrity c) Referential integrity d) Entity integritya) Column integrity
  129. 129Identify all of the incorrect statements that complete this sentence: A primary key is...(Choose three) a) Only one column that must be null. b) A single column that uniquely identifies each column in a table. c) One or more columns in a table that uniquely identifies each row in that table. d) A set of columns in one table that uniquely identifies each row in another table.a) Only one column that must be null. (*)
    b) A single column that uniquely identifies each column in a table. (*)
  130. 130Identify all of the correct statements that complete this sentence: A primary key is: (Choose Three) a) Only one column that cannot be null b) A set of columns and keys in a single table that uniquely identifies each row in a single table c) identifies each row in a table d) A set of columns that uniquely identifies each row in a tableb) A set of columns and keys in a single table that uniquely identifies each row in a single table (*)
    c) identifies each row in a table (*)
    d) A set of columns that uniquely identifies each row in a table
  131. 131Foreign keys cannot be null when a) It refers to another table b) It is part of a primary key c) It contains three or more columns d) It refers to the same tableb) It is part of a primary key (*)
  132. 132When mapping supertypes, relationships at the supertype level transform as usual. Relationships at subtype level are implemented as foreign keys, but the foreign key columns all become mandatory. True or False? a) True b) Falseb) False
  133. 133When mapping supertypes, relationships at the supertype level transform as usual. Relationships at the subtype level are implemented as foreign keys, but the foreign key columns all become optional. True or False? a) True b) Falsea) True (*)
  134. 134The Physical model is created by transforming which of the following models? a) Constraint b) Table c) Physical d) Conceptuald) Conceptual
  135. 135Attributes become columns in a database table. True or False? a) True b) Falsea) True
  136. 136Relationships on an ERD can only be transformed into UIDs in the physical model? True or False? a) True b) Falseb) False
  137. 137An Arc is transformed to the physical model by adding a foreign Key for every relationship in the Arc. True or False? a) True b) Falsea) True
  138. 138One-to-One relationships are transformed into Check Constraints in the tables created at either end of that relationship. True or False? a) True b) Falseb) False
  139. 139One-to-One relationships are transformed into Foreign Keys in the tables created at either end of that relationship. True or False? a) True b) Falseb) False
  140. 140Which of the following is a valid reason for considering a Subtype Implementation? a) The common access paths for the supertypes are different. b) Business functionality, business rules, access paths, and frequency of access are all very different between the subtypes. c) Most of the relationships are at the supertype level. d) The resulting table will reside in a single database and be used by just ONE user.b) Business functionality, business rules, access paths, and frequency of access are all very different between the subtypes.
  141. 141The conceptual model is transformed into a physical model. The physical implementation will be a relational database. True or False? a) True b) Falsea) True (*)
  142. 142Which of the following is a valid reason for considering a Subtype Implementation? a) The resulting table will reside in a single database and be used by just ONE user. b) The common access paths for the supertypes are different. c) Most of the relationships are at the supertype level. d) Business functionality, business rules, access paths, and frequency of access are all very different between the subtypes.d) Business functionality, business rules, access paths, and frequency of access are all very different between the subtypes.
  143. 143An "Arc Implementation" can be done just like any other Relationship - you simply add the required Foreign Keys. True or False? a) True b) Falseb) False
  144. 144One-to-One relationships are transformed into Check Constraints in the tables created at either end of that relationship. True or False? a) True b) Falseb) False (*)
  145. 145The explanation below is an example of which constraint type? The value in the dept_no column of the EMPLOYEES table must match a value in the dept_no column in the DEPARTMENTS table. a) Referential integrity b) Column integrity c) User-defined integrity d) Entity integritya) Referential integrity (*)
  146. 146A barred Relationship will result in a Foreign Key column that also is part of: a) The Check Constraint b) The Column Name c) The Primary Key d) The Table Namec) The Primary Key
  147. 147Attributes become columns in a database table. True or False? a) True b) Falsea) True
  148. 148Which of the following scenarios should be modeled so that historical data is kept? (Choose two) a) BABY and AGE b) CUSTOMER and ORDERS c) TEACHER and AGE d) CUSTOMER and PAYMENTSb) CUSTOMER and ORDERS (*)
    d) CUSTOMER and PAYMENTS (*)
  149. 149When modeling historical data the unique identifier is always made up of a barred relationship from the original two entities. True or False? a) True b) Falseb) False
  150. 150Which of the following scenarios should be modeled so that historical data is kept? (Choose two) a) LIBRARY and BOOK b) STUDENT and GRADE c) STUDENT and AGE d) LIBRARY and NUMBER OF BOOKSa) LIBRARY and BOOK (*)
    b) STUDENT and GRADE (*)
  151. 151Which of the following statements are true for ERD's to enhance their readability. (Choose Two) a) You must ensure that you have every single entity--even if hundreds of them exist--on one single, big diagram. b) The crows feet (many ends) can point whichever way is the easiest to draw. c) Avoid crossing one relationship line with another. d) It is OK to break down a large ERD into subsets of the overall picture. By doing so, you end up with more than one ERD that, taken together, documents the entire system.c) Avoid crossing one relationship line with another. (*)
    d) It is OK to break down a large ERD into subsets of the overall picture. By doing so, you end up with more than one ERD that, taken together, documents the entire system. (*)
  152. 152No formal rules exist for drawing ERD's. The most important thing is to make sure that all entities, attributes, and relationships are documented on the diagram, and the diagram is clear and readable. True or False? a) True b) Falsea) True
  153. 153You must make sure all entities of a proposed system can fit onto one diagram. It is not allowed to break up a data model into more than one diagram. True or False? a) True b) Falseb) False
  154. 154. Formal rules exist for drawing ERD's. You must always follow them, even if it results in an ERD that is difficult to read. True or False? a) True b) Falseb) False
  155. 155All systems must include functionality to provide logging or journaling in conceptual data models. True or False? a) True b) Falseb) False
  156. 156Which of the following is a logical constraint that could result from considering how time impacts an example of data storage? a) End Date must be before the Start Date. b) EMPLOYEE periods can overlap causing the database to crash. c) Dates must be stored with Time. d) An ASSIGNMENT may only refer to an EMPLOYEE with a valid employee record at the Start Date of the ASSIGNMENT.d) An ASSIGNMENT may only refer to an EMPLOYEE with a valid employee record at the Start Date of the ASSIGNMENT.
  157. 157What is the function of logging or journaling in conceptual data models? a) Represents entities as time in the data model. b) Creates a fixed time for all events in a data model. c) Gives a timestamp to all entities. d) Allows you to track the history of attribute values, relationships, and/or entire entitiesd) Allows you to track the history of attribute values, relationships, and/or entire entities
  158. 158How do you know when to use the different types of time in your design? Mark for Review (1) Points a) It depends on the functional needs of the system . b) Always model time; you can take it out later if it is not needed. c) You would first determine the existence of the concept of time and map it against the Greenwich Mean Time. d) The rules are fixed and should be followed.a) It depends on the functional needs of the system .
  159. 159Which of the following would be a logical constraint when modeling time for a country entity? a) If you are doing a system for France or Germany, you would need security clearance. b) Daily traffic patterns must be monitored to determine which countries are overcrowded. c) Countries may change their names and/or borders over a period of time. d) People have births and deaths in their countries that must be tracked by the system.c) Countries may change their names and/or borders over a period of time. (*)
  160. 160In a payroll system, it is desirable to have an entity called DAY with a holiday attribute when you want to track special holiday dates. True or False? a) True b) Falsea) True
  161. 161Modeling historical data is optional. True or False? a) True b) Falsea) True
  162. 162When a relationship may or may not be transferable, depending on time, this is know as a/an: Mark for Review (1) Points a) Transferable Relationship b) Non-transferable Relationship. c) Conditional Non-transferable Relationship. d) Arc.c) Conditional Non-transferable Relationship.
  163. 163You must make sure all entities of a proposed system can fit onto one diagram. It is not allowed to break up a data model into more than one diagram. True or False? a) True b) Falseb) False
  164. 164Which of the following statements are true for ERD's to enhance their readability. (Choose Two) a) You must ensure that you have every single entity--even if hundreds of them exist--on one single, big diagram. b) It is OK to break down a large ERD into subsets of the overall picture. By doing so, you end up with more than one ERD that, taken together, documents the entire system. c) The crows feet (many ends) can point whichever way is the easiest to draw. d)Avoid crossing one relationship line with another.b) It is OK to break down a large ERD into subsets of the overall picture. By doing so, you end up with more than one ERD that, taken together, documents the entire system.
  165. 165In an ERD, it is a good idea to group your entities according to the expected volumes. By grouping high volume entities together, the diagrams could become easier to read. True or False? a) True b) Falsea) True
  166. 166There is no point in trying to group your entities together on your diagram according to volume, and making a diagram look nice is a waste of time. True or False? a) True b) Falseb) False
  167. 167Modeling historical data can produce a unique identifier that includes a date. True or False? a) True b) Falsea) True
  168. 168When you add the concept of time to your data model, your model becomes more complex. True or False? a) True b) Falsea) True
  169. 169If you have an entity with a DATE attribute, in addition to other attributes that track date characteristics, you should create a DAY entity. True or False? a) True b) Falsea) True
  170. 170There are no circumstances where you would create a DAY entity. True or False? a) True b) Falseb) False
  171. 171You are doing a data model for a computer sales company where the price of postage depends upon the day of the week that goods are shipped. So shipping is more expensive if the customer wants a delivery to take place on a Saturday or Sunday. What would be the best way to model this? a) Email current prices to all employees whenever a price changes. b) Update the prices in the system, print out the current prices when they change, and pin them on the company noticeboard. c) Allow them to enter whatever delivery charge they want. d) Use a Delivery Day entity, which holds prices against week days, and ensure the we also have an attribute for the Requested Delivery Day in the Order Entity.d) Use a Delivery Day entity, which holds prices against week days, and ensure the we also have an attribute for the Requested Delivery Day in the Order Entity.
  172. 172Why would you want to model a time component when designing a system that lets people buy bars of gold? a) The Government of your country might want to be notified of this transaction. b) You would not want to model this; it is not important. c) The price of gold fluctuates and, to determine the current price, you need to know the time of purchase. d) Sales people must determine where the gold is coming from.c) The price of gold fluctuates and, to determine the current price, you need to know the time of purchase.
  173. 173All systems must include functionality to provide logging or journaling in conceptual data models. True or False? a) True b) Falseb) False
  174. 174All systems must have an entity called WEEK with a holiday attribute, so you know when to give your employees a holiday. True or False? a) True b) Falseb) False
  175. 175If you have an entity that a DATE attribute, and other attributes that track characteristics of the date, you should create a DAY entity. True or False? a) True b) Falsea) True
  176. 176In an ERD, High Volume Entities usually have very few relationships to other entities. True or False? a) True b) Falseb) False
  177. 177You are doing a data model for a computer sales company where the price of postage depends upon the day of the week that goods are shipped. So shipping is more expensive if the customer wants a delivery to take place on a Saturday or Sunday. What would be the best way to model this? a) Email current prices to all employees whenever a price changes. b) Update the prices in the system, print out the current prices when they change, and pin them on the company noticeboard. c) Use a Delivery Day entity, which holds prices against week days, and ensure the we also have an attribute for the Requested Delivery Day in the Order Entity. d) Allow them to enter whatever delivery charge they want.c) Use a Delivery Day entity, which holds prices against week days, and ensure the we also have an attribute for the Requested Delivery Day in the Order Entity.
  178. 178Which of the following is a logical constraint that could result from considering how time impacts an example of data storage? a) EMPLOYEE periods can overlap causing the database to crash. b) Dates must be stored with Time. c) End Date must be before the Start Date. d) An ASSIGNMENT may only refer to an EMPLOYEE with a valid employee record at the Start Date of the ASSIGNMENT.d) An ASSIGNMENT may only refer to an EMPLOYEE with a valid employee record at the Start Date of the ASSIGNMENT.
  179. 179Modeling historical data can produce a unique identifier that includes a date. True or False? a) True b) Falsea) True
  180. 180Which of the following statements are true to enhance the readability of ERDs? (Choose Two) a) Crossing relationship lines help the readability of the diagram. b) Crows feet (the many-ends of relationships) should consistently point the same direction where possible, either South & East or North & West. c) Relationship lines should not cross. d) It does not matter which way the crows feet (many ends of a relationship) point.b) Crows feet (the many-ends of relationships) should consistently point the same direction where possible, either South & East or North & West.
    c) Relationship lines should not cross.
  181. 181Modeling historical data is optional. True or False? a) True b) Falsea) True
  182. 182When modeling historical data the unique identifier is always made up of a barred relationship from the original two entities. True or False? a) True b) Falseb) False
  183. 183Arcs are Mandatory in Data modeling. All ERD's must have at least one Arc. True or False? a) True b) Falseb) False
  184. 184To visually represent exclusivity between two or more relationships in an ERD you would most likely use an ________. a) Arc b) Relationship c) Attribute d) UIDa) Arc
  185. 185An arc can often be modeled as Supertype and Subtypes. True or False? a) True b) Falsea) True
  186. 186All relationships participating in an arc must be mandatory. True or False? a) True b) Falseb) False
  187. 187Every business has restrictions on which attribute values and which relationships are allowed. These are known as: a) Constraints b) Relationships c) Entities. d) Attributesa) Constraints
  188. 188Arcs are used to visually represent _________ between two or more relationships in an ERD. a) Differences b) Inheritance c) Sameness d) Exclusivityd) Exclusivity
  189. 189Cascading UIDs are a feature often found in what type of Relationship? a) Invalid Relationship b) Recursive Relationship c) General Relationship d) Heirarchical Relationshipd) Heirarchical Relationship
  190. 190A Recursive Relationship is represented on an ERD by a/an: a) Single Toe b) Pig's Ear c) Crow's Foot d) Dog's Tailb) Pig's Ear
  191. 191A single relationship can be both Recursive and Hierarchical at the same time. True or False? a) True b) Falseb) False
  192. 192Business organizational charts are often modeled as a Hierarchical relationship. True or False? a) True b) Falsea) True
  193. 193A recursive relationship must be Mandatory at both ends. True or False? a) True b) Falseb) False
  194. 194A Hierarchical relationship is a series of relationships that reflect entities organized into successive levels. True or False? a) True b) Falsea) True
  195. 195A particular problem may be solved using either a Recursive Relationship or a Hierarchical Relationship, though not at the same time. True or False? (1) Points a) True b) Falsea) True (*)
  196. 196An arc can often be modeled as Supertype and Subtypes. True or False? a) True b) Falsea) True
  197. 197Which of the following can be added to a relationship? a) An optional attribute can be created b) A composite attribute c) An attribute d) An arc can be assignedd) An arc can be assigned
  198. 198cs are Mandatory in Data modeling. All ERD's must have at least one Arc. True or False? a) True b) Falseb) False
  199. 199Arcs model an Exclusive OR constraint. True or False? a) True b) Falsea) True
    XOR
  200. 200A logical mode includes; a) Only Entities, Attributes and UIDs b) Only Entities, Attributes and Relationships c) Only Entities, Attributes, UIDs and Relationships d) Only Entities and Relationshipsc) Only Entities, Attributes, UIDs and Relationships

Información

Descripción
Oracle SQL Fichas sobre Oracle - Practice Exam, creado por Amber Saxon el 19/02/2020.
Creado por
Amber Saxon
Visitas
14
Valoración

Escríbenos

¿Sobre qué es tu mensaje?

¿Qué te parece el nuevo diseño?

¿Te gusta?