Flashcards
SQL STATEMENT TRUE OR FALSE
Cards in this deck (14)
- 1EVERY SQL STATEMENT IS FINISHED WITH ...semi-colon
- 2IN SQL STATEMENT AFTER WORD 'SELECT'' - COLUMN NAMES ARE DECLARED IN ORDER THEY WILL APPEAR IN QUERY RESULTSTRUE
- 3IN SQL STATEMENT IF MORE THAN ONE COLUMN NAME IS NEEDED TO DISPLAY QUERY RESULTS - THEY ARE SEPARATED WITH ...COMMA
- 4IN SQL STATEMENT IN SEARCH CRITERIA - TEXT VALUE NEEDS TO BE INCLUDED WITHIN ...QUOTATION MARKS
- 5IN SQL STATEMENT WHEN DECLARING DATE RANGE IN SEARCH CRITERIA AFTER WHERE WORD - DATE MUST START AND END WITH...HASHTAGS
- 6WHAT IS THE DATE FORMAT USED IN SEARCH CRITERIA AFTER WORD WHERE?DD/MM/YYYY
- 7IN SQL STATEMENT EVERY WORD WRITTEN IN CAPITALS NEEDS TO START FROM NEW LINE TRUE OR FALSE?FALSE
- 8SQL STATEMENTS ARE NOT CASE SENSITIVE MEANING WE CAN USE UPPER OR LOWER LETTERS WHEN DECLARYING VALUES, COLUMN NAMES AND TABLE NAMES TRUE OR FALSE?FALSE
- 9IN MICROSOFT ACCESS IF COLUMN NAMES HAVE SPACE AND YOU USE THIS COLUMN NAME TO WRITE SQL STATEMENT - IT NEEDS TO BE INCLUDED WITHIN ....SQUARE BRACKETS
- 10IN EQUI JOIN STATEMENT WORD WHERE DEFINES...LINK BETWEEN TWO TABLES USING FOREIGN KEY COLUMN
- 11IN EQUI JOIN STATEMENT SEARCH CRITERIA WITH THECORRESPONDING COLUMN IS INCLUDED AFTER WORD...AND
- 12SELECT FIRST NAME SECOND NAME FROM STAFF ORDER BY SECOND NAME ASCCOLUMN NAMES MUST BE SEPARATED WITH COMMAS AND SQL STATEMENT ENDED WITH SEMI-COLON
- 13EQUI JOIN STATEMENT IS USED ONLY WHEN CREATING QUERY FOR DATA COLUMNS COMING FROM TWO DIFFERENT TABLESTRUE
- 14IN EQUI JOIN STATEMENT WHEN DECLARING LINK BETWEEN TWO TABLES USING FOREIGN KEY COLUMN TABLE NAME IS SEPARATED WITH COMMA FROM COLUMN NAME TRUE OR FALSEFALSE IT'S A FULL STOP
Information
- Description
- Flashcards on SQL STATEMENT TRUE OR FALSE , created by ADRIANNA DAR on 03/11/2020.
- Created by
- ADRIANNA DAR
- Views
- 0
- Rating