Management

Q: In order to use MySQL Workbench to create database designs, you must log into MySQL using: A) the Connect to Database dialog box. B) the Connect to MySQL Server dialog box. C) the MySQL | Connect to Server command. D) Both A and B are used together. E) None of the above is correct - no login is required.

Q: By default, the E-R diagrams created in the MySQL Workbench use: A) IE Crow's Foot notation. B) IDEF1X notation. C) UML notation. D) Microsoft Visio 2010 Arrow notation. E) None of the above is correct.

Q: The MySQL Workbench can be used to create: A) data models. B) data designs. C) database models. D) database designs. E) database diagrams.

Q: To access documentation at the MySQL Web site: A) use the Help | MySQL Workbench command. B) use the Help | Help Index command. C) use the Help | MySQL Website command. D) use the Help | MySQL.com Website command. E) go directly to the Web site http://dev.mysql.com/doc.

Q: SQL query results are displayed: A) in a tabbed results window. B) in a tabbed Results1 window. C) in a tabbed Document window. D) in a tabbed Messages window. E) in a tabbed Finished window.

Q: To run an SQL script or SQL command in MySQL Server Community Edition: A) click the Execute button on the Query Toolbar. B) click the Execute button on the Browser Toolbar. C) click the Run button on the Query Toolbar. D) click the Run button on the Browser Toolbar. E) click the Execute SQL Script button on the Toolbar.

Q: A new MySQL database is created using: A) the new_database dialog box. B) the Create Database command. C) the new_schema dialog box. D) the Create Schema command. E) the New Object dialog box.

Q: DBMS objects are displayed: A) in the Navigator Pane. B) in the Object Browser. C) in the tabbed database window. D) in the tabbed document window. E) in the command tab.

Q: Logging into the MySQL Community Server 5.6 DBMS is done using: A) the Connect to Server command. B) the Connect to Server dialog box. C) the Connect to MySQL Server command. D) the Connect to MySQL Server dialog box. E) None of the above is correct.

Q: The MySQL GUI tool is replaced by: A) MySQL Query Browser. B) MySQL Administrator. C) My SQL Workbench. D) Both A and B E) All of the above

Q: MySQL Community Server 5.6 requires the prior installation of: A) the .NET Framework version 3.0. B) the .NET Framework version 3.5. C) the .NET Framework version 3.5 SP1. D) the .NET Framework version 4.5.1. E) None of the abovethe .NET Framework is not required.

Q: In the MySQL Workbench, a 1:N non-identifying relationship between two tables that already contain the needed primary and foreign keys is created using the Place a Relationship Using Existing Columns button.

Q: In the MySQL Workbench, a 1:N non-identifying relationship between two tables that already contain the needed primary and foreign keys is created using the 1:N Non-identifying Relationship button.

Q: In the MySQL Table Editor, the abbreviation AI stands for AUTO_INCREMENT.

Q: In the MySQL Table Editor, the abbreviation NN stands for NOT NULL.

Q: In the MySQL Table Editor, the abbreviation PK stands for partial key.

Q: Table names are edited in the MySQL EER Component Editor.

Q: To add a table to a database design, click the Place a New Table button, move the cursor to the diagram area and click the left mouse button.

Q: To create a new MySQL Workbench EER model, you can use the File | New Model command.

Q: To create a new MySQL Workbench EER model, you can use the New Model link on the Home page.

Q: The MySQL Workbench EER models are data models.

Q: Users should create a Data Models folder to hold EER models created with the MySQL Workbench.

Q: Users should create a MySQL Workspace folder to hold documents created with the MySQL Workbench.

Q: In order to create MySQL EER diagrams, users must log into MySQL using the Connect to Database and the Connect to MySQL Server dialog boxes.

Q: SQL query results are displayed in a tabbed results window.

Q: Explain sequences and their relationship to surrogate keys.

Q: Describe how to create and run an SQL query in Oracle Database 11g Release 2 Express Edition.

Q: Describe how to create and run an SQL script in Oracle Database Express Edition 11g Release 2.

Q: What is SQL Developer?

Q: What is the Oracle Database XE 11.2?

Q: The Oracle Database ODBC Client is installed ________ when Oracle Database Express Edition 11g Release 2 is installed.

Q: SQL query results are displayed in a tabbed ________ window.

Q: Oracle Database Express Edition 11g Release 2 uses ________ to generate surrogate keys.

Q: To create a new SQL query, click the ________ button.

Q: To run an SQL query, click the ________ button.

Q: To run an SQL script, click the ________ button.

Q: Database objects are displayed in the ________ window in the SQL Developer.

Q: Users in SQL Developer log into a workspace using the ________ account.

Q: Users log into the Oracle Database XE 11.2 utility using the ________ account.

Q: An important reason for using Oracle Database Express Edition 11g Release 2 is that it has ________.

