CompTIA Updated FC0-U61 Exam Questions and Answers by lando

DROP is a SQL command that can be used to remove a database permanently from a database management system. DENY is a SQL command that can be used to revoke permissions from a user or role. ALTER is a SQL command that can be used to modify the structure of a database object, such as a table or column. DUMP is not a valid SQL command, but it may refer to a backup operation that creates a copy of a database. References: The Official CompTIA IT Fundamentals (ITF+) Student Guide (Exam FC0-U61), Chapter 6: Database Fundamentals1

 Data definition is the process of creating, modifying, or deleting the structure and objects of a database, such as tables, fields, indexes, and views. Data definition is performed using data definition language (DDL), which is a subset of SQL commands. An administrator can use DDL to grant or revoke permissions for a user to access data in a database. References : The Official CompTIA IT Fundamentals (ITF+) Study Guide (FC0-U61), page 144.

 SMTP and POP3 are the most likely network protocols that will be used when sending and receiving Internet email. SMTP stands for Simple Mail Transfer Protocol, which is a protocol that enables the transmission of email messages from a client to a server or from one server to another. SMTP is used to send outgoing email messages. POP3 stands for Post Office Protocol version 3, which is a protocol that enables the retrieval of email messages from a server to a client. POP3 is used to download incoming email messages. References : The Official CompTIA IT Fundamentals (ITF+) Study Guide (FC0-U61), page 166.

 DROP is the command that is used to completely remove a table and its data from a relational database. DROP is a SQL (Structured Query Language) statement that deletes the definition and contents of a database object, such as a table, index, or view. DROP cannot be undone, so it should be used with caution. For example, the statement DROP TABLE Customers; will delete the table named Customers and all its data from the database. References : The Official CompTIA IT Fundamentals (ITF+) Study Guide (FC0-U61), page 144.