51题库考试学习网
最新考题
-
多选题POS辅助空中三角测量区域网平差计算时,需导入( )进行联合平差。A内方位元素B摄站点坐标C像点坐标D像片外方位元素E控制点坐标
05-02
-
多选题Mysqldump was used to create a single schema backup; Shell mysqldump –u root –p sakila sakila2013.sql Which two commands will restore the sakila database without interfering with other running database?()AMysql> USE sakila; LOAD DATA INFILE 'sakila2013.sql';BShell> mysql –u root –p sakila sakila2013.sqlCShell> mysql import –u root –p sakila sakila2013.sqlDShell> mysql –u root -p –e 'use sakila; source sakila2013.sql'EShell> mysql –u root –p –silent < sakila2013.sql
05-02
-
单选题An existing master-slave setup is currently using a delayed replication of one hour. The master has crashed and the slave must be "rolled forward" to provide all the latest data. The SHOW SLAVE STATUS indicates the following values: RELAY_LOG_FILE =hostname-relay-bin.00004 RELAY_LOG_POS = 1383 Which command set would make the slave current?()AGtid_mode must be set to AUTO during point in time recoveriesBMysqlbinlog ignores arguments to – exclude-gtids-it means ignore all events with GTIDsCThe server keeps track of which GTIDs have already been executed and skips thoseDEnforce_gtid_consistency is set to ON
05-02
-
单选题MySQL is installed on a Linux server and has the following configuration: What is the purpose of changing ownership of datadir to the ‘mysql’ user?()A MySQL requires correct file ownership while remaining secureB MySQL needs to be run as the root user, but file cannot be owned by itC MySQL cannot be run as the root user
05-02
-
多选题下列测量工作中,属于建筑工程施工阶段测量工作的有( )。A立面测绘B点位放样C高程传递D剖面测量E轴线测设
05-02
-
单选题Which statement is true about using Microsoft Windows Cluster as a platform for Mysql?()AIt implements High Availability by using the .NET Connector's' load balancing capabilitiesBIt is shared-nothing architectureCIt is provided by means of IP- level disk replicationDIt relies on the shared disk architecture being visible to both servers
05-02
-
单选题《行政区域边界协议书附图集》是根据双方( )以及界桩成果表编纂而成的带状地图集。A边界协议书附图B行政区域边界协议书C行政区域协议书附图D边界协议书
05-02
-
多选题Which two statements are true about setting the per-thread buffers higher than required?()AMore memory per thread is beneficial in all scenariosBIt causes increased overhead due to initial memory allocationCIt can affect system stability during peak load times, due to swappingDIt requires increasing the thread_cache_size variable
05-02
-
多选题Which three statements describe how the strict SQL mode provides added security?()AIt rejects statements that try to insert out-of-range valuesBIt rejects invalid datesCIt limits the operations that the server can performDIt rejects queries that produce out-of-range valuesEIt rejects dates with zero day or month values
05-02
-
单选题The validate_password plugin is loaded and displays the following settings in global variables: Mysql> SHOW VARIABLES LIKE ‘validate_password%’; When attempting to set your password, you get the following error: Mysql> SET PASSWORD = PASSWORD (‘Hoverl@%’); ERROR 1819 (HY000): Your password does not satisfy the current policy requirements What is the cause of the error?()A The password is eight characters long, but needs to exceed validate_password_length to be validB All of the MEDIUM password policy requirements have not been honoredC The password matches a substring Hover as a dictionary wordD The password does not match the validate_passoword_number_count requirementE There is no dictionary file defined, so password validation cannot work as expected
05-02
-
多选题What are four capabilities of the mysql client program?()ACreating, dropping, and modifying tables and indexesBInitiating a binary backup of the database by using the START BACKUP commandCDisplaying replication status informationDShutting down the server by using the SHUTDOWN commandECreating and dropping databasesFCreating and administering users
05-02
-
单选题地籍测量工作中,内业互检的检查比例应为( )。A100%B0.7C0.5D30%
05-02
-
单选题Consider the MySQL Enterprise Audit plugin. On attempting to start the MySQL service after a crash, notice the following error: [ERROR] Plugin ‘audit_log’ init function returned error. In the audit log file, you notice the final entry: … What action should you take to fix the error and allow the service to start?()A Re-install the audit pluginB Execute the command FLUSH LOGSC Execute the command SET GLOBAL audit_log_fiush= OND Move or rename the existing audit.log file
05-02
-
单选题A user executes the statement; PURGE BINARY LOGS TO 'mysql-bin.010'; What is the result?()AIt deletes all binary log files, except 'mysql-in.010'BIt deletes all binary log files up to and including 'mysql-bin.010'CIt deletes all binary log files before 'mysql-bin.010'DIt deletes all binary log files after 'mysql-bin.010'
05-02
-
单选题中国沿海地区深度基准目前采用的是( )。A当地平均海面B海洋大地水准面C平均大潮高潮面D理论最低潮面
05-02
-
多选题GPS网平差的目的包括( )。A消除GPS网几何上的不一致性B评定GPS网的内符合精度C确定点在指定坐标系下的坐标D对GPS接收机进行检定E检核GPS天线相位中心稳定性
05-02
-
单选题You want a record of all queries that are not using indexes. How would you achieve this?()ABy enabling the Slow Query Log because all queries that are not using indexes will be logged automaticallyBBy enabling the Error Log because not using indexes is an errorCBy enabling the Slow Query Log and using the – log-queries-not-using-indexes optionDBy enabling the Error Log and using the – log-queries-not-using-indexes option
05-02
-
多选题航测像片调绘的方法有( )。A室内判调法B全野外调绘法C室内外综合调绘法D计算机辅助调绘法EGPS辅助调绘法
05-02
-
单选题Which statement is true about using Microsoft Windows Cluster as a platform for Mysql?()AIt implements High Availability by using the .NET Connector's' load balancing capabilitiesBIt is shared-nothing architectureCIt is provided by means of IP- level disk replicationDIt relies on the shared disk architecture being visible to both servers
05-02
-
单选题依据地形图资料和幅面大小设计地图时,所确定的图幅比例尺通常称为( )。A平均比例尺B基本比例尺C局部比例尺D主比例尺
05-02
-
单选题Which statement is true about the log-output variable?()AIt is a static variable and can be set only at MySQL server startupBIt enables and starts the General Query LogCIt sets the target location for the binary logs generated by the MySQL severDIt specifies output destinations for the slow and General Query logs
05-02
-
单选题Consider the Mysql Enterprise Audit plugin. Which statement is true when you identify a connection event that has used external authentication?()AThe attribute STATUS is set to the string EXTERNAL_AUTHBThe attribute PRIV_USER contains the usernameCThe event type that is given in the attribute NAME is EXTERNAL_AUTHDThere is no differentiation between native and external authentication eventsEExternal authentication is managed through external auditing logsFThe PROXY_PRIV user shows a username if external authentication is used
05-02
-
单选题相对重力测量是测定两点的( )。A重力差值B重力平均值C重力绝对值D重力加速度
05-02
-
单选题While reviewing the MySQL error log, you see occasions where MySQL has exceeded the number of file handles allowed to it by the operating system. Which method will reduce the number of file handles in use?()AActivating the MySQL Enterprise thread pool pluginBRelocating your data and log files to separate storage devicesCDisconnecting idle localhost client sessionsDImplementing storage engine data compression options
05-02
-
多选题Which three methods will show the storage engine for the Country table?()AABBCCDDEE
05-02
-
单选题You are attempting to secure a MySQL server by using SSL encryption. On starting MySQL, you get this error: 130123 10:38:02 [ERROR] mysqld: unknown option '—ssl' What is the cause of the error?()AThe — ssl level was not specifiedBThe server was not started with the – enable–ssl-plugin optionC— ssl is not a valid server optionDThe mysqld binary was not compiled with SSL supportEThe server's SSL certificate was invalid
05-02
-
单选题陀螺经纬仪测定的方位角是( )。A坐标方位角B磁北方位角C施工控制网坐标系方位角D真北方位角
05-02
-
单选题A database exists as a read-intensive server that is operating with query_cachek_type =DEMAND. The database is refreshed periodically, but the resultset size of the queries does not fluctuate. Note the following details about this environment: A web application uses a limited set of queries. The Query Cache hit rate is high. All resultsets fit into the Query Cache. All queries are configured to use the Query Cache successfully. The response times for queries have recently started to increase. The cause for this has correctly been identified as the increase in the number of concurrent users accessing the web service. Based solely on the information provided, what is the most likely cause for this slowdown at the database level?()AThe Query Cache is pruning queries due to an increased number of requestsBQuery_cache_min_res_unit has been exceeded, leading to an increased performance overhead due to additional memory block lookupsCMutex contention on the Query Cache is forcing the queries to take longer due to its singlethreaded natureDThe average resultset of a query is increasing due to an increase in the number of users requiring SQL statement execution
05-02
-
多选题What are three actions performed by the mysql_secure_installation tool?()AIt prompts you to set the root user account passwordBIt checks whether file permissions are appropriate within datadirCIt asks to remove the test database, which is generated at installation timeDIt can delete any anonymous accountsEIt verifies that all users are configuration with the longer password hash
05-02
-
多选题隧道工程测量中,竖井联系测量的平面控制方法有( )。AGPS RTK测量法B陀螺经纬仪定向法C激光准直投点法D悬挂钢尺法E联系三角形法
05-02
-
单选题Consider the following: Which statement best describes the meaning of the value for the key_len column?()A It shows the total size of the index rowB It shows how many columns in the index are examinedC It shows the number of characters indexed in the keyD It shows how many bytes will be used from each index row
05-02
-
单选题You adjust a default configuration to the following /etc/my.cnf on a Linux installation:[mysqld] Loq-bin Binrylog_format=ROW You do not notice the spelling error in binrylog_format and restart your production server. How does the MySQL server behave with incorrectly spelled options?()AMysqld uses internal configuration versioning and reverts to the previous configurationBWhen using mysql_config_editor for configuration adjustments, it detects incorrect syntax and typing mistakesCThe mysqld_safe script skips the unknown variable and starts using the remaining configuration changesDMysqld prints to the error log about an unknown variable, and then exits
05-02
-
多选题GIS系统调试的主要方法有( )。A硬性排错B软性排错C归纳法排错D演绎法排错E跟踪法排错
05-02
-
单选题下列测绘工作,属于新建公路工程初测的是( )。A中线测量B纵横断面测绘C曲线测设D带状地形图测绘
05-02
-
单选题竣工测量属于( )阶段的任务。A工程勘测B工程建设C工程运营D工程检测
05-02
-
单选题城镇建筑工程规划监督测量的0验线测量工作,测量时间为( )。A在建筑物基础放线后B在建筑物基础施工完成后C在建筑物施工完成后D定线测量后
05-02
-
单选题工矿区1:500比例尺竣工图测绘中,主要建筑物细部点坐标中误差不应超过( )米。A0.05B0.07C0.10D0.14
05-02
-
单选题You want to start monitoring statistics on the distribution of storage engines that are being used and the average sizes of tables in the various databases. Some details are as follows: The Mysql instance has 400 databases. Each database on an average consists of 25-50 tables. You use the query: SELECT TABLE_SCHEMA, 'ENGINE', COUNT (*), SUM(data_length) total_size FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE= 'BASE TABLE' GROUP BY TABLE_SCHEMA, 'ENGINE' ; Why is this query slow to execute?()ACollecting information requires large numbers of locks on various INFORMATION_SCHEMA tablesBAggregating details from various storage engine caches for the final output is time consumingCCollecting information requires various disk-level operations and is time consumingDCounting and summarizing all table pages in the InnoDB shared tablespace is time consuming
05-02
-
单选题Consider the following: Which statement best describes the meaning of the value for the key_len column?()A It shows the total size of the index rowB It shows how many columns in the index are examinedC It shows the number of characters indexed in the keyD It shows how many bytes will be used from each index row
05-02
-
多选题Mysqldump was used to create a single schema backup; Shell mysqldump –u root –p sakila sakila2013.sql Which two commands will restore the sakila database without interfering with other running database?()AMysql> USE sakila; LOAD DATA INFILE 'sakila2013.sql';BShell> mysql –u root –p sakila sakila2013.sqlCShell> mysql import –u root –p sakila sakila2013.sqlDShell> mysql –u root -p –e 'use sakila; source sakila2013.sql'EShell> mysql –u root –p –silent < sakila2013.sql
05-02