查看Oracle用户可以使用那些表数据字典表(管理用户所有表)descuser_tables;(查看可以操作的表)selecttables_namefromuser_tables;(SCOTT用户可以使用四个表)字符类型都是左对齐，数字类型的都是右对齐空值是不可用的、未分配的、未知的或不使用的值空值不同于零或空格设置显示行间距setlinesize200;宽度为200setpagesize50;每
原创
2019-09-03 17:23:24
710阅读
Which two statements are true regarding subqueries? (Choose two.)(关于子查询哪两句话是正确的？)A. A subquery can retrieve zero or more rows.（子查询能检索 0 行或多行）B. Only t
转载
2017-11-30 13:38:00
141阅读
2评论
Examine the data in the CUSTOMERS table: CUSTNO CUSTNAME CITY You want to list all cities that have more than one customer along with the customer det
转载
2017-11-29 18:20:00
184阅读
2评论
Which three statements are true about multiple-row subqueries? (Choose three.)A. They can contain a subquery within a subquery.B. They can return mult
转载
2017-11-30 14:11:00
84阅读
2评论
Which SQL statements would display the value 1890.55 as $1,890.55? (Choose three)A. SELECT TO_CHAR(1890.55,'$0G000D00') FROM DUAL;B. SELECT TO_CHAR(18
转载
2017-11-24 10:57:00
174阅读
2评论
View the E xhibit and examine the data in the EMPLOYEES table.You want to generate a report showing the total compensation paid to each employee to da
转载
2017-12-20 15:42:00
93阅读
2评论
View the Exhibit and examine the data in the CUSTOMERS table.Evaluate the following query:SQL> SELECT cust_name AS "NAME", cust_credit_limit/2 AS MIDP
转载
2017-12-20 15:33:00
83阅读
2评论
Which statement is true regarding transactions? (Choose all that apply.)A. A transaction can consist only of a set of DML and DDL statements.B. A part
转载
2017-11-30 17:48:00
84阅读
2评论
View the Exhibit and examine the structure of the PRODUCTS table.You want to display the category with the maximum number of items.You issue the follo
转载
2017-11-30 14:35:00
90阅读
2评论
Which two statements are true regarding indexes? (Choose two.)A. They can be created on tables and clusters.B. They can be created on tables and simpl
转载
2018-01-02 16:27:00
104阅读
2评论
Which three statements are true regarding the data types in Oracle Database 10g/11g? (Choose three.)A. Only one LONG column can be used per table.B. A
转载
2017-12-20 15:48:00
1831阅读
2评论
Oracle OCP 11G 051（61题版本）答案解析目录61题版本V9.021http://blog.csdn.net/rlhua/article/details/176358432 http://blog...
转载
2013-12-30 10:30:00
19阅读
2评论
一、 原题View the Exhibit and examine the structure of the SALES, CUSTOMERS, PRODUCTS, and TIMES tables.The PROD_ID column is the foreign key in the SALES table, which references the PRODUCTS table.Simila
转载
精选
2015-08-03 19:05:01
409阅读
一、原题 Which SQL statements would display the value 1890.55 as $1,890.55? (Choose three)A. SELECT TO_CHAR(1890.55,'$0G000D00') FROM DUAL;B. SELECT TO_CHAR(1890.55,'$9,999V99') FROM DUAL;C. SELECT T
转载
精选
2015-08-03 19:10:46
696阅读
一、原题View the Exhibit; examine the structure of the PROMOTIONS table.Each promotion has a duration of at least seven days.Your manager has asked you to generate a report, which provides the weekly cost
转载
精选
2015-08-03 19:16:45
435阅读
一、原题Examine the structure of the SHIPMENTS table:Name Null &nbs
转载
精选
2015-08-03 19:19:51
363阅读
后来重新复习的时候，发现这篇文章不错：https://www.cnblogs.com/z-sm/p/5691760.html 一：前提 1.安装条件 Java Scala zookeeper Kafka 2.使用版本 使用的版本是0.8.2.1 二：伪分布式安装 1.解压 kafka_2.10-0.
转载
2018-08-02 22:55:00
109阅读
2评论
The n-queens puzzle is the problem of placing n queens on an n×n chessboard such that no two queens attack each other.Given an integer n, return all distinct solutions to the n-queens puzzle.Each solution contains a distinct board configuration of the
原创
2022-04-15 09:33:19
29阅读
一、原题You need to extract details of those products in the SALES table where the PROD_ID column contains the string '_D123'.Which WHERE clause could be used in the SELECT statement to get the required o
转载
精选
2015-08-03 19:07:09
457阅读
一、原题Examine the structure of the SHIPMENTS table:Name Null &nbs
转载
精选
2015-08-03 19:13:08
260阅读
