Shared Flashcard Set

Details

SQL
Learn SQL
14
Computer Science
Graduate
09/15/2014

Additional Computer Science Flashcards

 


 

Cards

Term

 

 

What does SQL statements start and end with? 

Definition

 

 

It starts with a KEYWORK and ends with a SEMICOLON (;)

Term

 

 

Define SQL Syntax

Definition

 

 

Rules and guidelines that are unique for SQL

Term

 

 

 

Is the SQL statements case sensitive?

Definition

 

 

 

No, unless using MySQL where the statment needs to match what is written in the database. 

Term

 

 

SQL Statement for creating a new database is? 

Definition

 

 

SQL> CREATE DATABASE

Term

 

 

 

Syntax to drop an existing database into SQL schema

Definition

 

 

DROP DATABASE

Term

 

 

Syntax to select any existing database to use is? 

Definition

 

 

USE

Term

 

 

 

Syntax to create a new table for the sql database is? 

Definition

 

 

CREATE TABLE 

Term

 

 

1) Constraint to use when fields cannot be empty ?

 

 

2) Constraint to use when fields can be empty? 

Definition

 

 

 

1) NOT NULL

 

2) NULL

Term

 

 

What is the SQL syntax statement that is used to remove a table definition and all data, indexes, triggers, constraints, and permission specifications for that table?

Definition

 

 

 

DROP TABLE 

Term

 

 

Syntax to add new rows of data to a table? 

Definition

 

 

INSERT INTO 

Term

 

 

What are the two basic syntax to use with the INSERT INTO statement? 

Definition

 

INSERT INTO TABLE_NAME

 

and

 

INSERT INTO TABLE_NAME VALUES

Term

 

 

1) What is the SQL syntax statement that is used to fetch the data from a database table which returns data in the form of result table?


2) What is the result tables called? 

Definition

 

 

1) SELECT

 

 

2) Result-set

Term

 

 

 

What SQL clause is used to specify a condition while fetching the data from single table or joining with multiple tables.

Definition

 

 

 

WHERE

Term

 

 

1) What is the SQL syntax to combine multiple conditions to narrow data in an SQL statement.


2) What are these two operators called?

Definition

 

 

1) AND / OR

 

2) Conjuctuve Operators 

Supporting users have an ad free experience!