101.
Is it possible to save the result of a SELECT statement into a file using an SQL statement? Select
the best response.
- A.No, not with SQL alone.
- B.Yes, by using the FILE() function.
- C.Yes, by using the INTO OUTFILE clause.
- D.Yes, by using the LOAD DATA INFILE clause.
- Answer
- Report
Answer : [C]
102.
In the context of database transactions, the atomicity property guarantees that...
Select the best response.
- A.during a transaction, rows are processed one at a time.
- B.all statements that are executed inside a transaction are immediately committed.
- C.all statements that are executed inside a transaction are committed or rolled back as one unit.
- D.other transactions cannot see the changes made in other ongoing uncommitted transactions.
- Answer
- Report
Answer : [C]
103.
Which of the following statements best describes the purpose of the SQL WHERE clause? In SQL
statements, the WHERE clause specifies ...
Select the best response.
Select the best response.
- A.the tables from which data is to be retrieved.
- B.a condition to filter for only specific rows.
- C.a condition to filter for only specific groups defined by a GROUP BY clause.
- D.a number to limit the number of rows that is operated upon by the statement.
- Answer
- Report
Answer : [B]
104.
Which part of a SELECT statement specifies the tables from which data is to be retrieved? Select
the best response.
- A.The SELECT list.
- B.The FROM clause.
- C.The WHERE clause.
- D.The LIMIT clause.
- Answer
- Report
Answer : [B]
105.
A MySQL table has ...
Select the best response.
Select the best response.
- A.zero or more columns, and zero or more rows.
- B.zero or more columns, and one or more rows.
- C.one or more columns, and zero or more rows.
- D.one or more columns, and one or more rows.
- Answer
- Report
Answer : [C]
|
|
||||||||||||||||||||||||||||
