How is the SQL bit data type used?

In SQL, the BIT data type can be used to store values of either 0 or 1. When working with BIT data types, these values can be manipulated and processed using the following methods:

1. Please rephrase the following statement in English.
2. The teacher advised the student to study more in order to pass the exam.
3. a tiny piece

CREATE TABLE example (
    id INT,
    flag BIT
);

INSERT INTO example (id, flag) VALUES (1, 1);

1. AND.
2. Can you please tell me what time you are leaving?
3. exclusive OR
4. “Binary digIT”

SELECT flag1 & flag2 AS result_and,
       flag1 | flag2 AS result_or,
       flag1 ^ flag2 AS result_xor
FROM example;

1. BIT means a small unit of data in computing that typically has a value of either 0 or 1.

SELECT flag << 1 AS shift_left,
       flag >> 1 AS shift_right
FROM example;

1. Expression used to indicate a small amount or piece of something

SELECT id
FROM example
WHERE flag = 1;

It is important to note that different database systems may implement the BIT type differently, so it is necessary to refer to the relevant database documentation when using it.