Database Design [State Exam | 75 questions]

Good Guy Beket
Quiz by Good Guy Beket, updated 8 months ago
277
10
0

Description

State Database Design [Teachers: Kozina Lyudmila, Alshynov Chyngiz | FINAL EXAM + STATE EXAM ] ▼ (State Exam) Quiz on Database Design [State Exam | 75 questions], created by Good Guy Beket on 02/25/2019.
Tags No tags specified

Resource summary

Question 1

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

Question 2

Question
SQL aggregate functions are …
Answer
  • MIN, MAX, AVG, COUNT, SUM
  • SUM, AVG, MULT, DIV, MIN
  • SUM, AVG, MIN, MAX, MULT
  • SUM, AVG, MIN, MAX, NAME

Question 3

Question
Which SQL keyword is used to specify conditional search?
Answer
  • HAVING
  • WHERE
  • SELECT
  • FIND

Question 4

Question
The AVG SQL function returns the ...
Answer
  • The sum of values in a column
  • Average in the values in a group.
  • Maximum value from a column.

Question 5

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

Question 6

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

Question 7

Question
Which SQL keyword is used to retrieve a maximum value?
Answer
  • UPPER
  • MOST
  • TOP
  • MAX

Question 8

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

Question 9

Question
Which SQL functions is used to count the number of rows?
Answer
  • COUNT ( )
  • NUMBER ( )
  • SUM ( )
  • COUNTOF ( )

Question 10

Question
What is the purpose of the SQL AS clause?
Answer
  • 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

Question 11

Question
Which SQL statement is used to extract data from a database?
Answer
  • SELECT
  • OPEN
  • GET
  • EXTRACT

Question 12

Question
Which SQL statement is used to return only different (unique) values?
Answer
  • SELECT DIFFERENT
  • SELECT UNIQUE
  • SELECT DISTINCT
  • SELECT *

Question 13

Question
Which SQL keyword is used to sort the result set?
Answer
  • ORDER BY
  • FILTER
  • SORT BY
  • SORT

Question 14

Question
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?
Answer
  • AND
  • BOTH
  • TRUE
  • WHERE

Question 15

Question
What keyword would you use to group your results by a column's values?
Answer
  • ORDER BY
  • GROUP BY
  • BY
  • JOIN

Question 16

Question
What keyword can you use to search for a string in a column?
Answer
  • FIND STRING
  • HAS STRING
  • CONTAINS STRING
  • LIKE

Question 17

Question
Which of the following is the correct order of keywords for SQL SELECT statements?
Answer
  • SELECT, FROM, WHERE
  • FROM, WHERE, SELECT
  • WHERE, FROM, SELECT
  • SELECT, WHERE, FROM

Question 18

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

Question 19

Question
The result of an SQL SELECT statement is a(n) ________ .
Answer
  • report
  • form
  • file
  • table

Question 20

Question
In an SQL SELECT statement querying a single table, the asterisk (*) means that …
Answer
  • 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

Question 21

Question
The HAVING clause does which of the following?
Answer
  • 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

Question 22

Question
LIKE operator uses ___ and ___ .
Answer
  • asterisk (*) ; percent sign (%)
  • question mark (?) ; asterisk (*)
  • percent sign (%) ; underscore ( _ )
  • underscore ( _ ) ; question mark (?)

Question 23

Question
What SQL structure is used to limit column values of a table?
Answer
  • The LIMIT constraint
  • The CHECK constraint
  • The VALUE constraint
  • None of the above is correct

Question 24

Question
What operator tests column for the absence of data?
Answer
  • NOT operator
  • IS NULL operator
  • EXISTS operator
  • All of the above

Question 25

Question
What is the meaning of LIKE '%0%0%' ?
Answer
  • 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

Question 26

Question
The _______ operator returns all tuples in one relation that are not found in the other relation.
Answer
  • Select
  • None
  • Intersect
  • Difference

Question 27

Question
What is meant by the following relational algebra statement: STUDENT X GROUP ?
Answer
  • 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

Question 28

Question
What is meant by the term union compatibility?
Answer
  • 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

Question 29

Question
Which of the following is used to denote the selection operation in relational algebra?
Answer
  • Pi (Greek)
  • Sigma (Greek)
  • Lambda (Greek)
  • Omega (Greek)

Question 30

Question
Which product is returned in a join query have no join condition?
Answer
  • None
  • Equijoins
  • Both
  • Cartesian

Question 31

Question
The ____________ operator combines all tuples from two relations excluding duplicates.
Answer
  • Intersect
  • Difference
  • Union
  • Divide

Question 32

Question
Which of the following is used to denote the projection operation in relational algebra?
Answer
  • Pi (Greek)
  • Sigma (Greek)
  • Lambda (Greek)
  • Omega (Greek)

Question 33

Question
_______ specifies a search condition for a group or an aggregate function.
Answer
  • GROUP BY clause
  • HAVING clause
  • FROM clause
  • WHERE clause

Question 34

Question
The command to remove rows from CUSTOMER table is …
Answer
  • DROP FROM CUSTOMER ...
  • UPDATE FROM CUSTOMER ...
  • REMOVE FROM CUSTOMER ...
  • DELETE FROM CUSTOMER WHERE ...

Question 35

Question
DML is used to …
Answer
  • manipulate the structure of database applications
  • add and delete tables
  • add / modify / delete data in the database
  • specify the structure of a database

Question 36

Question
Identify the characteristic(s) of transactions
Answer
  • Atomicity
  • Durability
  • Isolation
  • All of the mentioned

Question 37

