Copy and Edit

Database Design [State Exam | 75 questions]

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 25/02/2019.
Good Guy Beket
Quiz by Good Guy Beket, updated more than 1 year ago
Good Guy Beket
Created by Good Guy Beket over 5 years ago
473
11
0

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)
Image:
Screenshot 10 (binary/octet-stream)
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

Want to create your own Quizzes for free with GoConqr? Learn more.

Similar

reading test 9 form
svetlana.gainano
Geography Quiz
PatrickNoonan
Quiz Geral
miminoma
Diffusion and osmosis
eimearkelly3
English Language
livbennett
Cells, Tissues and Organs
yusanr98
LOGARITHMS
pelumi opabisi
Revision Timetable
katy.lay
Mind Maps with GoConqr
croconnor
Improve your Learning using GoConqr
Micheal Heffernan
What are they doing?
Tamara Urzhumova
Browse Library