CREAR TEST

TEST BORRADO, QUIZÁS LE INTERESE: Chapter 7: Database Fundamentals

COMENTARIOS	ESTADÍSTICAS	RÉCORDS

REALIZAR TEST

Título del Test: Chapter 7: Database Fundamentals Descripción: Comptia IT Fundamentals+ Autor: Diana OTROS TESTS DEL AUTOR Fecha de Creación: 05/08/2024 Categoría: Informática Número Preguntas: 20

COMPARTE EL TEST

COMENTAR

No hay ningún comentario sobre este test.

Temario:

You have an address book for a small business with contact information for about 100 clients. The address book is used by two people. Which solution should you use to store the data? Spreadsheet Relational database Word processing software Non-relational database. A database developer is working on generating queries. If the developer needs to ensure that the output of the query has data persistence, to where should the data be written? RAM Cache SSD CPU. Which of the following consists of columns and rows of numerical or text data? Document database Key/value database Database dump Relational database. Joe creates a database. What does he need to do next to make it usable? Enable permissions Import data Run queries Create forms. A user, Ann, is granted permissions to access a database. What is this an example of? Data collection Data manipulation Direct/manual access Data definition. A medical office needs to create a solution to manage patient records. They have about 10,000 patients and eight staff, they want to include notes from medical professionals, emails to and from patients, and images such as X-ray. What should they create? Spreadsheet Relational database Non-relational database Primary key. You have created a relational database. Which of the following elements uniquely identifies a record in the database? Primary key Foreign key Schema Field. Mary, an administrator, creates a field and designates it to hold integer data. Joe, a user, tries to enter his name into the field, but it doesn't let him save the data. What is this an example of? Schema rules Primary key Foreign key Constraints. Rachel, a database administrator, has created a database for her website. It contains pictures of vacations that people have uploaded. In the database, pictures have associated information about who uploaded them and the date. What is this an example of? Semi-structured data Non-structured data Structured data Schema definition. Peter is accessing a database using a JDBC connection. Which of the following terms best describes the type of access he is using? Direct/manual access Programmatic access User interface/utility access Query/report builder. Oscar's user account has been granted permissions to view a database. Nathan then uses the deny command in an attempt to deny Oscar the ability to view the database and applies it to a group to which Oscar belongs. Which of the following statements is true? Oscar will still be able to view the database because a grant overrides a deny. Oscar will no longer be able to view the database because a deny overrides a grant. Oscar will no longer be able to view the database, because the deny cancels the grant, giving Oscar no specific permissions. Oscar will still be able to view the database because granted permissions must be removed with the revoke command. A school has a database with four tables, but it needs a fifth table. Which command is used to accomplish this task? INSERT UPDATE CREATE ALTER. Michael, an administrator, needs to add a column to an existing table. Which command should he use? INSERT UPDATE CREATE ALTER. Laura, your manager, instructs you to remove a table from a database permanently. Which command should you use? DELETE REMOVE DROP ALTER. Which of the following statements most accurately describes what a primary key refers to? A schema in a database A table in a schema A field in a table A record in a table. Kate, a database administrator, needs to add records into a database. Which command should she use? CREATE INSERT ALTER UPDATE. Henry wants to understand which of his customers has purchased part number BB8. Which command should he use? QUERY FIND SEARCH SELECT. George needs to remove a customer's information completely from a table. Which command should he use? DELETE DROP ALTER UPDATE. Which of the following descriptions best describes the type of structure that stores values as blobs? Relational database Non-relational database Document database Key/value database. An employee at your office just got married and changed their last name. Which command do you use to change their last name in the employee database? EDIT MODIFY ALTER UPDATE.

Denunciar Test