Introduction to Databases Exam Prep – Important Questions & Solutions.

Introduction to Databases Exam Prep – Important Questions & Solutions. Object in the real word with an independent existence that can be differentiated from other objects, has a physical existence, and a conceptual existence. Entity What are the characteristics of a relational database? -Values are atomic -Column values are of the same kind -Each row if unique -the sequence of columns and rows are insignificant -Each column has a unique name Candidate Key The set of all keys that are eligible to become unique keys Keys that are generated by the DBMS Surrogate keys Given the relations: STUDENT (SID, StudentName, Major, AdvisorID) Which of the following is true in reference to the STUDENT table SID is the primary key A primary key is All of the above All of the above used to identify unique rows a candidate key used to represent rows in relationships Incorrect Response required to be unique When the primary key of one relation is placed into a Foreign Key second relation, it is called a Feild Key Foreign Key Primary Key Candidate Key Compisite Key Identify the themes in the relation below TREATMENT(DoctorID, DoctorName, DoctorPhone, PatientID, PatientName, PatientPhone, InsuranceName, InsuranceType, InsuranceContactNumber) DOCTOR, PATIENT DOCTOR, HOSPITAL DOCTOR, PATIENT, HOSPITAL DOCTOR, PATIENT, INSURANCE DOCTOR, PATIENT, INSURANCE A candidate key is/can used to represent rows in relationships a candidate to be the primary key All of the above Can consist of composite keys required to be unique All of the above Which of the following is true about a relation? All entries in any column must be of the same kind A relation may have duplicate rows The order of the columns in a relation must go from largest to smallest A relation may have multiple names A relation may have duplicate column names All entries in any column must be of the same kind In relational tables, the primary key should always be assigned not null values True False true The characteristics of relational databases recommends that we name tables and meta data with names that actually represent what we are keeping track of Self-describing Sharing of data and multi user system Insulation between program and data Support for multiple views Self-describing A null value is a value in a cell relation primary alternate missing truncated entering zero for a value Missing Which database characteristics ensures that different groups of users in an organization can be given access to different subsets of a database Control of data redundancy Insulation between program and data Support for multiple views of data Self-describing Support for multiple views of data A key that contains more than one attribute is called Complex Key multi-key N-Key Composite Key Canindate Key Composite Key Given the relation with the assumption that now two StudentLastName, StudentFirstName, StudentDateEnrollment, Major is a students with the same firstname, lastname and date of composite key enrollment exists in a major STUDENT (SID, StudentLastName,StudentFirstName, StudentDateEnrollment, Major, AdvisorID) Which of the following is true There is no composite keys StudentLastName, StudentFirstName, StudentDateEnrollment is a composite key Correct Answer StudentLastName, StudentFirstName, StudentDateEnrollment, Major is a composite key StudentLastName, StudentFirstName and AdvisorID is a primary key StudentLastName, StudentFirstName,AdvisorID, Major is a composite key In the context of manipulating data, refers to Sort adding/combining fields together Aggregate Link Skip Sort Arrange A rule that requires that the values in a foreign key must a referential integrity constraint have a matching value in the primary key to which the foreign key corresponds is called: normalization a key matching constraint. a referential integrity constraint Required field cascade update Given the relation COMPUTER(Manufacturer, Make, Manufacturer, Make, Model, Supplier together would be a candidate key Model, Processor, RAM, Cost, Supplier) with the assumption that a manufacturer gives a computer in only one specific make and model to a supplier, which of the following would be true Incorrect Response Manufacturer, Make, Model together would be a candidate key Manufacturer, Make, Supplier together would be a candidate key Manufacturer, Make, Model, Supplier together would be a candidate key Manufacturer, Model, Supplier together would be a candidate key STUDENT (SID, StudentName, Major, AdvisorID) AdvisorID is a foreign key in the STUDENT table ADVISOR (AdvisorID, AdvisorName, Office, Phone) such that each student is assigned to one advisor, which of the following is true about the STUDENT table Phone is a candidate key in the ADVISOR table AdvisorName is a primary key in the ADVISOR table SID is a foreign key in the STUDENT table SID is a foreign key in the ADVISOR table AdvisorID is a foreign key in the STUDENT table is data about the structure of a database meta data such as names of tables, fields names of columns Data applications SQL Query Tables Meta data The major difference that Web 2.0 brought to websites ability users to interact with websites Ability users to interact with websites Ability to use HTML Ability to use intelligent personal agents Ability to add static content Ability to use mobile apps is used to update or extract data from Query a database Meta Data Referential Integrity Cloud storage Query Validation Rules Microsoft SQL Server is an example of a: Commercial database management system table personal database management system list manager data manipulation system. commercial database management system. The actual data in a database is stored in the Database database application database management system Local computer database The major role of a database for an organization support current transactions to store historical data support data mining support current transactions Analyze strategic information conduct forecasting of data The property of database enables one user's Data isolation changes to become visible to other concurrent users and systems Data redundancy Data quality Data isolation Data Integrity Data backup A relational database stores data in the form of: Tables Forms Tables Lists Spreadsheets Queries keeps track of historical data and is a Data Warehouse and BI systems helpful resource for conducting sophisticated data analysis for strategic planning Cloud systems Database Database Applications Data Warehouse and BI systems DBMS Which of the following would be an example of a database Microsoft Azure cloud technology MySql Office 365 Microsoft Azure Bing Microsoft SQL server sits between the end user and the Database Application DBMS (Database Management System) Database Personal Database System SQL Database Application Metadata Which of the following would be an example of database Names of tables in a database metadata? Queries against records in the database tables The actual data in a table Names of tables in a database The data organized in ascending order User information stored in tables Which component of the database system is used to Database Management System manage the database and set security rules Database Management System Applicaitons Web Server Database Users When you type a URL in the web browser, your computer web server is contacting the database management system web server database client system application development system The major purpose of a database is to Keep track of and organize data Data Cleaning Keep track of and organize data Support cloud services Program Applications Encrypt data SQL stands for Structural Question Language Standard Question Language Structured Query Language. Structured Question Language Standard Query Language Structured Q