Copiar e Editar

Database Design [State Exam | 75 questions]

Descrição

State Database Design [Teachers: Kozina Lyudmila, Alshynov Chyngiz | FINAL EXAM + STATE EXAM ] ▼ (State Exam) Quiz sobre Database Design [State Exam | 75 questions], criado por Good Guy Beket em 25-02-2019.
Good Guy Beket
Quiz por Good Guy Beket, atualizado more than 1 year ago
Good Guy Beket
Criado por Good Guy Beket quase 6 anos atrás
480
11
0

Resumo de Recurso

Questão 1

Questão
The SQL BETWEEN operator …
Responda
  • Specifies a range to test
  • None of the given
  • Specifies that a column is a primary key
  • Specifies which tables we are selecting from

Questão 2

Questão
SQL aggregate functions are …
Responda
  • MIN, MAX, AVG, COUNT, SUM
  • SUM, AVG, MULT, DIV, MIN
  • SUM, AVG, MIN, MAX, MULT
  • SUM, AVG, MIN, MAX, NAME

Questão 3

Questão
Which SQL keyword is used to specify conditional search?
Responda
  • HAVING
  • WHERE
  • SELECT
  • FIND

Questão 4

Questão
The AVG SQL function returns the ...
Responda
  • The sum of values in a column
  • Average in the values in a group.
  • Maximum value from a column.

Questão 5

Questão
What does follow after the SQL WHERE clause?
Responda
  • Selection condition
  • List of columns that will be selected or the * symbol
  • None of the given
  • Name of the table we are selecting from

Questão 6

Questão
What does the SQL FROM clause do?
Responda
  • Specifies the tables to retrieve rows from.
  • Specifies a search condition
  • None of the given
  • Specifies the columns we are retrieving

Questão 7

Questão
Which SQL keyword is used to retrieve a maximum value?
Responda
  • UPPER
  • MOST
  • TOP
  • MAX

Questão 8

Questão
What does follow after the SQL SELECT clause?
Responda
  • List of columns to be selected or the * symbol
  • Name of the table we are selecting from
  • None of the given
  • Selection condition

Questão 9

Questão
Which SQL functions is used to count the number of rows?
Responda
  • COUNT ( )
  • NUMBER ( )
  • SUM ( )
  • COUNTOF ( )

Questão 10

Questão
What is the purpose of the SQL AS clause?
Responda
  • The AS SQL clause is used change the name of a column in the result set or to assign a name to a derived column
  • The AS clause is used with the JOIN clause only
  • The AS clause defines a search condition
  • All of the mentioned

Questão 11

Questão
Which SQL statement is used to extract data from a database?
Responda
  • SELECT
  • OPEN
  • GET
  • EXTRACT

Questão 12

Questão
Which SQL statement is used to return only different (unique) values?
Responda
  • SELECT DIFFERENT
  • SELECT UNIQUE
  • SELECT DISTINCT
  • SELECT *

Questão 13

Questão
Which SQL keyword is used to sort the result set?
Responda
  • ORDER BY
  • FILTER
  • SORT BY
  • SORT

Questão 14

Questão
If you want to apply a second condition to your statement where both statements must be true, what keyword would you use between the conditions?
Responda
  • AND
  • BOTH
  • TRUE
  • WHERE

Questão 15

Questão
What keyword would you use to group your results by a column's values?
Responda
  • ORDER BY
  • GROUP BY
  • BY
  • JOIN

Questão 16

Questão
What keyword can you use to search for a string in a column?
Responda
  • FIND STRING
  • HAS STRING
  • CONTAINS STRING
  • LIKE

Questão 17

Questão
Which of the following is the correct order of keywords for SQL SELECT statements?
Responda
  • SELECT, FROM, WHERE
  • FROM, WHERE, SELECT
  • WHERE, FROM, SELECT
  • SELECT, WHERE, FROM

Questão 18

Questão
A subquery in an SQL SELECT statement is enclosed in …
Responda
  • parenthesis -- (...).
  • brackets -- [...].
  • CAPITAL LETTERS.
  • braces -- {...}.

Questão 19

Questão
The result of an SQL SELECT statement is a(n) ________ .
Responda
  • report
  • form
  • file
  • table

Questão 20

Questão
In an SQL SELECT statement querying a single table, the asterisk (*) means that …
Responda
  • all columns of the table are to be returned
  • all records meeting the full criteria are to be returned
  • all records with even partial criteria met are to be returned
  • None of the above is correct

Questão 21

Questão
The HAVING clause does which of the following?
Responda
  • Acts EXACTLY like a WHERE clause
  • Acts like a WHERE clause but is used for columns rather than groups
  • Acts like a WHERE clause but is used for groups rather than rows
  • Acts like a WHERE clause but is used for rows rather than columns

Questão 22

Questão
LIKE operator uses ___ and ___ .
Responda
  • asterisk (*) ; percent sign (%)
  • question mark (?) ; asterisk (*)
  • percent sign (%) ; underscore ( _ )
  • underscore ( _ ) ; question mark (?)

