CompTIA_(iTF)_Database

Where should a database developer write data to ensure persistence in query output?

For which of the following purposes is a relational database management system MOST frequently utilized?

Which command do you use to update an employee's last name in the database after they get married?

Which of the following statements most accurately describes what a primary key refers to?

Which situation best describes summarizing staff entry to a data center by reviewing log records outside business hours?

The solution that allows multiple users concurrent access to an apps, with a strong emphasis on secure info storage.

An administrator, needs to add a column to an existing table. Which command should he use?

Your manager, instructs you to remove a table from a database permanently. Which command should you use?

A business needs multiple analytical reports combining insights from multiple datasets. What's the #1 suitable storage?

A CSV file is MOST commonly associated with which of the following database concepts?

A database administrator, needs to add records into a database. Which command should she use?

A user, Anna, is granted permissions to access a database. What is this an example of?

Which of the following consists of columns and rows of numerical or text data?

Smith needs to remove a customer’s information completely from a table. Which command should he use?

For retailers needing precise reporting to guide business decisions & inventory management, which is the MOST effective.

Which of the following types of programming languages is typically used for manipulating a database?

Which of the following pertains to an element in a database that points to the unique identifier of its parent table?

which relational database feature ensures that only valid data is input into a specified column?

What solution should a medical office create to manage 10,000 patient records, notes, emails, and images?

In a database, which field would MOST likely be designed as the primary key?

A new developer wants to add a new table to an existing database. Which database operation should be executed?

What is true if Lee denies Kiki access to a database using the deny command applied to Kiki's group?

What is it an example of if Abel can't save his name in a field designated for integer data?

Each row in a relational database represents a unique record. Which of the following defines the role of the columns?

What solution should you use to store contact info for 100 clients, accessed by two people?

What is it an example of if a database stores vacation pictures with uploader info and dates?

Which of the following terms BEST aligns with a relational database?

Every night, an organization exports its inventory database. Which of the following actions is taking place?

A programmer inserts a query within a software app. The query will be used by the application to retrieve data from a DB

Dan wants to understand which of his customers has purchased part number BB8. Which command should he use?

Mike creates a database. What does he need to do next to make it usable?

What term best describes the type of access Peter is using to access a database via a Java Database (JDBC) connection?

What type of information would a company typically require employees to manage in a sensitive manner?

A DBA grants permissions for an employee to view information held within a database. What action has been taken?

In a relational database, which command can be used to entirely delete a table along with its data?

How does a NoSQL database structure its data?

Which type of data is best suited for storage in a flat file database?

Which of the following would a programmer modify using DML?

A school has a database with four tables, but it needs a fifth table. Which command is used to accomplish this task?

A DBA has developed a tool that fetches a set of record entries from a database in its native format.

Which option MOST accurately represents the persistent physical storage location of data within a database?

A DBA needs to populate a new DB with a large amount of data from an external source. Which action should be complete?

SELECT * FROM Employee.Tbl; Which categories of programming languages would BEST represent this code statement?

You have created a relational database. Which of the following elements uniquely identifies a record in the database?

Which of the following BEST describes a common use for business data?

Primary and foreign keys allow for which of the following in a SQL database?

A DBA wishes to retrieve all data from a database that meets a specific condition. Which command should be used?

Which value uniquely identifies a specific record in a relational database?

Which of the listed programming languages would be employed to generate a query from a DB that integrates with a web app

Which of the following descriptions best describes the type of structure that stores values as blobs?

Which of the following commands can be executed on a database to initiate a query?