Database Management System II - Prefinals Examination

Database Management System II - Prefinals Examination | Quizalize

30 questions

A key constraint that can be inserted multiple times in the table in different attributes and must be no duplicate.

30 sec

A constraint that used to fill a column with a default and fixed value if the user didn't input data.

30 sec

A percent sign and asterisk wildcard character can only be effective in criteria when you are using (equal) operator.

30 sec

A key constraint that specifies the constrained columns' values must UNIQUELY identify each row. Can be inserted once in a table.

30 sec

A key constraint that can be unique, compound, bi-directional, or clustered.

30 sec

A database object that means the structure of the database or name spaces for a collection of database objects is the (View).

30 sec

A (table) is populated invoked using SELECT statement. Its data/record can be derive from other tables.

30 sec

A key use used to connect the secondary table to the PRIMARY table.

30 sec

A foreign key option which refuses to update or delete a record from the parent table if there are records in the child table.

30 sec

A foreign key option that updates or deletes records from the child table automatically when updating or deleting a record from the parent table.

30 sec

SELECT relation_name FROM attribute1 WHERE attribute1 = "x" can be a (valid) SELECT query statement.

30 sec

If you are going to upload data from an excel file to your MySQL database table, what function in MySQL would you use?

30 sec

A dashed, asterisk, percent sign, brackets in SQL are what characters?

30 sec

As a database designer, your Project Manager asked you to create an SQL which will join three tables that will show only the record of a specific person. What type of join is appropriate?

30 sec

Between the relation customer with an attribute of customer_ID (primary key) and relation account with an attribute of customer_ID (unique key) where should be the reference key be located?

30 sec

An INNER JOIN returns rows of tables where the data _____.

30 sec

When linking two tables in MySQL designer, the foreign key is pertaining to what?

30 sec

Your people lead asked you what table will serve as the parent table in the relationship given that customer.customer_ID (reference key) = order.customer_ID (foreign key).

30 sec

>, >=, <, <=, = are all (comparison) operators which is use in query criteria to compare data.

30 sec

A (Index) is a virtual table derived from one or more tables or other views.

30 sec

Based on the tables provided. SELECT Studentrecord, Accounts FROM Firstname inner join Username on Firstname.ID = Username.StudentID where gender='Female' will result to Lina, Lina11 - Dina, Dina12

300 sec

Based on the tables provided. SELECT Firstname, Age FROM Studentrecord WHERE Lastname = '%o' ORDER BY Firstname ASC will result to Dina, 28 - Lina, 27

300 sec

Based on the tables provided. SELECT Accounts.Username, Studentrecord.Age FROM Studentrecord inner join Accounts on Studentrecord.ID = Accounts.StudentID WHERE Accounts.ID=3 will result to Dina12, 28

300 sec

Based on the tables provided. SELECT Username, ID FROM Accounts WHERE Password between 11 and 13 ORDER BY Username ASC will result to Dina12, 3 - Gaspar13, 4 - Lina11, 2

300 sec

Based on the tables provided. SELECT Studentrecord.ID, Studentrecord.Age, Accounts.Username FROM Studentrecord inner join Accounts on Studentrecord.studentID = Accounts.ID WHERE Studentrecord.ID = 2 will result to 2, 27, Lina11

300 sec

Based on the tables provided. Create or Replace View LABVIEW as Select * FROM Studentrecord WHERE StudentID = 3 will result to 3, Dina, Igo, 28, Female

300 sec

Based on the tables provided. Create or Replace View LABVIEW as Select Accounts.Password, Studentrecord.ID FROM Studentrecord inner join Accounts on Studentrecord.ID = Accounts.StudentID WHERE Username like "%_ _ 1_" will result to 10, 1 - 11, 2 - 12, 3 - 13, 4

300 sec

Based on the tables provided. SELECT Accounts.ID, Studentrecord.Firstname, WHERE Studentrecord inner join Accounts on Studentrecord.ID = Accounts.StudentID will result to 1, Ben - 2, Lina - 3, Dina - 4, Gaspar

300 sec

Based on the tables provided. If I want to show Gaspar13, 13, Gaspar - Ben10, 10, Ben What is the appropriate SQL Statement?

300 sec

Based on the tables provided. If I want to show Lina, 27, Lina11 - Gaspar, 25, Gaspar13 What is the appropriate SQL Statement?

300 sec

Related quizzes

Related quizzes