Structured Query Language (SQL) (Section 1)

Descrição

Chapter 1
Craig Willey
Quiz por Craig Willey, atualizado more than 1 year ago
Craig Willey
Criado por Craig Willey mais de 4 anos atrás
19
0

Resumo de Recurso

Questão 1

Questão
When transforming an ERD into a relational database, you often use an entity to build a database's:
Responda
  • Table
  • Column
  • Attribute
  • Relationship

Questão 2

Questão
The unique identifier of a row in a database table is a(n):
Responda
  • ID
  • Primary Key
  • Primary Column
  • Column

Questão 3

Questão
Which of the following is true of SQL?
Responda
  • It is the most commonly used language for interacting with a database.
  • It is the only language you can use to create a database.
  • It is the only language you can use to interact with a database.
  • None of these

Questão 4

Questão
What can you use to submit SQL statements for execution? (Choose all that apply.)
Responda
  • PHP
  • Java
  • SQL Developer
  • SQL*Plus

Questão 5

Questão
What is one of the purposes of DCL? (Choose the best answer.)
Responda
  • Query data from a given table
  • Issue privileges to users
  • Remove existing data from a database table
  • None of these

Questão 6

Questão
What can DDL be used for? (Choose three.)
Responda
  • Add comments to a database table
  • Add columns to a database table
  • Add data to a database table
  • Add privileges for a user to a database table

Questão 7

Questão
Which one of the following is a DML statement?
Responda
  • ADD
  • ALTER
  • UPDATE
  • MODIFY

Questão 8

Questão
Which of the following can be used to remove data from a table? (Choose two.)
Responda
  • DELETE
  • UPDATE
  • MODIFY
  • ALTER

Questão 9

Questão
What can a SELECT statement be used to query? (Choose the best answer.)
Responda
  • Only one report
  • Only one table
  • One or more reports
  • One or more tables

Questão 10

Questão
Which of the following is not a capability of the SELECT statement?
Responda
  • It can transform queried data and display the results.
  • It can remove data from a table.
  • It can join data from multiple tables.
  • It can aggregate database data.

Semelhante

Using DDL Statements to Create and Manage Tables ( Section 2)
Craig Willey
Manipulating Data (Section 3)
Craig Willey
Restricting and Sorting Data (Section 4)
Craig Willey
COMO APRENDER MAIS RAPIDO
Nataniel Neto
Dicas de Português para Concursos
Rodrigo Pizetta
Expressões em inglês #1
Eduardo .
DOCÊNCIA NO ENSINO SUPERIOR
SIQUELE CAMPELO
Ecologia I
kyungsos
Guerra fria-mapa mental
Valdemar Sievert
Contextualização da Aula 2 - Gestão - Administração da Carreira Profissional
Fabrícia Assunção