AI.1.3.2.d.SQL

AI.1.3.2.d.SQL

By Mr. Shingari

Retrieval practice-SQL

Wilf

You understand the purpose of key commands of SQL.​

​

Some text here about the topic of discussion

Multiple Choice

What is the purpose of the DELETE structure in SQL?

• To delete stored queries from a database
• To delete an index
• To delete a fields from a database table
• To delete records from a database table

Multiple Choice

What is the purpose of the DROP structure in SQL?

• To delete records from a database
• To delete fields in a database
• To remove the primary key from a field in a database
• To delete a table from a database

Multiple Choice

What is the purpose of the FROM structure in SQL?

• To define which tables will be used
• To enable field matches with wildcards
• To define which fields will be returned
• To define the criteria of the records returned

Multiple Choice

What is the purpose of the INSERT structure in SQL?

• To insert a relationship between tables
• To insert an index into a table
• To insert a field into a table
• To insert a record into an existing table

Multiple Choice

What does this SQL structure return? WHERE part LIKE 'G%'

• All the records where the part field is True
• All the parts that begin with G
• All the records above G%
• All the parts that are G%

Multiple Choice

What is the purpose of the LIKE structure in SQL?

• To define which tables will be used
• To return only preferred records
• To define which fields will be returned
• To enable the use of wildcards in WHERE statements

Multiple Choice

What is the purpose of the SELECT structure in SQL?

• To define which tables will be used
• To select a table to delete
• To define which fields will be returned
• To define the criteria of the records returned

Multiple Choice

If you want to SELECT all of the fields from a table using an SQL statement would you choose?

• SELECT ALL
• SELECT %
• SELECT *
• SELECT .

Multiple Choice

What is the purpose of the WHERE structure in SQL?

• To define the criteria of the records returned
• To define which fields will be returned
• To order the records returned
• To define which tables will be used

Multiple Choice

What database concept can be described as, 'maintaining the consistency of data in a data store'?

• Referential integrity
• Record locking
• Data integrity
• Transaction processing

Multiple Choice

Why is referential integrity such an important database concept?

• It allows you to encrypt a database and its contents
• Databases must not allowed to become inconsistent due to partially completed transactions
• It makes sure a database can't be attacked my malicious malware
• It allows more than one user to access a database at the same time

SQL fundamental

use the link on next slide to read about fundamental of SQL

Subject | Subject

Some text here about the topic of discussion

Isaac Computer Science

You can open this webpage in a new tab.

Copy link

Open in new tab

Create and drop tables using the SQL​

Walt:

Learn how to create tables in SQL using CREATE.

Understand the key concepts of table identifiers(names),Primary keys, foreign keys, SQL data types

Learn ​how to delete tables in SQL using DROP

Subject | Subject

Some text here about the topic of discussion

Isaac Computer Science

You can open this webpage in a new tab.

Copy link

Open in new tab

Home

Open in new tab

Copy link

Use Select statement in SQL

Walt:

Learn how to use select statement to retrieve information from table

Learn how to criteria of various data types to retrieve the information needed

Learn how to join data from different tables using Join command.​

​

Some text here about the topic of discussion

Isaac Computer Science

You can open this webpage in a new tab.

Copy link

Open in new tab

Wilf: SQL Select command

You can use SQL command to retrieve information from table.

Subject | Subject

Some text here about the topic of discussion

Home

Open in new tab

Copy link

Wilf: Select with Where clause

You can use Select command with a condition to retrieve information from given table.

Subject | Subject

Some text here about the topic of discussion

Home

Open in new tab

Copy link

Wilf: Select statement with order by.

You can use order by command combined with select to sort the results of sql queries. ​

Subject | Subject

Some text here about the topic of discussion

Home

Open in new tab

Copy link

Wilf: Use Join command to combine the fields needed from multiple tables.​

You can use join command to combine the results from two or more tables.​

Subject | Subject

Some text here about the topic of discussion

Home

Open in new tab

Copy link

Create and drop tables using the SQL​

Walt:

Learn how to use INSERT, UPDATE AND DELETE COMMAND.

Subject | Subject

Some text here about the topic of discussion

Isaac Computer Science

You can open this webpage in a new tab.

Copy link

Open in new tab

Wilf: You can use INSERT, UPDATE AND DELETE commands in SQL.

You can use wildcards in SQL.​

Subject | Subject

Some text here about the topic of discussion

Home

Open in new tab

Copy link

Home

Open in new tab

Copy link

Home

Open in new tab

Copy link

Home

Open in new tab

Copy link