Q&A Hero

Q: The New Wave film movement of France most admired which French film director? a. Jean Cocteau b. Jean Renoir c. Marcel Carn d. Jacques Prvert

Q: Romanian filmmakers and Islamic filmmakers share many filmmaking techniques with Italian neorealists.

Q: Blaxploitation films of the 1970s invariably featured anti-heroes as their main characters.

Q: If French civilization were destroyed today, what film, according to Richard Roud, could be used to reconstruct that civilization? a. Rules of the Game b. Beauty and the Beast c. Children of Paradise d. none of the above

Q: No German movie has won an Oscar in the 2000s.

Q: A major influence on the work of Steven Spielberg is a. Walt Disney b. D. W. Griffith c. Stanley Kubrick d. John Ford

Q: Jean Cocteau made which of the following magical tales? a. Beauty and the Beast b. The Blood of the Poet c. both a and b d. neither a and b

Q: British cinema has continued to languish in the 2000s.

Q: Woody Allen's sensibility is defined by his being a. Jewish. b. New Yorker. c. both a and b d. neither a nor b

Q: The French admired and paid homage in their surrealist films to a. American slapstick comedy as seen in Buster Keaton and Laurel and Hardy b. Russian masters Pudovkin and Eisenstein c. Alfred Hitchcock and Alexander Korda d. all of the above

Q: Many successful movies like the Lord of the Ring Trilogy have primarily been international co-productions.

Q: Robert DeNiro starred in all of the following Martin Scorsese films except a. Raging Bull b. Mean Streets c. Gangs of New York d. The King of Comedy

Q: What film did Alfred Hitchcock make in Britain which proved the precursor of later films like North by Northwest? a. Vertigo b. The 39 Steps c. Lifeboat d. Number 17

Q: The conflict between the powerful Hollywood and struggling cinemas of smaller countries has ceased in the 2000s.

Q: Martin Scorsese films are often imprinted with a. tight plots. b. logical endings. c. inconspicuous camera use. d. violence.

Q: Hitchcock in part achieved his films' effect and success through the influence and use of a. editing based on the theory of Kuleshov and Pudovkin b. German Expressionism c. innovations in sound d. all of the above

Q: The catch word of movie making in the 2000s is a. slash b. globalization c. innovate d. tradition

Q: The produce of B-films that gave many notable American directors of the 70s, including Martin Scorsese, their starts was a. Roger Corman b. Jack Warner c. Robert Altman d. none of the above

Q: Alexander Korda's problem with making his movies those he produced and directed was that a. he was not a very creative director b. he moved from country to country too often c. he let too many different people direct his movies d. he had tastes which were much too rarefied

Q: Briefly explain the process for configuring MySQL for importing Excel 2013 spreadsheet data into a SQL Server table, then discuss the import process using the MySQL for Excel Add-In.

Q: Explain the MySQL cursor statements.

Q: Explain the MySQL control-of-flow statements.

Q: Explain the MySQL Block Structure.

Q: What is the MySQL Table Editor?

Q: What MySQL utility is used for DBMS administration?

Q: What is the MySQL Workbench?

Q: What is the MySQL Command-Line Client?

Q: Describe how to create and run an SQL query in MySQL Server Community Edition.

Q: Describe how to create a new database in MySQL Community Edition.

Q: What is MySQL?

Q: What term does MySQL use as a synonym for backup? A) Replica B) Export C) Data export D) Data export dump

Q: Which schema privilege should not be specifically assigned to a user account? A) SELECT B) CREATE C) GRANT D) Both A and B are correct

Q: Which of the following set of MySQL authorizations can be specifically assigned to a user account? A) Administrative roles B) Schema privileges C) Root user equivalence D) Both A and B are correct

Q: Which transaction isolation level option(s) is (are) available in MySQL? A) READ UNCOMMITTED B) READ COMMITTED C) REPEATABLE WRITE D) Both A and B are correct

Q: Which transaction isolation level scope(s) is (are) available in MySQL? A) LOCAL B) SESSION C) TRANSACTION D) Both B and C are correct

Q: Which trigger type(s) does MySQL not support? A) BEFORE B) AFTER C) INSTEAD OF D) Both A and B are correct

Q: Which trigger type(s) does MySQL support? A) BEFORE B) AFTER C) INSTEAD OF D) Both A and B are correct

Q: The MySQL statement to delete a stored procedure already in the database is ________. A) CREATE PROCEDURE B) ALTER PROCEDURE C) DROP PROCEDURE D) CLOSE PROCEDURE

Q: The MySQL statement to change a stored procedure already stored in the database is ________. A) CREATE PROCEDURE B) ALTER PROCEDURE C) DROP PROCEDURE D) CLOSE PROCEDURE

Q: The MySQL statement to store a stored procedure in the database is ________. A) CREATE PROCEDURE B) ALTER PROCEDURE C) DROP PROCEDURE D) CLOSE PROCEDURE

Q: The MySQL keyword used to retrieve a row of data while the cursor is operating is ________. A) DECLARE CURSOR {CursorName} B) OPEN {CursorName} C) FETCH D) CLOSE {CursorName}

Q: The MySQL keyword to close and exit a cursor is ________. A) DECLARE CURSOR {CursorName} B) OPEN {CursorName} C) FINISH {CursorName} D) CLOSE {CursorName}

Q: The MySQL keyword to actually start using a cursor is ________. A) DECLARE CURSOR {CursorName} B) OPEN {CursorName} C) FETCH D) CLOSE {CursorName}

