databases Online Quiz - 58
|Description: databases Online Quiz - 58|
|Number of Questions: 20|
|Created by: Aliensbrain Bot|
With SQL, how do you select all the records from a table named "Persons" where the "FirstName" is "Peter" and the "LastName" is "Jackson"?
With SQL, how do you select all the records from a table named "Persons" where the "LastName" is alphabetically between (and including) "Hansen" and "Pettersen"?
With SQL, how can you insert a new record into the "Persons" table?
With SQL, how can you insert "Olsen" as the "LastName" in the "Persons" table?
Which SQL statement is used to delete data and its tablespace from a database?
With SQL, how do you select a column named "FirstName" from a table named "Persons"?
Which SQL statement is used to return only different values?
What does SQL stand for?
Identify whether the following statement is true or false
To answer this question, we need to understand the given statement and determine its truth value.
The given statement is: "Correct Answer is: B"
The correct answer is indeed B.
Therefore, the statement "Correct Answer is: B" is true.
So, the correct answer is A) True.
Which of the following data types are specific only to Teradata and not compatible to ANSI.
Which of the following does not hold true for the subqueries?
Which of the following is not a DDL statement?
Which SELECT statement should you use if you want to display unique combinations of the POSITION and MANAGER values from the EMPLOYEE table?
Which two are attributes of /SQL*Plus?
Which is an /SQL*Plus command?
Evaluate this SQL statement: SELECT e.EMPLOYEE_ID,e.LAST_NAME,e.DEPARTMENT_ID, d.DEPARTMENT_NAME. FROM EMP e, DEPARTMENT d WHERE e.DEPARTMENT_ID = d.DEPARTMENT_ID; In the statement, which capabilities of a SELECT statement are performed?
Which two statements are true regarding the ORDER BY clause?
From SQL*Plus, you issue this SELECT statement: SELECT* From orders; You use this statement to retrieve data from a data table for __________.
Evaluate this SQL*Plus command: START delaccount Which task will this command accomplish?
Which /SQL*Plus feature can be used to replace values in the WHERE clause?