Database tutor

Need a database tutor for my daughter. Teacher need to help on quiz preparation. I will need tutor for 1 month. Here I have attached some sample quiz ques. Give me the answer, if you able to do 100% will easy for me to select you.


Which of the following commands list existing databases in Oracle?
a. LIST DATABASES
b. SHOW DATABASES
c. DISPLAY DATABASES
d. All of the above
e. None of the above

Which command is used to list all columns in MS SQL Server?
a. DESCRIBE
b. SELECT
c. SHOW
d. LIST
e. All of the above

Which of the following does NOT NULL indicate?
a. Column must have a value including zero.
b. Column must have a value including void value.
c. Column must have a value including blank.
d. Column must not be void.

Which of the following is not a valid SQL command?
a. UPDATE
b. SHOW
c. SELECT
d. INSERT
e. All of the above
f. None of the above


Which of the following SQL statement is valid?
a. INSERT INTO SALES_REP VALUES ('25', 'Donna', 'Sanchez');
b. DELETE SALES_REP;
c. DROP TABLE SALES_REP;
d. UPDATE SALES_REP LAST_NAME = 'Austin';
e. All of the above.
f. None of the above.


Which of the following SQL statements is valid for MySQL, Oracle, and MS SQL Server?
a. CREATE TABLE sales_rep (id NUMBER(2), name CHAR (30));
b. CREATE TABLE sales_rep (id CHAR(2), name VARCHAR(30));
c. CREATE TABLE sales_rep (id NUMBER, name VARCHAR2(30));
d. CREATE TABLE sales_rep (id CHAR(2), name CHAR(30));
e. All of the above.
f. None of the above.


Which of the following commands list columns of a table in MS SQL?
a. DESCRIBE
b. DESC
c. EXEC SP_TABLE
d. EXEC SP_COLUMNS
e. All of the above.
f. None of the above.