DBS4

Which of the following is the original purpose of SQL? A. To specify the syntax and semantics of SQL data definition language B. To specify the syntax and semantics of SQL manipulation language C. To define the data structures D. All of the above.

ALL OF THE ABOVE

The command to remove rows from a table 'CUSTOMER' is: A. REMOVE FROM CUSTOMER ... B. DROP FROM CUSTOMER ... C. DELETE FROM CUSTOMER WHERE ... D. UPDATE FROM CUSTOMER ...

DELETE FROM CUSTOMER WHERE ...

To remove duplicate rows from the results of an SQL SELECT statement, the ________ qualifier specified must be included. A. ONLY B. UNIQUE C. DISTINCT

DISTINCT

SQL query and modification commands make up a(n) ________ . A. DDL B. DML C. HTML D. XML

DML

The command to eliminate a table from a database is: A. REMOVE TABLE CUSTOMER; B. DROP TABLE CUSTOMER; C. DELETE TABLE CUSTOMER; D. UPDATE TABLE CUSTOMER;

DROP TABLE CUSTOMER;

ON UPDATE CASCADE ensures which of the following? A. Normalization B. Data Integrity C. Materialized Views D. All of the above.

Data Integrity

To sort the results of a query use: A. SORT BY. B. GROUP BY. C. ORDER BY. D. None of the above is correct.

ORDER BY

Which one of the following sorts rows in SQL? A. SORT BY B. ALIGN BY C. ORDER BY D. GROUP BY

ORDER BY

Oracle RAC ____ is an application that adds to Oracle RAC by including the ability to integrate multiple databases into one cluster, further enhancing the scalability and fault tolerance of the architecture. a.One String b.One Nod c.Compression d.Cache

One Nod

The ____ Index Scans feature allows simultaneous full-index scans and reads of data blocks, increasing the response times for data manipulation and retrieval. a.Full b.Complete c.Concurrent d.Parallel

Parallel

It is in the ____ that the system stores space for users' connections, query executions, and SQL statements reused by the system. a.RAM b.CPU c.processor d.hard disk

RAM

____ consistency refers to the accuracy and reliability of data within a database. a.Store b.Backup c.Object d.Read

Read

The benefits of a standard relational language include which of the following? A. Reduced training costs B. Increased dependence on a single vendor C. Applications are not needed .D. All of the above.

Reduced training costs

The SQL statement that queries or reads data from a table is ________ . A. SELECT B. READ C. QUERY D. None of the above is correct.

SELECT

A subquery in an SQL SELECT statement is enclosed in: A. braces -- {...}. B. CAPITAL LETTERS. C. parenthesis -- (...) . D. brackets -- [...].

parenthesis -- (...) .

The SQL -92 wildcards are ____ and ____ . A. asterisk (*); percent sign (%) B. percent sign (%); underscore (_) C. underscore(_); question mark (?) D. question mark (?); asterisk (*)

percent sign (%); underscore (_)

A security audit tests to ensure that the proper ____ and procedures are in place to handle a potential vulnerability. a.people b.resources c.policies d.logs

policies

The Microsoft Access wildcards are ____ and ____ . A. asterisk (*); percent sign (%) B. percent sign (%); underscore (_) C. underscore(_); question mark (?) D. question mark (?); asterisk (*)

question mark (?); asterisk (*)

To define what columns should be displayed in an SQL SELECT statement: A. use FROM to name the source table(s) and list the columns to be shown after SELECT. B. use USING to name the source table(s) and list the columns to be shown after SELECT. C. use SELECT to name the source table(s) and list the columns to be shown after USING. D. use USING to name the source table(s) and list the columns to be shown after WHERE.

use FROM to name the source table(s) and list the columns to be shown after SELECT

The most common way to prepare an application to detect injections is to ensure that the application ____ the data being received by the user before sending it to the database. a.encrypts b.validates c.encapsulates d.authorizes

validates

The HAVING clause does which of the following? A. Acts like a WHERE clause but is used for groups rather than rows. B. Acts like a WHERE clause but is used for rows rather than columns. C. Acts like a WHERE clause but is used for columns rather than groups. D. Acts EXACTLY like a WHERE clause.

Acts like a WHERE clause but is used for groups rather than rows.

SQL can be used to: A. create database structures only. B. query database data only. C. modify database data only. D. All of the above can be done by SQL.

All of the above can be done by SQL.

Which of the following do you need to consider when you make a table in SQL? A. Data types B. Primary keys C. Default values D. All of the above.

All of the above.

The SQL keyword(s) ________ is used with wildcards. A. LIKE only B. IN only C. NOT IN only D. IN and NOT IN