Question
The ______ statement is used to end a successful transaction.
Answer
  • COMMIT TRANSACTION
  • ROLLBACK TRANSACTION
  • COMMIT WORK
  • All of the mentioned

Question 38

Question
DCL stands for …
Answer
  • Data Control Language
  • Data Console Language
  • Data Console Level
  • Data Control Level

Question 39

Question
Types of update anomalies are … (NF)
Answer
  • ц
  • у

Question 40

Question
Types of functional dependencies are …(NF)
Answer
  • w
  • 2

Question 41

Question
TCL stands for …
Answer
  • Transaction control language
  • Transaction command language
  • Transaction connect language
  • None of the given

Question 42

Question
UNIQUE constraint allows to create .. (NF)
Answer
  • 4
  • 5

Question 43

Question
Types of JOIN statement are ... (NF)
Answer
  • INNER JOIN
  • OUTER JOIN (LEFT, RIGHT, FULL JOIN)
  • CROSS JOIN
  • All of the mentioned

Question 44

Question
The statement to create a new user is …
Answer
  • w
  • 2

Question 45

Question
The column of a table is referred to as the …
Answer
  • Entity
  • Degree
  • Tuple
  • Attribute

Question 46

Question
The another name for a row is …
Answer
  • Attribute
  • Tuple
  • Degree
  • Entity

Question 47

Question
A primary key for an entity is
Answer
  • A relationship
  • A tuple
  • A unique attribute
  • Any attribute

Question 48

Question
In ER Diagram by Chen’s notation a relationship type is represented by …
Answer
  • Diamond (rhombus)
  • Rectangle
  • Ellipse
  • Dashed ellipse

Question 49

Question
Key to represent relationship between tables is called :
Answer
  • Primary Key
  • Foreign Key
  • Secondary Key
  • None of these

Question 50

Question
An entity relationship diagram is a tool to represent … (NF)
Answer
  • ?
  • 3

Question 51

Question
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.
Answer
  • No, removed from
  • At least one, removed from
  • At least one, added to
  • No, added to

Question 52

Question
Through normalization, data redundancy …
Answer
  • can be eliminated
  • can be maximized
  • can be minimized, but not eliminated
  • are usually left unchanged

Question 53

Question
Through normalization, update anomalies …
Answer
  • Can be eliminated
  • Can be maximized
  • Are usually unchanged
  • Can be minimized, but not eliminated

Question 54

Question
For a relation to be in 3NF, it should not contain _____ attribute that is transitively dependent on _____.
Answer
  • 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

Question 55

Question
For a relation to be in 2NF, _____ attribute must be fully functionally dependent on _____.
Answer
  • 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

Question 56

Question
Which normal form is considered “good” for relational database design?
Answer
  • 3NF
  • 2NF
  • 1NF
  • 4NF

Question 57

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

Question 58

Question
Table is synonymous with the term …
Answer
  • Record
  • Column
  • Field
  • Relation

Question 59

Question
If a relation scheme is in 3NF then it is also in …
Answer
  • 2NF
  • 4NF
  • 5NF
  • None of these

Question 60

Question
A functional dependency is a relationship between or among:
Answer
  • Tables
  • Relations
  • Rows
  • Attributes

Question 61

Question
In an ER diagram an entity is represented by a …
Answer
  • Rectangle
  • Ellipse
  • Circle
  • Diamond box

Question 62

Question
In an ER diagram by Chen’s notation attributes are represented by …
Answer
  • Rectangle
  • Square
  • Ellipse
  • Triangle

Question 63

Question
Who proposed the relational model?
Answer
  • Bill Gates
  • Charles Babbage
  • E. F. Codd
  • Herman Hollerith

Question 64

Question
Phases of a database development are …
Answer
  • Logical Design
  • Conceptual Design
  • Physical Design
  • All of these

Question 65

Question
A goal of normalization is …
Answer
  • Minimize the number of relationships
  • Minimize the number of tables
  • Minimize the number of entities
  • Minimize the number of redundancy
  • None of these

Question 66

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

Question 67

Question
Database is a collection of … (NF)
Answer
  • w
  • 2

Question 68

Question
DBMS stands for …
Answer
  • None of these
  • Database Administrator System
  • Database Basic Management System
  • Database Management System

Question 69

Question
Normalization is ...
Answer
  • 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

Question 70

Question
What does SQL stand for?
Answer
  • Standard Query Language
  • Structured Query Language
  • Strict Query Language
  • Strong Query Language

Question 71

Question
Which language is used to specify database structure?
Answer
  • Data Manipulation Language
  • Data Management Language
  • Data Definition Language
  • Data Development Language

Question 72

Question
The statement in SQL which allows to change the structure of a table is …
Answer
  • SELECT
  • ALTER
  • CREATE
  • UPDATE

Question 73

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

Question 74

Question
Determine the primary key by description of the table: Students (stud_id, lname, fname, bdate)
Answer
  • stud_id
  • lname
  • fname
  • bdate

Question 75

Question
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)
Answer
  • One-to-One
  • One-to-Many
  • Many-to-Many
  • None of these
Show full summary Hide full summary

Suggestions

reading test 9 form
svetlana.gainano
OCR GCSE Latin Vocab flash cards - all
jess99
GSCE Geography Unit 2 Human
crazytomguy
TYPES OF DATA
Elliot O'Leary
Cold War Causes Revision
Tom Mitchell
Animal Farm Chapter Overview
10jgorman
Certification Prep_1
Tonya Franklin
exchange midterm
maxwell3254
Japanese, basic phrases
vickiwauq
AS English language terminology revision
Caitlin Hadfield
BM 13 - COMENIUS, HERBART, DEWEY, HÖNIGSWALD
christoph wimmer