Q7:- Choose the correct statement:- Prints the database_information connection = getDbConnection() test1 =connection.get_server_info() cursor = connection.cursor() cursor.execute("select database();") test2 = cursor.fetchone() print(test2) closeDbConnection(connection) Prints the records for the selected database connection = getDbConnection() test1 = connection.get_server_info() cursor = connection.cursor() cursor.execute("select database();") test2 = cursor.fetchone() print(test1) closeDbConnection(connection) Both None of these

Q7:- Choose the correct statement:- Prints the database_information connection = getDbConnection() test1 =connection.get_server_info() cursor = connection.cursor() cursor.execute("select database();") test2 = cursor.fetchone() print(test2) closeDbConnection(connection) Prints the records for the selected database connection = getDbConnection() test1 = connection.get_server_info() cursor = connection.cursor() cursor.execute("select database();") test2 = cursor.fetchone() print(test1) closeDbConnection(connection) Both None of these

Oracle 12c: SQL

3rd Edition

ISBN:9781305251038

Author:Joan Casteel

Publisher:Joan Casteel

Chapter13: Views

Section: Chapter Questions

Problem 2MC

See similar textbooks

Similar questions

Which of the following data dictionary objects should be used to view information about the constraints in a database? USER_TABLES USER_RULES USER_COLUMNS USER_CONSTRAINTS None of the above objects should be used.
Which of the following is a correct statement? a. A commit is issued implicitly when a user exits SQL Developer or SQLPlus. b. A commit is issued implicitly when a DDL command is executed. c. A commit is issued automatically when a DML command is executed. d. All of the above are correct. e. Both a and b are correct. f. Both a and c are correct.
Write, but do not execute, the commands to grant the following privileges: a. User Oliver must be able to retrieve data from the CONDO_UNIT table. b. Users Crandall and Perez must be able to add new owners and condo units to thedatabase. c. Users Johnson and Klein must be able to change the condo fee of any unit. d. All users must be able to retrieve the unit number, condo fee, and owner number forevery condo unit. e. User Klein must be able to add and delete service categories. f. User Adams must be able to create an index on the SERVICE_REQUEST table. g. Users Adams and Klein must be able to change the structure of the CONDO_UNITtable. h. User Klein must have all privileges on the LOCATION, OWNER, and CONDO_UNITtables.
Which of the following keywords allows the user to delete a record from a table, even if rows in another table reference the record through a FOREIGN KEY constraint? a. CASCADE b. CASCADE ON DELETE c. DELETE ON CASCADE d. DROP e. ON DELETE CASCADE
Write, but do not execute, the commands to grant the following privileges: a. User Ashton must be able to retrieve data from the ITEM table. b. Users Kelly and Morgan must be able to add new orders and order lines. c. User James must be able to change the price for all items. d. User Danielson must be able to delete customers. e. All users must be able to retrieve each customers number, name, street, city, state,and postal code. f. f User Pere7 must be able to create an index on the ORDFRS table. g. User Washington must be able to change the structure of the ITEM table. h. User Grinstead must have all privileges on the ORDERS table.
In a rollforward, the DBMS uses the log to undo any changes made to the database during a certain period. (515)