Question
Answered

Please refer to the attachment to answer this question. This...

Please ignore the attached image. Help me with the following multiple choice questions. 1. after a database has been created, there are two ways of populating the tables - either from existing data or through the use of the user applications developed for the database. select one: True Or False 2. Given a relation R with three attributes A, B, C with the following dependencies: C -> A C -> B Assume that there is not any multivalued attribute, what is the best normal form that R satisfies (1NF, 2NF, 3NF or BCNF)? select one: a. 1NF b. 2NF c. 3NF d. BCNF 3. Which of the following is true about a relation? select one: a. there is a single attribute in each relation b. The order of the tuples of a relation is determined by the primary key. c. a relation is a one-dimensional table d. all the values in any column must be of the same type. 4. if a bank has to transfer 1,000 dollars from account A to account B, the step that increases the balance of account B by the amount of 1,000 dollars is called a transaction. True Or False 5. Which of the following is NOT true about functional dependency A -> (B,C)? select one: a. B is functionally dependent on A b. A determines C c. B and C together determine A d. B and C are functionally dependent on A 6. tblProducts table ProductID SupplierID CategoryID ProductName 1 1 1 Chai 2 1 1 Chang 3 1 2 Aniseed Syrup 4 2 2 Chef Anto's Cajun Using the tblProducts table shown above, which of the following SQL statements returns just the ProductID, CategoryID and ProductName of all the products with SupplierID of 1? select one: a. select * from tblProducts; b. select * from tblProducts where ProductID=1; c. select ProductID, CategoryID, ProductName from tblProducts where SupplierID=1; d. select ProductID=1, CategoryID, ProductName from tblProducts; 7. Look at the below SQL create command. Consider that there is only one profession which is named as "Student". Which of the following statements is wrong about this SQL create statement? CREATE TABLE USERS (NAME CHAR(20), AGE INTEGER, PROFESSION VARCHAR(30)) select one: a. Stored data for the NAME column requires more database space than stored data for the PROFESSION column. b. Table name is USERS. c. There are three columns in this table. d. CHAR (7) can also be used for the PROFESSION column. 8. Which of the following is not an element of the E-R Model? Select one: a. Use case b. Entity c. Cardinality d. Relationship 9. Considering all the other tables exist in the database, which of the following SQL statements that are used to create tables gives an error? Select one: a. Create Table Instructor( ID integer Not Null, Name varchar (40), SureName varchar (40), Primary Key (ID), Unique (ID)); b. Create Table Instructor( ID integer Not Null, Name varchar (40), SureName varchar (40), CONSTRAINT pk Primary Key (ID)); c. Create Table Instructor( ID integer Not Null, Name varchar (40), SureName varchar (40), Primary Key (ID), Foreign Key (Name)); d. Create Table Instructor( ID integer Not Null, Name varchar (40), SureName varchar (40), Primary Key (ID), Foreign Key (Name) References Departments); 10. Which of the following is wrong about domains of a relation? Select one: a. Two or more attributes can be defined on the same domain b. Two attributes that include values from different domains can easily be compared c. A tuple can draw values from different domains d. A pool of atomic values constitutes a domain 11. Which of the following SQL data types should not be used to define the numeric data: 111.11? Select one: a. integer(3,2) b. numeric(3,2) c. numeric(4,2) d. numeric(5,2) 12. Which of the following statements is wrong? Select one: a. SQL INSERT command is used to add data to a table b. A data type of Char(30) indicates a fixed-length field of 30 characters c. SQL was developed by IBM in the late 1970s d. While creating a table using SQL, specifying the NULL property for a column means that only null values can be stored in that column 13. In an E-R diagram, it is possible that an entity can have a relationship to itself. Select one: True False 14. Referential integrity constraints are concerned with checking INSERT and UPDATE operations that affect the parent child relationships. Select one: True False 15. A data model is a plan for a database design. Select one: True False 16. Which of the following statements is wrong? Select one: a. AVG() outputs the average (arithmetic mean) of the column values addressed by the query. b. MAX() outputs the maximum, the largest, column value from those that are addressed by the query. c. SUM() outputs the sum total of all the column values that are addressed by the query. This function can be used with every column. d. MIN() outputs the minimum, the smallest, column value from those that are addressed by the query. 17. Database application development is the process of obtaining real-world requirements, analyzing requirements, designing the data and functions of the system, and then implementing the operations in the system. Select one: True False 18. Which of the following is wrong? Select one: a. If A → BC, then A → B and B → C b. If A → B and B → C, then A → C c. If A → B and A → C, then A → BC d. If A → B and C is another attribute, then AC → BC 19. ODBC can be directly used with Java because it uses a C interface. Select one: True False 20. There could be static embedded SQL applications. Select one: True False

This question was created from XML Final Review PART TWO.docx

Answer & Explanation
Verified Solved by verified expert

a mole

ac,

nec

dictum

, c

m ri

ult

in

acinia

ipsu

or

ffic

a. Fusc

ultrices

ipsum do

e v

Donec a

ipis

sque dapi

molesti

trices ac magna. Fusce dui lectus, congue vel laoreet ac, dictum vitae odio. Done

Unlock full access to Course Hero

Explore over 16 million step-by-step answers from our library

Subscribe to view answer
Student reviews
56% (16 ratings)