LIKE only

A view is which of the following?A. A virtual table that can be accessed via SQL commands B. A virtual table that cannot be accessed via SQL commands C. A base table that can be accessed via SQL commands D. A base table that cannot be accessed via SQL commands

A virtual table that can be accessed via SQL commands

The wildcard in a WHERE clause is useful when? A. An exact match is necessary in a SELECT statement. B. An exact match is not possible in a SELECT statement. C. An exact match is necessary in a CREATE statement. D. An exact match is not possible in a CREATE statement.

An exact match is not possible in a SELECT statement.

When three or more AND and OR conditions are combined, it is easier to use the SQL keyword(s): A. LIKE only. B. IN only. C. NOT IN only. D. Both IN and NOT IN.

Both IN and NOT IN.

SQL data definition commands make up a(n) ________ . A. DDL B. DML C. HTML D. XML

DDL

Which of the following are the five built-in functions provided by SQL? A. COUNT, SUM, AVG, MAX, MIN B. SUM, AVG, MIN, MAX, MULT C. SUM, AVG, MULT, DIV, MIN D. SUM, AVG, MIN, MAX, NAME

COUNT, SUM, AVG, MAX, MIN

Which of the following is valid SQL for an Index? A. CREATE INDEX ID; B. CHANGE INDEX ID; C. ADD INDEX ID; D. REMOVE INDEX ID;

CREATE INDEX ID;

What procedures should take place to restore a system and its data files after system failure? a.Implement recovery procedures b.Restore from storage media backup c.Perform a parallel test d.Perform a walk-through test

Implement recovery procedures

Mixed Mode Authentication is the recommended authentication mode for SQL Server

FALSE

You can add a row using SQL in a database with which of the following? A. ADD B. CREATE C. INSERT D. MAKE

INSERT

Find the SQL statement below that is equal to the following: SELECT NAME FROM CUSTOMER WHERE STATE = 'VA'; A. SELECT NAME IN CUSTOMER WHERE STATE IN ('VA'); B. SELECT NAME IN CUSTOMER WHERE STATE = 'VA'; C. SELECT NAME IN CUSTOMER WHERE STATE = 'V'; D. SELECT NAME FROM CUSTOMER WHERE STATE IN ('VA');

SELECT NAME FROM CUSTOMER WHERE STATE IN ('VA');

Which of the following is the correct order of keywords for SQL SELECT statements? A. SELECT, FROM, WHERE B. FROM, WHERE, SELECT C. WHERE, FROM,SELECT D. SELECT,WHERE,FROM

SELECT, FROM, WHERE

________ was adopted as a national standard by ANSI in 1992. A. Oracle B. SQL C. Microsoft Access D. DBase

SQL

Many organizations cannot pay the price for a fully integrating Oracle solution that spans every level of the business architecture

TRUE

MySQL is an open-source application

TRUE

The query engine is the component of the architecture that optimizes and manages queries and SQL statements

TRUE

The result of a SQL SELECT statement is a(n) ________ . A. report B. form C. file D. table

Table

SQL is: A. a programming language. B. an operating system C. a data sublanguage. D. a DBMS.

a data sublanguage.

In an SQL SELECT statement querying a single table, according to the SQL-92 standard the asterisk (*) means that: A. all columns of the table are to be returned. B. all records meeting the full criteria are to be returned. C. all records with even partial criteria met are to be returned. D. None of the above is correct.

all columns of the table are to be returned

WEP ____ are software applications that are used to decrypt WEP keys. a.loggers b.sniffers c.crackers d.jumpers

crackers

In the ____ meeting, the auditor or committee of auditors communicates verbally and in writing the results of the audit. a.results b.channel c.perimeter d.debriefing

debriefing

The SQL keyword BETWEEN is used: A. for ranges. B. to limit the columns displayed. C. as a wildcard. D. None of the above is correct.

for ranges.

A subquery in an SQL SELECT statement: A. can only be used with two tables. B. can always be duplicated by a join. C. has a distinct form that cannot be duplicated by a join D. cannot have its results sorted using ORDER BY.

has a distinct form that cannot be duplicated by a join.

On the ____ page window, you will find the launch tools to begin stand-alone installation, to start a failover cluster installation, and to add a node for failover cluster installations. a.starting b.installation c.launch d.setup

installation

The SQL WHERE clause: A. limits the column data that are returned. B. limits the row data are returned. C. Both A and B are correct. D. Neither A nor B are correct.

limits the row data are returned

The ____ relationship is the ideal type of relationship withina relational database schema. a.one-to-one b.one-to-many c.many-to-one d.many-to-many

one-to-many