최신 IBM Certified Database Administrator C9050-548 무료샘플문제:
1. Which of the following options best describes the differences between Label Based Access Control
(LBAC) and Row and Column Access Control (RCAC)?
A) LBAC allows you to protect access only to rows, while RCAC allows you to protect both rows and
columns.
B) RCAC returns the data based on what is being asked (data centric), while LBAC returns data based on
who is asking what (user centric). Users with DATAACCESS authority are exempt from the Row and
Column Access Control rules.
C) With RCAC users do not get an error when accessing protected data, while with LBAC users can get
an error if they don't have the necessary credentials to access a LBAC protected column.
D) RCAC is a fixed label security model designed for the US government while LBAC is a general purpose
security model best suited for commercial customers.
2. Each database has its own system catalog tables and views. These store metadata about the database
objects. You can query them just like any other tables or views. Which of the following are some of the
system catalog tables?
A) SYSLOAD, SYSALL, and SYSPASS
B) SYSSTART, SYSBACKUP, and SYSOPEN
C) SYSIBM, SYSCAT, and SYSSTAT
D) SYSMANAGEMENT, SYSCREATE, and SYSSTORE
3. Which of the following options is TRUE about the Row and Column Access Control (RCAC) feature?
A) Table data is protected against direct access to the table. Access using views is unrestricted.
B) In order to take advantage of this feature, applications must be changed to work with the RCAC
feature.
C) Row and column level access control allows the creation of column masks that can control what
column values a user is permitted to see.
D) Users with DATAACCESS authority are exempt from the Row and Column Access Control rules.
4. What does the SQL SELECT statement do?
A) The SQL SELECT statement is not used in DB2 because DB2 is a hierarchical database.
B) The SQL SELECT statement allows the DBA to create table structures and pre-populate those table
structures with database metadata.
C) The SQL SELECT statement is used to return rows of data from your database table or tables.
D) The SQL SELECT statement is used to return the status of the health of the database in the health
DB2 health center application.
5. What is the role of the XML data type in DB2?
A) The XML data type does not exist.
B) The XML data type allows you to store well-formed XML documents in their hierarchical form within the
columns of a table.
C) The XML data type allows a parser to use the metadata in a table to link to an external XML document
stored outside of the columns of a table.
D) The XML data type allows you to link a reference to an XML document stored outside of the columns of
a table.
질문과 대답:
질문 # 1 정답: C | 질문 # 2 정답: C | 질문 # 3 정답: C | 질문 # 4 정답: C | 질문 # 5 정답: B |