SQL: Hardest Trivia Quiz On Relational Database!

60 Questions | Total Attempts: 153

SettingsSettingsSettings
Please wait...
SQL: Hardest Trivia Quiz On Relational Database!

.


Questions and Answers
  • 1. 
    In backtracking search, the most-constrained-variable and most-constraining variable strategies are used to
    • A. 

      Perform forward checking

    • B. 

      Decide what order should the values be tried for a variable

    • C. 

      Detect inevitable failure early

    • D. 

      Decide which variable should be assigned next

  • 2. 
    Which of the following sentences is equivalent to the sentence P => Q?
    • A. 

      – P => – Q

    • B. 

      – P V Q

    • C. 

      Q

    • D. 

      Q => P

  • 3. 
    Which of the following functions is admissible heuristic function for any problem?
    • A. 

      H( n) = 2n

    • B. 

      H( n) = 0

    • C. 

      H( n) = 2

    • D. 

      H( n) = n

  • 4. 
    What is the main difference between breadth-first search and depth-first search?
    • A. 

      The solution

    • B. 

      The goal state

    • C. 

      The initial state

    • D. 

      The order of node expansion

  • 5. 
    How many heuristic function are there for a given problem?
    • A. 

      2

    • B. 

      1

    • C. 

      Infinitely many

    • D. 

      0

  • 6. 
    In problem-solving agents, when a solution is found?
    • A. 

      Whenever a percept is perceived

    • B. 

      After all actions are performed

    • C. 

      Before the first action is performed

    • D. 

      After the first action is performed

  • 7. 
    What is the difference between informed search and uninformed search algorithms
    • A. 

      Uninformed search can find the optimal solution but informed search doesn't

    • B. 

      Uninformed search strategy uses knowledge beyond the definition of the problem itself but informed search strategy doesn't

    • C. 

      Informed search can find the optimal solution but uninformed search doesn't

    • D. 

      Informed search strategy uses knowledge beyond the definition of the problem itself but uninformed search strategy doesn't

  • 8. 
    An agent acts upon its environment through which of the following components?
    • A. 

      Agent program

    • B. 

      Sensors

    • C. 

      Agent function

    • D. 

      Actuators

  • 9. 
    Which of the following algorithms is NOT a local search algorithm?
    • A. 

      Simulated annealing search

    • B. 

      Hill-climbing search

    • C. 

      A* search

    • D. 

      Genetic algorithm

  • 10. 
    What is the role of a searching algorithm in problem-solving agents?
    • A. 

      Finding the path cost

    • B. 

      Finding a initial state

    • C. 

      Finding a goal state

    • D. 

      Finding a solution

  • 11. 
    Which of the following statements correctly explains relational database?
    • A. 

      Data are treated as a two-dimensional table from the users’ point of view. Relationship between records are defined by the value of fields in each record

    • B. 

      Relationships between records are expressed by parent-child relationship

    • C. 

      Data fields composing a record are stored in the index format by data type. Access to the record is made through the data gathering in these index values.

    • D. 

      Relationships between records are expressed by network structure

  • 12. 
    In SQL, the SELECT statement is used to extract records from a two-dimensional table. If the following statement is executed for the leased apartments below, which data group is extracted?  SELECT property FROM leased_apartment_table  WHERE (District_area = 'Minami-cho' OR Time_to_work < 15 AND Code > 60 )
    • A. 

      A,C

    • B. 

      A, C, D, E

    • C. 

      A

    • D. 

      B, D, E

  • 13. 
    Choose a correct answer from the following descriptions concerning characteristics of the CODASYL-type database?
    • A. 

      The data structure is represented as a network

    • B. 

      The data structure is represented by a hierarchy

    • C. 

      SQL is used as its standard database language

    • D. 

      The data structure is represented by a table format consisting of rows and columns

  • 14. 
    In the ERD diagram, the one-to-many relationship, "a company has multiple employees," is expressed as follows: Which of the following statements correctly explains the above diagram?
    • A. 

      One company has one shareholder

    • B. 

      There are multiple companies, and each company has multiple shareholders

    • C. 

      One company has multiple shareholders

    • D. 

      There are multiple companies, and each company has a shareholder

  • 15. 
    Which of the following two descriptions on the operation of the customer_table is wrong?  Operation 1: SELECT Customer_name, Address FROM Customer  Operation 2: SELECT * FROM Customer WHERE Customer_no = ‘D0010’
    • A. 

      Operation 1 is PROJECTION and operation 2 is SELECTION

    • B. 

      The table extracted by operation 1 has four rows

    • C. 

      The table extracted by operation 1 has two columns

    • D. 

      The table extracted by operation 2 has two columns

  • 16. 
    Which of the following data models is used for the conceptual design of a database, expressing the targeted world by two concepts of entities and relationships between entities?
    • A. 

      Relational data model

    • B. 

      E-R model

    • C. 

      Hierarchical data model

    • D. 

      Network data model

  • 17. 
    Which of the following describes the storage method of databases in storage devices?
    • A. 

      Subschema

    • B. 

      Internal schema

    • C. 

      Conceptual schema

    • D. 

      External schema

  • 18. 
    Which of the following SQL statements defines a schema?
    • A. 

      SELECT

    • B. 

      INSERT

    • C. 

      DELETE

    • D. 

      CREATE

  • 19. 
    Regarding relational database manipulation, which of the following statements correctly explains projection?
    • A. 

      Create a new table by combining tuples satisfying conditions from tuples in more than two tables

    • B. 

      Extract the specific columns from the table

    • C. 

      Extract the rows satisfying specific conditions from the table

    • D. 

      Create a table by combining inquiry results from one table and the ones of the other table

  • 20. 
    A school has recorded information on classes taken by students in the following record format. To create a database from these records, each record must be divided into several parts to avoid the problems of duplicated data. A student takes multiple classes, and multiple students can take one class at the same time. Every student can take a class only once. Which of the following is the most appropriate division pattern?
    • A. 

      Answer c.

    • B. 

      Answer d.

    • C. 

      Answer a.

    • D. 

      Answer b.

  • 21. 
    Affordances are:
    • A. 

      The completion times for a typical task

    • B. 

      The cost of buying a user interface component

    • C. 

      User settable preferences

    • D. 

      Possibilities for using an object or interface

  • 22. 
    A pluralistic walkthrough?
    • A. 

      Is often conducted with low-fidelity designs

    • B. 

      Is usually conducted at the end of the development process

    • C. 

      Requires a fully functional prototype

    • D. 

      Requires having several alternate designs

  • 23. 
    Which of the following corresponds to the computer interface technology that uses icon, etc?
    • A. 

      GDI

    • B. 

      CAI

    • C. 

      CUI

    • D. 

      GUI

  • 24. 
    Which of these are attributes of usability?
    • A. 

      Easy to use

    • B. 

      Usefulness

    • C. 

      Learnability

    • D. 

      Generalisability

  • 25. 
    Which of the following descriptions related to computer system reliability is correct?
    • A. 

      The system preventive maintenance is performed in order to extend the MTBF

    • B. 

      The system operating ratio is improved by extending the MTTR and MTBF

    • C. 

      System remote maintenance improves the operating ratio, by improving the MTBF

    • D. 

      The more complicated the system configuration is, the longer the MTBF becomes

Related Topics
Back to Top Back to top