CIS 2750 ALL 2026 CORE EXAM MANUAL QUESTIONS AND ANSWERS MARKED

CIS 2750 ALL 2026 CORE EXAM MANUAL QUESTIONS
AND ANSWERS MARKED A+
✔✔underscore method is called - ✔✔snake case

✔✔SQL keywords are - ✔✔case sensitive and written in all caps

✔✔Table and column names are can be either - ✔✔case sensitive or case insensitive -
implementation dependant

✔✔SELECT is used for - ✔✔data retrieval

✔✔FROM indicates - ✔✔the table from which to retrieve the data

✔✔WHERE is used to - ✔✔describe column features that are desired in the retrieved
data.

✔✔not providing WHERE will cause - ✔✔all rows to be returned

✔✔literal strings in SQL use - ✔✔'single quotes'

✔✔Empty tables are constructed using the - ✔✔CREATE TABLE statement
CREATE TABLE S (SNO CHAR(5),
SNAME CHAR(20),
STATUS DECIMAL(3),
CITY CHAR(15),
PRIMARY KEY (SNO) )

✔✔Data must be entered late in a new table using - ✔✔INSERT

✔✔Columns which are defined as primary keys will never have - ✔✔2 rows with the
same key value

✔✔composite key - ✔✔A primary key that consists of more than one column (values
unique in combination)

✔✔Foreign keys refer to - ✔✔other tables

✔✔UPDATE - ✔✔change values in existing records

✔✔DELETE - ✔✔removes a row

✔✔CRUD operations - ✔✔• table creation
• Create