FC0-U61 · Question #20
A systems administrator wants to return results for a time range within a database. Which of the following commands should the administrator use?
The correct answer is A. SELECT. Data Manipulation Language (DML) commands allow you to insert or update records and extract information from records for viewing (a query): INSERT INTO TableName - adds a new row in a table in the database. UPDATE TableName - changes the value of one or more table columns. This c
Question
A systems administrator wants to return results for a time range within a database. Which of the following commands should the administrator use?
Options
- ASELECT
- BINSERT
- CDELETE
- DUPDATE
How the community answered
(48 responses)- A90% (43)
- B2% (1)
- C2% (1)
- D6% (3)
Explanation
Data Manipulation Language (DML) commands allow you to insert or update records and extract information from records for viewing (a query): INSERT INTO TableName - adds a new row in a table in the database. UPDATE TableName - changes the value of one or more table columns. This can be used with a WHERE statement to filter the records that will be updated. If no WHERE statement is specified, the command applies to all the records in the table. DELETE FROM TableName - deletes records from the table. As with UPDATE, this will delete all records unless a WHERE statement is specified. SELECT - enables you to define a query to retrieve data from a database.
Topics
Community Discussion
No community discussion yet for this question.