describe Users; +---------------+--------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +---------------+--------------+------+-----+---------+----------------+ | user_id | int(11) | NO | PRI | NULL | auto_increment | | user_fname | varchar(255) | YES | | NULL | | | user_lname | varchar(255) | YES | | NULL | | | user_email | varchar(255) | YES | | NULL | | | user_password | varchar(255) | YES | | NULL | | +---------------+--------------+------+-----+---------+----------------+ SELECT * FROM Users; +---------+------------+------------+----------------+--------------------------------------------------------------+ | user_id | user_fname | user_lname | user_email | user_password | +---------+------------+------------+----------------+--------------------------------------------------------------+ | 11 | Test | User | test1@test.com | $2y$10$8oZDQlhmle95QODw4shhse2O.8c/diNTtgOsclVSGPQO5d1itnrSC | | 12 | test | user | test@test.com | testpassword | +---------+------------+------------+----------------+--------------------------------------------------------------+ describe Tests; +-----------+--------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-----------+--------------+------+-----+---------+----------------+ | test_id | int(11) | NO | PRI | NULL | auto_increment | | test_name | varchar(255) | YES | | NULL | | | image | varchar(255) | YES | | NULL | | +-----------+--------------+------+-----+---------+----------------+ SELECT * FROM Tests; +---------+----------------------------+---------------------+ | test_id | test_name | image | +---------+----------------------------+---------------------+ | 1 | Programming Languages | so-logo.png | | 2 | Computer Parts | motherboard.png | | 3 | C++ Knowledge Check | cpp-logo.png | | 4 | PHP Knowledge Check | PHP-logo.png | | 5 | JavaScript Knowledge Check | JavaScript-logo.png | +---------+----------------------------+---------------------+ describe Answer_sheet; +-----------------+--------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------------+--------------+------+-----+---------+-------+ | test_id | int(11) | NO | | NULL | | | question_number | int(11) | YES | | NULL | | | question_text | varchar(255) | YES | | NULL | | | answer1 | varchar(255) | YES | | NULL | | | answer2 | varchar(255) | YES | | NULL | | | answer3 | varchar(255) | YES | | NULL | | | answer4 | varchar(255) | YES | | NULL | | +-----------------+--------------+------+-----+---------+-------+ SELECT * FROM Answer_sheet; +---------+-----------------+--------------------------------------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------------------------------------------------------------------------------------------+----------------------------------------------------------------------------------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | test_id | question_number | question_text | answer1 | answer2 | answer3 | answer4 | +---------+-----------------+--------------------------------------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------------------------------------------------------------------------------------------+----------------------------------------------------------------------------------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | 1 | 1 | HTML stands for __________ | Hyper Text Markup Language | Hyper Text Markdown Language | Honestly Trivial Markup Language | Trick question, it does not stand for anything | | 1 | 2 | In what year was FORTRAN made by IBM? | 1957 | 1956 | 1958 | 1962 | | 1 | 3 | As of 2014, how many devices run Java? | 3 Billion | 7 Billion | 1 Billion | 5 Billion | | 1 | 4 | What type of language is Python commonly refered to as? | Interpreted Language | Markup Language | Compiled Language | Latin Based Language | | 1 | 5 | Which definition best describes an Algorithm? | A process or set of rules to be followed in calculations or other problem-solving operations. | A generalized mathmatical equation. | Al Gore keeping beat. | A phrase used by programmers when they do not want to explain what they did. | | 2 | 1 | Which of the following is a required component of a PC. | RAM | Dedicated sound card | Network adaptor | RGB lights | | 2 | 2 | CPU stands for __________ | Central Processing Unit | Control Process Unifier | Computer Power Unit | Computer Performance Utilizer | | 2 | 3 | Random Access Memory (RAM) is used for what purpose? | Quick but volatile storage of programs and files | Long term storage of programs and files | Assist the process with computations | Controlling where data is stored on a Hard Disk Drive or Solid State Drive | | 2 | 4 | Modern Motherboards come equiped with PCIe slots for expansion cards. Which of the following is not a type of PCIe slot? | PCIe x24 | PCIe x1 | PCIe x16 | PCIe x8 | | 2 | 5 | Where is the BIOS stored? | In the Motherboard | In RAM | In the HDD or SSD | In the Processor | | 3 | 1 | A member function can always access the data in __________ | the class of which it is a member | the object of which it is a member | the public part of its class | the private part of its class | | 3 | 2 | Which of the following is true about virtual functions in C++. | All of these | Virtual functions are functions that can be overridden in derived class with the same signature | Virtual functions enable run-time polymorphism in a inheritance hierarchy | If a function is virtual in the base class, the most-derived class`s implementation of the function is called according to the actual type of the object referred to, regardless of the declared type of the pointer or reference | | 3 | 3 | What is the difference between struct and class in C++? | Members of a class are private by default and members of struct are public by default. When deriving a struct from a class/struct, default access-specifier for a base class/struct is public and when deriving a class, default access specifier is private | All members of a structure are public and structures do not have constructors and destructors | All members of a structure are public and structures do not have virtual functions | All of the these | | 3 | 4 | Which of the following is not correct for virtual function in C++ ? | Virtual function can be static | Must be declared in public section of class | Virtual function should be accessed using pointers | Virtual function is defined in base class | | 3 | 5 | Which of the following cannot be passed to a function in C++ ? | Header file | Array | Structure | Constant | | 4 | 1 | Which of the following is correct about PHP? | All of these | PHP is a recursive acronym for `PHP: Hypertext Preprocessor`. | PHP is a server side scripting language that is embedded in HTML. | It is used to manage dynamic content, databases, session tracking, even build entire e-commerce sites. | | 4 | 2 | Which of the following is correct about NULL? | Both of the these. | NULL is a special type that only has one value: NULL. | The special constant NULL is capitalized by convention, but actually it is case insensitive. | None of the these. | | 4 | 3 | Which of the following function can be used to get an array in the reverse order? | array_reverse() | array_search() | array_shift() | array_slice() | | 4 | 4 | How will you concatenate two strings? | Using . operator | Using + operator | Using add() function | Using append() function | | 4 | 5 | Which of the following is an associative array of variables passed to the current script via HTTP cookies? | $_COOKIE | $Array | $Array | $ | | 5 | 1 | Inside which HTML element do we put the JavaScript? |