Questão 23

Questão
What SQL structure is used to limit column values of a table?
Responda
  • The LIMIT constraint
  • The CHECK constraint
  • The VALUE constraint
  • None of the above is correct

Questão 24

Questão
What operator tests column for the absence of data?
Responda
  • NOT operator
  • IS NULL operator
  • EXISTS operator
  • All of the above

Questão 25

Questão
What is the meaning of LIKE '%0%0%' ?
Responda
  • Feature has two 0's in it, at any position
  • Feature begins with two 0's
  • Feature has more than two 0's
  • Feature ends with two 0's

Questão 26

Questão
The _______ operator returns all tuples in one relation that are not found in the other relation.
Responda
  • Select
  • None
  • Intersect
  • Difference

Questão 27

Questão
What is meant by the following relational algebra statement: STUDENT X GROUP ?
Responda
  • Compute the left outer join between the STUDENT and GROUP relations
  • Compute the full outer join between the STUDENT and GROUP relations
  • Compute the cartesian product between the STUDENT and GROUP relations
  • Compute the right outer join between the STUDENT and GROUP relations

Questão 28

Questão
What is meant by the term union compatibility?
Responda
  • None
  • When two or more tables share the same (or compatible) domains
  • When two or more tables share the same number of columns and when they share the same domains
  • When two or more tables share the same number of columns

Questão 29

Questão
Which of the following is used to denote the selection operation in relational algebra?
Responda
  • Pi (Greek)
  • Sigma (Greek)
  • Lambda (Greek)
  • Omega (Greek)

Questão 30

Questão
Which product is returned in a join query have no join condition?
Responda
  • None
  • Equijoins
  • Both
  • Cartesian

Questão 31

Questão
The ____________ operator combines all tuples from two relations excluding duplicates.
Responda
  • Intersect
  • Difference
  • Union
  • Divide

Questão 32

Questão
Which of the following is used to denote the projection operation in relational algebra?
Responda
  • Pi (Greek)
  • Sigma (Greek)
  • Lambda (Greek)
  • Omega (Greek)

Questão 33

Questão
_______ specifies a search condition for a group or an aggregate function.
Responda
  • GROUP BY clause
  • HAVING clause
  • FROM clause
  • WHERE clause

Questão 34

Questão
The command to remove rows from CUSTOMER table is …
Responda
  • DROP FROM CUSTOMER ...
  • UPDATE FROM CUSTOMER ...
  • REMOVE FROM CUSTOMER ...
  • DELETE FROM CUSTOMER WHERE ...

Questão 35

Questão
DML is used to …
Responda
  • manipulate the structure of database applications
  • add and delete tables
  • add / modify / delete data in the database
  • specify the structure of a database

Questão 36

Questão
Identify the characteristic(s) of transactions
Responda
  • Atomicity
  • Durability
  • Isolation
  • All of the mentioned

Questão 37

Questão
The ______ statement is used to end a successful transaction.
Responda
  • COMMIT TRANSACTION
  • ROLLBACK TRANSACTION
  • COMMIT WORK
  • All of the mentioned

Questão 38

Questão
DCL stands for …
Responda
  • Data Control Language
  • Data Console Language
  • Data Console Level
  • Data Control Level

Questão 39

Questão
Types of update anomalies are … (NF)
Responda
  • ц
  • у

Questão 40

Questão
Types of functional dependencies are …(NF)
Responda
  • w
  • 2

Questão 41

Questão
TCL stands for …
Responda
  • Transaction control language
  • Transaction command language
  • Transaction connect language
  • None of the given

Questão 42

Questão
UNIQUE constraint allows to create .. (NF)
Responda
  • 4
  • 5

Questão 43

Questão
Types of JOIN statement are ... (NF)
Responda
  • INNER JOIN
  • OUTER JOIN (LEFT, RIGHT, FULL JOIN)
  • CROSS JOIN
  • All of the mentioned

Questão 44

Questão
The statement to create a new user is …
Responda
  • w
  • 2

Questão 45

Questão
The column of a table is referred to as the …
Responda
  • Entity
  • Degree
  • Tuple
  • Attribute

Questão 46

Questão
The another name for a row is …
Responda
  • Attribute
  • Tuple
  • Degree
  • Entity

Questão 47

Questão
A primary key for an entity is
Responda
  • A relationship
  • A tuple
  • A unique attribute
  • Any attribute

Questão 48

Questão
In ER Diagram by Chen’s notation a relationship type is represented by …
Responda
  • Diamond (rhombus)
  • Rectangle
  • Ellipse
  • Dashed ellipse

Questão 49

Questão
Key to represent relationship between tables is called :
Responda
  • Primary Key
  • Foreign Key
  • Secondary Key
  • None of these

Questão 50

Questão
An entity relationship diagram is a tool to represent … (NF)
Responda
  • ?
  • 3

Questão 51

Questão
The FD X -> Y is a full dependency in a relation R, if there is _____ attribute A that can be _____ X and the dependency still holds.
Responda
  • No, removed from
  • At least one, removed from
  • At least one, added to
  • No, added to

