C192 Practice Test

Descrição

College C192 Databases Quiz sobre C192 Practice Test, criado por Craig Willey em 27-06-2020.
Craig Willey
Quiz por Craig Willey, atualizado more than 1 year ago
Craig Willey
Criado por Craig Willey mais de 4 anos atrás
11
0

Resumo de Recurso

Questão 1

Questão
Which of the following is a benefit of using a DBMS?
Responda
  • They provide full security to data using private/public key encryption
  • They create automatic backups
  • They help create an environment for end users to have access to more data
  • They provide seamless Internet access to database data

Questão 2

Questão
The hierarchical database model is based on a ____.
Responda
  • tree structure
  • lack of a parent segment
  • lack of a child segment
  • matrix

Questão 3

Questão
Because an RDBMS hides the system's complexity from the user/designer, ____.
Responda
  • it does not exhibit data independence
  • it does not exhibit structural independence
  • data management is easier
  • data management is very difficult

Questão 4

Questão
The ERD is used to graphically represent the ____ database model.
Responda
  • condensed
  • physical
  • logical
  • conceptual

Questão 5

Questão
The property of ____ enables an entity subtype to inherit the attributes and relationships of the supertype.
Responda
  • subtype discriminator
  • inheritance
  • specialization hierarchy
  • entity supertype

Questão 6

Questão
At the implementation level, the supertype and its subtype(s) depicted in the specialization hierarchy maintain a ____ relationship.
Responda
  • none
  • 1:1
  • 1:M
  • M:N

Questão 7

Questão
Which command would be used to delete the table row where the P_Code = '2238/QPD'?
Responda
  • DELETE FROM PRODUCT WHERE P_CODE = '2238/QPD';
  • REMOVE FROM PRODUCT WHERE P_CODE = '2238/QPD';
  • ERASE FROM PRODUCT WHERE P_CODE = '2238/QPD';
  • ROLLBACK FROM PRODUCT WHERE P_CODE = '2238/QPD';

Questão 8

Questão
Which command is used to select partial table contents?
Responda
  • SELECT <column(s)> FROM <Table name> WHERE <Item>;
  • LIST <column(s)> FROM <Table name> WHERE <Conditions>;
  • SELECT <column(s)> FROM <Table name> WHERE <Conditions>;
  • LIST<column(s)> FROM <Table name> WHERE <Item>;

Questão 9

Questão
Which query will output the table contents when the value of V_CODE is equal to 21344?
Responda
  • SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE FROM PRODUCT WHERE V_CODE <> 21344;
  • SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE FROM PRODUCT WHERE V_CODE <= 21344;
  • SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE FROM PRODUCT WHERE V_CODE = 21344;
  • SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE FROM PRODUCT WHERE V_CODE => 21344;

Questão 10

Questão
What is the command used to list the P_CODE, P_DESCRIPT, P_INDATE, and P_PRICE fields from the Product table in ascending order by P_PRICE?
Responda
  • SELECT P_CODE, P_DESCRIPT, P_INDATE, P_PRICE FROM PRODUCT SEQUENCE BY P_PRICE;
  • SELECT P_CODE, P_DESCRIPT, P_INDATE, P_PRICE FROM PRODUCT LIST BY P_PRICE;
  • SELECT P_CODE, P_DESCRIPT, P_INDATE, P_PRICE FROM PRODUCT ORDER BY P_PRICE;
  • SELECT P_CODE, P_DESCRIPT, P_INDATE, P_PRICE FROM PRODUCT ASCENDING BY P_PRICE;

Questão 11

Questão
The basic SQL aggregate function that gives the total of all values for a selected attribute in a given column is ____.
Responda
  • COUNT
  • MIN
  • MAX
  • SUM

Questão 12

Questão
____ is used to tally the number of specific "values" of an attribute.
Responda
  • SUM
  • TOTAL
  • COUNT
  • ADD

Questão 13

Questão
UPDATE tablename ***** [WHERE conditionlist]; What command replaces the ***** in the above statement?
Responda
  • SET columnname = expression
  • columnname = expression
  • expression = columnname
  • LET columnname = expression

Questão 14

Questão
When using a(n) ____ join, only rows that meet the given criteria are returned.
Responda
  • full
  • inner
  • outer
  • set

Questão 15

