11/5/2018 Quiz: Final Exam
https://canvas.du.edu/courses/80278/quizzes/58545/take 1/11
Final Exam
Started: Nov 5 at 9:08am
Quiz Instruc�ons
Final Exam (Access granted in Week 9 (Monday, November 5, 2018 at 12:00 AM), due Week 10 (Monday, November 12, 2018 by 11:59 PM MT))
1 ptsQuestion 1
Add the customers to the db_denydatareader fixed database role.
Create a view. Grant the customers permissions for the view and permissions for the Products and Categories tables.
Create a view. Grant the customers permissions for the view, but not for the Products and Categories tables.
Deny the customers permissions for the SupplierID and UnitsInStock columns.
A Microsoft SQL Server 2014 server instance named SRV1 contains several databases, including the Parts database. The structure of the Parts database is shown in the following exhibit:
You must enable customers to access information in the Products and Categories tables, but they should not be able to see the SupplierID and UnitsInStock columns.
Which of the following should you do?
1 ptsQuestion 2
DBCC DBREINDEX (“HumanResources.Employee”, PK_Employee_BusinessEntityID,80);
ALTER INDEX PK_Employee_BusinessEntityID ON HumanResources.Employee REBUILD;
ALTER INDEX PK_Employee_BusinessEntityID ON HumanResources.Employee REORGANIZE;
DBCC DBREINDEX (“HumanResources.Employee”, ” “, 70)
ALTER INDEX ALL ON HumanResources.Employee REBUILD WITH (FILLFACTOR = 80, STATISTICS_NORECOMPUTE = ON);
You have a Microsoft SQL Server 2014 server instance named SRV1. An application runs queries on the HumanResources.Employee table in the database.
You use the system function to detect fragmentation on the PK_Employee_BusinessEntityID index, which is created on the HumanResources.Employee table. You see that the average
fragmentation for the index is above 35%. You need to create a script to fix this problem with the PK_Employee_BusinessEntityID index in the future.
What should you include in the script? Choose the BEST answer.
1 ptsQuestion 3
the INSERT was successful
the INSERT failed because of violation of a not null constraint
the INSERT failed because of violation of a check constraint
the INSERT failed because of string data truncation
Review the code that created the Customer5 table:
CREATE TABLE Customer5
(CustID int Primary Key,
Name varchar(10),
City varchar(15) Default ‘Atlanta’,
State char(2) CHECK (State IN (‘GA’, ‘FL’,’TN’)),
AccountID int UNIQUE,
SalesPerson varchar(15) NOT NULL)
There are two rows currently in the Customer5 table. They are:
CustID Name City State AccountID SalesPerson
1 Smith Dallas GA 42 Campbell
2 Jones Tallahassee FL 44 Petersen
You execute the following command:
INSERT into Customer5 values(4,’Smitty’,’Chicago’,’TN’,43,’Johnson’)
Which best describes the result?
11/5/2018 Quiz: Final Exam
https://canvas.du.edu/courses/80278/quizzes/58545/take 2/11
the INSERT failed because of violation of a primary key constraint
the INSERT failed because of a mismatch between the number of columns in the table and the number of values provided in the command
1 ptsQuestion 4
sys.dm_os_volume_stats
sys.master_files
sys.dm_os_windows_info
sys.databases
You are a database administrator using SQL Server 2014 Enterprise Edition. You are working on monitoring disk space usage on a server named SalesServer1.
You to need write a script containing a metadata query to find out the total disk size and the available space on each disk that hosts a SQL Server database file.
What dynamic management object (DMO) would display this information?
1 ptsQuestion 5
A temporary table can be created using a SELECT INTO
Indexes can be explicitly created on a temporary table using CREATE INDEX
A local temporary table is automatically cleaned up at the end of the stored procedure, function, or batch that contains it
Temporary tables generally require less locking and logging resources than table variables
Temporary tables can be altered after creation
You are working on refining a stored procedure that is being used in a complex SSRS report.
The stored procedure currently uses table variables to store intermediate data sets. However, you notice that the TEMPDB database is becoming a bottleneck in terms of performance. You
want to change the stored procedure to use temporary tables instead of table variables. You need to understand the benefits and limitations of temporary tables.
Which of the following statements are true about temporary tables? (Choose all that apply.)
1 ptsQuestion 6
ALTER SERVER ROLE [sysadmin] ADD MEMBER [AuditLogin];
CREATE SERVER ROLE [Auditor] AUTHORIZATION [sa];
CREATE ROLE [Auditor] AUTHORIZATION [sa];
GRANT CONNECT ANY DATABASE TO [Auditor];
GRANT ALTER ANY DATABASE TO [Auditor];
GRANT VIEW ANY DATABASE TO [Auditor];
GRANT SELECT ALL USER SECURABLES TO [Auditor];
ALTER SERVER ROLE [Auditor] ADD MEMBER [AuditLogin];
You are using SQL Server 2014 Enterprise Edition to support a SQL Server instance named Svr1. The instance currently supports two databases, named SalesDB and SalesDW.
You need to provide access to auditors so that read-only access is available for all databases on the server. Any future databases on the instance will need to be made available when
added.
In order to test the access, you create a test login with the following statement:
CREATE LOGIN [AuditLogin] WITH PASSWORD = ‘ga!!ifreyfa!!sn0m0re’
Which of the following steps would provide the best solution giving only the required permissions? (Choose four.)
1 ptsQuestion 7
You are working on designing an index maintenance strategy for the Sales.Orders table within a database SalesDB. You are using SQL Server 2014 Enterprise Edition.
The table currently has a clustered index on the primary key OrderId and three non-clustered indexes for frequently searched columns. You want to be able to rebuild the clustered index
when fragmentation exceeds 30%. You decide to write a script to perform the maintenance. The table is available 24 hours a day, so you need your strategy to allow user activity during the
rebuild. However, the rebuild is not regarded as important as user transactions. That means that if data in the table is being exclusively locked for more than three minutes when the rebuild
starts, the rebuild of the index should be cancelled.
Which of the following T-SQL statements would be best in order to rebuild the clustered index according to the requirements?
11/5/2018 Quiz: Final Exam
https://canvas.du.edu/courses/80278/quizzes/58545/take 3/11
ALTER INDEX PK_Order_OrderId ON Sales.Orders REBUILD WITH (ONLINE = OFF ( WAIT_AT_LOW_PRIORITY ( MAX_DURATION = 3 MINUTES, ABORT_AFTER_WAIT = NONE)));
ALTER INDEX PK_Order_OrderId ON Sales.Orders REBUILD WITH (ONLINE = OFF ( WAIT_AT_LOW_PRIORITY ( MAX_DURATION = 3 MINUTES, ABORT_AFTER_WAIT = BLOCKERS )));
ALTER INDEX PK_Order_OrderId ON Sales.Orders REBUILD WITH (ONLINE = OFF ( WAIT_AT_LOW_PRIORITY ( MAX_DURATION = 3 MINUTES, ABORT_AFTER_WAIT = SELF )));
ALTER INDEX PK_Order_OrderId ON Sales.Orders REBUILD WITH (ONLINE = ON ( WAIT_AT_LOW_PRIORITY ( MAX_DURATION = 3 MINUTES, ABORT_AFTER_WAIT = NONE)));
ALTER INDEX PK_Order_OrderId ON Sales.Orders REBUILD WITH (ONLINE = ON ( WAIT_AT_LOW_PRIORITY ( MAX_DURATION = 3 MINUTES, ABORT_AFTER_WAIT = BLOCKERS )));
ALTER INDEX PK_Order_OrderId ON Sales.Orders REBUILD WITH (ONLINE = ON ( WAIT_AT_LOW_PRIORITY ( MAX_DURATION = 3 MINUTES, ABORT_AFTER_WAIT = SELF )));
1 ptsQuestion 8
Full Backup
Partial Backup
Differential Backup
Copy-only Backup
Mirrored Backup
What type of SQL Server backup job copies only data that has changed since the last full backup?
1 ptsQuestion 9
1. Copy the files to the new server. 2. Detach SalesDB from the old server. 3. Attach SalesDB on the new server.
1. Detach SalesDB from the old server. 2. Move the files to the new server. 3. Attach SalesDB on the new server.
1. Shutdown the SQL Server service on the old server. 2. move the files to the new server. 3. Execute ALTER DATABASE with MOVE option on the new server.
1. Execute the ALTER DATABASE with the MOVE option on the old server. 2. Shut down the SQL Server service on both servers. 3. move the files to the new server. 4. Start the SQL Server service on both
servers.
You maintain a database named SalesDB. SalesDB is located on an instance of SQL Server 2008.
You are planning to decommission the where SalesDB is located.
You need to move SalesDB to a server running SQL Server 2014.
What should you do?
1 ptsQuestion 10
Use the xp_alertrelay stored procedure
Configure the remote servers to use event forwarding
Set up Enterprise Manager to query each server for alerts
Use Query Analyzer to execute Transact-SQL code that checks for new alerts
You are responsible for administering 30 SQL Servers located in various cities. You spend a significant amount of time each day logging into each server to check for new alerts. What can
you do to ease this administrative burden?
1 ptsQuestion 11
Schedule a differential backup every 30 minutes.
Schedule a transaction log backup every 30 minutes.
Change the recovery mode to Full.
Schedule a full backup every 30 minutes.
Schedule a differential backup every 2 hours.
You maintain a database named SalesDB in SQL Server 2014.
The SalesDB database is configured to use the Simple recovery model. A full backup is performed nightly.
A disk failure occurs and the company loses six hours of sales data. A new company policy is devised to prevent such catastrophe in the future. The policy has the following requirements:
* No more that 30 minutes of sales data can be lost due to disk failure.
* Backups must use a minimal amount of disk storage.
You need to configure SalesDB to meet the new requirements.
What should you do? (Choose 2)
1 ptsQuestion 12
11/5/2018 Quiz: Final Exam
https://canvas.du.edu/courses/80278/quizzes/58545/take 4/11
db_accessadmin
db_datareader
db_datawriter
db_ddladmin
db_securityadmin
Which of the following SQL server database roles allows a user to add or remove user IDs?
1 ptsQuestion 13
r$.sys.L9
apple1rK
sysadmin
a$1Rk
asjfk9sdn24
You are attempting to create a password for the sysadmin account on a SQL Server 2014 installation with password complexity enabled. Which of the following passwords is acceptable?
1 ptsQuestion 14
LEFT OUTER JOIN
RIGHT OUTER JOIN
SELF JOIN
INNER JOIN
What is the default join type used in SQL Server when only the keyword JOIN is specified?
1 ptsQuestion 15
Add Jane to the DatabaseMailUserRole database role in AccountDB
Create a Database Mail profile for Jane
Create a SQLMail profile for Jane
Add Jane to the DatabaseMailUserRole database role in msdb
You manage a database server running SQL Server 2014. The server is configured for Windows authentication.
A stored procedure in the AccountDB database calls sp_send_dbmail to send an e-mail. The procedure sends mail successfully when you execute it. Jane attempts to execute the stored
procedure and receives the following error:
Permission denied on sp_send_dbmail
You need to enable Jane to execute the stored procedure.
What should you do?
1 ptsQuestion 16
Execute DBCC CHECKFILEGROUP FG1
Execute DBCC CHECKDB SalesDB
Execute DBCC CHECKFILEGROUP FGIndex
Execute CHECKSUM SalesDB
You maintain a database named SalesDB. SalesDB is located on a server running SQL Server 2014. SalesDB has two filegroups. All tables are located on the filegroup named FG1. All
non-clustered indexes are located on the filegroup named FGIndex. You need to verify the integrity of the nonclustered indexes. What should you do?
1 ptsQuestion 17
You manage a server running SQL Server 2014. SQL Server is configured to use mixed-mode authentication.
Members of the Help Desk department need to be able to reset passwords for SQL Server logins and terminate processes involved in a deadlock condition. You create a login associated
with the Help Desk group.
You need to grant the minimum necessary permissions.
What should you do?
11/5/2018 Quiz: Final Exam
https://canvas.du.edu/courses/80278/quizzes/58545/take 5/11
Add the login as a member of the processadmin and securityadmin fixed server roles.
Add the login as a member of the serveradmin and securityadmin fixed server roles.
Add the login as a member of the serveradmin fixed server role.
Add the login as a member of the sysadmin fixed server role.
1 ptsQuestion 18
The Oracle Server will evaluate a HAVING clause before a WHERE clause.
The Oracle Server will evaluate a WHERE clause before a GROUP BY clause.
The Oracle Server will evaluate a GROUP BY clause before a HAVING clause.
The Oracle Server will evaluate an ORDER BY clause before a WHERE clause.
The Oracle Server will evaluate an ORDER BY clause before a HAVING clause.
Which two statements about the evaluation of clauses in a SELECT statement are true? (Choose two.)
1 ptsQuestion 19
The product_id value for the first record displayed is 220.
The product_id values for the last two rows displayed are 140 and 126.
The description value for the first two rows displayed is C 2pk-battery.
The description value for the first two rows displayed is AA 2pk-battery.
No row with a product_id of 220is displayed.
Examine the data in the PRODUCT table.
Evaluate this SELECT statement:
SELECT description, cost
FROM product
ORDER BY cost, quantity;
Which statements are true? (Choose all that apply.)
1 ptsQuestion 20
CREATE TABLE employee (employee_id NUMBER, emp_lname VARCHAR2(25) NOT NULL, emp_fname VARCHAR2(25), dept_id NUMBER, job_id NUMBER, mgr_id NUMBER, salary NUMBER(9,2),
hire_date DATE, CONSTRAINT employee_id_pk PRIMARY KEY(employee_id));
CREATE TABLE employee (employee_id NUMBER, emp_lname VARCHAR2(25) NOT NULL, emp_fname VARCHAR2(25), dept_id NUMBER, job_id NUMBER, mgr_id NUMBER, salary NUMBER(9,2),
hire_date DATE, CONSTRAINT employee_id_pk PRIMARY KEY(employee_id), CONSTRAINT mgr_id_fk FOREIGN KEY(mgr_id) REFERENCES employee(employee_id));
CREATE TABLE employee (employee_id NUMBER, emp_lname VARCHAR2(25) NOT NULL, emp_fname VARCHAR2(25), dept_id NUMBER, job_id NUMBER, mgr_id NUMBER, salary NUMBER(9,2),
hire_date DATE, CONSTRAINT employee_id_pk PRIMARY KEY(employee_id), CONSTRAINT dept_id_fk FOREIGN KEY(dept_id) REFERENCES department(dept_id), CONSTRAINT job_id_fk FOREIGN
KEY(job_id) REFERENCES job(job_id));
CREATE TABLE employee (employee_id NUMBER, emp_lname VARCHAR2(25) NOT NULL, emp_fname VARCHAR2(25), dept_id NUMBER, job_id NUMBER, mgr_id NUMBER, salary NUMBER(9,2),
hire_date DATE, CONSTRAINT employee_id_pk PRIMARY KEY(employee_id), CONSTRAINT dept_id_fk FOREIGN KEY(dept_id) REFERENCES department(dept_id), CONSTRAINT job_id_fk FOREIGN
KEY(job_id) REFERENCES job(job_id), CONSTRAINT mgr_id_fk FOREIGN KEY(mgr_id) REFERENCES employee(employee_id));
Examine the structure of the employee table.
Which CREATE TABLE statement should you use to create the employee table?
1 ptsQuestion 21
datafiles
trace files
control file
redo log files
parameter file
Where does the Oracle server record changes made to the data for recovery operations?
1 ptsQuestion 22
11/5/2018 Quiz: Final Exam
https://canvas.du.edu/courses/80278/quizzes/58545/take 6/11
Use the ALTER USER statement to time out JOHN’s session.
Use the ALTER SESSION KILL statement to kill JOHN’s session.
Use the ALTER SESSION statement to release the locks held by JOHN.
Use the ALTER SYSTEM KILL SESSION statement to kill JOHN’s session.
The users of the database in your company are complaining that they are not able to access the data in the master table of the database, and their queries seem to be waiting for a
response. Upon investigation, you discover that the table has been locked exclusively by the user JOHN.
You query the DBA_LOCK view and see that JOHN’s session has a value of Blocking for the BLOCKING_OTHERS column.
What should you do to make the data available to the other users?
1 ptsQuestion 23
ALTER DATABASE DATAFILE ‘D:\DATA\USERS01.DBF’ RESIZE 20M;
ALTER DATABASE DATAFILE ‘D:\DATA\USERS01.DBF’ AUTOEXTEND ON;
ALTER TABLESPACE USERS DATAFILE ‘D:\DATA\USERS01.DBF’ RESIZE 20M;
ALTER TABLESPACE USERS ADD DATAFILE ‘D:\DATA\USERS.DBF’ SIZE 10M;
ALTER TABLESPACE USERS DATAFILE ‘D:\DATA\USERS01.DBF’ AUTOEXTEND ON;
You are working on your production database. The database resides on a Windows Server machine. The USERS tablespace of your database is running out of space. The USERS
tablespace contains the D:\DATA\USERS01.DBF datafile of size 10 MB.
Which two statements will add more space to the datafile of the USERS tablespace? (Choose two.)
1 ptsQuestion 24
Consolidating multiple non-CDB databases into single multitenant container database reduces instance overhead.
Less downtime is required to patch pluggable databases.
All pluggable databases must share the same data dictionary.
A temporary tablespace common to all containers is required.
All of the data files belonging to the pluggable databases must use the same directory structure.
Which three statements are true regarding the Oracle 12c multitenant architecture?
1 ptsQuestion 25
media failure (loss or corruption of database files)
instance failure (Oracle memory and background processes)
user error (forgot to commit after making changes)
user process (session not responding)
In an Oracle environment, which categories of failure are likely to require DBA involvement for resolution? (Choose two.)
1 ptsQuestion 26
SELECT order_id, order_date, price, quantity FROM orders WHERE (order_id) IN (SELECT order_id FROM sales_persons);
SELECT order_id, order_date, price, quantity FROM orders WHERE (order_id) NOT IN (SELECT order_id FROM sales_persons);
SELECT order_id, order_date, price, quantity FROM orders WHERE (order_id) NOT IN (SELECT order_id FROM sales_persons WHERE sales_person_name=”Victor”);
SELECT order_id, order_date, price, quantity FROM orders WHERE (order_id) IN (SELECT order_id FROM sales_persons WHERE sales_person_name=’Victor’);
You maintain the data about the various sales_persons and orders in the sales_persons and orders tables. You need to display the records of the products sold by a sales person
named Victor.
Which of the following queries should you use to achieve the desired results?
1 ptsQuestion 27
Evaluate this SQL statement:
SELECT product_id, product_name, price
11/5/2018 Quiz: Final Exam
https://canvas.du.edu/courses/80278/quizzes/58545/take 7/11
the product_id, product_name, and price of products that are priced greater than $120.00 and have a qty_in_stock value greater than 100
the product_id, product_name, and price of products that are priced greater than $120.00 or that have a qty_in_stock value greater than 100
the product_id, product_name, and price of products that are priced greater than $120.00 or that have a qty_in_stock value greater than 100 and have a supplier
the product_id, product_name, and price of products supplied by a supplier with products that are priced greater than $120.00 or with products that have a qty_in_stock value greater than 100
FROM product
WHERE supplier_id IN (SELECT supplier_id
FROM product
WHERE price > 120 OR qty_in_stock > 100);
Which values will be displayed?
1 ptsQuestion 28
GRANT
SELECT
CREATE
COMMIT
UPDATE
ROLLBACK
Which two statements would cause an implicit COMMIT to occur in Oracle? (Choose two.)
1 ptsQuestion 29
Dates in Oracle are always stored with a time component. If a user enters a date as part of an INSERT statement and no time is specified, the time component will be equal to the time of the INSERT.
Dates in Oracle are always stored with a century component as a 4-digit year. If the user today enters a date with a value of 45 for the year using a format mask of RR for the year, it will be stored as 1945.
Some arithmetic operations with columns that have a datatype of DATE are possible, but other arithmetic operations on dates are forbidden. For example, you cannot add or subtract 3.14 to a column called
PROCESSING_DATE if that column is datatype DATE.
It is permissible to subtract one column from another in a table, assuming both columns are datatype DATE. If the two date columns are storing the same value, the result will be 0. If they are not the same, the
result will always be a whole number, but it may be negative.
SYSDATE represents the current date and time and has the same precision as any other Oracle column with a datatype of DATE. If you issued the SELECT ADD_MONTHS(SYSDATE,12) FROM dual;
command, the result would be the output of the date exactly one year from the day and time you issued the command.
Which one of the following statements about columns in Oracle with a datatype of DATE is TRUE?
1 ptsQuestion 30
when there is a log switch
when a user transaction is committed
when the database is shut down cleanly
when a table is dropped from the database
when a tablespace in the database is taken offline using OFFLINE NORMAL or OFFLINE TEMPORARY
when the server process cannot find free buffers in the database buffer cache
In which situations does DBWn write the data from the database buffer cache to datafiles? (Choose 3.)
1 ptsQuestion 31
A datafile in the database cannot be accessed.
The control file in the database cannot be accessed.
The redo log files in the database cannot be accessed.
The parameter file in the database cannot be accessed.
After changing some parameters in your initialization parameter file, you start the database in the NOMOUNT state using the following command:
SQL> STARTUP NOMOUNT;
After this, you want to enable redo archiving, so you issue the following statement to mount the database:
SQL> ALTER DATABASE MOUNT;
The database fails to mount. Which condition could be the reason for the failure?
11/5/2018 Quiz: Final Exam
https://canvas.du.edu/courses/80278/quizzes/58545/take 8/11
1 ptsQuestion 32
The statement executes successfully, and the DIR_ROLE role has all privileges provided by both roles.
The statement executes successfully, and both roles have the same privileges.
The statement generates an error because you cannot grant a role to another role.
The statement generates an error because you cannot grant roles in a circular fashion.
As the Oracle database administrator, you execute the following statements:
SQL> create role div_role;
Role created.
SQL> grant dir_role, drop any table to div_role;
Grant succeeded.
SQL>
Subsequently, you issue the following statement:
SQL> GRANT div_role TO dir_role;
What is the result of executing this statement?
1 ptsQuestion 33
Archived redo log files will be written to /u01/app/oracle.
Archived redo log files will be written to /u01/oradata/fra1.
Archiving will be disabled because the flash recovery area has not been configured properly.
The database instance will not start because no LOG_ARCHIVE_DEST_n parameters have been set.
Your database instance is running in ARCHIVELOG mode. Examine the initialization parameter settings shown in the exhibit.
No LOG_ARCHIVE_DEST_n locations have been configured.
Which statement about the database instance is true?
1 ptsQuestion 34
One of the tables is recovered from the Recycle Bin using a First In First Out (FIFO) approach.
One of the tables is recovered from the Recycle Bin using a Last In First Out (LIFO) approach.
Both the tables are recovered from the Recycle Bin with one table renamed to MY_TABLE2 and the other to a system-generated name.
None of the tables are recovered from the Recycle Bin, and the statement returns an error.
You discover that your Oracle Recycle Bin contains two tables with the same name, MY_TABLE. You also have a table named MY_TABLE in your schema.
You execute the following statement:
FLASHBACK TABLE my_table TO BEFORE DROP RENAME TO my_table2;
What will be the result of executing this statement?
1 ptsQuestion 35
VALIDATE STRUCTURE
COMPUTE STATISTICS
ESTIMATE STATISTICS
ESTIMATE STATISTICS SAMPLE 3000 ROWS
ESTIMATE STATISTICS SAMPLE 40 PERCENT
You suspect chaining in the FLIGHT table that has 8000 rows. Which Oracle option could you use with the ANALYZE TABLE command to generate the most accurate count of chained
rows?
1 ptsQuestion 36
11/5/2018 Quiz: Final Exam
https://canvas.du.edu/courses/80278/quizzes/58545/take 9/11
allows the user remote access
allow the user network access
allows the user database access without a password
specifies that the user must be authenticated by the operating system
What does the EXTERNALLY option do when creating a user with the CREATE USER command in Oracle?
1 ptsQuestion 37
EXECUTE
CREATE TABLE
DROP ANY INDEX
SELECT ANY TABLE
In Oracle, which is NOT a system privilege?
1 ptsQuestion 38
ALTER TABLE
DROP CONSTRAINT
REMOVE CONSTRAINT
DELETE CONSTRAINT
Which command in Oracle would you use to disable a constraint?
1 ptsQuestion 39
DB_NAME
DBA_VIEWS
DICTIONARY
DBA_DATA_FILES
Which view in Oracle contains the names of all the data dictionary views?
1 ptsQuestion 40
3
4
6
8
12
If the PROD Oracle database has four redo log groups and each group has three members, how many disks does Oracle recommend to maintain the redo log files?
1 ptsQuestion 41
when the schema contains objects
when the schema contains no objects
when the user is currently connected
when the user is not currently connected
when the user must be retained but the user’s objects need to be dropped
In Oracle, when would you use the CASCADE option to drop a user?
1 ptsQuestion 42
Which statement would be used to display resources and resource limits for user BOB in Oracle?
11/5/2018 Quiz: Final Exam
https://canvas.du.edu/courses/80278/quizzes/58545/take 10/11
SELECT resource_type, resource_name, limit FROM dba_users WHERE username = ‘BOB’;
SELECT resource_type, resource_name, limit FROM dba_profiles WHERE username = ‘BOB’;
SELECT p.resource_type, p.resource_name, p.limit FROM dba_users u, dba_profiles p WHERE p.profile = u.profile AND u.username = ‘BOB’;
SELECT p.resource_type, p.resource_name, u.limit FROM dba_users u, dba_profiles p WHERE p.profile = u.profile AND U.username = ‘BOB’;
1 ptsQuestion 43
DBA_COL_PRIVS
DBA_SYS_PRIVS
DBA_USER_PRIVS
USER_TAB_PRIVS_RECD
Which view in Oracle could you query to display users with the ALTER ANY ROLE privilege?
1 ptsQuestion 44
application code
database triggers
integrity constraints
stored procedures
Which method of enforcing business rules in an Oracle database are the most flexible and the most preferred?
1 ptsQuestion 45
SGA
PGA
UGA
VGA
The ______ is an Oracle memory area used to store all database information that is shared by database processes.
1 ptsQuestion 46
DBA
CONNECT
RESOURCE
EXP_FULL_DATABASE
SELECT_CATALOG_ROLE
Which role would you grant in Oracle to a developer that needs to query the data dictionary to tune applications?
1 ptsQuestion 47
to display all the object privileges granted to you
to display all the system privileges granted to roles
to display all the system privileges granted to users
to display the privileges available to you in the current session
Why would you query the SESSION_PRIVS data dictionary view in Oracle?
1 ptsQuestion 48
The role is removed from the database and revoked from all users to whom it was granted.
When removing a role from an Oracle database using the DROP ROLE command, which statement is true?
11/5/2018 Quiz: Final Exam
https://canvas.du.edu/courses/80278/quizzes/58545/take 11/11
Quiz saved at 4:36pm
The role remains in the database in a disabled state.
No special privileges are needed to execute the command.
The role is still available for all roles to whom it has been granted.
1 ptsQuestion 49
SMON
PMON
DBWR
LGWR
CKPT
If a user in Oracle abnormally terminates a database connection, which background process will release the locks held by the user?
1 ptsQuestion 50
to display the state of the current instance
to view the default values of all initialization parameters
to view the current settings of all initialization parameters
to display only the nondefault values of the initialization parameters
Evaluate this statement in Oracle:
SELECT * FROM v$parameter;
For which task would you use this statement?
Submit Quiz