Q: The MySQL keyword to create a cursor is ________. A) DECLARE CURSOR {CursorName} B) OPEN {CursorName} C) FETCH D) CLOSE {CursorName}

Q:

Q: The MySQL statement used to complete the basic SQL block structure is ________. A) DECLARE B) BEGIN C) a right brace symbol } D) END

Q: The MySQL statement used to repeat a set of SQL statements as long as some condition is true is ________. A) LOOP B) BEGIN C) IF...THEN.ELSE...END IF D) REPEAT

Q: The MySQL SQL/PSM statement used to test for a condition and then direct which blocks of code should be run depending on the outcome of the test is ________. A) DECLARE B) BEGIN C) IF...THEN...ELSE...END IF D) REPEAT

Q: The MySQL SQL/PSM code structure defines variables with the keyword ________. A) DECLARE B) BEGIN C) IF...THEN...ELSE...END IF D) VAR

Q: The MySQL statement used to define a set of MySQL procedure statements is ________. A) DECLARE B) BEGIN C) IF...THEN...ELSE...END IF D) REPEAT

Q: To insert non-sequential data into a MySQL table that uses AUTO_INCREMENT ________. A) Disable AUTO_INCREMENT B) Temporarily remove AUTO_INCREMENT C) Use the AUTO_INCREMENT_INSERT command D) Both A and C are correct

Q: To create a MySQL index using SQL, the correct SQL statement is ________. A) ALTER TABLE {TableName} ADD INDEX {IndexName} B) ALTER TABLE {TableName} INSERT INDEX {IndexName} C) CREATE INDEX {IndexName} ON TABLE {TableName} D) Both A and C are correct

Q: MySQL indexes can be created by using ________. A) the MySQL Table Editor B) the MySQL Index Editor C) an SQL statement D) Both A and C are correct

Q: The SQL query data results are displayed ________. A) in the Navigator window B) in a tabbed Result Grid C) in a Messages window D) in a tabbed Action Output window

Q: To run a single SQL command in MySQL Community Edition ________. A) click the "Execute" button in the MySQL Workbench B) click the "Execute SQL in Connected Server" button in the MySQL Workbench C) click the "Execute SQL Script in Connected Server" button in the MySQL Workbench D) click the "Execute SQL Statement under the keyboard cursor" button in the MySQL Workbench

Q: SQL statements can be run individually or as part of a related group of SQL statements known as a ________. A) Result B) Resultset C) Script D) Scriptset

Q: Which of the following statements is not true concerning the MySQL for Excel Add-In? A) It must be installed into MySQL before importing from Excel can be performed. B) The user must enter a password to connect to the MySQL instance. C) The data must first be normalized before importing. D) The user can modify some of the table characteristics before the actual data transfer.

Q: The MySQL command line utility is ________. A) MySQL*Plus B) the MySQL Command-Line Client C) MySQL-Shell D) MySQL-CMD

Q: The active MySQL database is specified using ________. A) the Set Schema command B) the Set Database command C) the Make Default Schema command D) the Set as Default Schema command

Q: A new MySQL database is created using ________. A) the New Database dialog tab B) the Create Database command C) the new_schema dialog tab D) the Create Schema command

Q: DBMS objects are displayed ________. A) in the Navigation Pane B) in the Object Browser C) in the tabbed database window D) in the tabbed document window

Q: Logging into the MySQL DBMS is done using ________. A) the Connect to Server command B) the Connect to Server dialog box C) the Local instance MySQL56 command D) the Local instance MySQL56 dialog box

Q: Which of the following MySQL configuration settings are recommended for use with this book? A) Developer machine B) Multifunction machine C) Decision Support (DSS)/OLAP D) Custom setup that only installs the needed components

Q: The main MySQL GUI utility is ________. A) MySQL Management Studio B) MySQL Developer C) My SQL Workbench D) Both A and B are correct

Q: The MySQL Installer for Windows requires the ________ operating system. A) Suse Linux B) Red Hat Linux C) Android D) Microsoft Windows

Q: MySQL restores are run on the Restore from Disk tab of the Data Export and Restore page.

Q: A MySQL data backup is accomplished by using the "Data Export" feature.

Q: MySQL backups are run on the Administration - Data Export tab of the Data Export page.

Q: MySQL uses the term data export dump as a synonym for backup.

Q: MySQL databases are backed up using the MySQL Backup System.

Q: MySQL users should always be given the GRANT OPTION for each schema.

Q: The MySQL Schema Privileges Select "ALL" button marks all MySQL privileges for assignment to the user.

Q: MySQL users must be granted the right to have MySQL schema privileges before the specific privileges themselves are granted.

Q: MySQL users may be granted MySQL server administrative roles.

Q: MySQL users are granted MySQL privileges for specific schemas only.

Q: MySQL users are created on the Users and Privileges page in the MySQL Workbench.

Q: When MySQL Server Administration is opened in the MySQL Workbench, the Startup/Shutdown page is initially displayed.

Q: The MySQL Workbench is the main utility used to implement MySQL security.

Q: The MySQL transaction isolation level can be manually set using a MySQL SET {SCOPE} TRANSACTION ISOLATION LEVEL {LEVEL OPTION} command.

Q: MySQL concurrency options include four scopes for the transaction isolation level: GLOBAL, LOCAL, SESSION and TRANSACTION.