Questão
What is the syntax for a left outer join?
Responda
  • SELECT column-list FROM table1 OUTER JOIN table2 LEFT WHERE join-condition
  • SELECT column-list FROM table1 LEFT [OUTER] JOIN table2 ON join-condition
  • SELECT column-list WHERE LEFT table1 = table 2
  • SELECT column-list FROM table1 LEFT table2 [JOIN] WHERE join-condition

Questão 16

Questão
In subquery terminology, the first query in the SQL statement is known as the ____ query.
Responda
  • outer
  • left
  • inner
  • base

Questão 17

Questão
In a subquery, which query is executed first?
Responda
  • Leftmost
  • Rightmost
  • Innermost
  • Outermost

Questão 18

Questão
Creating the conceptual design, selecting DBMS software, creating the logical design, and creating the physical design are part of the ____ phase.
Responda
  • database initial study
  • database design
  • implementation and loading
  • testing and evaluation

Questão 19

Questão
Which of the conceptual design steps defines entities, attributes, and relationships?
Responda
  • Database analysis and requirements
  • Entity relationship modeling and normalization
  • Data model verification
  • Distributed database design

Questão 20

Questão
What is the primary objective of database design?
Responda
  • To create the most efficient database possible
  • To create complete, normalized, non-redundant, and fully integrated conceptual, logical, and physical database models
  • To create the fastest queries
  • To be able to add data quickly

Questão 21

Questão
The most common algorithms for concurrency control are locks, ____ stamping, and optimistic methods.
Responda
  • date
  • time
  • hour
  • minute

Questão 22

Questão
____ requires that all operations of a transaction be completed.
Responda
  • Specificity
  • Atomicity
  • Durability
  • Time stamping

Questão 23

Questão
The ____ establishes the order in which the operations within concurrent transactions are executed.
Responda
  • transaction log
  • timer
  • lock manager
  • scheduler

Questão 24

Questão
When is the implicit beginning of a transaction?
Responda
  • When the database is started
  • When a table is accessed for the first time
  • When the first SQL statement is encountered
  • When the COMMIT command is issued

Questão 25

Questão
A(n) ____ phase in a two-phase lock is when a transaction releases all locks and cannot obtain any new lock.
Responda
  • growing
  • shrinking
  • locking
  • unlocking

Questão 26

Questão
What is a consistent database?
Responda
  • One in which all tables have foreign keys
  • One in which all data integrity constraints are satisfied
  • One in which all tables are normalized
  • One in which all SQL statements only update one table at a time

Questão 27

Questão
A transaction acquires a ____ prior to data access.
Responda
  • grain
  • timestamp
  • lock
  • key

Questão 28

Questão
Changes are permanently applied to the database during the ____ phase of a transaction.
Responda
  • commit
  • write
  • input
  • output

Questão 29

Questão
The phenomenon of ____ occurs when two transactions, T1 and T2, are executed concurrently and the first transaction (T1) is rolled back after the second transaction (T2) has already accessed the uncommitted data—thus violating the isolation property of transactions.
Responda
  • lost updates
  • uncommitted data
  • transaction failure
  • inconsistent retrieval

Questão 30

Questão
____ occur when a transaction calculates some summary (aggregate) functions over a set of data while other transactions are updating the data.
Responda
  • Lost updates
  • Uncommitted data
  • Transaction failures
  • Inconsistent retrievals

Questão 31

Questão
The scheduler facilitates data ____ to ensure that two transactions do not update the same data element at the same time.
Responda
  • durability
  • isolation
  • atomicity
  • serializability

Questão 32

Questão
Which is not a DML statement?
Responda
  • CREATE TABLE
  • SELECT
  • INSERT
  • DELETE

Questão 33

Questão
What feature is a DDBMS disadvantage?
Responda
  • Data is located near the “greatest demand” site
  • Growth facilitation
  • Reduced operating cost
  • Lack of standards

Questão 34

Questão
What feature is a DDBMS advantage?
Responda
  • Greater difficulty in managing the data environment
  • Less danger of a single-point failure
  • Increased training cost
  • Complexity of management and control

Questão 35

Questão
____ distributed database systems integrate different types of centralized DBMSs over a network.
Responda
  • Homogeneous
  • Heterogeneous
  • Fully homogeneous
  • Fully heterogeneous

Questão 36

Questão
____ transparency allows a transaction to update data at several network sites.
Responda
  • Transaction
  • Distribution
  • Failure
  • Performance

Questão 37

Questão
____ transparency ensures that the system will continue to operate in the event of a node failure.
Responda
  • Transaction
  • Distribution
  • Failure
  • Performance

Questão 38

