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
14
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
Semântica
GoConqr suporte .
Morfologia
Raíza Da Cunha
Redação para Vestibular
Alice Sousa
Teorema de Pitágoras 2
Paula Neto
Empreendedorismo - Contextualização da disciplina - Gestão
Ana Roberta Andrade
Sistema nervoso
João Victor
ADMINISTRAÇÃO PÚBLICA
Mateus de Souza