Question 1

_____ words are words used by SQL to perform specific functions.

Accepted Answer

Reserved

Question 2

How can a table be deleted from the database? Provide an example.

Accepted Answer

A table can be deleted from the database using the DROP TABLE command.For example, a user can delete the PART table with the following command:
DROP TABLE PART;
The user can drop a table only if it is not the "one" side of any relationship.If the user tries to drop a table otherwise, the RDBMS will generate an error message indicating that a foreign key integrity violation has occurred.

Question 3

A(n) _____ view is a view that can be used to update attributes in the base table(s) that are used in the view.

Accepted Answer

updatable

Question 4

The SQL data type DATE stores date in the _____ date format.

Accepted Answer

The answer of The SQL data type DATE stores date...

Question 5

Which statement describes a feature of Oracle sequences?

Accepted Answer

A)  Oracle sequences are tied to columns and tables. 
B)  Oracle sequences generate a character string that can be assigned to tables. 
C)  An Oracle sequence uses the identity column property to automatically number rows. 
D)  Dropping a sequence does not delete values assigned to table attributes; it deletes only the sequence object from the database. 
A)  Oracle sequences are tied to columns and tables. 
B)  Oracle sequences generate a character string that can be assigned to tables. 
C)  An Oracle sequence uses the identity column property to automatically number rows. 
D)  Dropping a sequence does not delete values assigned to table attributes; it deletes only the sequence object from the database.

Question 6

The _____ command permanently saves all changes-such as rows added, attributes modified, and rows deleted-made to any table in the database.

Accepted Answer

A)  COMMIT 
B)  SELECT 
C)  ROLLBACK 
D)  UPDATE 
A)  COMMIT 
B)  SELECT 
C)  ROLLBACK 
D)  UPDATE

Question 7

The most useful feature of PL/SQL blocks is that they let a designer create code that can be named, stored, and executed by the DBMS.

Accepted Answer

A) True 
 B)False

Question 8

The _____ specification creates an individualindex ona respective attribute; use it to avoid having duplicated values in a column.

Accepted Answer

A)  UNIQUE 
B)  NOT NULL 
C)  UPDATE 
D)  VARCHAR 
A)  UNIQUE 
B)  NOT NULL 
C)  UPDATE 
D)  VARCHAR

Question 9

Which command would be used to delete the table row where the P_CODE is 'BRT-345'?

Accepted Answer

A)  DELETE FROM      PRODUCT
WHERE                   P_CODE = 'BRT-345'; 
B)  REMOVE FROM PRODUCT
WHERE P_CODE = 'BRT-345'; 
C)  ERASE FROM        PRODUCT
WHERE                   P_CODE = 'BRT-345'; 
D)  ROLLBACK FROM   PRODUCT
WHERE                      P_CODE = 'BRT-345'; 
A)  DELETE FROM      PRODUCT
WHERE                   P_CODE = 'BRT-345'; 
B)  REMOVE FROM PRODUCT
WHERE P_CODE = 'BRT-345'; 
C)  ERASE FROM        PRODUCT
WHERE                   P_CODE = 'BRT-345'; 
D)  ROLLBACK FROM   PRODUCT
WHERE                      P_CODE = 'BRT-345';

Question 10

All changes in a table structure are made using the _____ TABLE command, followed by a keyword that produces the specific changes a user wants to make.

Accepted Answer

A)  ALTER 
B)  COMMIT 
C)  UPDATE 
D)  ROLLBACK 
A)  ALTER 
B)  COMMIT 
C)  UPDATE 
D)  ROLLBACK

Question 11

_____ is the term used to describe an environment in which the SQL statement is not known in advance and is generated at run time.

Accepted Answer

The answer of _____ is the term used to describe...

Question 12

In Oracle, you can use the SQL*Plus command SHOW ERRORS to help you diagnose errors found in PL/SQL blocks.

Accepted Answer

A) True 
 B)False

Question 13

A view is a virtual table based on a SELECT query.

Accepted Answer

A) True 
 B)False

Question 14

Summarize the hierarchy of steps involved in creating and running an executable program with embedded SQL statements.

Accepted Answer

While the steps required to create and e

Question 15

Words used by a system that cannot be used for any other purpose are called _____ words. For example, in Oracle SQL, the word INITIAL cannot be used to name tables or columns.

Accepted Answer

A)  reserved 
B)  unique 
C)  null 
D)  character 
A)  reserved 
B)  unique 
C)  null 
D)  character

Question 16

In Oracle, _____ retrieves the current value of a sequence.

Accepted Answer

A)  NEXTVAL 
B)  CURRVAL 
C)  VARCHAR 
D)  VARCHAR2 
A)  NEXTVAL 
B)  CURRVAL 
C)  VARCHAR 
D)  VARCHAR2

Question 17

When a user issues the DELETE FROM tablename command without specifying a WHERE condition, _____.

