SQL Basic
With SQL, how do you select all the columns from a table named "Products"?
The OR operator shows a record if any conditions listed are true. The AND operator shows a record if all of the conditions listed are true.
What SQL keyword is applied for sorting the result-set?
Which SQL statement is applied for updating data in a database?
What SQL statement is used to extract data from a database?
Which SQL statement is applied for returning only different values?
What SQL statement is used for inserting new data in a database?
Which SQL statement is used to delete data from a table?
The primary - foreign key relations are implemented to
Once AUTOCOMMIT is set on, changes will be made automatically at the end of every SQL statement.
Which of the following is true about CASE SQL statement?
Which of the following statements is true about embedded SQL?
Which of the following statements is true about systems information in an RDBMS?
What does AVG SQL return?
How else can the table columns be called?
Which of the SQL statements below deletes all the rows in a table called PricesData?
Can the SELECT clause list have a computed value like in the example below? SELECT CustomerName, UnitPrice * NumberofUnits FROM Sale.
What does the TRUNCATE TABLE do?
Which of the terms below is used to describe a database that occupies magnetic storage in the terabyte range, as well as to describe a database that contains billons of table rows?
Which of the following is an open standard application programming interface(API) for accessing a database?