Questão
The ____ contains the description of the entire database as seen by the database administrator.
Responda
  • distributed global dictionary
  • distributed data dictionary
  • distributed global schema
  • distributed data schema

Questão 39

Questão
____ query optimization means that the DDBMS finds the most cost-effective access path without user intervention.
Responda
  • Static
  • Dynamic
  • Automatic
  • Commit

Questão 40

Questão
____ query optimization takes place at execution time.
Responda
  • Automatic
  • Static
  • Manual
  • Dynamic

Questão 41

Questão
A ____ based query optimization algorithm uses statistical information about the database.
Responda
  • statistically
  • dynamic
  • rule
  • manual

Questão 42

Questão
Data ____ refers to the storage of data copies at multiple sites served by a computer network.
Responda
  • replication
  • fragmentation
  • persistence
  • optimization

Questão 43

Questão
To provide better performance, some OLAP systems merge the data warehouse and data mart approaches by storing small extracts of the data warehouse at end user ____.
Responda
  • workstations
  • queries
  • schemas
  • servers

Questão 44

Questão
____ makes a copy of a table and places it in a different location, to improve access time.
Responda
  • Periodicity
  • Aggregation
  • Partitioning
  • Replication

Questão 45

Questão
The ____ schema creates the near equivalent of a multidimensional database schema from the existing relational database.
Responda
  • star
  • square
  • OLAP
  • ROLAP

Questão 46

Questão
Using multidimensional jargon, the ability to focus on slices of the cube to perform a more detailed analysis is known as ____.
Responda
  • star cuts
  • slice and dice
  • microscoping
  • TPL processing

Questão 47

Questão
A ____ is a uniquely identifiable object that allows a given person to log on to the database.
Responda
  • user
  • role
  • profile
  • manager

Questão 48

Questão
Which DDL statement should be used to enforce referential integrity?
Responda
  • CREATE TRIGGER AFTER GRANT
  • CREATE TRIGGER BEFORE UPDATE
  • CREATE TRIGGER BEFORE DROP
  • CREATE TRIGGER AFTER SELECT

Questão 49

Questão
Use the given code to answer the following question: SELECT branchNo, COUNT(staffNo) AS myCount, SUM (salary) AS mySum FROM staff, GROUP BY branchNo ORDER By branchNo; What does this code do?
Responda
  • Orders the staff table by the ascending order of branchNo
  • Orders the staff by ascending order of salary
  • Finds the number of staff and the sum of their salaries in each branch
  • Finds the total number of branches

Questão 50

Questão
Use the give DDL statement to answer the following question: CREATE ASSERTION PhysicianNotOverbooked CHECK (NOT EXISTS (SELECT physician_number FROM scheduled_exams GROUP By physician_number HAVING COUNT (*) > 20)); Which action is this statement performing?
Responda
  • Creating a trigger
  • Creating a stored procedure
  • Creating an index
  • Creating a constraint

Questão 51

Questão
Which DCL Command gives Manager the privilege to SELECT on column AccountBalance of the table Customer?
Responda
  • GRANT SELECT (Customer) ON AccountBalance TO Manager;
  • GRANT SELECT (AccountBalance) ON Customer TO Manager;
  • PERMIT Manager SELECT ON Customer (AccountBalance);
  • ALLOW Manager SELECT AccountBalance FROM Customer;

Questão 52

Questão
Which statement produces a PL/SQL stored procedure?
Responda
  • INSERT OR SET PROCEDURE ProcessReport AS BEGIN SELECT * FROM sales END
  • CREATE OR REPLACE PROCEDURE ProcessReport AS BEGIN SELECT * FROM sales END
  • ADD OR UPDATE PROCEDURE ProcessReport AS BEGIN SELECT * FROM sales END
  • INSERT OR UPDATE PROCEDURE ProcessReport AS BEGIN SELECT * FROM sales END

Semelhante

Português - 3 - Ortografia e acentuação
glenerdourado
FUNÇÕES DA CRIMINOLOGIA.
fcmc2
Prazos – TJ – SP
andre.cuevas
Phrasal Verbs - Inglês #8
Eduardo .
Semântica
GoConqr suporte .
Pré-História
Valdemir Júnior
Psicologia Social Contemporânea
ANDERSON NUNES
Revisão de Química Geral (grandezas físicas, substâncias, misturas, estados físicos, modelos atômicos)
José Silva Santos
Fisiologia Humana
Felipe Penha
Questões SUS - ANVISA
Thiago Ferreira