Accounting
Anthropology
Archaeology
Art History
Banking
Biology & Life Science
Business
Business Communication
Business Development
Business Ethics
Business Law
Chemistry
Communication
Computer Science
Counseling
Criminal Law
Curriculum & Instruction
Design
Earth Science
Economic
Education
Engineering
Finance
History & Theory
Humanities
Human Resource
International Business
Investments & Securities
Journalism
Law
Management
Marketing
Medicine
Medicine & Health Science
Nursing
Philosophy
Physic
Psychology
Real Estate
Science
Social Science
Sociology
Special Education
Speech
Visual Arts
Question
SQL triggers are used for ________.A) validity checking
B) providing default values
C) updating views
D) A and B
E) A, B, and C
Answer
This answer is hidden. It contains 1 characters.
Related questions
Q:
What is a distributed database?
Q:
Why is operational data sometimes unusable for Business Intelligence use?
Q:
What is a reporting system?
Q:
How can XML be used with a DBMS?
Q:
Briefly describe PHP.
Q:
If the Web server and the DBMS are running on the different servers, the system has a(n) ________ architecture.
Q:
XML stands for:
A) Experimental Markup Language.
B) Existential Markup Language.
C) Extendable Markup Language.
D) Extensible Markup Language.
E) Extensible Marketing Language.
Q:
After trying to open a connection, a PHP connection to a DBMS needs to:
A) open the connection.
B) test the connection.
C) query the database.
D) process the query results.
E) close the connection.
Q:
In PHP, any programming language statements that are to be processed on the server must be enclosed in:
A) <!-- and --!>.
B) [php and php].
C) (php and php).
D) <?php and ?>.
E) <server> and </server>.
Q:
Which of the following is a task performed by the driver according to the ODBC standard?
A) Determines the appropriate DBMS
B) Validates the format of the ODBC command received from the application
C) Converts data source error codes into ODBC standard error codes
D) Verifies the application to the data source
E) Converts the data source into an SQL-compliant data structure
Q:
Which of the following is a function performed by the driver manager in ODBC?
A) Submit SQL statements to the data source.
B) Determine the type of DBMS that processes a given ODBC data source.
C) Load the appropriate ODBC driver into memory.
D) Convert data source error codes into ODBC error codes.
E) Both B and C
Q:
ODBC stands for:
A) Open Database Compatibility.
B) Open Database Connectivity.
C) Open-source Database Compatibility.
D) Open-source Database Connectivity.
E) None of the above
Q:
Which of the following SQL commands cannot be used with a trigger?
A) INSERT
B) SELECT
C) UPDATE
D) DELETE
E) Both B and D
Q:
What are the four transaction isolation levels?
Q:
Breaking hardware, power outages, and human mistakes are all reasons that ________.
Q:
________ is an important business function whose purpose is to manage the database to maximize its value to the organization.
Q:
Which of the following is not a means of processing databases?
A) Internet applications using ASP
B) Internet applications using JSP
C) Applications invoking stored procedures
D) Programs coded in C#
E) All of the above are means of processing a database.
Q:
When Microsoft Access 2013 uses user-level security with an Access 2003 file, the database is stored in a(n) *.accdb file.
Q:
Microsoft Access 2013 databases can be secured by deploying databases packaged with digital signatures.
Q:
Microsoft Access 2013 databases can be secured using trusted locations for database storage.
Q:
Rollback requires the use of logs, but rollforward does not.
Q:
Problematic data are called ________.
Q:
Refer to the table above.What is the definition of support for Drug A and Drug B?
A) The probability that Drug A will be purchased
B) The probability that Drug B will be purchased
C) The probability that both Drug A and Drug B will be purchased
D) The probability that Drug A will be purchased given that Drug B has been purchased
E) The probability that Drug B will be purchased given that Drug A has been purchased
Q:
With Oracle Database, data must be entered using SQL INSERT statements.
Q:
Oracle Database XE 11.2 uses Application Express to create new workspaces.
Q:
Describe how to create a new database in SQL Server 2014 Express.
Q:
The ODBC Driver 11 for SQL Server is installed ________ when SQL Server 2014 is installed.
Q:
SQL statements can be run individually or as part of a related group of SQL statements known as a(n) ________.
Q:
Database objects are displayed in the ________ window in the SQL Server Management Studio.
Q:
An important reason for using SQL Server 2014 Express is that it has ________.