数据库应用系统(DataBase Application System,DBAS)是一个使用了数据库技术的应用软件系统。
第1题:
ODBC(Open Database Connectivity,())是Microsoft公司开发的一套开放的数据库系统(),它为应用程序提供了一组对数据库访问的标准()和基于()的运行支撑环境。
第2题:
下列选项中,表示数据库管理系统的英文名称是()
第3题:
A user has an application server LPAR with a physical Ethernet adapter. They want to have a database LPAR also connected to the application LPAR via virtual Ethernet. Their security policies require a firewall between the application LPAR and database LPAR. Which of the following virtual Ethernet configurations satisfies the customer’s requirements?()
第4题:
You want to implement the backup and recovery strategy in your database using Recovery Manager (RMAN). You have chosen the control file of the target database for the RMAN repository. Which command-line RMAN command would you use to establish a local connection between RMAN and the RMAN repository if your database is using password file authentication?()
第5题:
You are a database administrator for your company. The company uses a vendor company’s application that is based on a proprietary database. You query data from the application database and import the data into a SQL Server 2005 database. The application vendor provides you with a new OLE DB driver to be used when querying the application database. Company policy prohibits connections between the SQL Server database and the application database, except when querying this data. You need to provide a way to query data from the application database. What should you?()
第6题:
he DBA is about to enable auditing on the Oracle database in an attempt to discover some suspicious activity. Audit trail information is stored in which of the following database object names?()
第7题:
WebSphere Commerce Server, WebSphere Application Server and Web server plugin
WebSphere Application Server, Database Client and Web server plugin
WebSphere Commerce Server, Database Server and WebSphere Application Server
WebSphere Commerce Server, WebSphere Application Server and Database Client
Web server, WebSphere Commerce Server and WebSphere Application Server
第8题:
rman TARGET / NOCATALOG
rman TARGET sys/password
rman TARGET sys/password AS SYSDBA
rman TARGET sys/password@db_name CATALOG rman_user/rman_password@rcat
第9题:
To achieve the goal, a Linked Server connection should be configured to the application database.
To achieve the goal, a query should be written, and an OPENQUERY command is utilized by the query.
To achieve the goal, a Remote Server connection to the application database should be configured.
To achieve the goal, a query should be written, and an OPENDATASOURCE command is utilized by the query.
第10题:
Use the SQL Server 2005 Management Studio to review the permissions of the default database objects.
Query the sys.server_permissions table on Server1.
Execute the sp_helplogins system stored procedure for each of the default users that the MedDATA application creates.
Query the sys.database_permissions and sys.database_principals tables in the MedDB database.
第11题:
Use the Sys.Debug.fail method.
Use the Sys.Debug.trace method.
Use the Sys.Debug.assert method.
Use the Sys.Debug.traceDump method.
第12题:
Oracle Database tier and Application server tier only
Oracle Database tier, Application server tier, and End-user client tier only
Oracle Database tier, Application server tier, and Development client tier only
Oracle Database tier, Application server tier, Development client tier, and End-user client tier
第13题:
下列数据库中,属于SQL server系统数据库的是()数据库。
第14题:
SQL Server数据库提供的错误信息如何查看?()
第15题:
You enabled an audit policy by issuing the following statements: SQL> AUDIT POLICY ORA_DATABASE_PARAMETER BY SCOTT; SQL> AUDIT POLICY ORA_DATABASE_PARAMETER BY SYS, SYSTEM; For which database users and for which executions is the audit policy now active? ()
第16题:
You wish to enable an audit policy for all database users, except SYS, SYSTEM, and SCOTT.You issue the following statements: SQL> AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SYS;SQL> AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SYSTEM; SQL> AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SCOTT; For which database users is the audit policy now active?()
第17题:
In a two-tier configuration, it is recommended to put which of the following components on different nodes?()
第18题:
Database client and database server
WebSphere Application Server and Database Server
WebSphere Commerce Server and WebSphere Application Server
Web server and WebSphere Application Server
第19题:
It creates database files for the duplicate database under the Oracle base with a different directory for the duplicate database.
It overwrites data files of the target database because a different location for data files is not mentioned for the duplicate database.
It creates database files for the duplicate database under the same Oracle home as that of the target database with the same directory structure.
It creates database files for the duplicate database under the same Oracle home as that of the target but with a different directory for the duplicate database.
第20题:
The application server,firewall,and database server on the same VLAN
The application server and firewall on one VLAN,and the database server on a second VLAN
The application server on one VLAN,and the database server and firewall on a second VLAN
The application server and firewall on one VLAN,and the firewall and database server on a second VLAN
第21题:
Use the Sys.Debug.fail method.
Use the Sys.Debug.trace method.
Use the Sys.Debug.assert method.
Use the Sys.Debug.traceDump method.
第22题:
查看系统视图sys.database_files
查看系统视图sys.messages
查看系统视图sys.error
查看系统视图sys.stats
第23题:
no profiles
the default profile
same as the profile of SYS user
same as the profile of SYSTEM user