CCC 206 — Midterm Exam

Question 1

Which of the following SQL statements is used to delete data from a database?
Correct answer: DELETE

Question 2

PHP is a server-side scripting language.
Correct answer: True

Question 3

The Apache HTTP server is a popular open-source web server software.
Correct answer: True

Question 4

In the context of databases, which term refers to a request for specific information from a database, typically using a programming language such as SQL?
Correct answer: Query

Question 5

Which of the following SQL keywords is used to sort the results of a query in descending order?
Correct answer: DESC

Question 6

Which of the following SQL statements is used to filter the results of a query based on a specific condition?
Correct answer: WHERE

Question 7

What programming language is commonly used to manage relational databases?
Correct answer: SQL

Question 8

Which of the following SQL statements is used to select data from a table?
Correct answer: FROM

Question 9

The DECIMAL data type in SQL is used to store integers.
Correct answer: False

Question 10

Which of the following statements best describes Data Definition Language (DDL) in SQL?
Correct answer: DDL is used to define or modify the structure of a database.

Question 11

Which of the following SQL statements is used to display the results of a query in a specific order?
Correct answer: GROUP BY

Question 12

A web application consists of HTML, CSS, and JavaScript files that are stored on a web server.
Correct answer: Static

Question 13

Which of the following statements best describes Interactive Data Manipulation Language (DML) in SQL?
Correct answer: DML is used to insert, update, or delete data in a database.

Question 14

Which of the following SQL statements is used to group the results of a query by one or more columns?
Correct answer: SELECT

Question 15

Which of the following SQL commands is used to create a new table in a database?
Correct answer: CREATE

Question 16

this web application generates content on the fly, depending on the user's request and input.
Correct answer: Dynamic.

Question 17

The content is generated by server-side scripts that can retrieve data from databases.
Correct answer: Dynamic.

Question 18

Which of the following SQL statements is used to retrieve data from a database?
Correct answer: SELECT

Question 19

The width of a SQL field is always determined by the maximum length of the data being stored in that field.
Correct answer: False

Question 20

Which of the following SQL statements is used to insert new data into a database?
Correct answer: INSERT

Question 21

MySQL is a popular open-source relational database management system.
Correct answer: True

Question 22

Which of the following SQL clauses is used to join data from two or more tables in a query?
Correct answer: JOIN

Question 23

PHP stands for Personal Home Page.
Correct answer: True

Question 24

This websites are usually simple and have limited functionality.
Correct answer: Static.

Question 25

Which of the following statements is true about SQL?
Correct answer: It is primarily used for manipulating and querying data in relational databases.

Question 26

Which of the following SQL commands is used to create a view in a database?
Correct answer: SELECT

Question 27

Which of the following SQL data types is used to store alphanumeric characters of variable length?
Correct answer: VARCHAR

Question 28

Which of the following SQL statements is used to select all columns from a table?
Correct answer: SELECT

Question 29

This web pages are fixed and do not change unless they are manually updated by a developer.
Correct answer: Static.

Question 30

It is a subset of SQL that is used to manage and manipulate data within a database.
Correct answer: DML

Question 31

Which of the following SQL clauses is used to limit the number of results returned by a query?
Correct answer: LIMIT

Question 32

PHP can be used to create web applications.
Correct answer: True

Question 33

The width of a SQL column is determined by the data type of the column
Correct answer: True

Question 34

Which of the following SQL clauses is used to filter results based on a specific condition?
Correct answer: WHERE

Question 35

Which of the following SQL commands is used to modify the definition of a view in a database?
Correct answer: ALTER VIEW

Question 36

Which of the following SQL statements is used to modify data in a database?
Correct answer: UPDATE

Question 37

PHP files have a .php extension.
Correct answer: True

Question 38

Including Database Management Systems is a called Sequel, as part of the system R projects in early what?
Correct answer: 1970s

Question 39

XAMPP is a web server software package that includes Apache, MySQL, PHP, and Perl.
Correct answer: True

Question 40

What is the Structured implemented the language, originally called sequel
Correct answer: IBM

Question 41

PHP is a compiled language.
Correct answer: False

Question 42

What does the acronym "SQL" stand for?
Correct answer: Structured Query Language

Question 43

The SELECT statement is used in SQL to modify data in a table.
Correct answer: False

Question 44

This websites are more complex and can offer a wide range of functionality such as e-commerce, user registration, and content management.
Correct answer: Dynamic.

Question 45

Which of the following SQL statements is used to specify the columns to be selected in a query?
Correct answer: SELECT

Question 46

Which of the following terms best describes a request for information or data, typically made through a search engine or database?
Correct answer: Query

Question 47

MySQL supports both transactional and non-transactional storage engines.
Correct answer: True

Question 48

Which of the following SQL clauses is used to specify the sorting order of the results of a query?
Correct answer: ORDER BY

Question 49

PHP can only run on Windows operating systems.
Correct answer: False

Question 50

XAMPP is a license cross platform web server solution stack package.
Correct answer: False