30018-rwanda-s6-wda-database-fundamentals-and-database-development-assessment-exam-Premium Welcome to your 30018-Rwanda-S6-WDA-Database-Fundamentals-and-Database-Development-Assessment-Exam-Premium EXAM TITLE: DATABASE FUNDEMENTALS AND DATABASE DEVELOPMENT SG EXAM ID: 30018-Rwanda-S6-WDA-Database-Fundamentals-and-Database-Development-Assessment-Exam-Premium TRADE: Software Development (LEVEL 5) INSTRUCTIONS AND NOTES: - This is an assessment exam prepared with collaboration of Standard Gateway, education and technology focused organization and operator of www.nationalexamination.com, operator of kezastore.com and their partners. The exam shall assess student preparedness in a computer based format, that can be practiced anytime on a smartphone, computer or any other electronics gadget! - It is intended to mimic a standard exam offered by a national examination council or a professional exam body. The exam is provided on an "use as is basis". The user shall judge him/herself on the applicability and usability. We recommend to utilize this exam as a self gauging tool in your preparation journey and take it multiple times to assess improvements. - We ask that students do not copy, redistribute without appropriate written approval by Standard Gateway staff, in ensuring the exam is beneficial to other examinees - ANSWER ALL QUESTIONS FOR ALL SECTIONS - READ QUESTIONS CAREFULLY BEFORE YOU ANSWER - SMART WORK IS REQUIRED Good Luck! What is the correct name of a column in a table?RowRecordDomainField Which of the following statement is true?Foreign key does not allow duplicate valuesIn primary key, you can enter a duplicate valuePrimary key does not allow duplicate valuesAll statement is true Which of the following is not a RDBMS?MS ACCESSSQL ServerMYSQLORACLEMS EXCEL Which of the following are characteristics of an RDBMS?Data are organized in a series of two-dimensional tables each of which contains records for one entity.Queries are possible on individual or groups of tables.It cannot use SQL.Tables are linked by common data known as keys. The keys that can have NULL values are Primary Key Unique Key Foreign Key None of the answers is correct SQL components are the following except:Data Definition LanguageData Manipulation LanguageData Transaction LanguageData Control Language What does SQL stand for?Structured Query LanguageStrong Question LanguageStructured Question LanguageStyle Query Language Which SQL statement is used to delete data from a database?RemoveEraseDeletecollapse 1 out of 5 Which SQL statement is used to insert new data in a database?ADD NewInsert newAdd recordInsert into With SQL, how do you select a column named “Firstname” from a table named “Students”Display Firstname from Students;Select Students.Firstname;Select Firstname from Students;Extract Firstname from Students; With SQL, how do you select all columns from a table named “Students”Select [all] from Students;Select * from Students;Select * Students;Select Students; With SQL, how do you select all the record from a table named “Students” where the value of column “Firstname” is “Peter”Select [all] from Students where Firstname=’Peter’;Select [all] from Students where Firstname LIKE ’Peter’;Select *from Students where Firstname=’Peter’;Select * from Students where Firstname==’Peter’; With SQL, how do you select all the record from a table named “Students” where the value of column “Firstname” start with an “p”Select [all] from Students where Firstname LIKE ‘%p’;Select * from Students where Firstname LIKE ‘%p%’;Select * from Students where Firstname LIKE ‘p%’;Select * from Students where Firstname =’p’; With SQL, how do you select all the record from a table named “Students” where “Firstname” is “Peter” and Lastname is “John”Select * from Students where Firstname=” Peter’ Lastname=” John”;Select * from Students where Firstname=” Peter ‘AND Lastname=” John”;Select * from Students where Firstname” Peter’ AND Lastname” John”;Select from Students where Firstname=” Peter’AND Lastname=” John”; Which SQL keyword is used to sort the Result –setSORTORDERSORT BYORDER BY With SQL how can you retun all the records from a table named “Student” sorted descending by FirstnameSelect * from Students ORDER BY Firstname DESC;Select * from Students SORT Firstname DESC;Select * from Students SORT BY Firstname DESC;Select * from Students ORDER Firstname DESC; 2 out of 5 With SQL how can you insert a new record into the Students table?Insert into Students value ("Habimana”,”Jean Claude”);Insert Students values ("Habimana”,” Jean Claude”);Insert value ("Habimana”,” Jean Claude”) into Students;Insert ("Habimana”,” Jean Claude”) into Students; How can you change “Habimana” into “Bikorimana” in the Firstname column in the Students table?Update Students set Firstname=” Bikorimana” into firstname=Habimana;Modify Students set Firstname=” Bikorimana” into firstname=Habimana;Update Students set Firstname=” Bikorimana” where firstname=Habimana;Modify Students set Firstname=” Bikorimana” where firstname=Habimana; With SQL how can I return the number of records in the Students table?select columns (*) from Students;select LEN (*) from Students;select count (*) from Students;select NO (*) from Students; With SQL how can delete the record where Firstname is Bikorimana in the Students table?Delete row Firstname=”Bikorimana” from Students;Delete Firstname=”Bikorimana” from Students;Delete * from Students Firstname=”Bikorimana”;Delete from Students where Firstname=”Bikorimana”; What is the most common type of joinJoinedINNER JOININSIDE JOINJOINED TABLE Which operator is used to select values within a rangeRANGEWITHINBETWEENFROM Which SQL statement is used to update data in databaseSAVEUPDATESAVE ASMODIFY Select the best answer:Cardinality in an Entity-Relationship diagram:Refers to the number of higher-level entities that are used in the ER model.s used to show the average number of items that might typically be involved in a relationship, e.g., the average number of children a family might have or the average number of employees per department in a company.Is used to show the order of the relationships between two entities, i.e. many relationships always precede a one relationship.Gives the count of the number of entities involved in a single relationship. 3 out of 5 When creating relationships, a key field in one table is connected to a related field in another table. For example, the State Code field of the STUDENT table is connected to the State Code field (primary key) of the STATE table. The State Code field of the STUDENT table is a of the STUDENT table.primary keycandidate keyforeign keyalternate keyminor key The OR operator display a record if any conditions listed are True, The AND operator display a record if all of the condition listed are TrueTrueFalse Constraints can be defined as rules that control values entered in a columnTrueFalse DBMS stands for Database management system and is not used to manage databaseTrueFalse The main goal of DBMS is to store and retrieve informationTrueFalse Database users include DBA and end usersTrueFalse Table is a set of rows and columns used to store dataTrueFalse Relational schema describes the table structureTrueFalse 4 out of 5 DBA stands for database agencyTrueFalse Procedures and users are not among components of DBMSTrueFalse Primary key, foreign key, unique, check, default, index and tuple are key constraintsTrueFalse Types of integrity constraints are only domain, entity and referential constraintsTrueFalse Drop command is used to remove data and structure of databaseTrueFalse 5 out of 5 Time is Up!