placeholder image to represent content

Database Management System II - Final Examination

Quiz by Felipe Sinjetsu

Our brand new solo games combine with your quiz, on the same screen

Correct quiz answers unlock more play!

New Quizalize solo game modes
20 questions
Show answers
  • Q1
    Your team lead ask you to  combine all fields of two tables (employee & department) and show matching data. What SQL Join statement are you going to use.
    SELECT * FROM employees, departments INNER JOIN  ON employees.department_id = departments.department_id
    SELECT * FROM employees INNER JOIN departments ON employees.department_id = departments.department_id
    SELECT * FROM employees FULL JOIN departments ON employees.department_id = departments.department_id
    SELECT employees  FROM * LEFT JOIN departments ON employees.department_id = departments.department_id
    120s
  • Q2
    Your are in an interview for a job and the interviewer is asking you which is the table that contains the primary key between the two tables in the SQL (SELECT * FROM employees INNER JOIN departments ON employees.department_id = departments.department_id). Which is it?
    department
    employees
    departments.deparment_id
    employees.department_id
    30s
  • Q3
    Your project manager wants you to combine two table which the first table will show all its record and the second table will match the record from the first table. Which join will you use?
    Left join
    Inner Join
    Self-Join
    Full Join
    30s
  • Q4
    A key constraint that can be inserted once in the table  and must be no duplicate.
    Index Key
    Unique Key
    Foreign Key
    Primary Key
    30s
  • Q5
    Your project manager wants the relationship between your tables must be the parent table will refuse record deletion or update if there are records in the child table. What foreign key option will be used?

    Set Refuse

    Restrict
    Set Null
    Cascade
    30s
  • Q6
    (Primary) key is used to connect two tables, the secondary table to the PRIMARY table.
    False, Foreign
    True
    False, Index
    False, Unique
    30s
  • Q7
    A (view) is populated invoked using SELECT statement. Its data/record can be derive from other tables.
    False, Index
    False, table
    False, Schema
    True
    30s
  • Q8
    Your lead is asking you to change the connection option of the table to, if the parent table will be updated or deleted, same should be in the child table. What foreign key option will you used?
    Restrict

    Swift

    Cascade
    Set Combine
    30s
  • Q9
    When linking two tables in MySQL designer, the foreign key is pertaining to what?
    a unique key or index key in child table
    foreign key in the child table
    primary key of the parent table
    primary key of the child table
    30s
  • Q10
    If you will be setting a one-to-one relationship in two tables, the child table attribute for foreign key must have (index) key.
    False, unique
    False, foreign
    False, primary
    True
    30s
  • Q11

    Your manager wants you to make the attribute name in the customer table to have "No name" as value if a user didn't put any name on it. What type of constraint will you use?

    Cluster
    Index
    Check
    Default
    30s
  • Q12
    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?
    customer.customer_ID
    account
    account.customer_ID
    customer
    30s
  • Q13
    In database, it allows you to define rules for the data in your table.
    Index
    Constraints
    Synonyms
    Cluster
    30s
  • Q14
    equals, less than, greater than, greater than or equal, less than or equal are examples of what operator?
    string
    arithmetic
    logical
    relational
    30s
  • Q15
    Using the SQL statement: Select Firstname From Account Where Barangay='tres' will output the following: Philip
    Question Image
    True
    False, statement has an error
    False, PI4
    False, will output Ines
    120s

Teachers give this quiz to your class