Recent Feedback
Computers in a network communicate through ____.Answer tokens messages notes letters2 points Question 29 Data about the data in a database is known as ____.Answer backup hyperdata metadata rollback2 points Question 30 In a PC-based DBMS, as long as one program has a row or table locked, no other program may access that row or table.Answer True False2 points Question 31 Which of the following DBMS evaluation categories does the following question relate to: XXXXX XXXXX the unit that may be locked and are exclusive locks the only ones permitted?Answer Concurrent update Data recovery Data dictionary Security2 points Question 32 When a centralized database becomes unavailable for any reason, no users can continue processing. In contrast, if a local database in a distributed database becomes unavailable, only users who need that data are affected. Because of this, distributed databases have a(n) ____ advantage over a centralized database.Answer local control of data increasing database capacity system availability added efficiency2 points Question 33 Combining the following two tables would result in ____.Employee (EmployeeNum, LastName, FirstName, WageRate, SocSecNum, DepartmentNum)Employee (EmployeeNum, LastName, FirstName, Street, City, State, Zip)Answer Employee (EmployeeNum, LastName, FirstName, WageRate, SocSecNum, DepartmentNum, (Street, City, Zip) ) Employee (EmployeeNum, LastName, FirstName, WageRate, SocSecNum, DepartmentNum, Street, City, State, Zip) Employee (EmployeeNum, LastName, FirstName, Street, City State, Zip, WageRate, SocSecNum) Employee (EmployeeNum, LastName, FirstName, WageRate, SocSecNum, DepartmentNum, EmployeeNum, LastName, FirstName, Street, City, State, Zip )2 points Question 34 Because the clients and the server perform different functions and can run two different operating systems, there is an arrangement of client/server architecture known as ____.Answer single-tier architecture two-tier architecture three-tier architecture four-tier architecture2 points Question 35 When provided with a user view or some sort of stated requirement, you must develop a collection of tables that will support it.Answer True False2 points Question 36 Convert the following table to first normal form:Branch (BranchNum, BranchName, (BookCode, Title, OnHand) )Answer Branch (BranchNum, BranchName)Book (BookCode, Title) Branch (BranchNum, BranchName) Book (BookCode, Title) Branch (BranchNum, BranchName, BookCode, Title, OnHand )2 points Question 37 Additional disk and memory space are not required to store timestamp values.Answer True False2 points Question 38 Which of the following DBMS evaluation categories does the following question relate to: XXXXX XXXXX operating system and hardware is the DBMS supported?Answer Concurrent update Security Integrity Limitations2 points Question 39 When a company decides to purchase a new DBMS, the CEO leads the DBMS evaluation and selection effort.Answer True False2 points Question 40 SQL is an example of a nonprocedural language.Answer True False2 points Question 41 The site that initiates the update in a two-phase commit is known as the ____.Answer director initiator coordinator leader2 points Question 42 The ____ determines the access privileges for all users and enters the appropriate authorization rules in the DBMS catalog to ensure that users access the database only in ways in which they are entitled to do so.Answer CEO programmer DBA IT manager2 points Question 43 When computers at one site need to be connected with computers at another site, the connection must be within a ____.Answer room building network combination2 points Question 44 In a DDBMS, the site where the user is located is called the remote site.Answer True False2 points Question 45 The ____ establishes the naming conventions for tables, fields, and indexes in the data dictionary.Answer users DBMS DBA programmers2 points Question 46 Which of the following DBMS evaluation categories does the following question relate to: XXXXX XXXXX vendor of the DBMS supply printed or online training manuals and how good are the manuals?Answer Portability Performance Cost Documentation and training2 points Question 47 The crucial issue in making the determination between a single many-to-many-to-many relationship and two (or three) many-to-many relationships is the ____.Answer independence data dependence redundancy cardinality2 points Question 48 A ____ is a place where a record of certain corporate data is kept.Answer depository data archive storage data bank2 points Question 49 ____ rules specify which users have what type of access to which data in the database.Answer Encryption Authentication Authorization View2 points Ques
Optional Information: Computer OS: Windows 7 Browser: IE Already Tried: ... ...
THIS ANSWER IS LOCKED!You can view this answer by clicking here to Register or Login and paying $3. If you've already paid for this answer, simply Login.
Experience: I have several years of teaching experience.
I'm sorry but i was in a time crunch. I submitted the questions and proceded myself. By the time I received your correspondence, i was well into the open-book quiz. It was much easier than i thought
Okay, Let me know if you need any help in future.
Thanks
Of course. I've got summer classes.