GradePack

    • Home
    • Blog
Skip to content
bg
bg
bg
bg

Author Archives: Anonymous

How many rows will be returned by the following query? SELEC…

How many rows will be returned by the following query? SELECT name FROM student WHERE major BETWEEN ‘Data Science’ AND ‘Computer Science’;

Read Details

Questions 16 to 18: Primary Keys & Normalization Concepts  …

Questions 16 to 18: Primary Keys & Normalization Concepts   Question 18 You have a Phone_Numbers column that contains values like “123-456-7890, 987-654-3210”. Under what condition does this violate 1NF?

Read Details

How many rows will be returned by the following query? SELEC…

How many rows will be returned by the following query? SELECT name FROM student WHERE major LIKE ‘%o%’;

Read Details

Questions 7 to 9: String Functions on Database Rows   Que…

Questions 7 to 9: String Functions on Database Rows   Question 9 What will the following command return? SELECT SUBSTRING_INDEX(name, ‘ ‘, -1) AS ‘Last_Name’ FROM student WHERE id = 101;

Read Details

Questions 10 to 15: Standalone String Functions   Questio…

Questions 10 to 15: Standalone String Functions   Question 12 What will the following command return? SELECT SUBSTRING(‘192.168.1.100’, 5, 3);

Read Details

Questions 10 to 15: Standalone String Functions   Questio…

Questions 10 to 15: Standalone String Functions   Question 13 What will the following command return? SELECT SUBSTRING(SUBSTRING_INDEX(‘apple-banana-cherry’, ‘-‘, -2), 1, 6);

Read Details

Questions 19 to 20: Evaluating 1NF Compliance   Questio…

Questions 19 to 20: Evaluating 1NF Compliance   Question 20 Below is a table description and its data: mysql> DESC projects; +———+————–+——+—–+———+—————-+ | Field | Type | Null | Key | Default | Extra | +———+————–+——+—–+———+—————-+ | id      | int     | NO  | PRI | NULL    | auto_increment | | title  | varchar(50) | YES |   | NULL |   | | members | varchar(100) | YES | | NULL | | +———+————–+——+—–+———+—————-+   mysql> SELECT* FROM projects; +—-+——————+_______________+ | id | title | members | +—-+——————+_______________+ | 1 | Mobile App | Alice, Bob, Charlie | | 2 | AI Chatbot | Diana, Evan | +—-+——————+_______________+ Is the above table in First Normal Form (1NF)?

Read Details

How many rows will be returned by the following query? SELEC…

How many rows will be returned by the following query? SELECT name FROM student WHERE gpa IN (3.5, 4.0);

Read Details

A story whose events are arranged so that the audience can f…

A story whose events are arranged so that the audience can follow their temporal order is told in [BLANK-1] time.

Read Details

Part II: Fill in the Blank5 questions • 1 point each • Write…

Part II: Fill in the Blank5 questions • 1 point each • Write the McKee term that best completes each statement.

Read Details

Posts pagination

Newer posts 1 … 8 9 10 11 12 … 98,771 Older posts

GradePack

  • Privacy Policy
  • Terms of Service
Top