Questão 52

Questão
Through normalization, data redundancy …
Responda
  • can be eliminated
  • can be maximized
  • can be minimized, but not eliminated
  • are usually left unchanged

Questão 53

Questão
Through normalization, update anomalies …
Responda
  • Can be eliminated
  • Can be maximized
  • Are usually unchanged
  • Can be minimized, but not eliminated

Questão 54

Questão
For a relation to be in 3NF, it should not contain _____ attribute that is transitively dependent on _____.
Responda
  • a primary key, a foreign key
  • a non-primary key, a foreign key
  • a non-primary key, the primary key
  • a primary key, a non-primary key

Questão 55

Questão
For a relation to be in 2NF, _____ attribute must be fully functionally dependent on _____.
Responda
  • every non-primary key, the primary key
  • every alternate key, the primary key
  • every non-key, every key
  • every non-key, at least one key

Questão 56

Questão
Which normal form is considered “good” for relational database design?
Responda
  • 3NF
  • 2NF
  • 1NF
  • 4NF

Questão 57

Questão
A relation in which the intersection of each row and column contains one and only one value is said to be in
Responda
  • 3NF
  • 2NF
  • 1NF
  • 4NF

Questão 58

Questão
Table is synonymous with the term …
Responda
  • Record
  • Column
  • Field
  • Relation

Questão 59

Questão
If a relation scheme is in 3NF then it is also in …
Responda
  • 2NF
  • 4NF
  • 5NF
  • None of these

Questão 60

Questão
A functional dependency is a relationship between or among:
Responda
  • Tables
  • Relations
  • Rows
  • Attributes

Questão 61

Questão
In an ER diagram an entity is represented by a …
Responda
  • Rectangle
  • Ellipse
  • Circle
  • Diamond box

Questão 62

Questão
In an ER diagram by Chen’s notation attributes are represented by …
Responda
  • Rectangle
  • Square
  • Ellipse
  • Triangle

Questão 63

Questão
Who proposed the relational model?
Responda
  • Bill Gates
  • Charles Babbage
  • E. F. Codd
  • Herman Hollerith

Questão 64

Questão
Phases of a database development are …
Responda
  • Logical Design
  • Conceptual Design
  • Physical Design
  • All of these

Questão 65

Questão
A goal of normalization is …
Responda
  • Minimize the number of relationships
  • Minimize the number of tables
  • Minimize the number of entities
  • Minimize the number of redundancy
  • None of these

Questão 66

Questão
A table in 1NF in which the unique candidate key consists of two of its three attributes:
Responda
  • Always violates 2NF
  • Never violates 2NF
  • May violate 2NF
  • None of the above

Questão 67

Questão
Database is a collection of … (NF)
Responda
  • w
  • 2

Questão 68

Questão
DBMS stands for …
Responda
  • None of these
  • Database Administrator System
  • Database Basic Management System
  • Database Management System

Questão 69

Questão
Normalization is ...
Responda
  • the process of adding primary key to a table
  • the process of arranging information stored in a database in a way, which redundancy and ambiguity
  • a special way of selecting data
  • none of these

Questão 70

Questão
What does SQL stand for?
Responda
  • Standard Query Language
  • Structured Query Language
  • Strict Query Language
  • Strong Query Language

Questão 71

Questão
Which language is used to specify database structure?
Responda
  • Data Manipulation Language
  • Data Management Language
  • Data Definition Language
  • Data Development Language

Questão 72

Questão
The statement in SQL which allows to change the structure of a table is …
Responda
  • SELECT
  • ALTER
  • CREATE
  • UPDATE

Questão 73

Questão
The SQL DROP TABLE clause is used to ...
Responda
  • create a new table in the database
  • modify an existing table in a database
  • delete a table from the database
  • none of these

Questão 74

Questão
Determine the primary key by description of the table: Students (stud_id, lname, fname, bdate)
Image:
Screenshot 10 (binary/octet-stream)
Responda
  • stud_id
  • lname
  • fname
  • bdate

Questão 75

Questão
Determine the type of the relationship between Students and Groups entities by its description: “One student can be enrolled only in one group, and from the other side one group contains many students” (NF)
Responda
  • One-to-One
  • One-to-Many
  • Many-to-Many
  • None of these

Quer criar seus próprios Quizzes gratuitos com a GoConqr? Saiba mais.

Semelhante

reading test 9 form
svetlana.gainano
CHINA
Alessandra S.
Os cinco mandamentos da inteligência emocional
Giselle Benzaquen
Gramática - Visão Geral - Fonologia
tiago meira de almeida
Lei 8666
Rômulo Campos
Apresentação em Inglês
GoConqr suporte .
Artigo Científico - estrutura
alineadc
História da Arte
GoConqr suporte .
FCE Opposites Practice
titaleoni
Avaliação de Alunos
Alessandra S.
Liderança Militar - Exercício 2
Ibsen Rodrigues Maciel
Explore a Biblioteca