Accepted Answer

A)  no rows will be deleted 
B)  the first row will be deleted 
C)  the last row will be deleted 
D)  all rows will be deleted 
A)  no rows will be deleted 
B)  the first row will be deleted 
C)  the last row will be deleted 
D)  all rows will be deleted

Question 18

What is a schema? How many schemas can be used in one database?

Accepted Answer

In the SQL environment, a schema is a lo

Question 19

MySQL allows multiple triggering conditions per trigger.

Accepted Answer

A) True 
 B)False

Question 20

A(n) _____-length character data type, like VARCHAR, is typically specified with a maximum length.

Accepted Answer

The answer of A(n) _____-length character data type, like VARCHAR,...

_____ words are words used by SQL to perform specific functions.

How can a table be deleted from the database? Provide an example.

A(n) _____ view is a view that can be used to update attributes in the base table(s) that are used in the view.

The SQL data type DATE stores date in the _____ date format.

Which statement describes a feature of Oracle sequences?

The _____ command permanently saves all changes-such as rows added, attributes modified, and rows deleted-made to any table in the database.

The most useful feature of PL/SQL blocks is that they let a designer create code that can be named, stored, and executed by the DBMS.

The _____ specification creates an individualindex ona respective attribute; use it to avoid having duplicated values in a column.

Which command would be used to delete the table row where the P_CODE is 'BRT-345'?

All changes in a table structure are made using the _____ TABLE command, followed by a keyword that produces the specific changes a user wants to make.

_____ is the term used to describe an environment in which the SQL statement is not known in advance and is generated at run time.

In Oracle, you can use the SQL*Plus command SHOW ERRORS to help you diagnose errors found in PL/SQL blocks.

A view is a virtual table based on a SELECT query.

Summarize the hierarchy of steps involved in creating and running an executable program with embedded SQL statements.

Words used by a system that cannot be used for any other purpose are called _____ words. For example, in Oracle SQL, the word INITIAL cannot be used to name tables or columns.

In Oracle, _____ retrieves the current value of a sequence.

When a user issues the DELETE FROM tablename command without specifying a WHERE condition, _____.

What is a schema? How many schemas can be used in one database?

MySQL allows multiple triggering conditions per trigger.

A(n) _____-length character data type, like VARCHAR, is typically specified with a maximum length.

Database Systems

Data Models

The Relational Database Model

Entity Relationship Er Modeling

Advanced Data Modeling

Normalization of Database Tables

Introduction to Structured Query Language Sql

Database Design

Transaction Management and Concurrency Control

Database Performance Tuning and Query Optimization

Distributed Database Management Systems

Business Intelligence and Data Warehouses

Big Data and Nosql

Database Connectivity and Web Technologies

Database Administration and Security

Filters

Exam 8: Advanced Sql

_____ words are words used by SQL to perform specific functions.

How can a table be deleted from the database? Provide an example.

A(n) _____ view is a view that can be used to update attributes in the base table(s) that are used in the view.

The SQL data type DATE stores date in the _____ date format.

Which statement describes a feature of Oracle sequences?

The _____ command permanently saves all changes-such as rows added, attributes modified, and rows deleted-made to any table in the database.

The most useful feature of PL/SQL blocks is that they let a designer create code that can be named, stored, and executed by the DBMS.

The _____ specification creates an individualindex ona respective attribute; use it to avoid having duplicated values in a column.

Which command would be used to delete the table row where the P_CODE is 'BRT-345'?

All changes in a table structure are made using the _____ TABLE command, followed by a keyword that produces the specific changes a user wants to make.

_____ is the term used to describe an environment in which the SQL statement is not known in advance and is generated at run time.

In Oracle, you can use the SQL*Plus command SHOW ERRORS to help you diagnose errors found in PL/SQL blocks.

A view is a virtual table based on a SELECT query.

Summarize the hierarchy of steps involved in creating and running an executable program with embedded SQL statements.

Words used by a system that cannot be used for any other purpose are called _____ words. For example, in Oracle SQL, the word INITIAL cannot be used to name tables or columns.

In Oracle, _____ retrieves the current value of a sequence.

When a user issues the DELETE FROM tablename command without specifying a WHERE condition, _____.

What is a schema? How many schemas can be used in one database?

MySQL allows multiple triggering conditions per trigger.

A(n) _____-length character data type, like VARCHAR, is typically specified with a maximum length.

Database Systems

Data Models

The Relational Database Model

Entity Relationship Er Modeling

Advanced Data Modeling

Normalization of Database Tables

Introduction to Structured Query Language Sql

Database Design

Transaction Management and Concurrency Control

Database Performance Tuning and Query Optimization

Distributed Database Management Systems

Business Intelligence and Data Warehouses

Big Data and Nosql

Database Connectivity and Web Technologies

Database Administration and Security

Filters