Q: If T3 is a table with three columns C1, C2 and C3, where C1 is integer data, C2 is character data, and C3 is date data, which of the following would be the proper statement to have Oracle Database enter the date 02/10/14 into a row in table T3 while making sure that it is formatted correctly as shown? A) SET INTO T3 VALUES (101, 'Smith', '02/10/14'); B) SET INTO T3 VALUES (101, 'Smith', TO_DATE ('02/10/14', 'DD/MM/YY')); C) INSERT INTO T3 VALUES (101, 'Smith', '02/10/2014'); D) INSERT INTO T3 VALUES (101, 'Smith', TO_DATE ('02/10/14', 'DD/MM/YY')); E) Any of the above will work correctly.

Q: Which method returns the next value in a sequence? A) CountVal B) Next C) UpVal D) NextVal E) Append

Q: When Oracle Database Express Edition 11g Release 2 is installed, the Oracle Database ODBC client is: A) installed automatically as part of the installation. B) installed manually as a separate part of the installation process. C) not installed and must be downloaded and installed manually. D) not installed because there is no ODBC client for Oracle Database 11g Release 2 Express Edition. E) Either A or B

Q: SQL query results are displayed: A) in a tabbed Resultset window. B) in a tabbed Query Result window. C) in a tabbed Document window. D) in a tabbed Messages window. E) in a tabbed Finished window.

Q: To run an SQL script in Oracle Database Express Edition 11g Release 2: A) click the Execute button. B) click the Execute Script button. C) click the Run Script button. D) click the Ready button. E) click the Results button.

Q: In SQL Developer, DBMS objects are displayed: A) in the Navigation Pane. B) in the Object Browser. C) in the Connections area. D) in the tabbed document window. E) in the command tab.

Q: Which of the following tasks can be done using the Oracle SQL Developer? A) See the structure of a table B) Add and remove columns from a table C) Insert and delete data from a table D) A and B E) A, B and C

Q: Which of the following is an account name for which you would enter a password to connect to a workspace in Oracle SQL Developer? A) Your own personal login B) The user login associated with the workspace C) INTERNAL D) A and B E) A, B and C

Q: Which of the following is an account name for which you are asked to enter a password for the Oracle Database XE 11.2 utility? A) SYSTEM B) EXTERNAL C) INTERNAL D) A and B E) A, B and C

Q: Which of the following is the easiest tool for doing database development with Oracle Database? A) The Oracle Database XE 11.2 utility B) The Oracle SQL*Plus command utility program C) The Oracle SQL Developer D) A and C E) A, B and C

Q: Which of the following is the easiest tool for creating a database with Oracle Database? A) The Oracle Database XE 11.2 utility B) The Oracle SQL*Plus command utility program C) The Oracle SQL Developer D) A and C E) A, B and C

Q: The Oracle Database ODBC Client is automatically installed when Oracle Database Express Edition 11g Release 2 is installed.

Q: The Oracle Database FORMAT_DATE function can be used to make sure that Oracle Database interprets date data correctly.

Q: ________ is a way of analyzing and ranking customers based on their purchasing patterns.

Q: BI ________ are intended to create meaningful information from disparate data sources and to deliver that information to the proper users on a timely basis.

Q: Problematic data are called ________.

Q: Refer to the table above. What is the lift for Drug B being purchased given that Drug A has been purchased? A) .200 B) .250 C) .333 D) .500 E) .667

Q: Refer to the table above. What is the confidence of Drug B being purchased given that Drug A has been purchased? A) .200 B) .250 C) .333 D) .400 E) .500

Q: Refer to the table above. What is the definition of confidence for Drug B with reference to Drug A? 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: Refer to the table above.What is the support for Drug A and Drug B? A) .025 B) .075 C) .100 D) .125 E) .200

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: Market basket analysis is: A) a data mart specific technique. B) a reporting technique. C) an RFM application. D) an OLAP application. E) a data mining technique.

Q: Which of the following popular data mining techniques require special software? A) Decision tree analysis B) Logistic regression analysis C) Neural networks D) A and B E) A, B and C

Q: Which of the following is a common supervised data mining technique? A) Cluster analysis B) Regression analysis C) RFM analysis D) Both A and B E) All of the above

Q: The Oracle Database ODBC Client is automatically installed when Oracle Database Express Edition 11g Release 2 is installed.

Q: The Oracle Database FORMAT_DATE function can be used to make sure that Oracle Database interprets date data correctly.

Q: With Oracle Database, data must be entered using SQL INSERT statements.

Q: With Oracle Database, using a sequence does not guarantee valid surrogate key values.

Q: The CurrVal method provides the current value in a sequence.

Q: The NextVal method provides the next value in a sequence.

Q: Sequences are most often used to provide values for surrogate keys.

Q: When using Oracle Database, a sequence is an object that generates a sequential series of unique numbers.

Q: The default file extension for text files created for or within SQL Developer is .sql.

Q: To log into a workspace connection in Oracle SQL Developer, use the username and password you created for Application Express.

Q: The Oracle Database GUI tool used for application development is the Oracle SQL Developer.

Q: Oracle Database XE 11.2 uses Application Express to create new workspaces.

1 2 3 … 1,015 Next »

Subjects